Vendor Ledger Entry

    API Details

    Property Value
    Endpoint /tablesFinance/vendorLedgerEntries
    Table name Vendor Ledger Entry
    Table id 25
    Table caption Vendor Ledger Entry
    Data per company True
    Group Finance

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    entryNo Entry No. Integer 4 *
    vendorNo Vendor No. Code 20 Vendor
    postingDate Posting Date Date 4
    documentType Document Type Option 4 , Payment, Invoice, Credit Memo, Finance Charge Memo, Reminder, Refund, Storno, Arrangement, Arrangement Term
    documentNo Document No. Code 20
    description Description Text 100
    vendorName Vendor Name Text 100
    currencyCode Currency Code Code 10 Currency
    purchaseLCY Purchase (LCY) Decimal 12
    invDiscountLCY Inv. Discount (LCY) Decimal 12
    buyfromVendorNo Buy-from Vendor No. Code 20 Vendor
    vendorPostingGroup Vendor Posting Group Code 20 Vendor Posting Group
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    purchaserCode Purchaser Code Code 20 Salesperson/Purchaser
    userID User ID Code 50 User
    sourceCode Source Code Code 10 Source Code
    onHold On Hold Code 3 On Hold Code
    appliestoDocType Applies-to Doc. Type Option 4 , Payment, Invoice, Credit Memo, Finance Charge Memo, Reminder, Refund, Storno, Arrangement, Arrangement Term
    appliestoDocNo Applies-to Doc. No. Code 20
    open Open Boolean 4
    dueDate Due Date Date 4
    pmtDiscountDate Pmt. Discount Date Date 4
    originalPmtDiscPossible Original Pmt. Disc. Possible Decimal 12
    pmtDiscRcdLCY Pmt. Disc. Rcd.(LCY) Decimal 12
    origPmtDiscPossibleLCY Org. Pmt. Disc. Possible (LCY) Decimal 12
    positive Positive Boolean 4
    closedByEntryNo Closed by Entry No. Integer 4 Vendor Ledger Entry
    closedAtDate Closed at Date Date 4
    closedByAmount Closed by Amount Decimal 12
    appliestoID Applies-to ID Code 50
    journalTemplName Journal Template Name Code 10
    journalBatchName Journal Batch Name Code 10
    reasonCode Reason Code Code 10 Reason Code
    balAccountType Bal. Account Type Option 4 G/L Account, Customer, Vendor, Bank Account, Fixed Asset, IC Partner, Employee, Allocation Account
    balAccountNo Bal. Account No. Code 20
    transactionNo Transaction No. Integer 4
    closedByAmountLCY Closed by Amount (LCY) Decimal 12
    documentDate Document Date Date 4
    externalDocumentNo External Document No. Code 35
    noSeries No. Series Code 20 No. Series
    closedByCurrencyCode Closed by Currency Code Code 10 Currency
    closedByCurrencyAmount Closed by Currency Amount Decimal 12
    adjustedCurrencyFactor Adjusted Currency Factor Decimal 12
    originalCurrencyFactor Original Currency Factor Decimal 12
    remainingPmtDiscPossible Remaining Pmt. Disc. Possible Decimal 12
    pmtDiscToleranceDate Pmt. Disc. Tolerance Date Date 4
    maxPaymentTolerance Max. Payment Tolerance Decimal 12
    acceptedPaymentTolerance Accepted Payment Tolerance Decimal 12
    acceptedPmtDiscTolerance Accepted Pmt. Disc. Tolerance Boolean 4
    pmtToleranceLCY Pmt. Tolerance (LCY) Decimal 12
    amountToApply Amount to Apply Decimal 12
    icPartnerCode IC Partner Code Code 20 IC Partner
    applyingEntry Applying Entry Boolean 4
    reversed Reversed Boolean 4
    reversedByEntryNo Reversed by Entry No. Integer 4 Vendor Ledger Entry
    reversedEntryNo Reversed Entry No. Integer 4 Vendor Ledger Entry
    prepayment Prepayment Boolean 4
    creditorNo Creditor No. Code 20
    paymentReference Payment Reference Code 50
    paymentMethodCode Payment Method Code Code 10 Payment Method
    appliestoExtDocNo Applies-to Ext. Doc. No. Code 35
    invoiceReceivedDate Invoice Received Date Date 4
    recipientBankAccount Recipient Bank Account Code 20
    messageToRecipient Message to Recipient Text 140
    exportedToPaymentFile Exported to Payment File Boolean 4
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    remittoCode Remit-to Code Code 20
    factuursoort Invoice Type Option 4 , Onderhoud, Prolongatie, Afrekening, , , , , , , , , , , , , , , Verkoop, Terugkoop
    eenheidnr Realty Object No. Code 20 OGE
    clusternr Cluster No. Code 20 Cluster
    huisnr House No. Code 20
    toevoegsel Addition Code 20
    bedragNaarGrekening Amount to B-Account Decimal 12
    restbedragGrekening Remaining Amount B-account Decimal 12
    commitment Commitment Boolean 4
    disReferenceNo DIS Reference No. Code 50
    transactionModeCode Transaction Mode Code Code 20
    bAccount B-Account Boolean 4
    amountInclBAccount Amount incl. B-Account Decimal 12
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8