Detailed Cust. Ledg. Entry

    API Details

    Property Value
    Endpoint /tablesFinance/detailedCustLedgEntries
    Table name Detailed Cust. Ledg. Entry
    Table id 379
    Table caption Detailed Cust. Ledg. 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 *
    custLedgerEntryNo Cust. Ledger Entry No. Integer 4 Cust. Ledger Entry
    entryType Entry Type Option 4 , Initial Entry, Application, Unrealized Loss, Unrealized Gain, Realized Loss, Realized Gain, Payment Discount, Payment Discount (VAT Excl.), Payment Discount (VAT Adjustment), Appln. Rounding, Correction of Remaining Amount, Payment Tolerance, Payment Discount Tolerance, Payment Tolerance (VAT Excl.), Payment Tolerance (VAT Adjustment), Payment Discount Tolerance (VAT Excl.), Payment Discount Tolerance (VAT Adjustment), Payment Arrangement
    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
    amount Amount Decimal 12
    amountLCY Amount (LCY) Decimal 12
    customerNo Customer No. Code 20 Customer
    currencyCode Currency Code Code 10 Currency
    userID User ID Code 50 User
    sourceCode Source Code Code 10 Source Code
    transactionNo Transaction No. Integer 4
    journalBatchName Journal Batch Name Code 10
    reasonCode Reason Code Code 10 Reason Code
    debitAmount Debit Amount Decimal 12
    creditAmount Credit Amount Decimal 12
    debitAmountLCY Debit Amount (LCY) Decimal 12
    creditAmountLCY Credit Amount (LCY) Decimal 12
    initialEntryDueDate Initial Entry Due Date Date 4
    initialEntryGlobalDim1 Initial Entry Global Dim. 1 Code 20
    initialEntryGlobalDim2 Initial Entry Global Dim. 2 Code 20
    genBusPostingGroup Gen. Bus. Posting Group Code 20 Gen. Business Posting Group
    genProdPostingGroup Gen. Prod. Posting Group Code 20 Gen. Product Posting Group
    useTax Use Tax Boolean 4
    vatBusPostingGroup VAT Bus. Posting Group Code 20 VAT Business Posting Group
    vatProdPostingGroup VAT Prod. Posting Group Code 20 VAT Product Posting Group
    initialDocumentType Initial Document Type Option 4 , Payment, Invoice, Credit Memo, Finance Charge Memo, Reminder, Refund, Storno, Arrangement, Arrangement Term
    appliedCustLedgerEntryNo Applied Cust. Ledger Entry No. Integer 4
    unapplied Unapplied Boolean 4
    unappliedByEntryNo Unapplied by Entry No. Integer 4 Detailed Cust. Ledg. Entry
    remainingPmtDiscPossible Remaining Pmt. Disc. Possible Decimal 12
    maxPaymentTolerance Max. Payment Tolerance Decimal 12
    taxJurisdictionCode Tax Jurisdiction Code Code 10 Tax Jurisdiction
    applicationNo Application No. Integer 4
    ledgerEntryAmount Ledger Entry Amount Boolean 4
    postingGroup Customer Posting Group Code 20 Customer Posting Group
    exchRateAdjmtRegNo Exch. Rate Adjmt. Reg. No. Integer 4 Exch. Rate Adjmt. Reg.
    factuursoort Invoice Subject Option 4 , Diversen, Beheer, S&V-kosten, Prolongatie, , , , , , Verkoop
    eenheidnr Realty Object No. Code 20
    contractvolgnr Contract No. Integer 4
    clusternr Cluster No. Code 20
    arrangementCode Arrangement Code Code 20
    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