Gen. Journal Line

    API Details

    Property Value
    Endpoint /tablesFinance/genJournalLines
    Table name Gen. Journal Line
    Table id 81
    Table caption Gen. Journal Line
    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
    journalTemplateName Journal Template Name Code 10 * Gen. Journal Template
    lineNo Line No. Integer 4 *
    accountType Account Type Option 4 G/L Account, Customer, Vendor, Bank Account, Fixed Asset, IC Partner, Employee, Allocation Account
    accountNo Account No. Code 20
    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
    vatPct VAT % Decimal 12
    balAccountNo Bal. Account No. Code 20
    currencyCode Currency Code Code 10 Currency
    amount Amount Decimal 12
    debitAmount Debit Amount Decimal 12
    creditAmount Credit Amount Decimal 12
    amountLCY Amount (LCY) Decimal 12
    balanceLCY Balance (LCY) Decimal 12
    currencyFactor Currency Factor Decimal 12
    salesPurchLCY Sales/Purch. (LCY) Decimal 12
    profitLCY Profit (LCY) Decimal 12
    invDiscountLCY Inv. Discount (LCY) Decimal 12
    billtoPaytoNo Bill-to/Pay-to No. Code 20
    postingGroup Posting Group Code 20
    shortcutDimension1Code Shortcut Dimension 1 Code Code 20
    shortcutDimension2Code Shortcut Dimension 2 Code Code 20
    salespersPurchCode Salespers./Purch. Code Code 20
    pendingApproval Pending Approval Boolean 4
    sourceCode Source Code Code 10 Source Code
    systemCreatedEntry System-Created Entry Boolean 4
    yourReference Your Reference Text 35
    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
    dueDate Due Date Date 4
    pmtDiscountDate Pmt. Discount Date Date 4
    paymentDiscountPct Payment Discount % Decimal 12
    jobNo Job No. Code 20 Job
    quantity Quantity Decimal 12
    vatAmount VAT Amount Decimal 12
    vatPosting VAT Posting Option 4 Automatic VAT Entry, Manual VAT Entry
    paymentTermsCode Payment Terms Code Code 10 Payment Terms
    appliestoID Applies-to ID Code 50
    businessUnitCode Business Unit Code Code 20 Business Unit
    journalBatchName Journal Batch Name Code 10 *
    reasonCode Reason Code Code 10 Reason Code
    recurringMethod Recurring Method Option 4 , F Fixed, V Variable, B Balance, RF Reversing Fixed, RV Reversing Variable, RB Reversing Balance, BD Balance by Dimension, RBD Reversing Balance by Dimension
    expirationDate Expiration Date Date 4
    recurringFrequency Recurring Frequency DateFormula 32
    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
    vatCalculationType VAT Calculation Type Option 4 Normal VAT, Reverse Charge VAT, Full VAT, Sales Tax
    eU3PartyTrade EU 3-Party Trade Boolean 4
    allowApplication Allow Application Boolean 4
    balAccountType Bal. Account Type Option 4 G/L Account, Customer, Vendor, Bank Account, Fixed Asset, IC Partner, Employee, Allocation Account
    balGenPostingType Bal. Gen. Posting Type Option 4 , Purchase, Sale, Settlement
    balGenBusPostingGroup Bal. Gen. Bus. Posting Group Code 20 Gen. Business Posting Group
    balGenProdPostingGroup Bal. Gen. Prod. Posting Group Code 20 Gen. Product Posting Group
    balVATCalculationType Bal. VAT Calculation Type Option 4 Normal VAT, Reverse Charge VAT, Full VAT, Sales Tax
    balVATPct Bal. VAT % Decimal 12
    balVATAmount Bal. VAT Amount Decimal 12
    bankPaymentType Bank Payment Type Option 4 , Computer Check, Manual Check, Electronic Payment, Electronic Payment-IAT
    vatBaseAmount VAT Base Amount Decimal 12
    balVATBaseAmount Bal. VAT Base Amount Decimal 12
    correction Correction Boolean 4
    printPostedDocuments Print Posted Documents Boolean 4
    checkPrinted Check Printed Boolean 4
    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
    postingNoSeries Posting 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
    balTaxAreaCode Bal. Tax Area Code Code 20 Tax Area
    balTaxLiable Bal. Tax Liable Boolean 4
    balTaxGroupCode Bal. Tax Group Code Code 20 Tax Group
    balUseTax Bal. 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
    balVATBusPostingGroup Bal. VAT Bus. Posting Group Code 20 VAT Business Posting Group
    balVATProdPostingGroup Bal. VAT Prod. Posting Group Code 20 VAT Product Posting Group
    additionalCurrencyPosting Additional-Currency Posting Option 4 None, Amount Only, Additional-Currency Amount Only
    faAddCurrencyFactor FA Add.-Currency Factor Decimal 12
    sourceCurrencyCode Source Currency Code Code 10 Currency
    sourceCurrencyAmount Source Currency Amount Decimal 12
    sourceCurrVATBaseAmount Source Curr. VAT Base Amount Decimal 12
    sourceCurrVATAmount Source Curr. VAT Amount Decimal 12
    vatBaseDiscountPct VAT Base Discount % Decimal 12
    vatAmountLCY VAT Amount (LCY) Decimal 12
    vatBaseAmountLCY VAT Base Amount (LCY) Decimal 12
    balVATAmountLCY Bal. VAT Amount (LCY) Decimal 12
    balVATBaseAmountLCY Bal. VAT Base Amount (LCY) Decimal 12
    reversingEntry Reversing Entry Boolean 4
    allowZeroAmountPosting Allow Zero-Amount Posting Boolean 4
    shiptoOrderAddressCode Ship-to/Order Address Code Code 10
    vatDifference VAT Difference Decimal 12
    balVATDifference Bal. VAT Difference Decimal 12
    icPartnerCode IC Partner Code Code 20 IC Partner
    icDirection IC Direction Option 4 Outgoing, Incoming
    icPartnerTransactionNo IC Partner Transaction No. Integer 4
    selltoBuyfromNo Sell-to/Buy-from No. Code 20
    vatRegistrationNo VAT Registration No. Text 20
    countryRegionCode Country/Region Code Code 10 Country/Region
    prepayment Prepayment Boolean 4
    financialVoid Financial Void Boolean 4
    copyVATSetupToJnlLines Copy VAT Setup to Jnl. Lines Boolean 4
    vatBaseBeforePmtDisc VAT Base Before Pmt. Disc. Decimal 12
    origPmtDiscPossible Original Pmt. Disc. Possible Decimal 12
    origPmtDiscPossibleLCY Orig. Pmt. Disc. Possible (LCY) Decimal 12
    vatReportingDate VAT Date Date 4
    icAccountType IC Account Type Option 4 G/L Account, Bank Account
    icAccountNo IC Account No. Code 20
    jobQueueStatus Job Queue Status Option 4 , Scheduled for Posting, Error, Posting
    jobQueueEntryID Job Queue Entry ID GUID 16
    incomingDocumentEntryNo Incoming Document Entry No. Integer 4 Incoming Document
    creditorNo Creditor No. Code 20
    paymentReference Payment Reference Code 50
    paymentMethodCode Payment Method Code Code 10 Payment Method
    appliestoExtDocNo Applies-to Ext. Doc. No. Code 35
    invoiceReceivedDate Invoice Received Date Date 4
    keepDescription Keep Description Boolean 4
    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
    remittoCode Remit-to Code Code 20
    jobTaskNo Job Task No. Code 20
    jobUnitPriceLCY Job Unit Price (LCY) Decimal 12
    jobTotalPriceLCY Job Total Price (LCY) Decimal 12
    jobQuantity Job Quantity Decimal 12
    jobUnitCostLCY Job Unit Cost (LCY) Decimal 12
    jobLineDiscountPct Job Line Discount % Decimal 12
    jobLineDiscAmountLCY Job Line Disc. Amount (LCY) Decimal 12
    jobUnitOfMeasureCode Job Unit Of Measure Code Code 10 Unit of Measure
    jobLineType Job Line Type Option 4 , Budget, Billable, Both Budget and Billable
    jobUnitPrice Job Unit Price Decimal 12
    jobTotalPrice Job Total Price Decimal 12
    jobUnitCost Job Unit Cost Decimal 12
    jobTotalCost Job Total Cost Decimal 12
    jobLineDiscountAmount Job Line Discount Amount Decimal 12
    jobLineAmount Job Line Amount Decimal 12
    jobTotalCostLCY Job Total Cost (LCY) Decimal 12
    jobLineAmountLCY Job Line Amount (LCY) Decimal 12
    jobCurrencyFactor Job Currency Factor Decimal 12
    jobCurrencyCode Job Currency Code Code 10
    jobPlanningLineNo Job Planning Line No. Integer 4
    jobRemainingQty Job Remaining Qty. Decimal 12
    directDebitMandateID Direct Debit Mandate ID Code 35
    dataExchEntryNo Data Exch. Entry No. Integer 4 Data Exch.
    payerInformation Payer Information Text 50
    transactionInformation Transaction Information Text 100
    dataExchLineNo Data Exch. Line No. Integer 4
    appliedAutomatically Applied Automatically Boolean 4
    linkedTableID Linked Table ID Integer 4
    linkedSystemID Linked System ID GUID 16
    deferralCode Deferral Code Code 10 Deferral Template
    deferralLineNo Deferral Line No. Integer 4
    selectedAllocAccountNo Allocation Account No. Code 20 Allocation Account
    allocationAccountNo Posting Allocation Account No. Code 20 Allocation Account
    campaignNo Campaign No. Code 20 Campaign
    prodOrderNo Prod. Order No. Code 20
    faPostingDate FA Posting Date Date 4
    faPostingType FA Posting Type Option 4 , Acquisition Cost, Depreciation, Write-Down, Appreciation, Custom 1, Custom 2, Disposal, Maintenance, Interest
    depreciationBookCode Depreciation Book Code Code 10 Depreciation Book
    salvageValue Salvage Value Decimal 12
    noOfDepreciationDays No. of Depreciation Days Integer 4
    deprUntilFAPostingDate Depr. until FA Posting Date Boolean 4
    deprAcquisitionCost Depr. Acquisition Cost Boolean 4
    maintenanceCode Maintenance Code Code 10 Maintenance
    insuranceNo Insurance No. Code 20 Insurance
    budgetedFANo Budgeted FA No. Code 20 Fixed Asset
    duplicateInDepreciationBook Duplicate in Depreciation Book Code 10 Depreciation Book
    useDuplicationList Use Duplication List Boolean 4
    faReclassificationEntry FA Reclassification Entry Boolean 4
    faErrorEntryNo FA Error Entry No. Integer 4 FA Ledger Entry
    indexEntry Index Entry Boolean 4
    sourceLineNo Source Line No. Integer 4
    comment Comment Text 250
    checkExported Check Exported Boolean 4
    checkTransmitted Check Transmitted Boolean 4
    reverseDateCalculation Reverse Date Calculation DateFormula 32
    nonDeductibleVATPct Non-Deductible VAT % Decimal 12
    nonDeductibleVATBase Non-Deductible VAT Base Decimal 12
    nonDeductibleVATAmount Non-Deductible VAT Amount Decimal 12
    nonDeductibleVATBaseLCY Non-Deductible VAT Base LCY Decimal 12
    nonDeductibleVATAmountLCY Non-Deductible VAT Amount LCY Decimal 12
    nonDeductibleVATBaseACY Non-Deductible VAT Base ACY Decimal 12
    nonDeductibleVATAmountACY Non-Deductible VAT Amount ACY Decimal 12
    faglAccountNo FA G/L Account No. Code 20
    nonDeductibleVATDiff Non-Deductible VAT Difference Decimal 12
    balNonDedVATPct Bal. Non-Deductible VAT % Decimal 12
    balNonDedVATBase Bal. Non-Deductible VAT Base Decimal 12
    balNonDedVATAmount Bal. Non-Deductible VAT Amount Decimal 12
    balNonDedVATBaseLCY Bal. Non-Deductible VAT Base LCY Decimal 12
    balNonDedVATAmountLCY Bal. Non-Deductible VAT Amount LCY Decimal 12
    accountId Account Id GUID 16 G/L Account
    customerId Customer Id GUID 16 Customer
    appliestoInvoiceId Applies-to Invoice Id GUID 16 Sales Invoice Entity Aggregate
    contactGraphId Contact Graph Id Text 250
    lastModifiedDateTime Last Modified DateTime DateTime 8
    journalBatchId Journal Batch Id GUID 16 Gen. Journal Batch
    paymentMethodId Payment Method Id GUID 16 Payment Method
    balanceAccountId Balance Account Id GUID 16 G/L Account
    vendorId Vendor Id GUID 16 Vendor
    controleOverslaan Skip Test Boolean 4
    factuursoort Invoice Subject Option 4 , Diversen, Beheer, S&V-kosten, Prolongatie, , , , , , Verkoop
    afrekeningsoort Statement Type Option 4 Revenue, Deposit, AdministrationReimbursement, Costs
    factuursoortInkoop InvoiceTypePurchase Option 4 , Onderhoud, Prolongatie, Afrekening
    costCode Cost Code Text 10
    eenheidnr Object No. Code 20 OGE
    contractvolgnr Contract Entry No. Integer 4
    gedeeldeFactuur Shared Invoice Boolean 4
    eenheidnrKostentabel Object No. Cost Table Code 20 OGE
    tabel Table Option 4 , Cluster, Eenheid
    clusternr Cluster No. Code 20
    huisnr House No. Code 20
    toevoegsel Addition Code 20
    kostencodesoort Cost Code Type Option 4 , Service, Verbruik, Water, Individueel
    tenLasteVan Charged to Option 4 Beheergever, Beheerder
    vooruitbetaling Prepayment Line Boolean 4
    regelGechecked LineChecked Boolean 4
    bedragNaarGrekening Amount to B-Account Decimal 12
    rcCode RC Code Code 10 RC Verhoudingen
    rcBufferEntryNo RC Buffer Entry No. Integer 4
    prorataPct Pro-rata % Decimal 12
    weigeringsbedrag Amount Refused Decimal 12
    telebankNietControleren NoCheckTelebank Boolean 4
    verdelingsmethode Allocation Method Option 4 , Lineair, Oppervlakte, Kale huur, WOZ-waarde, Teller/Noemer
    eersteFactuur First Invoice Boolean 4
    soortContract Invoice Option Option 4 , Verhuur, Erfpacht
    leegstandsderving Vacancy Loss Boolean 4
    extraAflossingBetRegeling Extra Repayment Payment Scheme Boolean 4
    commitment Commitment Boolean 4
    woningzoekendenr Prospect No. Code 20
    empireProjectnr Project No. (Emp.) Code 20 Empire Project
    empireProjecttype Project Type Code 20 Empire Projecttype
    empireWerksoort Job Type Code 20 Empire Werksoort
    workTypePostingGroup Werksoortboekingsgroep Code 10 Werksoortboekingsgroep
    description2 Description 2 Text 50
    gmuNo GMU No. Code 20
    gmuLineNo GMU Line No. Integer 4
    transactionModeCode Transaction Mode Code Code 20
    eigenDienst Internal Service Boolean 4
    bAccount B-Account Boolean 4
    amountInclBAccount Amount incl. B-Account Decimal 12
    surchargeAmount Surcharge Amount Decimal 12
    elementNo Element No.EMP Code 20
    clonedCustomerLedgerEntry Cloned Customer Ledger Entry Option 4 , Cloned Payment Scheme, Cloned Invoice
    prolHeaderNo Prol Header No. Code 20
    prolLineNo Prol Line No.EMP Integer 4
    prolRunNo Prol Run No.EMP Integer 4
    prolVATOnly Prol VAT OnlyEMP Boolean 4
    systemCostCode System Cost CodeEMP Text 10
    cbgNo No. Integer 4
    cbgLineNo CBG Line No. Integer 4
    scBatchName S&&C Batch Name Code 10
    maintenanceTaskNo Maintenance Task No. Code 20 DM - Maintenance Task
    mandateCode Mandate Code Code 20
    distributionKeyID Distribution Key ID Integer 4
    distributionReferenceDate Distribution Reference Date Date 4
    targetAccountNonDAEB Target Account Non-DAEB Code 20
    paymentSchemeCode Payment Scheme Code Code 20 Payment Scheme
    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