title: "Building" category: reference tags: [entity, building, datamodel] source: Entities.xml date: 2026-04-17 status: published
Building
Type: Entity Properties: 155 Contexts: 3 Statussen: 2
Zie ook het handgeschreven artikel: building
DB-schema:
lookup_table_schema("Building")· ../tables/Building
Contextsbewerken
- 0: Standaard (
BuildingContext.None) - 1: Standaard (
BuildingContext.Standard) - 2: Complex (
BuildingContext.Complex)
Statussenbewerken
- -1: Trash (
BuildingStatus.Trash) - 0: None (
BuildingStatus.None)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | BLDID | 11 | false | |
| AddressLine1 | UltimoString | BLDADDRESSLINE1 | 100 | true | |
| AddressLine2 | UltimoString | BLDADDRESSLINE2 | 100 | true | |
| BookValueEquipments | CompanyMoney | BLDINSTALLATIONBSV | false | 0 | |
| BookValueLand | CompanyMoney | BLDLANDEDPROPERTYBSV | false | 0 | |
| BookValueTotal | CompanyMoney | BLDBUILDINGTOTALBSV | false | 0 | |
| BuildingBsv | CompanyMoney | BLDBUILDINGBSV | false | 0 | |
| BuildingParts | List[BuildingPart] | BLDPBLDID | false | ||
| BuildingType | BuildingType | BLDBLDTID | true | ||
| CadDocument | Document | BLDCADDOCID | true | ||
| ChildBuildings | List[Building] | BLDPARTOFBLDID | true | ||
| City | UltimoString | BLDCITY | 40 | true | |
| CityPart | UltimoString | BLDCITYPART | 40 | true | |
| ComplexBuilding | Building | BLDCOMPLEXBLDID | true | ||
| ConstructionYear | Int32 | BLDCONSTRUCTIONYEAR | false | 0 | |
| Context | Context | BLDCONTEXT | false | 1 | |
| CostCenter | CostCenter | BLDCCRID | true | ||
| CostYear1 | CompanyMoney | BLDCOSTYEAR1 | false | 0 | |
| CostYear10 | CompanyMoney | BLDCOSTYEAR10 | false | 0 | |
| CostYear11 | CompanyMoney | BLDCOSTYEAR11 | false | 0 | |
| CostYear12 | CompanyMoney | BLDCOSTYEAR12 | false | 0 | |
| CostYear13 | CompanyMoney | BLDCOSTYEAR13 | false | 0 | |
| CostYear14 | CompanyMoney | BLDCOSTYEAR14 | false | 0 | |
| CostYear15 | CompanyMoney | BLDCOSTYEAR15 | false | 0 | |
| CostYear16 | CompanyMoney | BLDCOSTYEAR16 | false | 0 | |
| CostYear17 | CompanyMoney | BLDCOSTYEAR17 | false | 0 | |
| CostYear18 | CompanyMoney | BLDCOSTYEAR18 | false | 0 | |
| CostYear19 | CompanyMoney | BLDCOSTYEAR19 | false | 0 | |
| CostYear2 | CompanyMoney | BLDCOSTYEAR2 | false | 0 | |
| CostYear20 | CompanyMoney | BLDCOSTYEAR20 | false | 0 | |
| CostYear21 | CompanyMoney | BLDCOSTYEAR21 | false | 0 | |
| CostYear22 | CompanyMoney | BLDCOSTYEAR22 | false | 0 | |
| CostYear23 | CompanyMoney | BLDCOSTYEAR23 | false | 0 | |
| CostYear24 | CompanyMoney | BLDCOSTYEAR24 | false | 0 | |
| CostYear25 | CompanyMoney | BLDCOSTYEAR25 | false | 0 | |
| CostYear26 | CompanyMoney | BLDCOSTYEAR26 | false | 0 | |
| CostYear27 | CompanyMoney | BLDCOSTYEAR27 | false | 0 | |
| CostYear28 | CompanyMoney | BLDCOSTYEAR28 | false | 0 | |
| CostYear29 | CompanyMoney | BLDCOSTYEAR29 | false | 0 | |
| CostYear3 | CompanyMoney | BLDCOSTYEAR3 | false | 0 | |
| CostYear30 | CompanyMoney | BLDCOSTYEAR30 | false | 0 | |
| CostYear31 | CompanyMoney | BLDCOSTYEAR31 | false | 0 | |
| CostYear32 | CompanyMoney | BLDCOSTYEAR32 | false | 0 | |
| CostYear33 | CompanyMoney | BLDCOSTYEAR33 | false | 0 | |
| CostYear34 | CompanyMoney | BLDCOSTYEAR34 | false | 0 | |
| CostYear35 | CompanyMoney | BLDCOSTYEAR35 | false | 0 | |
| CostYear36 | CompanyMoney | BLDCOSTYEAR36 | false | 0 | |
| CostYear37 | CompanyMoney | BLDCOSTYEAR37 | false | 0 | |
| CostYear38 | CompanyMoney | BLDCOSTYEAR38 | false | 0 | |
| CostYear39 | CompanyMoney | BLDCOSTYEAR39 | false | 0 | |
| CostYear4 | CompanyMoney | BLDCOSTYEAR4 | false | 0 | |
| CostYear40 | CompanyMoney | BLDCOSTYEAR40 | false | 0 | |
| CostYear5 | CompanyMoney | BLDCOSTYEAR5 | false | 0 | |
| CostYear6 | CompanyMoney | BLDCOSTYEAR6 | false | 0 | |
| CostYear7 | CompanyMoney | BLDCOSTYEAR7 | false | 0 | |
| CostYear8 | CompanyMoney | BLDCOSTYEAR8 | false | 0 | |
| CostYear9 | CompanyMoney | BLDCOSTYEAR9 | false | 0 | |
| Country | Country | BLDCNTRID | true | DefaultCountryId | |
| CurrentNumberOfUsers | Int32 | BLDUSERSTATE | false | 0 | |
| DataProvider | UltimoString | BLDDATAPROVIDER | 50 | true | |
| DateOfFirstUse | Date? | BLDINSETDATE | true | ||
| Decomposition | Decomposition | BLDDECID | true | ||
| Department | Department | BLDDEPID | true | ||
| Description | UltimoString | BLDDESCR | 200 | true | |
| EquipmentFloorArea | Decimal | BLDFLOORNETTINSTM2 | false | 0 | |
| ExpensesPerYear | CompanyMoney | BLDCHARGESONFIXEDASSETS | false | 0 | |
| Exported | Boolean | BLDEXPORTED | false | ||
| ExternalId | UltimoString | BLDEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | BLDEXTERNALSTATUS | 50 | true | |
| FloorNetArea | Decimal | BLDFLOORNETTM2 | false | 0 | |
| FloorTareArea | Decimal | BLDFLOORTAREM2 | false | 0 | |
| GeocodeX | Decimal | BLDGEOCODEX | false | ||
| GeocodeY | Decimal | BLDGEOCODEY | false | ||
| GrossExternalArea | Decimal | BLDFLOORGROSSM2 | false | 0 | |
| GrossInternalArea | Decimal | BLDMANUALFLOORNETTM2 | false | 0 | |
| GrossManualExternalArea | Decimal | BLDMANUALFLOORGROSSM2 | false | 0 | |
| GroupRecordAuthorizations | List[GroupRecordAuthorization] | SGRABLDID | true | ||
| HorizontalCirculationArea | Decimal | BLDFLOORNETTTRAFHORM2 | false | 0 | |
| ImageFile | UltimoString | BLDIMAGEFILE | true | ||
| LandPurchased | Boolean | BLDLANDEDPROPERTY | false | ||
| LastDateUptakeNumberOfPersons | DateTime? | BLDDATEUSERSTATE | true | ||
| LongTermAsset | LongTermAsset | BLDLTAID | true | ||
| ManualGrossVolume | Decimal | BLDMANUALGROSSM3 | false | 0 | |
| ManualNetVolume | Decimal | BLDMANUALNETTM3 | false | 0 | |
| ManualOutsideArea1 | Decimal | BLDMANUALOUTSIDEAREA1M2 | false | 0 | |
| ManualOutsideArea2 | Decimal | BLDMANUALOUTSIDEAREA2M2 | false | 0 | |
| ManualOutsideArea3 | Decimal | BLDMANUALOUTSIDEAREA3M2 | false | 0 | |
| ManualOutsideArea4 | Decimal | BLDMANUALOUTSIDEAREA4M2 | false | 0 | |
| MarketValue | CompanyMoney | BLDMARKETVALUE | false | 0 | |
| MaximumNumberOfPersons | Int32 | BLDMAXUSERSTATE | false | 0 | |
| Neighborhood | UltimoString | BLDNEIGHBORHOOD | 40 | true | |
| NetUsableArea | Decimal | BLDFLOORNETTUSABM2 | false | 0 | |
| NumberOfParkingPlaces | Int32 | BLDPARKINGSTATE | false | 0 | |
| ObjectContacts | List[ObjectContact] | OBJCONBLDID | true | ||
| ObjectFeatures | List[ObjectFeature] | OBJFBLDID | true | ||
| OperatingCost | CompanyMoney | BLDBUSINESSCOST | false | 0 | |
| Owner | Customer | BLDCUSID | true | ||
| PartOfBuilding | Building | BLDPARTOFBLDID | true | ||
| ProcessFunction | ProcessFunction | BLDPRFID | true | ||
| ProviderMutationDate | DateTime? | BLDPROVIDERMUTDATE | true | ||
| ProvinceStateRegion | UltimoString | BLDPROVINCESTATEREGION | 40 | true | |
| Purpose | Purpose | BLDPURID | true | ||
| RecordChangeDate | DateTime? | BLDRECCHANGEDATE | true | ||
| RecordCreateDate | DateTime? | BLDRECCREATEDATE | true | SYSDATETIME | |
| ReplacementValue | CompanyMoney | BLDREPLACEMENTVALUE | false | 0 | |
| Site | Site | BLDSITID | true | ||
| Status | Status | BLDRECSTATUS | false | ||
| SystemCompany | Company | BLDCOMPID | false | ||
| Text | UltimoString | BLDTEXT | true | ||
| TransferNextTime | Boolean | BLDTRANSFERNEXTTIME | false | ||
| UserRecordAuthorizations | List[UserRecordAuthorization] | SUSERABLDID | true | ||
| Vendor | Vendor | BLDVDRID | true | ||
| VerticalCirculationArea | Decimal | BLDFLOORNETTTRAFVERTM2 | false | 0 | |
| WallArea | Decimal | BLDWALLM2 | false | 0 | |
| Year1 | Int16 | BLDYEAR1 | false | ||
| Year10 | Int16 | BLDYEAR10 | false | ||
| Year11 | Int16 | BLDYEAR11 | false | ||
| Year12 | Int16 | BLDYEAR12 | false | ||
| Year13 | Int16 | BLDYEAR13 | false | ||
| Year14 | Int16 | BLDYEAR14 | false | ||
| Year15 | Int16 | BLDYEAR15 | false | ||
| Year16 | Int16 | BLDYEAR16 | false | ||
| Year17 | Int16 | BLDYEAR17 | false | ||
| Year18 | Int16 | BLDYEAR18 | false | ||
| Year19 | Int16 | BLDYEAR19 | false | ||
| Year2 | Int16 | BLDYEAR2 | false | ||
| Year20 | Int16 | BLDYEAR20 | false | ||
| Year21 | Int16 | BLDYEAR21 | false | ||
| Year22 | Int16 | BLDYEAR22 | false | ||
| Year23 | Int16 | BLDYEAR23 | false | ||
| Year24 | Int16 | BLDYEAR24 | false | ||
| Year25 | Int16 | BLDYEAR25 | false | ||
| Year26 | Int16 | BLDYEAR26 | false | ||
| Year27 | Int16 | BLDYEAR27 | false | ||
| Year28 | Int16 | BLDYEAR28 | false | ||
| Year29 | Int16 | BLDYEAR29 | false | ||
| Year3 | Int16 | BLDYEAR3 | false | ||
| Year30 | Int16 | BLDYEAR30 | false | ||
| Year31 | Int16 | BLDYEAR31 | false | ||
| Year32 | Int16 | BLDYEAR32 | false | ||
| Year33 | Int16 | BLDYEAR33 | false | ||
| Year34 | Int16 | BLDYEAR34 | false | ||
| Year35 | Int16 | BLDYEAR35 | false | ||
| Year36 | Int16 | BLDYEAR36 | false | ||
| Year37 | Int16 | BLDYEAR37 | false | ||
| Year38 | Int16 | BLDYEAR38 | false | ||
| Year39 | Int16 | BLDYEAR39 | false | ||
| Year4 | Int16 | BLDYEAR4 | false | ||
| Year40 | Int16 | BLDYEAR40 | false | ||
| Year5 | Int16 | BLDYEAR5 | false | ||
| Year6 | Int16 | BLDYEAR6 | false | ||
| Year7 | Int16 | BLDYEAR7 | false | ||
| Year8 | Int16 | BLDYEAR8 | false | ||
| Year9 | Int16 | BLDYEAR9 | false | ||
| ZipCode | UltimoString | BLDZIPCODE | 10 | true |
Brondatabewerken
- Entity-definitie —
lookup_entity("Building")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("Building")· ../tables/Building DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="Building")Before/After Save events voor Building. Bron:workflows.xml.