Cust. Ledger Entry #21

Sales table in Microsoft Dynamics 365 Business Central. 100 fields, 579 records in Cronus demo.

The Cust. Ledger Entry table (ID 21) is part of the Sales area in Microsoft Dynamics 365 Business Central. It contains 100 fields, with a primary key of Entry No., and includes 16 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.

100

Fields

579

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

Cust. Ledger Entry — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
3	Customer No.	Code	Normal	→ Customer #18
4	Posting Date	Date	Normal
5	Document Type	Option	Normal
6	Document No.	Code	Normal
7	Description	Text	Normal
8	Customer Name	Text	Normal
10	Your Reference	Text	Normal
11	Currency Code	Code	Normal	→ Currency #4
13	Amount ⚡ FLOW	Decimal	FlowField
14	Remaining Amount ⚡ FLOW	Decimal	FlowField
15	Original Amt. (LCY) ⚡ FLOW	Decimal	FlowField
16	Remaining Amt. (LCY) ⚡ FLOW	Decimal	FlowField
17	Amount (LCY) ⚡ FLOW	Decimal	FlowField
18	Sales (LCY)	Decimal	Normal
19	Profit (LCY)	Decimal	Normal
20	Inv. Discount (LCY)	Decimal	Normal
21	Sell-to Customer No.	Code	Normal	→ Customer #18
22	Customer Posting Group	Code	Normal	→ Customer Posting Group #92
23	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
24	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
25	Salesperson Code	Code	Normal	→ Salesperson/Purchaser #13
27	User ID	Code	Normal
28	Source Code	Code	Normal	→ Source Code #230
33	On Hold	Code	Normal
34	Applies-to Doc. Type	Option	Normal
35	Applies-to Doc. No.	Code	Normal
36	Open	Boolean	Normal
37	Due Date	Date	Normal
38	Pmt. Discount Date	Date	Normal
39	Original Pmt. Disc. Possible	Decimal	Normal
40	Pmt. Disc. Given (LCY)	Decimal	Normal
42	Orig. Pmt. Disc. Possible (LCY)	Decimal	Normal
43	Positive	Boolean	Normal
44	Closed by Entry No.	Integer	Normal	→ Cust. Ledger Entry #21
45	Closed at Date	Date	Normal
46	Closed by Amount	Decimal	Normal
47	Applies-to ID	Code	Normal
48	Journal Template Name	Code	Normal
49	Journal Batch Name	Code	Normal
50	Reason Code	Code	Normal	→ Reason Code #231
51	Bal. Account Type	Option	Normal
52	Bal. Account No.	Code	Normal
53	Transaction No.	Integer	Normal
54	Closed by Amount (LCY)	Decimal	Normal
58	Debit Amount ⚡ FLOW	Decimal	FlowField
59	Credit Amount ⚡ FLOW	Decimal	FlowField
60	Debit Amount (LCY) ⚡ FLOW	Decimal	FlowField
61	Credit Amount (LCY) ⚡ FLOW	Decimal	FlowField
62	Document Date	Date	Normal
63	External Document No.	Code	Normal
64	Calculate Interest	Boolean	Normal
65	Closing Interest Calculated	Boolean	Normal
66	No. Series	Code	Normal	→ No. Series #308
67	Closed by Currency Code	Code	Normal	→ Currency #4
68	Closed by Currency Amount	Decimal	Normal
73	Adjusted Currency Factor	Decimal	Normal
74	Original Currency Factor	Decimal	Normal
75	Original Amount ⚡ FLOW	Decimal	FlowField
76	Date Filter	Date	FlowFilter
77	Remaining Pmt. Disc. Possible	Decimal	Normal
78	Pmt. Disc. Tolerance Date	Date	Normal
79	Max. Payment Tolerance	Decimal	Normal
80	Last Issued Reminder Level	Integer	Normal
81	Accepted Payment Tolerance	Decimal	Normal
82	Accepted Pmt. Disc. Tolerance	Boolean	Normal
83	Pmt. Tolerance (LCY)	Decimal	Normal
84	Amount to Apply	Decimal	Normal
85	IC Partner Code	Code	Normal	→ IC Partner #413
86	Applying Entry	Boolean	Normal
87	Reversed	Boolean	Normal
88	Reversed by Entry No.	Integer	Normal	→ Cust. Ledger Entry #21
89	Reversed Entry No.	Integer	Normal	→ Cust. Ledger Entry #21
90	Prepayment	Boolean	Normal
171	Payment Reference	Code	Normal
172	Payment Method Code	Code	Normal	→ Payment Method #289
173	Applies-to Ext. Doc. No.	Code	Normal
288	Recipient Bank Account	Code	Normal	→ Customer Bank Account #287
289	Message to Recipient	Text	Normal
290	Exported to Payment File	Boolean	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
1200	Direct Debit Mandate ID	Code	Normal	→ SEPA Direct Debit Mandate #1230
1300	Payment Prediction	Option	Normal
1301	Prediction Confidence	Option	Normal
1302	Prediction Confidence %	Decimal	Normal
1340	Dispute Status	Code	Normal	→ Dispute Status #142
1341	Promised Pay Date	Date	Normal
8000	Recurring Billing	Boolean	Normal
30100	Shopify Transaction Id	BigInteger	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