Bewerken: BuildingPart

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `BldpBldId` | nvarchar(11) | Nee | — | — |
| `BldpId` | nvarchar(11) | Nee | — | — |
| `BldpDescr` | nvarchar(200) | Ja | — | — |
| `BldpContext` | bigint | Nee | ((1)) | — |
| `BldpRecStatus` | int | Nee | ((0)) | — |
| `BldpAddressLine1` | nvarchar(100) | Ja | — | — |
| `BldpAddressLine2` | nvarchar(100) | Ja | — | — |
| `BldpCadDocId` | nvarchar(11) | Ja | — | — |
| `BldpCcrId` | nvarchar(9) | Ja | — | — |
| `BldpCity` | nvarchar(40) | Ja | — | — |
| `BldpCntrId` | nvarchar(9) | Ja | — | — |
| `BldpCompId` | nvarchar(6) | Nee | — | — |
| `BldpConstructionYear` | int | Nee | ((0)) | — |
| `BldpCostYear1` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear10` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear11` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear12` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear13` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear14` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear15` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear16` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear17` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear18` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear19` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear2` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear20` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear21` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear22` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear23` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear24` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear25` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear26` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear27` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear28` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear29` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear3` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear30` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear31` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear32` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear33` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear34` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear35` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear36` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear37` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear38` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear39` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear4` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear40` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear5` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear6` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear7` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear8` | decimal(21,5) | Nee | ((0)) | — |
| `BldpCostYear9` | decimal(21,5) | Nee | ((0)) | — |
| `BldpDataProvider` | nvarchar(50) | Ja | — | — |
| `BldpDepId` | nvarchar(11) | Ja | — | — |
| `BldpExported` | smallint | Nee | ((0)) | — |
| `BldpExternalId` | nvarchar(50) | Ja | — | — |
| `BldpExternalStatus` | nvarchar(50) | Ja | — | — |
| `BldpFloorGrossM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldpFloorNettInstM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldpFloorNettM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldpFloorNettTrafHorM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldpFloorNettTrafVertM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldpFloorNettUsabM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldpFloorTareM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldpGeocodeX` | decimal(21,10) | Nee | ((0)) | — |
| `BldpGeocodeY` | decimal(21,10) | Nee | ((0)) | — |
| `BldpImageFile` | nvarchar(max) | Ja | — | — |
| `BldpParkingState` | int | Nee | ((0)) | — |
| `BldpProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `BldpProvinceStateRegion` | nvarchar(40) | Ja | — | — |
| `BldpPurId` | nvarchar(6) | Ja | — | — |
| `BldpQty` | decimal(21,2) | Nee | ((0)) | — |
| `BldpQtyUntId` | nvarchar(6) | Ja | — | — |
| `BldpRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `BldpSitId` | nvarchar(8) | Ja | — | — |
| `BldpText` | nvarchar(max) | Ja | — | — |
| `BldpTransferNextTime` | smallint | Nee | ((0)) | — |
| `BldpWallM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldpYear1` | smallint | Nee | ((0)) | — |
| `BldpYear10` | smallint | Nee | ((0)) | — |
| `BldpYear11` | smallint | Nee | ((0)) | — |
| `BldpYear12` | smallint | Nee | ((0)) | — |
| `BldpYear13` | smallint | Nee | ((0)) | — |
| `BldpYear14` | smallint | Nee | ((0)) | — |
| `BldpYear15` | smallint | Nee | ((0)) | — |
| `BldpYear16` | smallint | Nee | ((0)) | — |
| `BldpYear17` | smallint | Nee | ((0)) | — |
| `BldpYear18` | smallint | Nee | ((0)) | — |
| `BldpYear19` | smallint | Nee | ((0)) | — |
| `BldpYear2` | smallint | Nee | ((0)) | — |
| `BldpYear20` | smallint | Nee | ((0)) | — |
| `BldpYear21` | smallint | Nee | ((0)) | — |
| `BldpYear22` | smallint | Nee | ((0)) | — |
| `BldpYear23` | smallint | Nee | ((0)) | — |
| `BldpYear24` | smallint | Nee | ((0)) | — |
| `BldpYear25` | smallint | Nee | ((0)) | — |
| `BldpYear26` | smallint | Nee | ((0)) | — |
| `BldpYear27` | smallint | Nee | ((0)) | — |
| `BldpYear28` | smallint | Nee | ((0)) | — |
| `BldpYear29` | smallint | Nee | ((0)) | — |
| `BldpYear3` | smallint | Nee | ((0)) | — |
| `BldpYear30` | smallint | Nee | ((0)) | — |
| `BldpYear31` | smallint | Nee | ((0)) | — |
| `BldpYear32` | smallint | Nee | ((0)) | — |
| `BldpYear33` | smallint | Nee | ((0)) | — |
| `BldpYear34` | smallint | Nee | ((0)) | — |
| `BldpYear35` | smallint | Nee | ((0)) | — |
| `BldpYear36` | smallint | Nee | ((0)) | — |
| `BldpYear37` | smallint | Nee | ((0)) | — |
| `BldpYear38` | smallint | Nee | ((0)) | — |
| `BldpYear39` | smallint | Nee | ((0)) | — |
| `BldpYear4` | smallint | Nee | ((0)) | — |
| `BldpYear40` | smallint | Nee | ((0)) | — |
| `BldpYear5` | smallint | Nee | ((0)) | — |
| `BldpYear6` | smallint | Nee | ((0)) | — |
| `BldpYear7` | smallint | Nee | ((0)) | — |
| `BldpYear8` | smallint | Nee | ((0)) | — |
| `BldpYear9` | smallint | Nee | ((0)) | — |
| `BldpZipCode` | nvarchar(10) | Ja | — | — |