Projectbouwnummer

    API Details

    Property Value
    Endpoint /tablesRealEstate/projectConstructionNumbers
    Table name Projectbouwnummer
    Table id 11030908
    Table caption Projectbouwnummer
    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
    jobNo Job No. Code 20 * Empire Project
    bouwnr Construction No. Code 10 *
    woningtype Unit Type Code 10
    grondprijsInclBTW Unit Price Ground incl. VAT Decimal 12
    bouwsomInclBTW Unit Price incl. VAT Decimal 12
    koop For Sale Boolean 4
    termijnschema Term Scheme Code 10 Termijnschemakop
    contactnrKoper Buyer Contact No. Code 20 Contact
    contactnrNotaris Notary Contact No. Code 20 Contact
    termijnenGenereren Create Terms Boolean 4
    termijnschemaMeerwerk Term Scheme Additional Work Code 10 Termijnschemakop
    termijnenMeerwerkGenereren Create Terms Additional Work Boolean 4
    sluitingsdatumMeerwerkopties Closing Date Additional Work Date 4
    projecttype Project Type Code 20 Empire Projecttype
    straatnaam Street Name Text 50
    huisnr House No. Code 20
    toevoegsel Addition Code 20
    postCode Post Code Code 20
    city City Text 30
    ogAanmaken Create Realty Object Boolean 4
    ogEenheidnr Realty Object No. Code 20 OGE
    makelaar Estate Agent Code 20 Contact
    startVerkoop Starting Date Sales Date 4
    tekenenKAO Date Signing Contract Date 4
    laatsteOntbindingMogelijk Last Date Canceling Contract Possible Date 4
    notarieelTransport Date Notarial Transport Date 4
    eOpleverdatum1 Date of Delivery Date 4
    eOpleverdatum2 Date of Delivery Defects Fixed Date 4
    garantietermijn End Date Warranty Date 4
    ontvangstWaarborgCertificaat Receiving Date Certificate Date 4
    laatsteTermijnbetaling Payment Final Term Option 4 , Depot, Bankgarantie
    attachmentSetID Attachment Set ID"" Integer 4
    houseLetter House Letter Text 1
    houseNoExtension House No. Extension Text 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