Projectverkoopregel

    API Details

    Property Value
    Endpoint /tablesRealEstate/projectSalesLines
    Table name Projectverkoopregel
    Table id 11030488
    Table caption Projectverkoopregel
    Data per company True
    Group RealEstate

    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
    projectnr Projectnr. Code 20 * Empire Project
    budgetregelnr Budgetregelnr. Integer 4 *
    documentType Document Type Option 4 * Offerte, Order, Bouw, Meerwerk, Bouwrente, Credit Memo Sales, Invoice
    documentNo Document No. Code 20 *
    invoerdatum Invoerdatum Date 4
    contactnr Contactnr. Code 20 Contact
    eenheidnr Eenheidnr. Code 20 OGE
    omschrijving Omschrijving Text 100
    gearchiveerd Gearchiveerd Boolean 4
    amount Amount Decimal 12
    amountInclVAT Amount incl. VAT Decimal 12
    nrHoofdproject Nr. Hoofdproject Code 20
    clusternr Clusternr. Code 20 Cluster
    werksoort Werksoort Code 20 Empire Projecttype werksoorten
    status Status Option 4 , Posted
    bouwnr Bouwnr. Code 10 *
    outstandingAmount Outstanding Amount Decimal 12
    outstandingAmountInclVAT Outstanding Amount Incl. VAT Decimal 12
    dateClosed Date Closed Date 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
    lastModifiedDateTime Last Modified Date Time DateTime 8