Maintenance Request

    API Details

    Property Value
    Endpoint /tablesRealEstate/maintenanceRequests
    Table name Maintenance Request
    Table id 11031240
    Table caption Maintenance Request
    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 External Order No. Code 20
    externalCustomerNo External Customer No. Code 20 Customer
    externalRealtyObjectNo External Realty Object No. Code 20
    externalAmountCostSpec External Amount Cost Specification Decimal 12
    description Description Text 150
    realtyObjectNo Realty Object No. Code 20
    commonArea Common Area Boolean 4
    type Type Code 10
    typeDescription Description Text 70
    clusterNo Cluster No. Code 20
    costAllocationClusterNo Cost Allocation Cluster No. Code 20
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    noSeries No. Series Code 20 No. Series
    address Address Text 100
    postCode Post Code Code 20
    city City Text 30
    status Status Option 4 New, , , To Judge, , , Inspection, , , , In Progress, , , , Work Completed, Rejected after Costs Specification, Pending Approval Cost Specifation, Rejected after Sampling, Released for Invoicing, , Closed, , , , , Cancelled, , , , , Refused
    requestCompleted Request Completed Boolean 4
    reasonDeclinedCode Reason Declined Code Code 20 DM - Reason Declined
    reasonCodeRefusal Reason Code Refusal Code 10 Purchase Reason Code
    reportingDate Reporting Date Date 4
    reportingTime Reporting Time Time 4
    completeBeforeDate Complete Before Date Date 4
    locationCode Location Code Code 10
    maintenanceType Maintenance Type Option 4 , , , Repair maintenance, , , , Mutation maintenance, , , , Planned maintenance, , , , Livability maintenance, , , , WMO maintenance, , , , Improvement
    mutationType Mutation Type Code 20 DM - Mutation Type
    callerContactNo Caller Contact No. Code 20 Contact
    callerName Caller Name Text 105
    callerName2 Caller Name 2 Text 50
    callerAddress Caller Address Text 100
    callerAddress2 Caller Address 2 Text 50
    callerPostCode Caller Post Code Code 20 Post Code
    callerCity Caller City Text 30
    callerPhoneNo Caller Phone No. Text 30
    callerPhoneNo2 Caller Phone No. 2 Text 30
    callerMobilePhoneNo Caller Mobile Phone No. Text 30
    callerDaytimePhoneNo Caller Daytime Phone No. Text 30
    callerFaxNo Caller Fax No. Text 30
    callerEMail Caller E-Mail Text 80
    callerContact Caller Contact Text 30
    tenantCustomerNo Tenant Customer No. Code 20 Customer
    tenantName Tenant Name Text 100
    tenantName2 Tenant Name 2 Text 50
    tenantAddress Tenant Address Text 100
    tenantAddress2 Tenant Address 2 Text 50
    tenantPostCode Tenant Post Code Code 20 Post Code
    tenantCity Tenant City Text 30
    tenantPhoneNo Tenant Phone No. Text 30
    tenantPhoneNo2 Tentant Phone No. 2 Text 30
    tenantMobilePhoneNo Tenant Mobile Phone No. Text 30
    tenantDaytimePhoneNo Tenant Daytime Phone No. Text 30
    tenantFaxNo Tenant Fax No. Text 30
    tenantEMail Tenant E-Mail Text 80
    tenantContact Tenant Contact Text 100
    reasonCodeTermination Reason Code Termination Code 20 Reason Recision
    completionBy Completion By Option 4 Property Manager, Owner
    livabilityDossierNo Livability Dossier No. Code 20 Livability Dossier
    handlingMaintenanceOrder Handling Maintenance Order Option 4 , Charge to Owner, Award to Supervisor
    ownerNo Owner No. Code 20
    supervisorNo Supervisor No. Code 20
    fixedBySolutionTips Fixed By Solution Tips Boolean 4
    attachmentSetID Attachment Set ID Integer 4
    descriptionSetID Description Set ID Integer 4
    createdBy Created By ID Code 50 User
    createdFrom Created from Option 4 Manual, Portal, Decision Tree, Termination of Lease, KOVRA
    completedAt Completed At Date 4
    closedBy Closed By Code 50 User
    closedAt Closed At Date 4
    inspection Inspection Boolean 4
    clusterInspectorCode Cluster Inspector Code Code 20 Salesperson/Purchaser
    inspectorCode Inspector Code Code 20 Salesperson/Purchaser
    contractLineNo Contract Line No. Integer 4
    leaseStartDate Lease Start Date Date 4
    leaseEndDate Lease End Date Date 4
    budgetHolderUserID Budget Holder User ID Code 50 User Setup
    budgetHolderDMUserID Budget Holder (DM) User ID Code 50 User Setup
    activeUser Active User Code 10 Salesperson/Purchaser
    inOwnersAssociation In Owners Association Boolean 4
    companyNameLink Company Name Link Text 50 Company
    let Let Boolean 4
    communicationType Communication Type Code 30
    surveyInfoInternSvcFinal Survey Info Intern. Svc. Final Boolean 4
    systemInitiatedModification System-Initiated Modification Boolean 4
    notAwardAutomatically Not Award Automatically 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