Table 379 Detailed Cust. Ledg. Entry

Base Application, Microsoft.Sales.Receivables
List17181920212223242526272829
Fields122
Keys22273
Events12

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; "Customer No.", "Currency Code", "Excluded from calculation") { SumIndexFields = Amount, "Amount (LCY)"; }17-29changed in 28, 29
changed, was key(Key2; "Customer No.", "Currency Code") { SumIndexFields = Amount, "Amount (LCY)"; }
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
changed, was key(Key6; "Customer No.", "Currency Code", "Initial Entry Global Dim. 1", "Initial Entry Global Dim. 2", "Initial Entry Due Date", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; }
key(Key14; "Customer No.", "Initial Entry Due Date") { IncludedFields = Amount, "Amount (LCY)", "Excluded from calculation"; }17-29changed in 28, 29
changed, was key(Key14; "Customer No.", "Initial Entry Due Date") { IncludedFields = Amount, "Amount (LCY)"; }

In 28 6 changed, 1 gone

key(Key2; "Customer No.", "Currency Code") { SumIndexFields = Amount, "Amount (LCY)"; }17-29changed in 28, 29
changed, was key(Key2; "Cust. Ledger Entry No.", "Posting Date") { SumIndexFields = Amount, "Amount (LCY)"; }
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
changed, was 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)"; }
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
changed, was 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)"; SumIndexFields = Amount, "Amount (LCY)"; }
key(Key6; "Customer 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; "Customer 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(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
changed, was 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)"; SumIndexFields = Amount, "Amount (LCY)", "Debit Amount", "Debit Amount (LCY)", "Credit Amount", "Credit Amount (LCY)"; }
key(Key14; "Customer No.", "Initial Entry Due Date") { IncludedFields = Amount, "Amount (LCY)"; }17-29changed in 28, 29
changed, was key(Key14; "Customer No.", "Initial Entry Due Date") { IncludedFields = Amount, "Amount (LCY)", "Excluded from calculation"; SumIndexFields = Amount, "Amount (LCY)"; }
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
gone

In 25 1 gone, 1 changed

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
gone
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)"; SumIndexFields = Amount, "Amount (LCY)", "Debit Amount", "Debit Amount (LCY)", "Credit Amount", "Credit Amount (LCY)"; }17-29changed in 25, 28
changed, was 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)"; SumIndexFields = Amount, "Amount (LCY)"; }

In 23 2 changed

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
changed, was 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)"; SumIndexFields = Amount, "Amount (LCY)", "Debit Amount", "Debit Amount (LCY)", "Credit Amount", "Credit Amount (LCY)"; }
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
changed, was 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)"; SumIndexFields = Amount, "Amount (LCY)", "Debit Amount", "Debit Amount (LCY)", "Credit Amount", "Credit Amount (LCY)"; }

In 22 2 added

[IntegrationEvent] OnAfterUpdateDebitCredit(var DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry"; Correction: Boolean)new in 22
added
[IntegrationEvent] OnSetZeroTransNoOnBeforeDetailedCustLedgEntryModify(var DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry")new in 22
added

In 21 1 added

[IntegrationEvent] OnBeforeSetLedgerEntryAmount(var DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry"; var IsHandled: Boolean)new in 21
added

In 20 2 added

field(44; "Posting Group"; Code[20])new in 20
added
field(45; "Exch. Rate Adjmt. Reg. No."; Integer)new in 20
added

In 18 2 changed, 1 added

field(3; "Entry Type"; Enum "Detailed CV Ledger Entry Type")17-29changed in 18
changed, was field(3; "Entry Type"; Option)
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
changed, was 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)"; SumIndexFields = Amount, "Amount (LCY)"; }
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)"; SumIndexFields = Amount, "Amount (LCY)", "Debit Amount", "Debit Amount (LCY)", "Credit Amount", "Credit Amount (LCY)"; }18 to 27changed in 23
added