Project Budget Line

    API Details

    Property Value
    Endpoint /tablesRealEstate/empireProjectBudgetLines
    Table name Empire Projectbudgetregel
    Table id 11030453
    Table caption Project Budget Line
    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 Project No. Code 20 * Empire Project
    regelnr Line No. Integer 4 *
    projecttype Project Type Code 20 Empire Projecttype
    clusternr Cluster No. Code 20
    omschrijving Description Text 50
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    werksoort Work Type Code 20
    werksoortomschrijving Work Type Description Text 50
    regelsoort Line Type Option 4 Standaard, Titel, Totaal, Begintotaal, Eindtotaal
    totaling Totaling Text 250 Empire Werksoort
    indentation Indentation Integer 4
    lineFilter Line Filter Text 250
    startdatum Start Date Date 4
    opleverdatum Delivery Date Date 4
    status Status Option 4 , , , , , , , , , , Doorloop, , , , , Vervallen, , , , , Technisch gereed, , , , , Afgehandeld, , , , , Uitstel
    statusreden Status Reason Code 10 Reason Code
    werksoortboekingsgroep Work Type Posting Group Code 10 Werksoortboekingsgroep
    pctUitgevoerd % Ready Decimal 12
    kladblokvolgnr Draft Entry No. Integer 4
    kladblokregelnr Draft Line No. Integer 4
    nrHoofdproject No. Main Project Code 20
    datumformuleStartdatum Date Formula Start Date DateFormula 32
    datumformuleEinddatum Date Formula End Date DateFormula 32
    resultaatExclBTW Result Excl. VAT Decimal 12
    resultaatInclBTW Result Incl. VAT Decimal 12
    type Type Code 10 Reason Code
    projectstatus Project Status Code 20 Empire Projectstatus
    projectfase Project Phase Code 10
    initialStartDate Initial Start Date Date 4
    initialDeliveryDate Initial Delivery Date Date 4
    mspTaskUniqueID MSP Task UniqueID Integer 4
    mspTaskID MSP Task ID Integer 4
    mspPredecessors MSP Predecessors Text 250
    bedragBetaaldInclBTWCONV Paid Amount Incl. VAT CONV Decimal 12
    bedragBetaaldExclBTWCONV Paid Amount Excl. VAT CONV Decimal 12
    vrijeCodeBudgetregel Free Code Budget Line Text 30
    buildingBlock Building Block Code 20
    statusCalculation Status Calculation Option 4 Open, Released
    budgetStatus Budget Mutation Status Option 4 , Transferred, Calculated
    approvalDateBudget Approval Date Budget Date 4
    lastModifiedByModel LastModifiedByModel Boolean 4
    approvalDateBegroot Approval Date Initial Budget Date 4
    approvalDatePrognose Approval Date Prognose 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