Bewerken: Building

Sectie: Properties

Reden:

## Properties

| 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 |  |