Financing

    API Details

    Property Value
    Endpoint /tablesFinance/financings
    Table name Financing
    Table id 11030206
    Table caption Financing
    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
    nr No. Code 20 *
    soort Type Option 4 Lening, Belegging
    externNummer External No. Code 20
    status Status Code 20 Leningstatus
    geldgeverID Financier ID Code 20 Contact
    omschrijving Description Text 30
    wsw Guarantee Fund No. Text 30
    wijzeBorgstelling Type of Guarantee Code 10 Wijze borgstelling
    gemeenteAchtervang City Guarantee Decimal 12
    finBoekingsgroep Fin. Posting Group Code 10 Fin. boekingsgroepen
    variabeleRente Floating Interest Boolean 4
    nrreeks No. Series Code 10
    geblokkeerd Blocked Boolean 4
    geprolongeerdTot Posted Until Date 4
    actueelModel Current Model Integer 4
    gemeente City Text 30
    kenmerk Characteristic Code 10 Kenmerken financieringen
    glIntegration G/L Integration Option 4 , GrootboekPlusLev, AlleenGrootboek
    leveranciersnrGeldgever Vendor No. Financier Code 20 Vendor
    tempSortingProl Temp. Sorting (Posting) Boolean 4
    transactionModeCode Transaction Mode Code Code 20
    bankAccountCode Bank Account 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