Job Budget Ledger Entry
API Details
Property | Value |
---|---|
Endpoint | /tablesRealEstate/empireProjectBudgetEntries |
Table name | Empire Projectbudgetpost |
Table id | 11030455 |
Table caption | Job Budget Ledger Entry |
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 | |||||||
volgnummer | Entry No. | Integer | 4 | * | ||||||
projecttype | Job Type | Code | 20 | Empire Projecttype | ||||||
projectnr | Job No. | Code | 20 | Empire Project | ||||||
cluster | Cluster | Code | 20 | Cluster | ||||||
werksoortcode | Work Type Code | Code | 20 | Empire Werksoort | ||||||
bedragExclBTW | Amount excl. VAT | Decimal | 12 | |||||||
bedragInclBTW | Amount incl. VAT | Decimal | 12 | |||||||
datum | Date | Date | 4 | |||||||
gebruikersID | User ID | Code | 50 | |||||||
redenWijziging | Reason Change | Code | 10 | Reason Code | ||||||
budgetregelnr | Budget Line No. | Integer | 4 | |||||||
werksoortboekingsgroep | Work Type Posting Group | Code | 10 | Werksoortboekingsgroep | ||||||
nrHoofdproject | Main Job No. | Code | 20 | |||||||
projectfase | Job Phase | Code | 10 | Empire Projectfase | ||||||
contractNo | Contract No. | Code | 20 | Maintenance Contract | ||||||
bedrag | Amount | Decimal | 12 | |||||||
projectnrVan | Job No. From | Code | 20 | Empire Project | ||||||
budgetregelnrVan | Budget Line No. From | Integer | 4 | |||||||
projectnrNaar | Job No. To | Code | 20 | Empire Project | ||||||
budgetregelnrNaar | Budget Line No. To | Integer | 4 | |||||||
source | Source | Option | 4 | , Mutation, Projectmodel | ||||||
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 |