G/L Entry

    API Details

    Property Value
    Endpoint /tablesFinance/glEntries
    Table name G/L Entry
    Table id 17
    Table caption G/L 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 *
    glAccountNo G/L Account No. Code 20 G/L Account
    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
    balAccountNo Bal. Account No. Code 20
    amount Amount Decimal 12
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    userID User ID Code 50 User
    sourceCode Source Code Code 10 Source Code
    systemCreatedEntry System-Created Entry Boolean 4
    priorYearEntry Prior-Year Entry Boolean 4
    jobNo Job No. Code 20 Job
    quantity Quantity Decimal 12
    vatAmount VAT Amount Decimal 12
    businessUnitCode Business Unit Code Code 20 Business Unit
    journalBatchName Journal Batch Name Code 10
    reasonCode Reason Code Code 10 Reason Code
    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
    balAccountType Bal. Account Type Option 4 G/L Account, Customer, Vendor, Bank Account, Fixed Asset, IC Partner, Employee, Allocation Account
    transactionNo Transaction No. Integer 4
    debitAmount Debit Amount Decimal 12
    creditAmount Credit Amount Decimal 12
    documentDate Document Date Date 4
    externalDocumentNo External Document No. Code 35
    sourceType Source Type Option 4 , Customer, Vendor, Bank Account, Fixed Asset, IC Partner, Employee
    sourceNo Source No. Code 20
    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
    additionalCurrencyAmount Additional-Currency Amount Decimal 12
    addCurrencyDebitAmount Add.-Currency Debit Amount Decimal 12
    addCurrencyCreditAmount Add.-Currency Credit Amount Decimal 12
    closeIncomeStatementDimID Close Income Statement Dim. ID Integer 4
    icPartnerCode IC Partner Code Code 20 IC Partner
    reversed Reversed Boolean 4
    reversedByEntryNo Reversed by Entry No. Integer 4 G/L Entry
    reversedEntryNo Reversed Entry No. Integer 4 G/L Entry
    journalTemplName Journal Template Name Code 10
    vatReportingDate VAT Date Date 4
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    lastDimCorrectionEntryNo Last Dim. Correction Entry No. Integer 4
    lastDimCorrectionNode Last Dim. Correction Node Integer 4
    dimensionChangesCount Count of Dimension Changes Integer 4
    allocationAccountNo Allocation Account No. Code 20
    prodOrderNo Prod. Order No. Code 20
    faEntryType FA Entry Type Option 4 , Fixed Asset, Maintenance
    faEntryNo FA Entry No. Integer 4
    comment Comment Text 250
    nonDeductibleVATAmount Non-Deductible VAT Amount Decimal 12
    nonDeductibleVATAmountACY Non-Deductible VAT Amount ACY Decimal 12
    lastModifiedDateTime Last Modified DateTime DateTime 8
    open Open Boolean 4
    remainingAmount Remaining Amount Decimal 12
    closedByEntryNo Closed by Entry No. Integer 4
    closedAtDate Closed at Date Date 4
    closedByAmount Closed by Amount Decimal 12
    appliestoID Applies-to ID Code 50
    clusternr Cluster No. Code 20 Cluster
    consolidatie Consolidation Integer 4
    commitment Commitment Boolean 4
    empireProjectnr Project No. Code 20 Empire Project
    empireProjecttype Project Type Code 20 Empire Projecttype
    empireWerksoort Job Type Code 20 Empire Werksoort
    workTypePostingGroup Job Type Posting Group Code 10 Werksoortboekingsgroep
    description2 Description 2 Text 50
    gecorrigeerdePost 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