Table 25 Vendor Ledger Entry

Base Application, Microsoft.Purchases.Payables

17 keys

KeyVersions
key(Key1; "Entry No.") { Clustered = true; }17-29
key(Key2; "Vendor No.", "Currency Code") { SumIndexFields = "Purchase (LCY)", "Inv. Discount (LCY)"; }17-29changed in 28
key(Key3; "Vendor No.", "Currency Code", "Posting Date") { IncludedFields = "Purchase (LCY)", "Inv. Discount (LCY)"; }17-29changed in 28
key(Key4; "Document No.")17-29
key(Key5; "External Document No.")17-29
key(Key6; "Vendor No.", Open, Positive, "Due Date", "Currency Code")17-29
key(Key7; Open, "Due Date")17-29
key(Key9; "Closed by Entry No.")17-29
key(Key10; "Transaction No.")17-29
key(Key11; "Vendor No.", "Global Dimension 1 Code", "Global Dimension 2 Code", "Posting Date", "Currency Code") { IncludedFields = "Purchase (LCY)", "Inv. Discount (LCY)"; }17-29changed in 28
key(Key15; "Vendor No.", "Applies-to ID", Open, Positive, "Due Date")17-29
key(Key16; "Vendor Posting Group")17-29
key(Key17; "Pmt. Discount Date")17-29
key(Key18; "Document Type", "Due Date", Open)17-29
key(Key25; "Vendor No.", "Posting Date", "Applies-to ID") { IncludedFields = "Currency Code", "Amount to Apply", Open; }new in 19
key(Key26; "Applies-to ID") { IncludedFields = "Accepted Payment Tolerance"; }new in 25
key(PmtReconCandidates; "Document Type", Open, "Posting Date")new in 29