FA Ledger Entry

    API Details

    Property Value
    Endpoint /tablesFinance/faLedgerEntries
    Table name FA Ledger Entry
    Table id 5601
    Table caption FA 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 *
    glEntryNo G/L Entry No. Integer 4 G/L Entry
    faNo FA No. Code 20 Fixed Asset
    faPostingDate FA Posting Date Date 4
    postingDate Posting Date Date 4
    documentType Document Type Option 4 , Payment, Invoice, Credit Memo, Finance Charge Memo, Reminder, Refund, Storno, Arrangement, Arrangement Term
    documentDate Document Date Date 4
    documentNo Document No. Code 20
    externalDocumentNo External Document No. Code 35
    description Description Text 100
    depreciationBookCode Depreciation Book Code Code 10 Depreciation Book
    faPostingCategory FA Posting Category Option 4 , Disposal, Bal. Disposal
    faPostingType FA Posting Type Option 4 Acquisition Cost, Depreciation, Write-Down, Appreciation, Custom 1, Custom 2, Proceeds on Disposal, Salvage Value, Gain/Loss, Book Value on Disposal, Interest, Sales Cost
    amount Amount Decimal 12
    debitAmount Debit Amount Decimal 12
    creditAmount Credit Amount Decimal 12
    reclassificationEntry Reclassification Entry Boolean 4
    partOfBookValue Part of Book Value Boolean 4
    partOfDepreciableBasis Part of Depreciable Basis Boolean 4
    disposalCalculationMethod Disposal Calculation Method Option 4 , Net, Gross
    disposalEntryNo Disposal Entry No. Integer 4
    noOfDepreciationDays No. of Depreciation Days Integer 4
    quantity Quantity Decimal 12
    faNoBudgetedFANo FA No./Budgeted FA No. Code 20 Fixed Asset
    faSubclassCode FA Subclass Code Code 10 FA Subclass
    faLocationCode FA Location Code Code 10 FA Location
    faPostingGroup FA Posting Group Code 20 FA Posting Group
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    locationCode Location Code Code 10
    userID User ID Code 50 User
    depreciationMethod Depreciation Method Option 4 Straight-Line, Declining-Balance 1, Declining-Balance 2, DB1/SL, DB2/SL, User-Defined, Manual, Annuïtair, Geen afschrijving
    depreciationStartingDate Depreciation Starting Date Date 4
    straightLinePct Straight-Line % Decimal 12
    noOfDepreciationYears No. of Depreciation Years Decimal 12
    fixedDeprAmount Fixed Depr. Amount Decimal 12
    decliningBalancePct Declining-Balance % Decimal 12
    depreciationTableCode Depreciation Table Code Code 10 Depreciation Table Header
    journalBatchName Journal Batch Name Code 10
    sourceCode Source Code Code 10 Source Code
    reasonCode Reason Code Code 10 Reason Code
    transactionNo Transaction No. Integer 4
    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
    vatAmount VAT Amount Decimal 12
    genPostingType Gen. Posting Type Option 4 , Purchase, Sale, Settlement
    genBusPostingGroup Gen. Bus. Posting Group Code 20 Gen. Business Posting Group
    genProdPostingGroup Gen. Prod. Posting Group Code 20 Gen. Product Posting Group
    faClassCode FA Class Code Code 10 FA Class
    faExchangeRate FA Exchange Rate Decimal 12
    amountLCY Amount (LCY) Decimal 12
    resultOnDisposal Result on Disposal Option 4 , Gain, Loss
    correction Correction Boolean 4
    indexEntry Index Entry Boolean 4
    canceledFromFANo Canceled from FA No. Code 20 Fixed Asset
    depreciationEndingDate Depreciation Ending Date Date 4
    useFALedgerCheck Use FA Ledger Check Boolean 4
    automaticEntry Automatic Entry Boolean 4
    deprStartingDateCustom1 Depr. Starting Date (Custom 1) Date 4
    deprEndingDateCustom1 Depr. Ending Date (Custom 1) Date 4
    accumDeprPctCustom1 Accum. Depr. % (Custom 1) Decimal 12
    deprPctThisYearCustom1 Depr. % this year (Custom 1) Decimal 12
    propertyClassCustom1 Property Class (Custom 1) Option 4 , Personal Property, Real Property
    noSeries No. Series Code 20 No. Series
    taxAreaCode Tax Area Code Code 20 Tax Area
    taxLiable Tax Liable Boolean 4
    taxGroupCode Tax Group Code Code 20 Tax 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
    reversed Reversed Boolean 4
    reversedByEntryNo Reversed by Entry No. Integer 4 FA Ledger Entry
    reversedEntryNo Reversed Entry No. Integer 4 FA Ledger Entry
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    baseValue Base Value Decimal 12
    faNoReinvestedFANo FA No./Reinvested FA No. Code 20 Fixed Asset
    profitCorrection Profit Correction Boolean 4
    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