Detailed Cust. Ledg. Entry #379

Other table in Microsoft Dynamics 365 Business Central. 43 fields, 1,145 records in Cronus demo.

The Detailed Cust. Ledg. Entry table (ID 379) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 43 fields, with a primary key of Entry No.. Use the reference below to explore every field, data type, and table relation.

Fields

1,145

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 (43)

Detailed Cust. Ledg. Entry — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
2	Cust. Ledger Entry No.	Integer	Normal	→ Cust. Ledger Entry #21
3	Entry Type	Option	Normal
4	Posting Date	Date	Normal
5	Document Type	Option	Normal
6	Document No.	Code	Normal
7	Amount	Decimal	Normal
8	Amount (LCY)	Decimal	Normal
9	Customer No.	Code	Normal	→ Customer #18
10	Currency Code	Code	Normal	→ Currency #4
11	User ID	Code	Normal
12	Source Code	Code	Normal	→ Source Code #230
13	Transaction No.	Integer	Normal
14	Journal Batch Name	Code	Normal
15	Reason Code	Code	Normal	→ Reason Code #231
16	Debit Amount	Decimal	Normal
17	Credit Amount	Decimal	Normal
18	Debit Amount (LCY)	Decimal	Normal
19	Credit Amount (LCY)	Decimal	Normal
20	Initial Entry Due Date	Date	Normal
21	Initial Entry Global Dim. 1	Code	Normal	→ Dimension Value #349
22	Initial Entry Global Dim. 2	Code	Normal	→ Dimension Value #349
24	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
25	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
29	Use Tax	Boolean	Normal
30	VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
31	VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
35	Initial Document Type	Option	Normal
36	Applied Cust. Ledger Entry No.	Integer	Normal
37	Unapplied	Boolean	Normal
38	Unapplied by Entry No.	Integer	Normal	→ Detailed Cust. Ledg. Entry #379
39	Remaining Pmt. Disc. Possible	Decimal	Normal
40	Max. Payment Tolerance	Decimal	Normal
41	Tax Jurisdiction Code	Code	Normal	→ Tax Jurisdiction #320
42	Application No.	Integer	Normal
43	Ledger Entry Amount	Boolean	Normal
44	Customer Posting Group	Code	Normal	→ Customer Posting Group #92
45	Exch. Rate Adjmt. Reg. No.	Integer	Normal	→ Exch. Rate Adjmt. Reg. #86
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