Inspection Appointment
API Details
Property | Value |
---|---|
Endpoint | /tablesRealEstate/dmInspectionAppointments |
Table name | DM - Inspection Appointment |
Table id | 11031290 |
Table caption | Inspection Appointment |
Data per company | True |
Group | RealEstate |
Schema
Properties
Property | Table Fieldname | Type | Max.Length | Key | Options | Table relation | Version introduced | Version removed | Obsolete state | Obsolete reason |
---|---|---|---|---|---|---|---|---|---|---|
id | System Id | GUID | 16 | |||||||
maintenanceRequestNo | Maintenance Request No. | Code | 20 | * | Maintenance Request | |||||
lineNo | Line No. | Integer | 4 | * | ||||||
clusterNo | Cluster No. | Code | 20 | Cluster | ||||||
realtyObjectNo | Realty Object No. | Code | 20 | OGE | ||||||
customerNo | Customer No. | Code | 20 | Customer | ||||||
customerPresent | Customer Present | Boolean | 4 | |||||||
type | Type | Option | 4 | Pre-survey, End-survey, Inspection | ||||||
date | Date | Date | 4 | |||||||
startTime | Start Time | Time | 4 | |||||||
endTime | End Time | Time | 4 | |||||||
duration | Duration | Duration | 8 | |||||||
inspectorCode | Inspector Code | Code | 20 | Salesperson/Purchaser | ||||||
status | Status | Option | 4 | New, In Process, Completed, Canceled, Absent, Synchronized, Resetted | ||||||
statusModifiedBy | Status Modified By | Code | 50 | User | ||||||
signatureCustomer | Signature Customer | Boolean | 4 | |||||||
customerDisagrees | Customer disagrees | Boolean | 4 | |||||||
exchangeID | Exchange ID | GUID | 16 | |||||||
systemCreatedEntry | System Created Entry | Boolean | 4 | |||||||
cancellationReasonCode | Cancellation Reason Code | Code | 20 | DM - App. Cancell. Reason Code | ||||||
firstPreInspection | First Pre Inspection | Boolean | 4 | |||||||
repairTemplateCodeInsp | Repair Template Code Inspection | Code | 20 | DM - Repair Template | ||||||
signatureExtenstion | Signature Extenstion | Text | 10 | |||||||
laterOnRequestCustomer | Later On Request Customer | Boolean | 4 | |||||||
customerIsNotPresent | Customer is not present | Boolean | 4 | |||||||
workflowIndex | Workflow Index | Integer | 4 | |||||||
graphEventID | Graph Event ID | Text | 250 | |||||||
veraNo | Vera No. | Integer | 4 | |||||||
tempContractLineNo | Temporary Contract Line No. | Integer | 4 | |||||||
connectItID | Connect-It ID | Code | 20 | |||||||
connectItNoSeries | No. Series | Code | 10 | No. Series | ||||||
connectItStatus | Connect-It Status | Option | 4 | , To Plan, Planned, Def. Planned, In Progress, Completed | ||||||
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 |