Connect-It Plan Lock

    API Details

    Property Value
    Endpoint /tablesRealEstate/connectItPlanLocks
    Table name Connect-It PlanLock
    Table id 11031411
    Table caption Connect-It Plan Lock
    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
    entryNo Entry No. Integer 4 *
    externalId External Id Code 50
    lineNo Line No. Integer 4
    externalOrderNo External Order No. Code 20
    externalCustomerNo External Customer No. Code 20 Customer
    status Status Option 4 Created, , , , , Active, , , , , Planned, , , , , Released, , , , , Expired, , , , , Cancelled
    maintenanceOrderNo Maintenance Order No. Code 20 DM - Maintenance Order
    expireMinutes Expire Duration In Minutes Decimal 12
    expireDateTime Expire Date Time DateTime 8
    createdDateTime Created Date Time DateTime 8
    userId Resource No. Code 50
    startDateTime Start Date Time DateTime 8
    durationMinutes Duration In Minutes Decimal 12
    resourceSkillCode Resource Skill Code Code 20
    workAreaCode Work Area Code Code 20
    address Address Text 50
    zipcode Zipcode Text 50
    city City Text 50
    blockTimeFrom Block Time From Time 4
    blockTimeUntil Block Time Until Time 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