Project

    API Details

    Property Value
    Endpoint /tablesRealEstate/empireProjects
    Table name Empire Project
    Table id 11030452
    Table caption Project
    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
    nr No. Code 20 *
    naam Name Text 50
    omschrijving Description Text 50
    zoeknaam Search Name Code 50
    status Status Code 20 Empire Projectstatus
    type Project Type Code 20 Empire Projecttype
    divisie Responsibility Centre Code 10 Responsibility Center
    aangemaaktOp Created On Date 4
    startdatum Start Date Date 4
    opleverdatum Delivery Date Date 4
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    geblokkeerd Blocked Boolean 4
    gewijzigdOp Changed On Date 4
    nrreeks No. Series Code 20 No. Series
    jaar Year Integer 4
    soort Type Option 4 Hoofdproject, Deelproject
    nrHoofdproject No. Main Project Code 20 Empire Project
    projectfase Project Phase Code 10
    exploitatiemodel Exploitation Model Code 20
    besluit Decision Code 20 Besluit
    datumGereed Date Ready Date 4
    hulpDatumGereed Support Date Ready Date 4
    attachmentSetID Attachment Set ID"" Integer 4
    applicationMethod Application Method Option 4 Apply to Oldest, Manual
    recognitionDate Recognition Date Date 4
    percentageGereed Percentage ready Decimal 12
    projectmodelnr Project Model No. Code 20
    modelversienr Model Version No. Integer 4
    clusternr Cluster No. Code 20 Cluster
    initialStartDate Initial Start Date Date 4
    initialDeliveryDate Initial Delivery Date Date 4
    mspTaskUniqueID MSP Task UniqueID Integer 4
    mspTaskID MSP Task ID Integer 4
    relativeLocationMPPFile Relative Location (.MPP) File Text 250
    createDateMPPFile Create Date (.MPP) File DateTime 8
    lastExportDateTime Last Export Date Time DateTime 8
    lastImportDateTime Last Import Date Time DateTime 8
    expectedNoUnitsToSell Expected No. Units to Sell Integer 4
    expectedNoUnitsToLet Expected No. Units to Let Integer 4
    finishYear Finishing Year Integer 4
    contractNo Contract No. Code 20 Maintenance Contract
    contractYear Contract Year Integer 4
    bedenktijdKoopcontract Reflection Period Purchase Contract DateFormula 32
    active Active Boolean 4
    dateClosed Closed at Date 4
    projectManager Project Manager Code 50 User Setup
    showOnCustomerPortal Show on Customer Portal Boolean 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