Detailed Vendor Ledg. Entry #380

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

43
Fields
809
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 Vendor Ledg. Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Vendor Ledger Entry No. Integer Normal → Vendor Ledger Entry #25
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 Vendor No. Code Normal → Vendor #23
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 Vend. Ledger Entry No. Integer Normal
37 Unapplied Boolean Normal
38 Unapplied by Entry No. Integer Normal → Detailed Vendor Ledg. Entry #380
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 Vendor Posting Group Code Normal → Vendor Posting Group #93
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 Vendor Ledg. Entry table through TableRelation properties.

Vendor Ledger Entry
#25 · Purchasing · via Vendor Ledger Entry No.
Vendor
#23 · Purchasing · via Vendor 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 Vendor Ledg. Entry
#380 · Other · via Unapplied by Entry No.
Tax Jurisdiction
#320 · Other · via Tax Jurisdiction Code
Vendor Posting Group
#93 · Other · via Vendor Posting Group
Exch. Rate Adjmt. Reg.
#86 · Other · via Exch. Rate Adjmt. Reg. No.