Bewerken: Space

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `SpcId` | nvarchar(40) | Nee | — | — |
| `SpcDescr` | nvarchar(200) | Ja | — | — |
| `SpcContext` | bigint | Nee | ((1)) | — |
| `SpcRecStatus` | int | Nee | ((0)) | — |
| `SpcAdrId` | nvarchar(9) | Ja | — | — |
| `SpcBimGuid` | nvarchar(50) | Ja | — | — |
| `SpcBldfId` | nvarchar(23) | Ja | — | — |
| `SpcBldId` | nvarchar(11) | Ja | — | — |
| `SpcBldpId` | nvarchar(11) | Ja | — | — |
| `SpcCadDocId` | nvarchar(11) | Ja | — | — |
| `SpcCadHandle` | decimal(20,0) | Nee | ((0)) | — |
| `SpcCadHandleDocId` | nvarchar(11) | Ja | — | — |
| `SpcCadIdHandle` | decimal(20,0) | Nee | ((0)) | — |
| `SpcCadReportColor` | nvarchar(6) | Ja | — | — |
| `SpcCadReportPatternAngle` | int | Nee | ((0)) | — |
| `SpcCadReportPatternScale` | decimal(21,2) | Nee | ((0)) | — |
| `SpcCapacity` | decimal(21,0) | Nee | ((0)) | — |
| `SpcCcrId` | nvarchar(9) | Ja | — | — |
| `SpcClass` | nvarchar(2) | Ja | — | — |
| `SpcCompId` | nvarchar(6) | Nee | — | — |
| `SpcCopyFromSpcId` | nvarchar(40) | Ja | — | — |
| `SpcCostYear1` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear10` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear11` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear12` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear13` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear14` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear15` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear16` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear17` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear18` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear19` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear2` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear20` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear21` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear22` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear23` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear24` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear25` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear26` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear27` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear28` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear29` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear3` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear30` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear31` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear32` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear33` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear34` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear35` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear36` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear37` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear38` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear39` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear4` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear40` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear5` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear6` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear7` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear8` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCostYear9` | decimal(21,5) | Nee | ((0)) | — |
| `SpcCrptpId` | nvarchar(4) | Ja | — | — |
| `SpcDataProvider` | nvarchar(50) | Ja | — | — |
| `SpcDefCleaningTime` | int | Nee | ((0)) | — |
| `SpcDefPrepareTime` | int | Nee | ((0)) | — |
| `SpcDepId` | nvarchar(11) | Ja | — | — |
| `SpcEmailAddress` | nvarchar(80) | Ja | — | — |
| `SpcExchangePreviousPushMessageDate` | datetimeoffset(7) | Ja | — | — |
| `SpcExchangeSubscriptionId` | nvarchar(200) | Ja | — | — |
| `SpcExported` | smallint | Nee | ((0)) | — |
| `SpcExternalId` | nvarchar(50) | Ja | — | — |
| `SpcExternalStatus` | nvarchar(50) | Ja | — | — |
| `SpcFloorGrossM2` | decimal(21,2) | Nee | ((0)) | — |
| `SpcFloorNettInstM2` | decimal(21,2) | Nee | ((0)) | — |
| `SpcFloorNettM2` | decimal(15,2) | Nee | ((0)) | — |
| `SpcFloorNettTrafHorM2` | decimal(21,2) | Nee | ((0)) | — |
| `SpcFloorNettTrafVertM2` | decimal(21,2) | Nee | ((0)) | — |
| `SpcFloorNettUsabM2` | decimal(21,2) | Nee | ((0)) | — |
| `SpcFreeHeight` | decimal(21,2) | Nee | ((0)) | — |
| `SpcGrossHeight` | decimal(21,2) | Nee | ((0)) | — |
| `SpcHousenumberExtra` | nvarchar(6) | Ja | — | — |
| `SpcImageFile` | nvarchar(max) | Ja | — | — |
| `SpcImportReservationsFromExchange` | smallint | Nee | ((0)) | — |
| `SpcInvgId` | nvarchar(7) | Ja | — | — |
| `SpcIsDeliverySpace` | smallint | Nee | ((0)) | — |
| `SpcMinCapacity` | decimal(21,0) | Nee | ((0)) | — |
| `SpcNettHeight` | decimal(21,2) | Nee | ((0)) | — |
| `SpcProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `SpcPurId` | nvarchar(6) | Ja | — | — |
| `SpcRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `SpcRentable` | smallint | Nee | ((0)) | — |
| `SpcRentHourTariff` | decimal(21,5) | Nee | ((0)) | — |
| `SpcRentRealEstateStartDate` | date | Ja | — | — |
| `SpcReservable` | smallint | Nee | ((0)) | — |
| `SpcResoId` | nvarchar(11) | Ja | — | — |
| `SpcRnttId` | nvarchar(9) | Ja | — | — |
| `SpcRoomNr` | nvarchar(11) | Ja | — | — |
| `SpcSendReservationsToExchange` | smallint | Nee | ((0)) | — |
| `SpcSfcId` | nvarchar(6) | Ja | — | — |
| `SpcSitId` | nvarchar(8) | Ja | — | — |
| `SpcSpcstId` | nvarchar(11) | Ja | — | — |
| `SpcSpctId` | nvarchar(11) | Ja | — | — |
| `SpcStataId` | nvarchar(9) | Ja | — | — |
| `SpcTaxAdmCode` | nvarchar(14) | Ja | — | — |
| `SpcTaxAdmDisabledHousing` | smallint | Nee | ((0)) | — |
| `SpcTaxAdmLargeHousehold` | smallint | Nee | ((0)) | — |
| `SpcTaxAdmSpaceCode` | smallint | Nee | ((0)) | — |
| `SpcText` | nvarchar(max) | Ja | — | — |
| `SpcTransferNextTime` | smallint | Nee | ((0)) | — |
| `SpcVdrId` | nvarchar(6) | Ja | — | — |
| `SpcWallM2` | decimal(21,2) | Nee | ((0)) | — |
| `SpcYear1` | smallint | Nee | ((0)) | — |
| `SpcYear10` | smallint | Nee | ((0)) | — |
| `SpcYear11` | smallint | Nee | ((0)) | — |
| `SpcYear12` | smallint | Nee | ((0)) | — |
| `SpcYear13` | smallint | Nee | ((0)) | — |
| `SpcYear14` | smallint | Nee | ((0)) | — |
| `SpcYear15` | smallint | Nee | ((0)) | — |
| `SpcYear16` | smallint | Nee | ((0)) | — |
| `SpcYear17` | smallint | Nee | ((0)) | — |
| `SpcYear18` | smallint | Nee | ((0)) | — |
| `SpcYear19` | smallint | Nee | ((0)) | — |
| `SpcYear2` | smallint | Nee | ((0)) | — |
| `SpcYear20` | smallint | Nee | ((0)) | — |
| `SpcYear21` | smallint | Nee | ((0)) | — |
| `SpcYear22` | smallint | Nee | ((0)) | — |
| `SpcYear23` | smallint | Nee | ((0)) | — |
| `SpcYear24` | smallint | Nee | ((0)) | — |
| `SpcYear25` | smallint | Nee | ((0)) | — |
| `SpcYear26` | smallint | Nee | ((0)) | — |
| `SpcYear27` | smallint | Nee | ((0)) | — |
| `SpcYear28` | smallint | Nee | ((0)) | — |
| `SpcYear29` | smallint | Nee | ((0)) | — |
| `SpcYear3` | smallint | Nee | ((0)) | — |
| `SpcYear30` | smallint | Nee | ((0)) | — |
| `SpcYear31` | smallint | Nee | ((0)) | — |
| `SpcYear32` | smallint | Nee | ((0)) | — |
| `SpcYear33` | smallint | Nee | ((0)) | — |
| `SpcYear34` | smallint | Nee | ((0)) | — |
| `SpcYear35` | smallint | Nee | ((0)) | — |
| `SpcYear36` | smallint | Nee | ((0)) | — |
| `SpcYear37` | smallint | Nee | ((0)) | — |
| `SpcYear38` | smallint | Nee | ((0)) | — |
| `SpcYear39` | smallint | Nee | ((0)) | — |
| `SpcYear4` | smallint | Nee | ((0)) | — |
| `SpcYear40` | smallint | Nee | ((0)) | — |
| `SpcYear5` | smallint | Nee | ((0)) | — |
| `SpcYear6` | smallint | Nee | ((0)) | — |
| `SpcYear7` | smallint | Nee | ((0)) | — |
| `SpcYear8` | smallint | Nee | ((0)) | — |
| `SpcYear9` | smallint | Nee | ((0)) | — |
| `SpcZonId` | nvarchar(6) | Ja | — | — |
| `SpcFloorTareM2` | decimal(21,2) | Nee | — | — |
| `SpcFileExtension` | nvarchar(5) | Nee | — | — |
| `SPCTEXT_FT` | varbinary(max) | Ja | — | — |
| `SpcExchangeDeltaLink` | nvarchar(max) | Ja | — | — |
| `SpcExchangeClientState` | nvarchar(50) | Ja | — | — |