G/L Entry #17

Ledger Entries table in Microsoft Dynamics 365 Business Central. 85 fields, 3,990 records in Cronus demo.

G/L Entry is the core general ledger table in Business Central — every posted financial transaction ultimately creates one or more rows here. It is the single source of truth for all account balances, trial balances, and financial reporting. If money moved in the system, it is recorded in table 17.

COMMON USE CASES

Trial balance and financial statements
G/L account transaction history
Dimension-based financial analysis
Period-end close and reconciliation
Audit trail and posting verification

Fields

3,990

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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

All fields (85)

G/L Entry — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
3	G/L Account No.	Code	Normal	→ G/L Account #15
4	Posting Date	Date	Normal
5	Document Type	Option	Normal
6	Document No.	Code	Normal
7	Description	Text	Normal
10	Bal. Account No.	Code	Normal
17	Amount (LCY)	Decimal	Normal
18	Source Currency Amount	Decimal	Normal
19	Source VAT Currency Amount	Decimal	Normal
20	Source Currency Code	Code	Normal	→ Currency #4
23	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
24	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
27	User ID	Code	Normal
28	Source Code	Code	Normal	→ Source Code #230
29	System-Created Entry	Boolean	Normal
30	Prior-Year Entry	Boolean	Normal
41	Project No.	Code	Normal	→ Job #167
42	Quantity	Decimal	Normal
43	VAT Amount	Decimal	Normal
45	Business Unit Code	Code	Normal	→ Business Unit #220
46	Journal Batch Name	Code	Normal
47	Reason Code	Code	Normal	→ Reason Code #231
48	Gen. Posting Type	Option	Normal
49	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
50	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
51	Bal. Account Type	Option	Normal
52	Transaction No.	Integer	Normal
53	Debit Amount (LCY)	Decimal	Normal
54	Credit Amount (LCY)	Decimal	Normal
55	Document Date	Date	Normal
56	External Document No.	Code	Normal
57	Source Type	Option	Normal
58	Source No.	Code	Normal
59	No. Series	Code	Normal	→ No. Series #308
60	Tax Area Code	Code	Normal	→ Tax Area #318
61	Tax Liable	Boolean	Normal
62	Tax Group Code	Code	Normal	→ Tax Group #321
63	Use Tax	Boolean	Normal
64	VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
65	VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
68	Additional-Currency Amount	Decimal	Normal
69	Add.-Currency Debit Amount	Decimal	Normal
70	Add.-Currency Credit Amount	Decimal	Normal
71	Close Income Statement Dim. ID	Integer	Normal
72	IC Partner Code	Code	Normal	→ IC Partner #413
73	Reversed	Boolean	Normal
74	Reversed by Entry No.	Integer	Normal	→ G/L Entry #17
75	Reversed Entry No.	Integer	Normal	→ G/L Entry #17
76	G/L Account Name ⚡ FLOW	Text	FlowField
78	Journal Template Name	Code	Normal
79	VAT Date	Date	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
481	Shortcut Dimension 3 Code ⚡ FLOW	Code	FlowField
482	Shortcut Dimension 4 Code ⚡ FLOW	Code	FlowField
483	Shortcut Dimension 5 Code ⚡ FLOW	Code	FlowField
484	Shortcut Dimension 6 Code ⚡ FLOW	Code	FlowField
485	Shortcut Dimension 7 Code ⚡ FLOW	Code	FlowField
486	Shortcut Dimension 8 Code ⚡ FLOW	Code	FlowField
495	Last Dim. Correction Entry No.	Integer	Normal
496	Last Dim. Correction Node	Integer	Normal
497	Count of Dimension Changes	Integer	Normal
2678	Allocation Account No.	Code	Normal
2679	Allocation Journal Line SystemId	GUID	Normal
5400	Prod. Order No.	Code	Normal
5600	FA Entry Type	Option	Normal
5601	FA Entry No.	Integer	Normal
5618	Comment	Text	Normal
6200	Non-Deductible VAT Amount	Decimal	Normal
6201	Non-Deductible VAT Amount ACY	Decimal	Normal
6202	Source Currency Non-Deductible VAT Amount	Decimal	Normal
8000	Subscription Contract No.	Code	Normal
8001	Account Id ⚡ FLOW	GUID	FlowField	→ G/L Account #15
8005	Last Modified DateTime	DateTime	Normal
22212	Reviewed ⚡ FLOW	Boolean	FlowField
22213	Reviewed By ⚡ FLOW	Code	FlowField
22214	Reviewed Date ⚡ FLOW	DateTime	FlowField
22215	Reviewed Identifier ⚡ FLOW	Integer	FlowField
22217	Reviewed Amount ⚡ FLOW	Decimal	FlowField
22218	Amount to Review	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