Projectbudgetdetailline

    API Details

    Property Value
    Endpoint /tablesRealEstate/empireProjectBudgDetLines
    Table name Empire Projectbudg.det.regel
    Table id 11030454
    Table caption Projectbudgetdetailline
    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 Job No. Code 20 * Empire Project
    clusternr Cluster No. Code 20 Cluster
    werksoort Work Type Code 20 Empire Werksoort
    volgnummer Entry No. Integer 4 *
    type Type Option 4 Werk derden, Uren, Materiaal
    regelsoort Line Type Option 4 Quote, Order, Invoice, Credit Memo, , , Resource, Item, Subsidie, Vergoeding
    nr No. Code 20
    invoerdatum Input Date Date 4
    orderleveranciernr Order Vendor No. Code 20 Vendor
    naam Name Text 100
    omschrijving Description Text 100
    aantal Quantity Decimal 12
    kostprijs Cost Price Decimal 12
    eenheidscode Unit Code Code 10 Unit of Measure
    vestiging Location Code 10 Location
    status Status Option 4 Open, In aanvraag (Offerte), In behandeling (Offerte), Omgezet (Offerte), Afgewezen (Offerte), Pending Approval, Released, Awarded, Ready, Completed, Cancelled
    meerwerk Additional Work Boolean 4
    redencode Reason Code Code 10 Redencode offerte / order
    budgetregelnr Budget Line No. Integer 4 *
    inkoopregelnr Purchase Line No. Integer 4
    regieorder Stage management Order Boolean 4
    geboektOrderssubsidie Posted (order,Subsidy) Decimal 12
    correctie Correction Option 4 , Factuur, Creditnota
    gearchiveerdEnVerwijderd Archived And RFemoved Boolean 4
    allowPostingFrom Allow Posting From Date 4
    allowPostingTo Allow Posting To Date 4
    datumGereed Date Ready Date 4
    hulpDatumGereed Support Date Ready Date 4
    offertedetailregelnr Quote Detail Line No. Integer 4
    omschrijving2 Description 2 Text 50
    initialPostingFrom Initial Posting From Date 4
    initialPostingTo Initial Posting To Date 4
    mspTaskUniqueID MSP Task UniqueID Integer 4
    mspTaskID MSP Task ID Integer 4
    mspPredecessors MSP Predecessors Text 250
    hide Hide Boolean 4
    nrHoofdproject No. Main Job Code 20
    eenheidnr Unit No. Code 20 OGE
    statusVergoeding Status Fee Option 4 , Geboekt
    contactnr Contact No. Code 20 Contact
    vergoedingExclBTW Fee Excl. VAT Decimal 12
    vergoedingInclBTW Fee Incl. VAT Decimal 12
    maintenanceService Maintenance Service Boolean 4
    buildingBlock Building Block Code 20
    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