Table "Vendor Ledger Entry"

ID 25

Namespace: Microsoft.Purchases.Payables

Properties

Name	Value
Caption	Vendor Ledger Entry
DrillDownPageID	Page Microsoft.Purchases.Payables."Vendor Ledger Entries"
LookupPageID	Page Microsoft.Purchases.Payables."Vendor Ledger Entries"
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 No."	Code[20]	Specifies the number of the vendor account that the entry is linked to.
"Posting Date"	Date	Specifies the vendor entry's posting date.
"Document Type"	Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type"	Specifies the document type that the vendor entry belongs to.
"Document No."	Code[20]	Specifies the vendor entry's document number.
Description	Text[100]	Specifies a description of the vendor entry.
"Vendor Name"	Text[100]	Specifies the name of the vendor account that the entry is linked to.
"Currency Code"	Code[10]	Specifies the currency code for the amount on the line.
Amount	Decimal	Specifies the amount of the entry.
"Remaining Amount"	Decimal	Specifies the amount that remains to be applied to before the entry is totally applied to.
"Original Amt. (LCY)"	Decimal
"Remaining Amt. (LCY)"	Decimal
"Amount (LCY)"	Decimal
"Purchase (LCY)"	Decimal
"Inv. Discount (LCY)"	Decimal
"Buy-from Vendor No."	Code[20]
"Vendor Posting Group"	Code[20]	Specifies the vendor's market type to link business transactions to.
"Global Dimension 1 Code"	Code[20]	Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists.
"Global Dimension 2 Code"	Code[20]	Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists.
"Purchaser Code"	Code[20]	Specifies which purchaser is assigned to the vendor.
"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.
"On Hold"	Code[3]	Specifies that the related entry represents an unpaid invoice for which either a payment suggestion, a reminder, or a finance charge memo exists.
"Applies-to Doc. Type"	Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type"
"Applies-to Doc. No."	Code[20]
Open	Boolean	Specifies whether the amount on the entry has been fully paid or there is still a remaining amount that must be applied to.
"Due Date"	Date	Specifies the due date on the entry.
"Pmt. Discount Date"	Date	Specifies the date on which the amount in the entry must be paid for a payment discount to be granted.
"Original Pmt. Disc. Possible"	Decimal	Specifies the discount that you can obtain if the entry is applied to before the payment discount date.
"Pmt. Disc. Rcd.(LCY)"	Decimal
"Orig. Pmt. Disc. Possible(LCY)"	Decimal
Positive	Boolean	Specifies if the entry to be applied is positive.
"Closed by Entry No."	Integer
"Closed at Date"	Date	Specifies the date at which the vendor ledger entry was closed.
"Closed by Amount"	Decimal	Specifies the amount that the entry was finally applied to (closed) with.
"Applies-to ID"	Code[50]	Specifies the ID of entries that will be applied to when you choose the Apply Entries action.
"Journal Templ. Name"	Code[10]
"Journal Batch Name"	Code[10]
"Reason Code"	Code[10]	Specifies the reason code, a supplementary source code that enables you to trace the entry.
"Bal. Account Type"	Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Account Type"	Specifies the type of account that a balancing entry is posted to, such as BANK for a cash account.
"Bal. Account No."	Code[20]	Specifies the number of the general ledger, customer, vendor, or bank account that the balancing entry is posted to, such as a cash account for cash purchases.
"Transaction No."	Integer	Specifies the transaction number that groups related G/L entries from the same posting.
"Closed by Amount (LCY)"	Decimal
"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
"Document Date"	Date	Specifies the vendor entry's document date.
"External Document No."	Code[35]	Specifies a document number that refers to the customer's or vendor's numbering system.
"No. Series"	Code[20]
"Closed by Currency Code"	Code[10]	Specifies the currency code of the entry that was applied to (and closed) this vendor ledger entry.
"Closed by Currency Amount"	Decimal	Specifies the amount that was finally applied to (and closed) this vendor ledger entry.
"Adjusted Currency Factor"	Decimal
"Original Currency Factor"	Decimal
"Original Amount"	Decimal	Specifies the amount of the original entry.
"Date Filter"	Date
"Remaining Pmt. Disc. Possible"	Decimal	Specifies the remaining payment discount which can be received if the payment is made before the payment discount date.
"Pmt. Disc. Tolerance Date"	Date	Specifies the latest date the amount in the entry must be paid in order for payment discount tolerance to be granted.
"Max. Payment Tolerance"	Decimal	Specifies the maximum tolerated amount the entry can differ from the amount on the invoice or credit memo.
"Accepted Payment Tolerance"	Decimal
"Accepted Pmt. Disc. Tolerance"	Boolean
"Pmt. Tolerance (LCY)"	Decimal
"Amount to Apply"	Decimal	Specifies the amount to apply.
"IC Partner Code"	Code[20]	Specifies the code of the intercompany partner that the transaction is related to if the entry was created from an intercompany transaction.
"Applying Entry"	Boolean
Reversed	Boolean	Specifies if the entry has been part of a reverse transaction.
"Reversed by Entry No."	Integer	Specifies the number of the correcting entry that replaced the original entry in the reverse transaction.
"Reversed Entry No."	Integer	Specifies the number of the original entry that was undone by the reverse transaction.
Prepayment	Boolean
"G/L Register No."	Integer	Specifies the G/L register number that groups related G/L entries from the same posting.
"Creditor No."	Code[20]	Specifies the vendor who sent the purchase invoice.
"Payment Reference"	Code[50]	Specifies the payment of the purchase invoice.
"Payment Method Code"	Code[10]	Specifies how to make payment, such as with bank transfer, cash, or check.
"Applies-to Ext. Doc. No."	Code[35]
"Invoice Received Date"	Date	Specifies the date when the vendor's invoice was received.
"Recipient Bank Account"	Code[20]	Specifies the bank account to transfer the amount to.
"Message to Recipient"	Text[140]	Specifies the message exported to the payment file when you use the Export Payments to File function in the Payment Journal window.
"Exported to Payment File"	Boolean	Specifies that the entry was created as a result of exporting a payment journal line.
"Dimension Set ID"	Integer	Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table.
"Shortcut Dimension 3 Code"	Code[20]	Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window.
"Shortcut Dimension 4 Code"	Code[20]	Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window.
"Shortcut Dimension 5 Code"	Code[20]	Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window.
"Shortcut Dimension 6 Code"	Code[20]	Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window.
"Shortcut Dimension 7 Code"	Code[20]	Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window.
"Shortcut Dimension 8 Code"	Code[20]	Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window.
"Remit-to Code"	Code[20]	Specifies the address for the remit-to code.
"Dispute Status"	Code[10]	Specifies if there is an ongoing dispute for this document.
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,25,r)]
procedure GetLastEntryNo(): Integer

