Currency Exchange Rate #330

Other table in Microsoft Dynamics 365 Business Central. 13 fields, 53 records in Cronus demo.

13
Fields
53
Records
2
Primary key
0
FlowFields
4
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Currency Code, Starting Date.

All fields (13)

Currency Exchange Rate — FIELDS
NO.FIELDTYPECLASSRELATION
1 Currency Code PK Code Normal → Currency #4
2 Starting Date PK Date Normal
3 Exchange Rate Amount Decimal Normal
4 Adjustment Exch. Rate Amount Decimal Normal
5 Relational Currency Code Code Normal → Currency #4
6 Relational Exch. Rate Amount Decimal Normal
7 Fix Exchange Rate Amount Option Normal
8 Relational Adjmt Exch Rate Amt Decimal Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (2)

Tables referenced by fields on the Currency Exchange Rate table through TableRelation properties.

Currency
#4 · General Ledger · via Currency Code, Relational Currency Code