G/L - Item Ledger Relation #5823

Other table in Microsoft Dynamics 365 Business Central. 8 fields, 1,494 records in Cronus demo.

The G/L - Item Ledger Relation table (ID 5823) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 8 fields, with a primary key of G/L Entry No., Value Entry No.. Use the reference below to explore every field, data type, and table relation.

Fields

1,494

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: G/L Entry No., Value Entry No..

All fields (8)

G/L - Item Ledger Relation — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	G/L Entry No. PK	Integer	Normal	→ G/L Entry #17
2	Value Entry No. PK	Integer	Normal	→ Value Entry #5802
3	G/L Register No.	Integer	Normal	→ G/L Register #45
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 (4)

Tables referenced by fields on the G/L - Item Ledger Relation table through TableRelation properties.

G/L Entry

#17 · Ledger Entries · via G/L Entry No.

Value Entry

#5802 · Ledger Entries · via Value Entry No.

G/L Register

#45 · Sales Documents · via G/L Register No.