G/L Account

    API Details

    Property Value
    Endpoint /tablesFinance/glAccounts
    Table name G/L Account
    Table id 15
    Table caption G/L Account
    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
    no No. Code 20 *
    name Name Text 100
    searchName Search Name Code 100
    accountType Account Type Option 4 Posting, Heading, Total, Begin-Total, End-Total
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    accountCategory Account Category Option 4 , Assets, Liabilities, Equity, Income, Cost of Goods Sold, Expense
    incomeBalance Income/Balance Option 4 Income Statement, Balance Sheet
    debitCredit Debit/Credit Option 4 Both, Debit, Credit
    no2 No. 2 Code 20
    blocked Blocked Boolean 4
    directPosting Direct Posting Boolean 4
    reconciliationAccount Reconciliation Account Boolean 4
    newPage New Page Boolean 4
    noOfBlankLines No. of Blank Lines Integer 4
    indentation Indentation Integer 4
    lastModifiedDateTime Last Modified Date Time DateTime 8
    lastDateModified Last Date Modified Date 4
    totaling Totaling Text 250
    consolTranslationMethod Consol. Translation Method Option 4 Average Rate (Manual), Closing Rate, Historical Rate, Composite Rate, Equity Rate
    consolDebitAcc Consol. Debit Acc. Code 20
    consolCreditAcc Consol. Credit Acc. Code 20
    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
    automaticExtTexts Automatic Ext. Texts Boolean 4
    taxAreaCode Tax Area Code Code 20 Tax Area
    taxLiable Tax Liable Boolean 4
    taxGroupCode Tax Group Code Code 20 Tax Group
    vatBusPostingGroup VAT Bus. Posting Group Code 20 VAT Business Posting Group
    vatProdPostingGroup VAT Prod. Posting Group Code 20 VAT Product Posting Group
    exchangeRateAdjustment Exchange Rate Adjustment Option 4 No Adjustment, Adjust Amount, Adjust Additional-Currency Amount
    defaultICPartnerGLAccNo Default IC Partner G/L Acc. No Code 20 IC G/L Account
    accountSubcategoryEntryNo Account Subcategory Entry No. Integer 4 G/L Account Category
    costTypeNo Cost Type No. Code 20 Cost Type
    defaultDeferralTemplateCode Default Deferral Template Code Code 10 Deferral Template
    apiAccountType API Account Type Option 4 Posting, Heading, Total, Begin-Total, End-Total
    omitDefaultDescrInJnl Omit Default Descr. in Jnl. Boolean 4
    reviewPolicy Review Policy Option 4 None, Allow Review, Allow Review and Match Balance
    clusterDistributionKeyType Cluster Distribution Key Type Code 20 Cluster Distribution Key Types
    balAccountNo Bal. G/L Account No. Code 20
    costClassification Cost Classification Option 4 , Both, Categorical, Functional, None
    allocateToOGEs Allocate to OGEs 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