Table "Detailed Vendor Ledg. Entry"

ID 380

Namespace: Microsoft.Purchases.Payables

Properties

Name	Value
Caption	Detailed Vendor Ledg. Entry
DataCaptionFields	9
DrillDownPageID	Page Microsoft.Purchases.Payables."Detailed Vendor Ledg. Entries"
LookupPageID	Page Microsoft.Purchases.Payables."Detailed Vendor Ledg. Entries"
Permissions	TableData "Detailed Vendor Ledg. Entry" = m
DataClassification	CustomerContent

Fields

Name	Type	Description
"Entry No."	Integer	Specifies the number of the entry, as assigned from the specified number series when the entry was created.
"Vendor Ledger Entry No."	Integer	Specifies the entry number of the vendor ledger entry that the detailed vendor ledger entry line was created for.
"Entry Type"	Enum Microsoft.Finance.ReceivablesPayables."Detailed CV Ledger Entry Type"	Specifies the entry type of the detailed vendor ledger entry.
"Posting Date"	Date	Specifies the posting date of the detailed vendor ledger entry.
"Document Type"	Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type"	Specifies the document type of the detailed vendor ledger entry.
"Document No."	Code[20]	Specifies the document number of the transaction that created the entry.
Amount	Decimal	Specifies the amount of the detailed vendor ledger entry.
"Amount (LCY)"	Decimal
"Vendor No."	Code[20]	Specifies the number of the vendor account to which the entry is posted.
"Currency Code"	Code[10]	Specifies the code for the currency if the amount is in a foreign currency.
"User ID"	Code[50]	Specifies the ID of the user who posted the entry, to be used, for example, in the change log.
"Source Code"	Code[10]	Specifies the source code that specifies where the entry was created.
"Transaction No."	Integer	Specifies the transaction number that groups related G/L entries from the same posting.
"Journal Batch Name"	Code[10]
"Reason Code"	Code[10]	Specifies the reason code, a supplementary source code that enables you to trace the entry.
"Debit Amount"	Decimal	Specifies the total of the ledger entries that represent debits.
"Credit Amount"	Decimal	Specifies the total of the ledger entries that represent credits.
"Debit Amount (LCY)"	Decimal
"Credit Amount (LCY)"	Decimal
"Initial Entry Due Date"	Date	Specifies the date on which the initial entry is due for payment.
"Initial Entry Global Dim. 1"	Code[20]	Specifies the Global Dimension 1 code of the initial vendor ledger entry.
"Initial Entry Global Dim. 2"	Code[20]	Specifies the Global Dimension 2 code of the initial vendor ledger entry.
"Gen. Bus. Posting Group"	Code[20]
"Gen. Prod. Posting Group"	Code[20]
"Use Tax"	Boolean
"VAT Bus. Posting Group"	Code[20]
"VAT Prod. Posting Group"	Code[20]
"Initial Document Type"	Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type"	Specifies the document type that the initial vendor ledger entry was created with.
"Applied Vend. Ledger Entry No."	Integer
Unapplied	Boolean	Specifies whether the entry has been unapplied (undone) from the Unapply Vendor Entries window by the entry no. shown in the Unapplied by Entry No. field.
"Unapplied by Entry No."	Integer	Specifies the number of the correcting entry, if the original entry has been unapplied (undone) from the Unapply Vendor Entries window.
"Remaining Pmt. Disc. Possible"	Decimal
"Max. Payment Tolerance"	Decimal
"Tax Jurisdiction Code"	Code[10]
"Application No."	Integer
"Ledger Entry Amount"	Boolean
"Posting Group"	Code[20]	Specifies the vendor's market type to link business transactions to.
"Exch. Rate Adjmt. Reg. No."	Integer
"G/L Register No."	Integer	Specifies the G/L register number that groups related G/L entries from the same posting.
"Excluded from calculation"	Boolean
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemCreatedByUserName	Text[50]
SystemCreatedByFullName	Text[80]
SystemModifiedByUserName	Text[50]
SystemModifiedByFullName	Text[80]
SystemRowVersion	BigInteger

Methods

GetLastEntryNo

[InherentPermissions(TableData,380,r)]
procedure GetLastEntryNo(): Integer

Returns

Type	Description
Integer

UpdateDebitCredit

procedure UpdateDebitCredit(Correction: Boolean)

Parameters

Name	Type	Description
Correction	Boolean

SetZeroTransNo

procedure SetZeroTransNo(TransactionNo: Integer)

Parameters

Name	Type	Description
TransactionNo	Integer

GetUnrealizedGainLossAmount

procedure GetUnrealizedGainLossAmount(EntryNo: Integer): Decimal

Parameters

Name	Type	Description
EntryNo	Integer

Returns

Type	Description
Decimal

Events

OnAfterUpdateDebitCredit

[IntegrationEvent(False,False)]
local procedure OnAfterUpdateDebitCredit(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; Correction: Boolean)

Parameters

Name	Type	Description
DetailedVendorLedgEntry	Table Microsoft.Purchases.Payables."Detailed Vendor Ledg. Entry"
Correction	Boolean

OnBeforeSetLedgerEntryAmount

[IntegrationEvent(False,False)]
local procedure OnBeforeSetLedgerEntryAmount(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; var IsHandled: Boolean)

Parameters

Name	Type	Description
DetailedVendorLedgEntry	Table Microsoft.Purchases.Payables."Detailed Vendor Ledg. Entry"
IsHandled	Boolean

OnSetZeroTransNoOnBeforeDetailedVendorLedgEntryModify

[IntegrationEvent(False,False)]
local procedure OnSetZeroTransNoOnBeforeDetailedVendorLedgEntryModify(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry")

Parameters

Name	Type	Description
DetailedVendorLedgEntry	Table Microsoft.Purchases.Payables."Detailed Vendor Ledg. Entry"

See also

• Table