Bewerken: Building

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `BldId` | nvarchar(11) | Nee | — | — |
| `BldDescr` | nvarchar(200) | Ja | — | — |
| `BldContext` | bigint | Nee | ((1)) | — |
| `BldRecStatus` | int | Nee | ((0)) | — |
| `BldAddressLine1` | nvarchar(100) | Ja | — | — |
| `BldAddressLine2` | nvarchar(100) | Ja | — | — |
| `BldBldtId` | nvarchar(5) | Ja | — | — |
| `BldBuildingBSV` | decimal(21,5) | Nee | ((0)) | — |
| `BldBusinessCost` | decimal(21,5) | Nee | ((0)) | — |
| `BldCadDocId` | nvarchar(11) | Ja | — | — |
| `BldCcrId` | nvarchar(9) | Ja | — | — |
| `BldChargesOnFixedAssets` | decimal(21,5) | Nee | ((0)) | — |
| `BldCity` | nvarchar(40) | Ja | — | — |
| `BldCityPart` | nvarchar(40) | Ja | — | — |
| `BldCntrId` | nvarchar(9) | Ja | — | — |
| `BldCompId` | nvarchar(6) | Nee | — | — |
| `BldComplexBldId` | nvarchar(11) | Ja | — | — |
| `BldConstructionYear` | int | Nee | ((0)) | — |
| `BldCostYear1` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear10` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear11` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear12` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear13` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear14` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear15` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear16` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear17` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear18` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear19` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear2` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear20` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear21` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear22` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear23` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear24` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear25` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear26` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear27` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear28` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear29` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear3` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear30` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear31` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear32` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear33` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear34` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear35` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear36` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear37` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear38` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear39` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear4` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear40` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear5` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear6` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear7` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear8` | decimal(21,5) | Nee | ((0)) | — |
| `BldCostYear9` | decimal(21,5) | Nee | ((0)) | — |
| `BldCusId` | nvarchar(6) | Ja | — | — |
| `BldDataProvider` | nvarchar(50) | Ja | — | — |
| `BldDateUserState` | datetimeoffset(7) | Ja | — | — |
| `BldDecId` | nvarchar(15) | Ja | — | — |
| `BldDepId` | nvarchar(11) | Ja | — | — |
| `BldExported` | smallint | Nee | ((0)) | — |
| `BldExternalId` | nvarchar(50) | Ja | — | — |
| `BldExternalStatus` | nvarchar(50) | Ja | — | — |
| `BldFloorGrossM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldFloorNettInstM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldFloorNettM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldFloorNettTrafHorM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldFloorNettTrafVertM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldFloorNettUsabM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldFloorTareM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldGeocodeX` | decimal(21,10) | Nee | ((0)) | — |
| `BldGeocodeY` | decimal(21,10) | Nee | ((0)) | — |
| `BldImageFile` | nvarchar(max) | Ja | — | — |
| `BldInsetDate` | date | Ja | — | — |
| `BldInstallationBSV` | decimal(21,5) | Nee | ((0)) | — |
| `BldLandedProperty` | smallint | Nee | ((0)) | — |
| `BldLandedPropertyBSV` | decimal(21,5) | Nee | ((0)) | — |
| `BldLtaId` | nvarchar(10) | Ja | — | — |
| `BldManualFloorGrossM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldManualFloorNettM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldManualGrossM3` | decimal(21,2) | Nee | ((0)) | — |
| `BldManualNettM3` | decimal(21,2) | Nee | ((0)) | — |
| `BldManualOutsideArea1M2` | decimal(21,2) | Nee | ((0)) | — |
| `BldManualOutsideArea2M2` | decimal(21,2) | Nee | ((0)) | — |
| `BldManualOutsideArea3M2` | decimal(21,2) | Nee | ((0)) | — |
| `BldManualOutsideArea4M2` | decimal(21,2) | Nee | ((0)) | — |
| `BldMarketValue` | decimal(21,5) | Nee | ((0)) | — |
| `BldMaxUserState` | int | Nee | ((0)) | — |
| `BldNeighborhood` | nvarchar(40) | Ja | — | — |
| `BldParkingState` | int | Nee | ((0)) | — |
| `BldPartOfBldId` | nvarchar(11) | Ja | — | — |
| `BldPrfId` | nvarchar(50) | Ja | — | — |
| `BldProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `BldProvinceStateRegion` | nvarchar(40) | Ja | — | — |
| `BldPurId` | nvarchar(6) | Ja | — | — |
| `BldRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `BldReplacementValue` | decimal(21,5) | Nee | ((0)) | — |
| `BldSitId` | nvarchar(8) | Ja | — | — |
| `BldText` | nvarchar(max) | Ja | — | — |
| `BldTransferNextTime` | smallint | Nee | ((0)) | — |
| `BldUserState` | int | Nee | ((0)) | — |
| `BldVdrId` | nvarchar(6) | Ja | — | — |
| `BldWallM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldYear1` | smallint | Nee | ((0)) | — |
| `BldYear10` | smallint | Nee | ((0)) | — |
| `BldYear11` | smallint | Nee | ((0)) | — |
| `BldYear12` | smallint | Nee | ((0)) | — |
| `BldYear13` | smallint | Nee | ((0)) | — |
| `BldYear14` | smallint | Nee | ((0)) | — |
| `BldYear15` | smallint | Nee | ((0)) | — |
| `BldYear16` | smallint | Nee | ((0)) | — |
| `BldYear17` | smallint | Nee | ((0)) | — |
| `BldYear18` | smallint | Nee | ((0)) | — |
| `BldYear19` | smallint | Nee | ((0)) | — |
| `BldYear2` | smallint | Nee | ((0)) | — |
| `BldYear20` | smallint | Nee | ((0)) | — |
| `BldYear21` | smallint | Nee | ((0)) | — |
| `BldYear22` | smallint | Nee | ((0)) | — |
| `BldYear23` | smallint | Nee | ((0)) | — |
| `BldYear24` | smallint | Nee | ((0)) | — |
| `BldYear25` | smallint | Nee | ((0)) | — |
| `BldYear26` | smallint | Nee | ((0)) | — |
| `BldYear27` | smallint | Nee | ((0)) | — |
| `BldYear28` | smallint | Nee | ((0)) | — |
| `BldYear29` | smallint | Nee | ((0)) | — |
| `BldYear3` | smallint | Nee | ((0)) | — |
| `BldYear30` | smallint | Nee | ((0)) | — |
| `BldYear31` | smallint | Nee | ((0)) | — |
| `BldYear32` | smallint | Nee | ((0)) | — |
| `BldYear33` | smallint | Nee | ((0)) | — |
| `BldYear34` | smallint | Nee | ((0)) | — |
| `BldYear35` | smallint | Nee | ((0)) | — |
| `BldYear36` | smallint | Nee | ((0)) | — |
| `BldYear37` | smallint | Nee | ((0)) | — |
| `BldYear38` | smallint | Nee | ((0)) | — |
| `BldYear39` | smallint | Nee | ((0)) | — |
| `BldYear4` | smallint | Nee | ((0)) | — |
| `BldYear40` | smallint | Nee | ((0)) | — |
| `BldYear5` | smallint | Nee | ((0)) | — |
| `BldYear6` | smallint | Nee | ((0)) | — |
| `BldYear7` | smallint | Nee | ((0)) | — |
| `BldYear8` | smallint | Nee | ((0)) | — |
| `BldYear9` | smallint | Nee | ((0)) | — |
| `BldZipCode` | nvarchar(10) | Ja | — | — |
| `BldBuildingTotalBSV` | decimal(21,5) | Nee | — | — |
| `BldFileExtension` | nvarchar(5) | Nee | — | — |
| `BldText_FT` | varbinary(max) | Ja | — | — |