Bewerken: BuildingPart

Sectie: Properties

Reden:

## Properties

| Property | Type | Kolom | Width | Nullable | Default |
|----------|------|-------|-------|----------|---------|
| Id.Building | Building | BLDPBLDID |  | false |  |
| Id.Id | UltimoString | BLDPID | 11 | false |  |
| AddressLine1 | UltimoString | BLDPADDRESSLINE1 | 100 | true |  |
| AddressLine2 | UltimoString | BLDPADDRESSLINE2 | 100 | true |  |
| BuildingFloors | List[BuildingFloor] | BLDFBLDID, BLDFBLDPID |  | false | ,  |
| CadDocument | Document | BLDPCADDOCID |  | true |  |
| City | UltimoString | BLDPCITY | 40 | true |  |
| ConstructionYear | Int32 | BLDPCONSTRUCTIONYEAR |  | false | 0 |
| Context | Context | BLDPCONTEXT |  | false | 1 |
| CostCenter | CostCenter | BLDPCCRID |  | true |  |
| CostYear1 | CompanyMoney | BLDPCOSTYEAR1 |  | false | 0 |
| CostYear10 | CompanyMoney | BLDPCOSTYEAR10 |  | false | 0 |
| CostYear11 | CompanyMoney | BLDPCOSTYEAR11 |  | false | 0 |
| CostYear12 | CompanyMoney | BLDPCOSTYEAR12 |  | false | 0 |
| CostYear13 | CompanyMoney | BLDPCOSTYEAR13 |  | false | 0 |
| CostYear14 | CompanyMoney | BLDPCOSTYEAR14 |  | false | 0 |
| CostYear15 | CompanyMoney | BLDPCOSTYEAR15 |  | false | 0 |
| CostYear16 | CompanyMoney | BLDPCOSTYEAR16 |  | false | 0 |
| CostYear17 | CompanyMoney | BLDPCOSTYEAR17 |  | false | 0 |
| CostYear18 | CompanyMoney | BLDPCOSTYEAR18 |  | false | 0 |
| CostYear19 | CompanyMoney | BLDPCOSTYEAR19 |  | false | 0 |
| CostYear2 | CompanyMoney | BLDPCOSTYEAR2 |  | false | 0 |
| CostYear20 | CompanyMoney | BLDPCOSTYEAR20 |  | false | 0 |
| CostYear21 | CompanyMoney | BLDPCOSTYEAR21 |  | false | 0 |
| CostYear22 | CompanyMoney | BLDPCOSTYEAR22 |  | false | 0 |
| CostYear23 | CompanyMoney | BLDPCOSTYEAR23 |  | false | 0 |
| CostYear24 | CompanyMoney | BLDPCOSTYEAR24 |  | false | 0 |
| CostYear25 | CompanyMoney | BLDPCOSTYEAR25 |  | false | 0 |
| CostYear26 | CompanyMoney | BLDPCOSTYEAR26 |  | false | 0 |
| CostYear27 | CompanyMoney | BLDPCOSTYEAR27 |  | false | 0 |
| CostYear28 | CompanyMoney | BLDPCOSTYEAR28 |  | false | 0 |
| CostYear29 | CompanyMoney | BLDPCOSTYEAR29 |  | false | 0 |
| CostYear3 | CompanyMoney | BLDPCOSTYEAR3 |  | false | 0 |
| CostYear30 | CompanyMoney | BLDPCOSTYEAR30 |  | false | 0 |
| CostYear31 | CompanyMoney | BLDPCOSTYEAR31 |  | false | 0 |
| CostYear32 | CompanyMoney | BLDPCOSTYEAR32 |  | false | 0 |
| CostYear33 | CompanyMoney | BLDPCOSTYEAR33 |  | false | 0 |
| CostYear34 | CompanyMoney | BLDPCOSTYEAR34 |  | false | 0 |
| CostYear35 | CompanyMoney | BLDPCOSTYEAR35 |  | false | 0 |
| CostYear36 | CompanyMoney | BLDPCOSTYEAR36 |  | false | 0 |
| CostYear37 | CompanyMoney | BLDPCOSTYEAR37 |  | false | 0 |
| CostYear38 | CompanyMoney | BLDPCOSTYEAR38 |  | false | 0 |
| CostYear39 | CompanyMoney | BLDPCOSTYEAR39 |  | false | 0 |
| CostYear4 | CompanyMoney | BLDPCOSTYEAR4 |  | false | 0 |
| CostYear40 | CompanyMoney | BLDPCOSTYEAR40 |  | false | 0 |
| CostYear5 | CompanyMoney | BLDPCOSTYEAR5 |  | false | 0 |
| CostYear6 | CompanyMoney | BLDPCOSTYEAR6 |  | false | 0 |
| CostYear7 | CompanyMoney | BLDPCOSTYEAR7 |  | false | 0 |
| CostYear8 | CompanyMoney | BLDPCOSTYEAR8 |  | false | 0 |
| CostYear9 | CompanyMoney | BLDPCOSTYEAR9 |  | false | 0 |
| Country | Country | BLDPCNTRID |  | true | DefaultCountryId |
| DataProvider | UltimoString | BLDPDATAPROVIDER | 50 | true |  |
| Department | Department | BLDPDEPID |  | true |  |
| Description | UltimoString | BLDPDESCR | 200 | true |  |
| EquipmentFloorArea | Decimal | BLDPFLOORNETTINSTM2 |  | false | 0 |
| Exported | Boolean | BLDPEXPORTED |  | false |  |
| ExternalId | UltimoString | BLDPEXTERNALID | 50 | true |  |
| ExternalStatus | UltimoString | BLDPEXTERNALSTATUS | 50 | true |  |
| FloorNetArea | Decimal | BLDPFLOORNETTM2 |  | false | 0 |
| FloorTareArea | Decimal | BLDPFLOORTAREM2 |  | false | 0 |
| GeocodeX | Decimal | BLDPGEOCODEX |  | false |  |
| GeocodeY | Decimal | BLDPGEOCODEY |  | false |  |
| GrossExternalArea | Decimal | BLDPFLOORGROSSM2 |  | false | 0 |
| HorizontalCirculationArea | Decimal | BLDPFLOORNETTTRAFHORM2 |  | false | 0 |
| ImageFile | UltimoString | BLDPIMAGEFILE |  | true |  |
| NetUsableArea | Decimal | BLDPFLOORNETTUSABM2 |  | false | 0 |
| NumberOfParkingPlaces | Int32 | BLDPPARKINGSTATE |  | false | 0 |
| ProviderMutationDate | DateTime? | BLDPPROVIDERMUTDATE |  | true |  |
| ProvinceStateRegion | UltimoString | BLDPPROVINCESTATEREGION | 40 | true |  |
| Purpose | Purpose | BLDPPURID |  | true |  |
| Quantity | Decimal | BLDPQTY |  | false | 0 |
| RecordChangeDate | DateTime? | BLDPRECCHANGEDATE |  | true |  |
| RecordCreateDate | DateTime? | BLDPRECCREATEDATE |  | true | SYSDATETIME |
| Site | Site | BLDPSITID |  | true |  |
| Status | Status | BLDPRECSTATUS |  | false |  |
| SystemCompany | Company | BLDPCOMPID |  | false |  |
| Text | UltimoString | BLDPTEXT |  | true |  |
| TransferNextTime | Boolean | BLDPTRANSFERNEXTTIME |  | false |  |
| Unit | Unit | BLDPQTYUNTID |  | true |  |
| VerticalCirculationArea | Decimal | BLDPFLOORNETTTRAFVERTM2 |  | false | 0 |
| WallArea | Decimal | BLDPWALLM2 |  | false | 0 |
| Year1 | Int16 | BLDPYEAR1 |  | false |  |
| Year10 | Int16 | BLDPYEAR10 |  | false |  |
| Year11 | Int16 | BLDPYEAR11 |  | false |  |
| Year12 | Int16 | BLDPYEAR12 |  | false |  |
| Year13 | Int16 | BLDPYEAR13 |  | false |  |
| Year14 | Int16 | BLDPYEAR14 |  | false |  |
| Year15 | Int16 | BLDPYEAR15 |  | false |  |
| Year16 | Int16 | BLDPYEAR16 |  | false |  |
| Year17 | Int16 | BLDPYEAR17 |  | false |  |
| Year18 | Int16 | BLDPYEAR18 |  | false |  |
| Year19 | Int16 | BLDPYEAR19 |  | false |  |
| Year2 | Int16 | BLDPYEAR2 |  | false |  |
| Year20 | Int16 | BLDPYEAR20 |  | false |  |
| Year21 | Int16 | BLDPYEAR21 |  | false |  |
| Year22 | Int16 | BLDPYEAR22 |  | false |  |
| Year23 | Int16 | BLDPYEAR23 |  | false |  |
| Year24 | Int16 | BLDPYEAR24 |  | false |  |
| Year25 | Int16 | BLDPYEAR25 |  | false |  |
| Year26 | Int16 | BLDPYEAR26 |  | false |  |
| Year27 | Int16 | BLDPYEAR27 |  | false |  |
| Year28 | Int16 | BLDPYEAR28 |  | false |  |
| Year29 | Int16 | BLDPYEAR29 |  | false |  |
| Year3 | Int16 | BLDPYEAR3 |  | false |  |
| Year30 | Int16 | BLDPYEAR30 |  | false |  |
| Year31 | Int16 | BLDPYEAR31 |  | false |  |
| Year32 | Int16 | BLDPYEAR32 |  | false |  |
| Year33 | Int16 | BLDPYEAR33 |  | false |  |
| Year34 | Int16 | BLDPYEAR34 |  | false |  |
| Year35 | Int16 | BLDPYEAR35 |  | false |  |
| Year36 | Int16 | BLDPYEAR36 |  | false |  |
| Year37 | Int16 | BLDPYEAR37 |  | false |  |
| Year38 | Int16 | BLDPYEAR38 |  | false |  |
| Year39 | Int16 | BLDPYEAR39 |  | false |  |
| Year4 | Int16 | BLDPYEAR4 |  | false |  |
| Year40 | Int16 | BLDPYEAR40 |  | false |  |
| Year5 | Int16 | BLDPYEAR5 |  | false |  |
| Year6 | Int16 | BLDPYEAR6 |  | false |  |
| Year7 | Int16 | BLDPYEAR7 |  | false |  |
| Year8 | Int16 | BLDPYEAR8 |  | false |  |
| Year9 | Int16 | BLDPYEAR9 |  | false |  |
| ZipCode | UltimoString | BLDPZIPCODE | 10 | true |  |