Cust. Ledger Entry

    API Details

    Property Value
    Endpoint /tablesFinance/custLedgerEntries
    Table name Cust. Ledger Entry
    Table id 21
    Table caption Cust. 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 *
    customerNo Customer No. Code 20 Customer
    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
    customerName Customer Name Text 100
    yourReference Your Reference Text 35
    currencyCode Currency Code Code 10 Currency
    salesLCY Sales (LCY) Decimal 12
    profitLCY Profit (LCY) Decimal 12
    invDiscountLCY Inv. Discount (LCY) Decimal 12
    selltoCustomerNo Sell-to Customer No. Code 20 Customer
    customerPostingGroup Customer Posting Group Code 20 Customer Posting Group
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    salespersonCode Salesperson 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
    pmtDiscGivenLCY Pmt. Disc. Given (LCY) Decimal 12
    origPmtDiscPossibleLCY Orig. Pmt. Disc. Possible (LCY) Decimal 12
    positive Positive Boolean 4
    closedByEntryNo Closed by Entry No. Integer 4 Cust. 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
    calculateInterest Calculate Interest Boolean 4
    closingInterestCalculated Closing Interest Calculated Boolean 4
    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
    lastIssuedReminderLevel Last Issued Reminder Level Integer 4
    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 Cust. Ledger Entry
    reversedEntryNo Reversed Entry No. Integer 4 Cust. Ledger Entry
    prepayment Prepayment Boolean 4
    paymentReference Payment Reference Code 50
    paymentMethodCode Payment Method Code Code 10 Payment Method
    appliestoExtDocNo Applies-to Ext. Doc. No. Code 35
    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
    directDebitMandateID Direct Debit Mandate ID Code 35
    factuursoort Invoice Subject Option 4 , Diversen, Beheer, S&V-kosten, Prolongatie, , , , , , Verkoop
    betalingsregeling Payment Scheme Code 20 Payment Scheme
    eenheidnr Object No. Code 20 OGE
    contractvolgnr Contract Entry No. Integer 4
    clusternr Cluster No. Code 20 Cluster
    huisnr House No. Code 20
    toevoegsel Addition Code 20
    vooruitbetaling Prepayment Inv. Boolean 4
    gedeeldeFactuur Shared Invoice Boolean 4
    stornobrief Repay Document Date 4
    weigeringsbedrag Amount Refused Decimal 12
    eersteFactuur First Invoice Boolean 4
    soortContract Invoice Option Option 4 , Huur, Erfpacht, , Onderh.tlv huurder, Onderh.tlv derden, 1e verhuurnota
    gestorneerdDoorVolgnr Corrected by Entry No. Integer 4
    arrangementCode Payment Scheme Code Code 20 Payment Scheme
    awaitSetupEntryNo On Hold Code Setup Entry No. Integer 4
    woningzoekendenr Prospect No. Code 20
    disReferenceNo DIS Reference No. Code 50
    transactionModeCode Transaction Mode Code Code 20
    clonedCustomerLedgerEntry Cloned Customer Ledger Entry Option 4 , Cloned Payment Scheme, Cloned Invoice
    onHoldDate On Hold Date Date 4
    mandateCode Mandate 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