Table 21 Cust. Ledger Entry

Base Application, Microsoft.Sales.Receivables

26 keys

KeyVersions
key(Key1; "Entry No.") { Clustered = true; }17-29
key(Key2; "Customer No.", "Currency Code") { SumIndexFields = "Sales (LCY)", "Profit (LCY)", "Inv. Discount (LCY)"; }17-29changed in 28
key(Key3; "Customer No.", "Currency Code", "Posting Date") { Enabled = false; }gone after 21
key(Key4; "Document No.")17-29
key(Key5; "External Document No.")17-29
key(Key6; "Customer No.", Open, Positive, "Due Date", "Currency Code")17-29
key(Key7; Open, "Due Date")17-29
key(Key8; "Customer No.", "Document Type", "Posting Date", "Currency Code") { IncludedFields = "Sales (LCY)", "Profit (LCY)", "Inv. Discount (LCY)"; }17-29changed in 28
key(Key9; "Salesperson Code", "Posting Date")17-29
key(Key10; "Closed by Entry No.")17-29
key(Key11; "Transaction No.")17-29
key(Key12; "Customer No.", Open, Positive, "Calculate Interest", "Due Date") { Enabled = false; }gone after 21
key(Key13; "Customer No.", "Global Dimension 1 Code", "Global Dimension 2 Code", "Posting Date", "Currency Code") { Enabled = false; SumIndexFields = "Sales (LCY)", "Profit (LCY)", "Inv. Discount (LCY)"; }gone after 21
key(Key14; "Customer No.", Open, "Global Dimension 1 Code", "Global Dimension 2 Code", Positive, "Due Date", "Currency Code") { Enabled = false; }gone after 21
key(Key15; Open, "Global Dimension 1 Code", "Global Dimension 2 Code", "Due Date") { Enabled = false; }gone after 21
key(Key16; "Document Type", "Customer No.", "Global Dimension 1 Code", "Global Dimension 2 Code", "Posting Date", "Currency Code") { Enabled = false; }gone after 21
key(Key17; "Customer No.", "Applies-to ID", Open, Positive, "Due Date")17-29
key(Key18; "Document Type", "Posting Date") { SumIndexFields = "Sales (LCY)"; }17-29
key(Key19; "Document Type", "Customer No.", Open, "Due Date")17-29
key(Key20; "Customer Posting Group")17-29
key(Key21; "Document Type", Open, "Posting Date", "Closed at Date")17-29
key(Key22; "Salesperson Code")17-29
key(Key23; SystemModifiedAt)17-29
key(Key35; "Customer No.", "Posting Date", "Applies-to ID") { IncludedFields = "Currency Code", "Amount to Apply", Open; }new in 19
key(Key36; "Document Type", Reversed, "Posting Date") { IncludedFields = "Customer No.", Open, "Sales (LCY)"; }new in 22
key(Key37; "Applies-to ID") { IncludedFields = "Accepted Payment Tolerance"; }new in 25