Cost Code
API Details
Property | Value |
---|---|
Endpoint | /tablesRealEstate/costCodes |
Table name | Cost Code |
Table id | 11024021 |
Table caption | Cost Code |
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 | |||||||
tabel | Table | Option | 4 | * | , Cluster, Eenheid | |||||
clusternr | Cluster No. | Code | 20 | * | ||||||
eenheidnr | Object No. | Code | 20 | * | ||||||
nr | Code | Text | 10 | * | ||||||
omschrijving | Description | Text | 100 | |||||||
costCodeType | Cost Code Type | Option | 4 | , Service, Verbruik, Water, Individueel | ||||||
productboekingsgroep | Gen. Prod. Posting Group | Code | 20 | Gen. Product Posting Group | ||||||
soort | Type | Option | 4 | * | Kostencodesoort, Titel, Totaal, Begintotaal, Eindtotaal | |||||
samentelling | Addition | Text | 30 | |||||||
inspringen | Indent | Integer | 4 | |||||||
bedrag | Amount | Decimal | 12 | |||||||
tenLasteVan | Charged To | Option | 4 | Beheergever, Beheerder | ||||||
btWproductboekingsgroep | VAT Prod. Posting Group | Code | 20 | VAT Product Posting Group | ||||||
klachtsoort | Service Call Type | Code | 20 | Service Call Type | ||||||
tenLasteVanHuurder | Charged to Tenant | Option | 4 | , Percentage, Bedrag | ||||||
pctBedragTenLasteVanHuurder | %/Amount Charged to Tenant | Decimal | 12 | |||||||
opslagSV | Surcharge S&&C | Code | 20 | Surcharge Service + Usage | ||||||
verdelingsmethode | Division Method | Option | 4 | , Lineair, Oppervlakte, Kale huur, WOZ-waarde, Teller/Noemer | ||||||
component | Component | Option | 4 | , G/D-component, Serviceabonnement | ||||||
opslagVT | Surcharge P&&S | Code | 20 | Surcharge Prep. + Supervision | ||||||
doorbelLeegstand | Charge Through Vacancy | Boolean | 4 | |||||||
dagelijksOnderhoud | Daily Maintenance | Boolean | 4 | |||||||
costApportionmentSU | Cost Apportionment S&&U | Option | 4 | Period, Degree Days | ||||||
percentageToSettle | Percentage to Settle | Decimal | 12 | |||||||
budgetHolderCostCodeID | Budget Holder Cost Code | Code | 50 | User Setup | ||||||
clusterDistributionKeyType | Cluster Distribution Key Type | Code | 20 | Cluster Distribution Key Types | ||||||
globalDimension1Code | Global Dimension 1 Code | Code | 20 | |||||||
globalDimension2Code | Global Dimension 2 Code | 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 |