Currency #4

General Ledger table in Microsoft Dynamics 365 Business Central. 55 fields, 47 records in Cronus demo.

The Currency table (ID 4) is part of the General Ledger area in Microsoft Dynamics 365 Business Central. It contains 55 fields, with a primary key of Code, and includes 13 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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

All fields (55)

Currency — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Code PK	Code	Normal
2	Last Date Modified	Date	Normal
3	Last Date Adjusted	Date	Normal
4	ISO Code	Code	Normal
5	ISO Numeric Code	Code	Normal
6	Unrealized Gains Acc.	Code	Normal	→ G/L Account #15
7	Realized Gains Acc.	Code	Normal	→ G/L Account #15
8	Unrealized Losses Acc.	Code	Normal	→ G/L Account #15
9	Realized Losses Acc.	Code	Normal	→ G/L Account #15
10	Invoice Rounding Precision	Decimal	Normal
12	Invoice Rounding Type	Option	Normal
13	Amount Rounding Precision	Decimal	Normal
14	Unit-Amount Rounding Precision	Decimal	Normal
15	Description	Text	Normal
17	Amount Decimal Places	Text	Normal
18	Unit-Amount Decimal Places	Text	Normal
19	Customer Filter	Code	FlowFilter	→ Customer #18
20	Vendor Filter	Code	FlowFilter	→ Vendor #23
21	Global Dimension 1 Filter	Code	FlowFilter	→ Dimension Value #349
22	Global Dimension 2 Filter	Code	FlowFilter	→ Dimension Value #349
23	Date Filter	Date	FlowFilter
24	Cust. Ledg. Entries in Filter ⚡ FLOW	Boolean	FlowField
25	Customer Balance ⚡ FLOW	Decimal	FlowField
26	Customer Outstanding Orders ⚡ FLOW	Decimal	FlowField
27	Customer Shipped Not Invoiced ⚡ FLOW	Decimal	FlowField
28	Customer Balance Due ⚡ FLOW	Decimal	FlowField
29	Vendor Ledg. Entries in Filter ⚡ FLOW	Boolean	FlowField
30	Vendor Balance ⚡ FLOW	Decimal	FlowField
31	Vendor Outstanding Orders ⚡ FLOW	Decimal	FlowField
32	Vendor Amt. Rcd. Not Invoiced ⚡ FLOW	Decimal	FlowField
33	Vendor Balance Due ⚡ FLOW	Decimal	FlowField
34	Customer Balance (LCY) ⚡ FLOW	Decimal	FlowField
35	Vendor Balance (LCY) ⚡ FLOW	Decimal	FlowField
40	Realized G/L Gains Account	Code	Normal	→ G/L Account #15
41	Realized G/L Losses Account	Code	Normal	→ G/L Account #15
44	Appln. Rounding Precision	Decimal	Normal
45	EMU Currency	Boolean	Normal
46	Currency Factor	Decimal	Normal
47	Residual Gains Account	Code	Normal	→ G/L Account #15
48	Residual Losses Account	Code	Normal	→ G/L Account #15
50	Conv. LCY Rndg. Debit Acc.	Code	Normal	→ G/L Account #15
51	Conv. LCY Rndg. Credit Acc.	Code	Normal	→ G/L Account #15
52	Max. VAT Difference Allowed	Decimal	Normal
53	VAT Rounding Type	Option	Normal
54	Payment Tolerance %	Decimal	Normal
55	Max. Payment Tolerance Amount	Decimal	Normal
56	Symbol	Text	Normal
57	Last Modified Date Time	DateTime	Normal
166	Currency Symbol Position	Option	Normal
721	Coupled to Dataverse ⚡ FLOW	Boolean	FlowField
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 (5)

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

G/L Account

#15 · General Ledger · via Unrealized Gains Acc., Realized Gains Acc., Unrealized Losses Acc., Realized Losses Acc., Realized G/L Gains Account, Realized G/L Losses Account, Residual Gains Account, Residual Losses Account, Conv. LCY Rndg. Debit Acc., Conv. LCY Rndg. Credit Acc.

Customer

#18 · Sales · via Customer Filter

Vendor

#23 · Purchasing · via Vendor Filter

Dimension Value

#349 · Dimensions · via Global Dimension 1 Filter, Global Dimension 2 Filter