Table 379 Detailed Cust. Ledg. Entry

Base Application, Microsoft.Sales.Receivables

Fields 40 in 29.0, DE

1Entry No.Integer17-29
2Cust. Ledger Entry No.Integer17-29
3Entry TypeEnum "Detailed CV Ledger Entry Type"17-29changed in 18
4Posting DateDate17-29
5Document TypeEnum "Gen. Journal Document Type"17-29
6Document No.Code[20]17-29
7AmountDecimal17-29
8Amount (LCY)Decimal17-29
9Customer No.Code[20]17-29

All 40 fields

Events 3 in 29.0, DE

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

Public procedures 4 in 29.0, DE

GetLastEntryNo(): Integer17-29
UpdateDebitCredit(Correction: Boolean)17-29
SetZeroTransNo(TransactionNo: Integer)17-29
GetUnrealizedGainLossAmount(EntryNo: Integer): Decimal17-29

Trigger events 10

OnBeforeInsertEvent(var Rec: Record "Detailed Cust. Ledg. Entry"; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record "Detailed Cust. Ledg. Entry"; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record "Detailed Cust. Ledg. Entry"; var xRec: Record "Detailed Cust. Ledg. Entry"; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record "Detailed Cust. Ledg. Entry"; var xRec: Record "Detailed Cust. Ledg. Entry"; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record "Detailed Cust. Ledg. Entry"; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record "Detailed Cust. Ledg. Entry"; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record "Detailed Cust. Ledg. Entry"; var xRec: Record "Detailed Cust. Ledg. Entry"; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record "Detailed Cust. Ledg. Entry"; var xRec: Record "Detailed Cust. Ledg. Entry"; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record "Detailed Cust. Ledg. Entry"; var xRec: Record "Detailed Cust. Ledg. Entry"; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record "Detailed Cust. Ledg. Entry"; var xRec: Record "Detailed Cust. Ledg. Entry"; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 5 in 29.0

List17181920212223242526272829
Fields122
Keys22273
Events12
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)"; }

All 5 changes in 29.0, DE