Bewerken: BuildingFloor

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `BldfBldId` | nvarchar(11) | Nee | — | — |
| `BldfBldpId` | nvarchar(11) | Nee | — | — |
| `BldfId` | nvarchar(23) | Nee | — | — |
| `BldfDescr` | nvarchar(200) | Ja | — | — |
| `BldfContext` | bigint | Nee | ((1)) | — |
| `BldfRecStatus` | int | Nee | ((0)) | — |
| `BldfCadDocId` | nvarchar(11) | Ja | — | — |
| `BldfCcrId` | nvarchar(9) | Ja | — | — |
| `BldfCompId` | nvarchar(6) | Nee | — | — |
| `BldfCostYear1` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear10` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear11` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear12` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear13` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear14` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear15` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear16` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear17` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear18` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear19` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear2` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear20` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear21` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear22` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear23` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear24` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear25` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear26` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear27` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear28` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear29` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear3` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear30` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear31` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear32` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear33` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear34` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear35` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear36` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear37` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear38` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear39` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear4` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear40` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear5` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear6` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear7` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear8` | decimal(21,5) | Nee | ((0)) | — |
| `BldfCostYear9` | decimal(21,5) | Nee | ((0)) | — |
| `BldfDataProvider` | nvarchar(50) | Ja | — | — |
| `BldfDepId` | nvarchar(11) | Ja | — | — |
| `BldfExported` | smallint | Nee | ((0)) | — |
| `BldfExternalId` | nvarchar(50) | Ja | — | — |
| `BldfExternalStatus` | nvarchar(50) | Ja | — | — |
| `BldfFloorGrossM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldfFloorNettInstM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldfFloorNettM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldfFloorNettTrafHorM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldfFloorNettTrafVertM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldfFloorNettUsabM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldfFloorTareM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldfImageFile` | nvarchar(max) | Ja | — | — |
| `BldfProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `BldfPurId` | nvarchar(6) | Ja | — | — |
| `BldfRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `BldfSitId` | nvarchar(8) | Ja | — | — |
| `BldfText` | nvarchar(max) | Ja | — | — |
| `BldfTransferNextTime` | smallint | Nee | ((0)) | — |
| `BldfWallM2` | decimal(21,2) | Nee | ((0)) | — |
| `BldfYear1` | smallint | Nee | ((0)) | — |
| `BldfYear10` | smallint | Nee | ((0)) | — |
| `BldfYear11` | smallint | Nee | ((0)) | — |
| `BldfYear12` | smallint | Nee | ((0)) | — |
| `BldfYear13` | smallint | Nee | ((0)) | — |
| `BldfYear14` | smallint | Nee | ((0)) | — |
| `BldfYear15` | smallint | Nee | ((0)) | — |
| `BldfYear16` | smallint | Nee | ((0)) | — |
| `BldfYear17` | smallint | Nee | ((0)) | — |
| `BldfYear18` | smallint | Nee | ((0)) | — |
| `BldfYear19` | smallint | Nee | ((0)) | — |
| `BldfYear2` | smallint | Nee | ((0)) | — |
| `BldfYear20` | smallint | Nee | ((0)) | — |
| `BldfYear21` | smallint | Nee | ((0)) | — |
| `BldfYear22` | smallint | Nee | ((0)) | — |
| `BldfYear23` | smallint | Nee | ((0)) | — |
| `BldfYear24` | smallint | Nee | ((0)) | — |
| `BldfYear25` | smallint | Nee | ((0)) | — |
| `BldfYear26` | smallint | Nee | ((0)) | — |
| `BldfYear27` | smallint | Nee | ((0)) | — |
| `BldfYear28` | smallint | Nee | ((0)) | — |
| `BldfYear29` | smallint | Nee | ((0)) | — |
| `BldfYear3` | smallint | Nee | ((0)) | — |
| `BldfYear30` | smallint | Nee | ((0)) | — |
| `BldfYear31` | smallint | Nee | ((0)) | — |
| `BldfYear32` | smallint | Nee | ((0)) | — |
| `BldfYear33` | smallint | Nee | ((0)) | — |
| `BldfYear34` | smallint | Nee | ((0)) | — |
| `BldfYear35` | smallint | Nee | ((0)) | — |
| `BldfYear36` | smallint | Nee | ((0)) | — |
| `BldfYear37` | smallint | Nee | ((0)) | — |
| `BldfYear38` | smallint | Nee | ((0)) | — |
| `BldfYear39` | smallint | Nee | ((0)) | — |
| `BldfYear4` | smallint | Nee | ((0)) | — |
| `BldfYear40` | smallint | Nee | ((0)) | — |
| `BldfYear5` | smallint | Nee | ((0)) | — |
| `BldfYear6` | smallint | Nee | ((0)) | — |
| `BldfYear7` | smallint | Nee | ((0)) | — |
| `BldfYear8` | smallint | Nee | ((0)) | — |
| `BldfYear9` | smallint | Nee | ((0)) | — |