Empire Comment Line
API Details
Property | Value |
---|---|
Endpoint | /tablesGeneral/empireCommentLines |
Table name | Empire Comment Line |
Table id | 11024006 |
Table caption | Empire Comment Line |
Data per company | True |
Group | General |
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 | |||||||
tableName | Table | Option | 4 | * | Complex, Eenheid, Contract, Additioneel, Punten, Leefbaarheid, Opdracht, Onderhoud, Sleutel, Deurwaarder, Betalingsregeling, Contact, Verkoop, Terugkoop, Verhuurmutatie, WoonnetAdv, WoonnetAdvKenm, Opnamegegevens, Bid, , , , , Besluiten, Bijzonderheden, Fiat, Abonnement, Email, OpmDeurw, Afwachtcode, Dossierstappensjabloon, Inspectie, Cartotheek, WRVAdvKenm, WRVAdv, DebtRecov, OpdrachtLev, OpdrachtCluInsp, SalesDossier | |||||
no | No. | Code | 20 | * | ||||||
subNo | Sub No. | Code | 20 | * | ||||||
seqNo | Seq. No. | Integer | 4 | * | ||||||
lineNo | Line No. | Integer | 4 | * | ||||||
date | Date | Date | 4 | |||||||
comment | Comment | Text | 100 | |||||||
subLineNo | Sub Line No. | Integer | 4 | * | ||||||
userID | 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 |