Connect-It Take Away Materials
API Details
Property | Value |
---|---|
Endpoint | /tablesRealEstate/connectItTakeAwayMaterials |
Table name | Connect-It Take Away Material |
Table id | 11031412 |
Table caption | Connect-It Take Away Materials |
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 | |||||||
entryNo | Entry No. | Integer | 4 | * | ||||||
externalId | External Id | Code | 50 | |||||||
status | Status | Option | 4 | New, , , , , Invoice, , , , , Posted, , , , , Cancelled | ||||||
maintenanceOrderNo | Maintenance Order No. | Code | 20 | DM - Maintenance Order | ||||||
documentNo | Invoice No. | Code | 20 | |||||||
documentLineNo | Invoice Line No. | Integer | 4 | |||||||
maintenanceRequestNo | Maintenance Request No. | Code | 20 | Maintenance Request | ||||||
name | Name | Text | 50 | |||||||
description | Description | Text | 50 | |||||||
price | Price | Decimal | 12 | |||||||
userId | Resource No. | Code | 50 | Resource | ||||||
amount | Amount | Decimal | 12 | |||||||
storageId | Warehouse | Code | 20 | |||||||
createdDate | Created Date | Date | 4 | |||||||
vendorNo | Vendor 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 |