Livability Dossier Action Line
API Details
Property | Value |
---|---|
Endpoint | /tablesHousing/livabilityDossierActionLines |
Table name | Livability Dossier Action Line |
Table id | 11024153 |
Table caption | Livability Dossier Action Line |
Data per company | True |
Group | Housing |
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 | |||||||
dossierNo | Livability Dossier No. | Code | 20 | * | Livability Dossier | |||||
lineNo | Line No. | Integer | 4 | * | ||||||
date | Date | Date | 4 | |||||||
actie | Action | Code | 10 | Livability Action | ||||||
description | Description | Text | 100 | |||||||
user | User | Code | 50 | |||||||
involvedPerson | Involved Person | Code | 20 | Contact | ||||||
serviceCallSettlementCode | Service Call Settlement Code | Code | 20 | Service Call Settlement Code | ||||||
executePeriod | Execution Period | Code | 20 | Urgency Code | ||||||
costCode | Cost Code | Text | 10 | Cost Code | ||||||
chargeToInitiator | Charge to Initiator | Boolean | 4 | |||||||
pctChargeSales | Charge Percentage | Decimal | 12 | |||||||
salesAmount | Charge Amount | Decimal | 12 | |||||||
status | Status | Option | 4 | , In Order, Request Permission, Denied Permission, Permission, Closed | ||||||
offerNo | Offer No. | Code | 20 | |||||||
orderNo | Order No. | Code | 20 | |||||||
campaignNo | Campagnenr. | Code | 20 | Campaign | ||||||
afgehandeldDoor | Closed By | Code | 50 | Contact | ||||||
afgehandeldPer | Closed At | Date | 4 | |||||||
actieregelstatus | Action Line Status | Code | 10 | Liv. Dossier Status | ||||||
customerNo | Customer No. | Code | 20 | Customer | ||||||
urgencyCodeConversion | Urgency Code Conversion | Code | 20 | |||||||
maintenanceRequestNo | Maintenance Request No. | Code | 20 | Maintenance Request | ||||||
maintenanceTaskNo | Maintenance Task No. | Code | 20 | |||||||
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 |