Table 380 Detailed Vendor Ledg. Entry

Base Application, Microsoft.Purchases.Payables

Fields 40 in 29.0, US

1Entry No.Integer17-29
2Vendor 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
9Vendor No.Code[20]17-29

All 40 fields

Events 3 in 29.0, US

[IntegrationEvent] OnAfterUpdateDebitCredit(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; Correction: Boolean)new in 22
[IntegrationEvent] OnSetZeroTransNoOnBeforeDetailedVendorLedgEntryModify(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry")new in 22
[IntegrationEvent] OnBeforeSetLedgerEntryAmount(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; var IsHandled: Boolean)new in 24

Public procedures 4 in 29.0, US

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 Vendor Ledg. Entry"; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record "Detailed Vendor Ledg. Entry"; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record "Detailed Vendor Ledg. Entry"; var xRec: Record "Detailed Vendor Ledg. Entry"; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record "Detailed Vendor Ledg. Entry"; var xRec: Record "Detailed Vendor Ledg. Entry"; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record "Detailed Vendor Ledg. Entry"; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record "Detailed Vendor Ledg. Entry"; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record "Detailed Vendor Ledg. Entry"; var xRec: Record "Detailed Vendor Ledg. Entry"; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record "Detailed Vendor Ledg. Entry"; var xRec: Record "Detailed Vendor Ledg. Entry"; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record "Detailed Vendor Ledg. Entry"; var xRec: Record "Detailed Vendor Ledg. Entry"; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record "Detailed Vendor Ledg. Entry"; var xRec: Record "Detailed Vendor Ledg. Entry"; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 5 in 29.0

List17181920212223242526272829
Fields122
Keys14153
Events21
field(95; "G/L Register No."; Integer)new in 29
added
field(7000004; "Excluded from calculation"; Boolean)new in 29
added
key(Key2; "Vendor No.", "Currency Code", "Excluded from calculation") { SumIndexFields = Amount, "Amount (LCY)"; }17-29changed in 20, 23, 28, 29
changed, was key(Key2; "Vendor No.", "Currency Code") { SumIndexFields = Amount, "Amount (LCY)"; }
key(Key4; "Vendor Ledger Entry No.", "Ledger Entry Amount", "Posting Date", "Excluded from calculation") { IncludedFields = "Currency Code", Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }17-29changed in 23, 28, 29
changed, was key(Key4; "Vendor Ledger Entry No.", "Ledger Entry Amount", "Posting Date") { IncludedFields = "Currency Code", Amount, "Amount (LCY)", "Debit Amount", "Credit Amount", "Debit Amount (LCY)", "Credit Amount (LCY)"; }
key(Key6; "Vendor 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; "Vendor No.", "Currency Code", "Initial Entry Global Dim. 1", "Initial Entry Global Dim. 2", "Initial Entry Due Date", "Posting Date") { IncludedFields = Amount, "Amount (LCY)"; }

All 5 changes in 29.0, US