Detailed Cust. Ledg. Entry #379

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

43
Fields
1,145
Records
1
Primary key
0
FlowFields
18
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.FIELDTYPECLASSRELATION
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

Related tables (15)

Tables referenced by fields on the Detailed Cust. Ledg. Entry table through TableRelation properties.

Cust. Ledger Entry
#21 · Sales · via Cust. Ledger Entry No.
Customer
#18 · Sales · via Customer No.
Currency
#4 · General Ledger · via Currency Code
Source Code
#230 · Other · via Source Code
Reason Code
#231 · Other · via Reason Code
Dimension Value
#349 · Dimensions · via Initial Entry Global Dim. 1, Initial Entry Global Dim. 2
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
Detailed Cust. Ledg. Entry
#379 · Other · via Unapplied by Entry No.
Tax Jurisdiction
#320 · Other · via Tax Jurisdiction Code
Customer Posting Group
#92 · Other · via Customer Posting Group
Exch. Rate Adjmt. Reg.
#86 · Other · via Exch. Rate Adjmt. Reg. No.