Returns

Type	Description
Integer

ShowDoc

procedure ShowDoc(): Boolean

Returns

Type	Description
Boolean

ShowPostedDocAttachment

procedure ShowPostedDocAttachment()

HasPostedDocAttachment

procedure HasPostedDocAttachment(): Boolean

Returns

Type	Description
Boolean

DrillDownOnEntries

procedure DrillDownOnEntries(var DtldVendLedgEntry: Record "Detailed Vendor Ledg. Entry")

Parameters

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

DrillDownOnOverdueEntries

procedure DrillDownOnOverdueEntries(var DtldVendLedgEntry: Record "Detailed Vendor Ledg. Entry")

Parameters

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

GetOriginalCurrencyFactor

procedure GetOriginalCurrencyFactor(): Decimal

Returns

Type	Description
Decimal

GetAdjustedCurrencyFactor

procedure GetAdjustedCurrencyFactor(): Decimal

Returns

Type	Description
Decimal

ShowDimensions

procedure ShowDimensions()

SetStyle

procedure SetStyle(): Text

Returns

Type	Description
Text

CopyFromGenJnlLine

procedure CopyFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")

Parameters

Name	Type	Description
GenJnlLine	Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"

CopyFromCVLedgEntryBuffer

procedure CopyFromCVLedgEntryBuffer(var CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer")

Parameters

Name	Type	Description
CVLedgerEntryBuffer	Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer"

RecalculateAmounts

procedure RecalculateAmounts(FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; PostingDate: Date)

Parameters

Name	Type	Description
FromCurrencyCode	Code[10]
ToCurrencyCode	Code[10]
PostingDate	Date

UpdateAmountsForApplication

procedure UpdateAmountsForApplication(ApplnDate: Date; ApplnCurrencyCode: Code[10]; RoundAmounts: Boolean; UpdateMaxPaymentTolerance: Boolean)

Parameters

Name	Type	Description
ApplnDate	Date
ApplnCurrencyCode	Code[10]
RoundAmounts	Boolean
UpdateMaxPaymentTolerance	Boolean

GetRemainingPmtDiscPossible

procedure GetRemainingPmtDiscPossible(ReferenceDate: Date): Decimal

Parameters

Name	Type	Description
ReferenceDate	Date

Returns

Type	Description
Decimal

Events

OnAfterCopyVendLedgerEntryFromGenJnlLine

[IntegrationEvent(False,False)]
local procedure OnAfterCopyVendLedgerEntryFromGenJnlLine(var VendorLedgerEntry: Record "Vendor Ledger Entry"; GenJournalLine: Record "Gen. Journal Line")

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
GenJournalLine	Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"

OnAfterCopyVendLedgerEntryFromCVLedgEntryBuffer

[IntegrationEvent(False,False)]
local procedure OnAfterCopyVendLedgerEntryFromCVLedgEntryBuffer(var VendorLedgerEntry: Record "Vendor Ledger Entry"; CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer")

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
CVLedgerEntryBuffer	Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer"

OnAfterRecalculateAmounts

[IntegrationEvent(False,False)]
local procedure OnAfterRecalculateAmounts(var VendorLedgerEntry: Record "Vendor Ledger Entry"; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; PostingDate: Date)

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
FromCurrencyCode	Code[10]
ToCurrencyCode	Code[10]
PostingDate	Date

OnValidateMaxPaymentToleranceBeforeError

[IntegrationEvent(False,False)]
local procedure OnValidateMaxPaymentToleranceBeforeError(var VendorLedgerEntry: Record "Vendor Ledger Entry")

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"

OnAfterShowDoc

[IntegrationEvent(False,False)]
local procedure OnAfterShowDoc(var VendorLedgerEntry: Record "Vendor Ledger Entry")

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"

OnAfterShowPostedDocAttachment

[IntegrationEvent(False,False)]
local procedure OnAfterShowPostedDocAttachment(var VendorLedgerEntry: Record "Vendor Ledger Entry")

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"

OnAfterHasPostedDocAttachment

[IntegrationEvent(False,False)]
local procedure OnAfterHasPostedDocAttachment(var VendorLedgerEntry: Record "Vendor Ledger Entry"; var HasPostedDocumentAttachment: Boolean)

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
HasPostedDocumentAttachment	Boolean

OnBeforeDrillDownEntries

[IntegrationEvent(False,False)]
local procedure OnBeforeDrillDownEntries(var VendorLedgerEntry: Record "Vendor Ledger Entry"; var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; var DrillDownPageID: Integer)

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
DetailedVendorLedgEntry	Table Microsoft.Purchases.Payables."Detailed Vendor Ledg. Entry"
DrillDownPageID	Integer

OnBeforeDrillDownOnOverdueEntries

[IntegrationEvent(True,False)]
local procedure OnBeforeDrillDownOnOverdueEntries(var VendorLedgerEntry: Record "Vendor Ledger Entry"; var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; var DrillDownPageID: Integer)

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
DetailedVendorLedgEntry	Table Microsoft.Purchases.Payables."Detailed Vendor Ledg. Entry"
DrillDownPageID	Integer

OnBeforeValidateMessagetoRecipient

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateMessagetoRecipient(var VendorLedgerEntry: Record "Vendor Ledger Entry"; var IsHandled: Boolean)

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
IsHandled	Boolean

OnBeforeShowDoc

[IntegrationEvent(False,False)]
local procedure OnBeforeShowDoc(var VendorLedgerEntry: Record "Vendor Ledger Entry"; var Result: Boolean; var IsHandled: Boolean)

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
Result	Boolean
IsHandled	Boolean

OnBeforeSetStyle

[IntegrationEvent(True,False)]
local procedure OnBeforeSetStyle(var Result: Text; var IsHandled: Boolean)

Parameters

Name	Type	Description
Result	Text
IsHandled	Boolean

OnAfterUpdateAmountsForApplication

[IntegrationEvent(False,False)]
local procedure OnAfterUpdateAmountsForApplication(var VendorLedgerEntry: Record "Vendor Ledger Entry"; ApplnDate: Date; ApplnCurrencyCode: Code[10]; RoundAmounts: Boolean; UpdateMaxPaymentTolerance: Boolean)

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
ApplnDate	Date
ApplnCurrencyCode	Code[10]
RoundAmounts	Boolean
UpdateMaxPaymentTolerance	Boolean

OnAfterGetRemainingPmtDiscPossible

[IntegrationEvent(False,False)]
local procedure OnAfterGetRemainingPmtDiscPossible(VendorLedgerEntry: Record "Vendor Ledger Entry"; ReferenceDate: Date; var RemainingPmtDiscPossible: Decimal)

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
ReferenceDate	Date
RemainingPmtDiscPossible	Decimal

OnBeforeRecalculateAmounts

[IntegrationEvent(False,False)]
local procedure OnBeforeRecalculateAmounts(var VendorLedgerEntry: Record "Vendor Ledger Entry"; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; PostingDate: Date; var IsHandled: Boolean)

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
FromCurrencyCode	Code[10]
ToCurrencyCode	Code[10]
PostingDate	Date
IsHandled	Boolean

OnBeforeUpdateAmountsForApplication

[IntegrationEvent(False,False)]
local procedure OnBeforeUpdateAmountsForApplication(var VendorLedgerEntry: Record "Vendor Ledger Entry"; ApplnDate: Date; ApplnCurrencyCode: Code[10]; RoundAmounts: Boolean; UpdateMaxPaymentTolerance: Boolean; var IsHandled: Boolean)

Parameters

Name	Type	Description
VendorLedgerEntry	Table Microsoft.Purchases.Payables."Vendor Ledger Entry"
ApplnDate	Date
ApplnCurrencyCode	Code[10]
RoundAmounts	Boolean
UpdateMaxPaymentTolerance	Boolean
IsHandled	Boolean

See also

• Table