Table 379 Detailed Cust. Ledg. Entry

Base Application, Microsoft.Sales.Receivables

15 keys

KeyVersions
key(Key1; "Entry No.") { Clustered = true; }17-29
key(Key2; "Customer No.", "Currency Code", "Excluded from calculation") { SumIndexFields = Amount, "Amount (LCY)"; }17-29changed in 28, 29
key(Key3; "Cust. Ledger Entry No.", "Entry Type", "Posting Date") { IncludedFields = "Ledger Entry Amount", Amount, "Amount (LCY)", "Debit Amount", "Debit Amount (LCY)", "Credit Amount", "Credit Amount (LCY)"; }17-29changed in 18, 28
key(Key4; "Ledger Entry Amount", "Cust. Ledger Entry No.", "Posting Date") { IncludedFields = Amount, "Amount (LCY)", "Debit Amount", "Debit Amount (LCY)", "Credit Amount", "Credit Amount (LCY)"; }gone after 24changed in 23
key(Key5; "Initial Document Type", "Entry Type", "Customer 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; "Customer 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 Cust. Ledger Entry No.", "Entry Type")17-29
key(Key9; "Transaction No.", "Customer No.", "Entry Type")17-29
key(Key10; "Application No.", "Customer No.", "Entry Type")17-29
key(Key11; "Customer No.", "Entry Type", "Posting Date", "Initial Document Type") { IncludedFields = Amount, "Amount (LCY)", "Debit Amount", "Debit Amount (LCY)", "Credit Amount", "Credit Amount (LCY)"; }17-29changed in 25, 28
key(Key12; "Document Type") { SumIndexFields = "Amount (LCY)"; }17-29
key(Key13; "Initial Document Type", "Initial Entry Due Date") { SumIndexFields = "Amount (LCY)"; }17-29
key(Key14; "Customer No.", "Initial Entry Due Date") { IncludedFields = Amount, "Amount (LCY)", "Excluded from calculation"; }17-29changed in 28, 29
key(Key17; "Cust. Ledger Entry No.", "Posting Date", "Ledger Entry Amount") { IncludedFields = Amount, "Amount (LCY)", "Debit Amount", "Debit Amount (LCY)", "Credit Amount", "Credit Amount (LCY)"; }18 to 27changed in 23