Detail Line

    API Details

    Property Value
    Endpoint /tablesFinance/detailLines
    Table name Detail Line
    Table id 11000003
    Table caption Detail 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
    accountType Account Type Option 4 Customer, Vendor, Employee
    serialNoEntry Serial No. (Entry) Integer 4
    accountNo Account No. Code 20
    date Date Date 4
    status Status Option 4 Proposal, In process, Posted, Correction
    bank Bank Code 20
    ourBank Our Bank Code 20 Bank Account
    transactionMode Transaction Mode Code 20
    order Order Option 4 Both, Debit, Credit
    amount Amount Decimal 12
    transactionNo Transaction No. Integer 4 *
    connectLines Connect Lines Integer 4
    connectBatches Connect Batches Code 20
    description Description Text 32
    currencyCode Currency Code Code 10 Currency
    amountEntry Amount (Entry) Decimal 12
    currencyCodeEntry Currency Code (Entry) Code 10
    stuknummer Doucment No. Code 20
    globalDimension1Code Code globale dimensie 1 Code 20
    globalDimension2Code Code globale dimensie 2 Code 20
    rcCode RC-code Code 10 RC Verhoudingen
    interCompanyVolgnrPost InterCompany Volgnr.(Post) Integer 4
    betalingsregeling Betalingsregeling Code 20
    betalingsregelingregel Betalingsregelingregel Integer 4
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    mandateCode Mandate Code Code 20
    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