Maintenance Order

    API Details

    Property Value
    Endpoint /tablesRealEstate/dmMaintenanceOrders
    Table name DM - Maintenance Order
    Table id 11031279
    Table caption Maintenance Order
    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
    no No. Code 20 *
    externalOrderNo KOVRA Order No. Code 20
    vendorNo Vendor No. Code 20 Vendor
    name Name Text 100
    vendorAddress Vendor Address Text 100
    vendorAddress2 Vendor Address 2 Text 50
    vendorPostCode Vendor Post Code Code 20 Post Code
    vendorCity Vendor City Text 30 Post Code
    internalService Internal Service Boolean 4
    maintenanceRequestNo Maintenance Request No. Code 20 Maintenance Request
    description Description Text 150
    creationDate Creation Date DateTime 8
    createdBy Created by Code 50 User
    modifiedOn Modified on DateTime 8
    modifiedBy Modified by Code 50 User
    status Status Option 4 New, , , , Quote Requested, , , , Quote Received, , , , Quote Accepted, , , , Quote Rejected, , , , Pending Approval, , , , Released, , , , Awarded, , , , Accepted, , , , Refused, , , , To Plan, , , , Planned, , , , Def. Planned, , , , In Progress, , , , Intermittent, , , , Work Completed, , Pending Approval Cost Specifation, Released for Invoicing, Closed, Cancelled
    kovraStatusCode KOVRA Status Code 3 KVStatus
    costCode Cost Code Text 10
    oldCostCode Old Cost Code Text 10
    vatBusPostingGroup VAT Bus. Posting Group Code 20 VAT Business Posting Group
    inPlanner In Planner Boolean 4
    duration Duration Decimal 12
    waitingPeriod Waiting period Decimal 12
    earliestStartDate Earliest start date Date 4
    utmostReadyDate Utmost ready date Date 4
    technicalReadyDate Technical ready date DateTime 8
    appointmentDate Appointment Date Date 4
    timeFrom Start Time From Time 4
    timeTo Start Time To Time 4
    reasonBeyondUtmostRdyDate Reason Beyond Utmost Ready Date Code 10 DM - Reason Beyond Utmost Date
    noOfResources No. of Resources Integer 4
    resourceSkillCode Resource Skill Code Code 20 Resource Skill Code
    urgencyCode Urgency Code Code 20 Urgency Code
    externalReferenceNo External Reference No. Text 30
    dateAwarded Date Awarded DateTime 8
    dateAccepted Date Accepted DateTime 8
    dateRefusal Date Refusal DateTime 8
    reasonCodeRefusal Reason Code Refusal Code 10 Purchase Reason Code
    actualStartDate Actual Start Date DateTime 8
    technicalReadyBy Set to Work Completed by Code 50
    manual Manual Boolean 4
    purchaseMethod Purchase Method Option 4 Subsequent Calculation, Fixed Price, Contract, Quote
    commitment Contracted Commitment Decimal 12
    commitmentAwarded Commitment (Awarded) Decimal 12
    salesMethod Sales Method Option 4 Subsequent Calculation, Fixed Price, Contract, , , Differs per Task
    salesPrice Sales Price Decimal 12
    attachmentSetID Attachment Set ID Integer 4
    descriptionSetID Description Set ID Integer 4
    purchaseOrderNo Purchase Order No. Code 20
    pctToBaccount % to B-account Decimal 12
    amountToBaccount Amount to B-account Decimal 12
    vatReverseCharge VAT Reverse Charge Boolean 4
    plannerFinishCode Finish Code Order Code 20 DM - Order Finish Code
    vendorQuoteNo Vendor Quote No. Code 35
    vendorOrderNo Vendor Order No. Code 35
    maintenanceType Maintenance Type Option 4 , , , Repair maintenance, , , , Mutation maintenance, , , , Planned maintenance, , , , Livability maintenance, , , , WMO maintenance, , , , Improvement
    noPrinted No. Printed Integer 4
    noEmailed No. Emailed Integer 4
    amountLaborHighRate Amount Labor High Rate Decimal 12
    amountLaborLowRate Amount Labor Low Rate Decimal 12
    amountLaborZeroRate Amount Labor Zero Rate Decimal 12
    amountMaterialHighRate Amount Material High Rate Decimal 12
    amountMaterialLowRate Amount Material Low Rate Decimal 12
    amountMaterialZeroRate Amount Material Zero Rate Decimal 12
    amountTravelCostsHighRate Amount Travel Costs High Rate Decimal 12
    amountTravelCostsLowRate Amount Travel Costs Low Rate Decimal 12
    amountTravelCostsZeroRate Amount Travel Costs Zero Rate Decimal 12
    amountMiscellaneousHigh Amount Miscellaneous High Rate Decimal 12
    amountMiscellaneousLow Amount Miscellaneous Low Rate Decimal 12
    amountMiscellaneousZero Amount Miscellaneous Zero Rate Decimal 12
    amountTotalHighRate Amount Total High Rate Decimal 12
    amountTotalLowRate Amount Total Low Rate Decimal 12
    amountTotalZeroRate Amount Total Zero Rate Decimal 12
    costSpecificationFinal Cost Specification Final Boolean 4
    plannerCompleted Planner Completed Boolean 4
    deleted KOVRA Ready to Send Cost Specification Boolean 4
    kovra KOVRA Boolean 4
    newCostCode New Cost Code Text 10
    newPostingDate New Posting Date Date 4
    postingDateMessage Posting Date Message Text 250
    postingMessage Posting Message Text 250
    processingStatus Processing Status Option 4 , Errors, Processed
    orderCompany Company Text 30 Company
    createdOrderWoCostSpec Created from Maintenance Order w/o Cost Spec Boolean 4
    hideCustomerData Hide Customer Data Boolean 4
    locationCode Location Code Code 10
    costSpecificationType Cost Specification Type Option 4 Calculation, Fixed Price
    dateCompleted Date Completed Date 4
    preventive Preventive Boolean 4
    assignedUserID Assigned User ID Code 50 User Setup
    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