Table 379 Detailed Cust. Ledg. Entry

Base Application, Microsoft.Sales.Receivables

Source AL, 568 lines

src/Layers/W1/BaseApp/Sales/Receivables/DetailedCustLedgEntry.Table.allines 24 to 39 of 568, Copyright (c) Microsoft Corporation. MIT

table 379 "Detailed Cust. Ledg. Entry"{    Caption = 'Detailed Cust. Ledg. Entry';    DataCaptionFields = "Customer No.";    DrillDownPageID = "Detailed Cust. Ledg. Entries";    LookupPageID = "Detailed Cust. Ledg. Entries";    Permissions = TableData "Detailed Cust. Ledg. Entry" = m;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Specifies the unique sequential number assigned to this detailed customer ledger entry.        /// </summary>        field(1; "Entry No."; Integer)        {

All 568 lines

Fields 40 in 29

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

[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

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

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 24 changes in 17-29