Table 380 Detailed Vendor Ledg. Entry

Base Application, Microsoft.Purchases.Payables

12 keys

KeyVersions
key(Key1; "Entry No.") { Clustered = true; }17-29
key(Key2; "Vendor No.", "Currency Code", "Excluded from calculation") { SumIndexFields = Amount, "Amount (LCY)"; }17-29changed in 20, 23, 28, 29
key(Key3; "Vendor Ledger Entry No.", "Entry Type", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; }17-29changed in 23
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
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
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
key(Key7; "Document No.", "Document Type", "Posting Date")17-29
key(Key8; "Applied Vend. Ledger Entry No.", "Entry Type")17-29
key(Key9; "Transaction No.", "Vendor No.", "Entry Type")17-29
key(Key10; "Application No.", "Vendor No.", "Entry Type")17-29
key(Key11; "Initial Document Type", "Initial Entry Due Date") { SumIndexFields = "Amount (LCY)"; }17-29
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