Maintenance Template Line

    API Details

    Property Value
    Endpoint /tablesRealEstate/maintenanceTemplateLines
    Table name Maintenance Template Line
    Table id 11031245
    Table caption Maintenance Template 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
    maintenanceTemplateCode Maintenance Template Code Code 20 * Maintenance Template
    lineNo Line No. Integer 4 *
    roomTypeCode Room Type Code Code 20 Room Type
    constructionPartCode Construction Part Code Code 20 Construction Part
    partCode Part Code Code 20 Part
    activityCode Activity Code Code 10 Maintenance Activity
    description Description Text 85
    issue Issue Text 50
    quantity Quantity Decimal 12
    unitOfMeasureCode Unit of Measure Code 10 Unit of Measure
    unitCostLCY Unit Cost (LCY) Decimal 12
    amountLCY Amount (LCY) Decimal 12
    unitPriceLCY Unit Price (LCY) Decimal 12
    costCode Cost Code Text 10
    urgencyCode Urgency Code Code 20 Urgency Code
    maintenanceTypeCode Maintenance Type Code Code 20 Maintenance Type
    operatingActivity Operating activity Code 20 Exploitation Activity Code
    executedBy Executed by Option 4 , , , Internal Service, , , Vendor
    resourceSkillCode Resource Skill Code Code 20 Resource Skill Code
    vendorNo Vendor No. Code 20 Vendor
    standardNoOfHours Standard No. of Hours Decimal 12
    totalNoOfHours Total No. of Hours Decimal 12
    chargeTo Charge to Option 4 , , , Tenant, , , Other Customer
    chargeToCustomerNo Charge to Customer No. Code 20 Customer
    chargePct Charge % Decimal 12
    chargeAmountLCY Charge Amount (LCY) Decimal 12
    paymentArrangement Payment Arrangement Option 4 , Fixed Price, Subsequent Calculation, Contract
    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