Table 380 Detailed Vendor Ledg. Entry

Base Application, Microsoft.Purchases.Payables
List17181920212223242526272829
Fields122
Keys14153
Events21

In 29 2 added, 3 changed

field(95; "G/L Register No."; Integer)new in 29
added
field(7000004; "Excluded from calculation"; Boolean)new in 29
added
key(Key2; "Vendor No.", "Currency Code", "Excluded from calculation") { SumIndexFields = Amount, "Amount (LCY)"; }17-29changed in 20, 23, 28, 29
changed, was key(Key2; "Vendor No.", "Currency Code") { SumIndexFields = Amount, "Amount (LCY)"; }
key(Key4; "Vendor Ledger Entry No.", "Ledger Entry Amount", "Posting Date", "Excluded from calculation") { IncludedFields = "Currency Code", Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }17-29changed in 23, 28, 29
changed, was key(Key4; "Vendor Ledger Entry No.", "Ledger Entry Amount", "Posting Date") { IncludedFields = "Currency Code", Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }
key(Key6; "Vendor No.", "Currency Code", "Initial Entry Global Dim. 1", "Initial Entry Global Dim. 2", "Initial Entry Due Date", "Posting Date", "Excluded from calculation") { IncludedFields = Amount, "Amount (LCY)"; }17-29changed in 28, 29
changed, was key(Key6; "Vendor No.", "Currency Code", "Initial Entry Global Dim. 1", "Initial Entry Global Dim. 2", "Initial Entry Due Date", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; }

In 28 5 changed

key(Key2; "Vendor No.", "Currency Code") { SumIndexFields = Amount, "Amount (LCY)"; }17-29changed in 20, 23, 28, 29
changed, was key(Key2; "Vendor Ledger Entry No.", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; SumIndexFields = Amount, "Amount (LCY)"; }
key(Key4; "Vendor Ledger Entry No.", "Ledger Entry Amount", "Posting Date") { IncludedFields = "Currency Code", Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }17-29changed in 23, 28, 29
changed, was key(Key4; "Ledger Entry Amount", "Vendor Ledger Entry No.", "Posting Date") { IncludedFields = Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }
key(Key5; "Initial Document Type", "Entry Type", "Vendor No.", "Currency Code", "Initial Entry Global Dim. 1", "Initial Entry Global Dim. 2", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; }17-29changed in 28
changed, was key(Key5; "Initial Document Type", "Entry Type", "Vendor No.", "Currency Code", "Initial Entry Global Dim. 1", "Initial Entry Global Dim. 2", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; SumIndexFields = Amount, "Amount (LCY)"; }
key(Key6; "Vendor No.", "Currency Code", "Initial Entry Global Dim. 1", "Initial Entry Global Dim. 2", "Initial Entry Due Date", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; }17-29changed in 28, 29
changed, was key(Key6; "Vendor No.", "Currency Code", "Initial Entry Global Dim. 1", "Initial Entry Global Dim. 2", "Initial Entry Due Date", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; SumIndexFields = Amount, "Amount (LCY)"; }
key(Key12; "Vendor No.", "Entry Type", "Posting Date") { IncludedFields = Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }new in 23changed in 25, 28
changed, was key(Key12; "Entry Type", "Vendor No.", "Posting Date") { IncludedFields = Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; SumIndexFields = "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }

In 25 1 changed

key(Key12; "Entry Type", "Vendor No.", "Posting Date") { IncludedFields = Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; SumIndexFields = "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }new in 23changed in 25, 28
changed, was key(Key12; "Entry Type", "Vendor No.", "Posting Date") { IncludedFields = Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }

In 24 1 added

[IntegrationEvent] OnBeforeSetLedgerEntryAmount(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; var IsHandled: Boolean)new in 24
added

In 23 3 changed, 1 added

key(Key2; "Vendor Ledger Entry No.", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; SumIndexFields = Amount, "Amount (LCY)"; }17-29changed in 20, 23, 28, 29
changed, was key(Key2; "Vendor Ledger Entry No.", "Posting Date") { SumIndexFields = Amount, "Amount (LCY)"; }
key(Key3; "Vendor Ledger Entry No.", "Entry Type", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; }17-29changed in 23
changed, was key(Key3; "Vendor Ledger Entry No.", "Entry Type", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; SumIndexFields = Amount, "Amount (LCY)"; }
key(Key4; "Ledger Entry Amount", "Vendor Ledger Entry No.", "Posting Date") { IncludedFields = Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }17-29changed in 23, 28, 29
changed, was key(Key4; "Ledger Entry Amount", "Vendor Ledger Entry No.", "Posting Date") { IncludedFields = "Currency Code", Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; SumIndexFields = Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }
key(Key12; "Entry Type", "Vendor No.", "Posting Date") { IncludedFields = Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }new in 23changed in 25, 28
added

In 22 2 added

[IntegrationEvent] OnAfterUpdateDebitCredit(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; Correction: Boolean)new in 22
added
[IntegrationEvent] OnSetZeroTransNoOnBeforeDetailedVendorLedgEntryModify(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry")new in 22
added

In 20 2 added, 1 changed

field(44; "Posting Group"; Code[20])new in 20
added
field(45; "Exch. Rate Adjmt. Reg. No."; Integer)new in 20
added
key(Key2; "Vendor Ledger Entry No.", "Posting Date") { SumIndexFields = Amount, "Amount (LCY)"; }17-29changed in 20, 23, 28, 29
changed, was key(Key2; "Vendor Ledger Entry No.", "Posting Date") { SumIndexFields = Amount, "Amount (LCY)"; }

In 18 1 changed

field(3; "Entry Type"; Enum "Detailed CV Ledger Entry Type")17-29changed in 18
changed, was field(3; "Entry Type"; Option)