Maintenance Task

    API Details

    Property Value
    Endpoint /tablesRealEstate/dmMaintenanceTasks
    Table name DM - Maintenance Task
    Table id 11031294
    Table caption Maintenance Task
    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 *
    maintenanceRequestNo Maintenance Request No. Code 20 Maintenance Request
    taskNo Task No. Code 10
    standardTaskCode Standard Task Code Code 20 DM - Standard Task
    creationDate Creation Date Date 4
    creationTime Creation Time Time 4
    manual Manual Boolean 4
    repairTemplate Repair Template Boolean 4
    templateCode Template Code Code 20
    causeCode Cause Code Code 20 DM - Cause
    noSeries No. Series Code 20 No. Series
    status Status Option 4 New, , , , , , , , , , Quote, , , , , , , , , In Progress, Work Completed, , , , , , , , Closed, , , , Cancelled
    kovraStatusCode KOVRA Status Code 3 KVStatus
    costCode Cost Code Text 10
    maintenanceTypeCode Maintenance Type Code Code 20 Maintenance Type
    constructionPartCode Construction Part Code Code 20 DM - Construction Part
    partCode Part Code Code 20 DM - Part
    issue Issue Code 20 DM - Issue
    roomTypeCode Room Type Code Code 20 DM - Room Type
    activityCode Activity Code Code 10 Maintenance Activity
    description Description Text 150
    originalQuantity Original Quantity Decimal 12
    quantity Quantity Decimal 12
    unitOfMeasureCode Unit of Measure Code 10 Unit of Measure
    unitCostLCY Unit Cost (LCY) Decimal 12
    amountLCY Amount (LCY) Decimal 12
    totalAmountInclVAT Total Amount Incl. VAT Decimal 12
    preferredDate Preferred Date Date 4
    preferredDaypart Preferred Daypart Code 20 Period
    orderCompany Company Text 30 Company
    taskPlanable Task planable Boolean 4
    executedBy Executed by Option 4 , , , Internal Service, , , Vendor
    resourceSkillCode Resource Skill Code Code 20 Resource Skill Code
    noOfResources No. of Resources Integer 4
    vendorNo Vendor No. Code 20 Vendor
    createAndAwardOrder CreateAndAwardOrder Boolean 4
    standardNoOfHours Standard No. of Hours Decimal 12
    totalNoOfHours Total No. of Hours Decimal 12
    maintenanceOrderNo Maintenance Order No. Code 20 DM - Maintenance Order
    purchaseQuoteNo Purchase Quote No. Code 20
    plannerFinishCode Finish Code Task Code 20 DM - Task Finish Code
    chargeTo Charge to Option 4 , , , Tenant, , , Other Customer
    toCharge To Charge Boolean 4
    chargeCreated Charge to Post Boolean 4
    chargeReversed Charge Reversed Boolean 4
    chargeToCustomerNo Charge to Customer No. Code 20 Customer
    salesMethod Sales Method Option 4 Calculation, Fixed Price, Contract
    tenantAgreesToCosts Tenant agrees to the costs Boolean 4
    chargePct Charge % Decimal 12
    unitPriceLCY Unit Price (LCY) Decimal 12
    unitPriceInclVAT Unit Price incl. VAT Decimal 12
    standardUnitPrice Standard Unit Price Boolean 4
    chargeAmountLCY Charge Amount (LCY) Decimal 12
    chargeAmountInclVAT Charge Amount Incl. VAT Decimal 12
    appointmentPrinted Appointment Printed Integer 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
    dateCompletedEntry Date Completed (Entry) Date 4
    closedBy Closed By Code 50 User
    closedAt Closed At Date 4
    createdBy Created By Code 50 User
    livabilityDossierNo Livability Dossier No. Code 20 Livability Dossier
    createdFromTaskspecification Created from Taskspecification Boolean 4
    toTakeOver To Take Over Boolean 4
    acceptedByCorporation Accepted By Corporation Boolean 4
    attachmentSetID Attachment Set ID Integer 4
    descriptionSetID Description Set ID Integer 4
    realtyObjectNo Realty Object No. Code 20 OGE
    commonArea Common Area Boolean 4
    clusterNo Cluster No. Code 20
    costAllocationClusterNo Cost Allocation Cluster No. Code 20
    externalOrderNo External Order No. Code 20
    kovraInstructionSubNo KOVRA Instruction Sub No. Code 20
    kovraCostSpecLineNo KOVRA Cost Specification Line No. Integer 4
    urgencyCode Urgency Code Code 20 Urgency Code
    completeBeforeDate Complete Before Date Date 4
    locationCode Location Code Code 10
    callerContactNo Caller Contact No. Code 20 Contact
    callerName Caller Name Text 105
    callerAddress Caller Address Text 100
    tenantCustomerNo Tenant Customer No. Code 20 Customer
    tenantAddress Tenant Address Text 100
    serviceCallTypeCode Service Call Type Code Code 20 Service Call Type
    maintPortal Maint. Portal Boolean 4
    inspectionRequest Inspection App Boolean 4
    clusterInspectorCode Cluster Inspector Code Code 20 Salesperson/Purchaser
    inspectorCode Inspector Code Code 20 Salesperson/Purchaser
    budgetHolderUserID Budget Holder User ID Code 50 User Setup
    budgetHolderDMUserID Budget Holder (DM) User ID Code 50 User Setup
    budgetHClusterCostCodeID Budget Holder Cluster/Cost Code Code 50 User Setup
    budgetHolderCostCodeID Budget Holder Cost Code Code 50 User Setup
    purchaseMethod Purchase Method Option 4 Subsequent Calculation, Fixed Price, Contract, Quote
    warranty Warranty Boolean 4
    reportingDate Reporting Date Date 4
    syncInInspectionApp Synchronized with Inspection App Boolean 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