Gen. Journal Template

    API Details

    Property Value
    Endpoint /tablesFinance/genJournalTemplates
    Table name Gen. Journal Template
    Table id 80
    Table caption Gen. Journal Template
    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
    name Name Code 10 *
    description Description Text 80
    testReportID Test Report ID Integer 4
    pageID Page ID Integer 4
    postingReportID Posting Report ID Integer 4
    forcePostingReport Force Posting Report Boolean 4
    type Type Option 4 General, Sales, Purchases, Cash Receipts, Payments, Assets, Intercompany, Jobs, Cash, Bank
    sourceCode Source Code Code 10 Source Code
    reasonCode Reason Code Code 10 Reason Code
    recurring Recurring Boolean 4
    forceDocBalance Force Doc. Balance Boolean 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
    noSeries No. Series Code 20 No. Series
    postingNoSeries Posting No. Series Code 20 No. Series
    copyVATSetupToJnlLines Copy VAT Setup to Jnl. Lines Boolean 4
    allowVATDifference Allow VAT Difference Boolean 4
    custReceiptReportID Cust. Receipt Report ID Integer 4
    vendorReceiptReportID Vendor Receipt Report ID Integer 4
    incrementBatchName Increment Batch Name Boolean 4
    copyToPostedJnlLines Copy to Posted Jnl. Lines Boolean 4
    allowPostingDateFrom Allow Posting Date From Date 4
    allowPostingDateTo Allow Posting Date To Date 4
    importID Import ID Integer 4
    kwitantieID Cash Receipt ID Integer 4
    swifTgegevensOpslaan Record SWIFT Data Option 4 Never, Nomatch, Always
    swifTgegevensVerwijderen Delete SWIFT Data Boolean 4
    includeInRealizedCashFlow Include in Realized Cash Flow Boolean 4
    realCashFlowForBalAcc Realized Cash Flow for Bal. Account No. 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