Other table in Microsoft Dynamics 365 Business Central. 13 fields, 53 records in Cronus demo.
The Currency Exchange Rate table (ID 330) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 13 fields, with a primary key of Currency Code, Starting Date. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Currency Code, Starting Date.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Currency Exchange Rate table through TableRelation properties.