Bewerken: SpaceMaintenance

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `SpcmId` | nvarchar(14) | Nee | — | — |
| `SpcmContext` | bigint | Nee | ((1)) | — |
| `SpcmRecStatus` | int | Nee | ((0)) | — |
| `SpcmBldfId` | nvarchar(23) | Ja | — | — |
| `SpcmBldId` | nvarchar(11) | Ja | — | — |
| `SpcmBldpId` | nvarchar(11) | Ja | — | — |
| `SpcmCompId` | nvarchar(6) | Nee | — | — |
| `SpcmCostYear1` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear10` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear11` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear12` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear13` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear14` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear15` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear16` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear17` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear18` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear19` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear2` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear20` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear21` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear22` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear23` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear24` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear25` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear26` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear27` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear28` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear29` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear3` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear30` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear31` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear32` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear33` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear34` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear35` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear36` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear37` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear38` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear39` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear4` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear40` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear5` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear6` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear7` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear8` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCostYear9` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmCurrentMntsId` | nvarchar(11) | Ja | — | — |
| `SpcmDataProvider` | nvarchar(50) | Ja | — | — |
| `SpcmDeletedByInspector` | smallint | Nee | ((0)) | — |
| `SpcmElementQty` | decimal(21,2) | Nee | ((0)) | — |
| `SpcmEqmId` | nvarchar(24) | Ja | — | — |
| `SpcmExistByInspector` | smallint | Nee | ((1)) | — |
| `SpcmExported` | smallint | Nee | ((0)) | — |
| `SpcmExternalId` | nvarchar(50) | Ja | — | — |
| `SpcmExternalStatus` | nvarchar(50) | Ja | — | — |
| `SpcmLocation` | nvarchar(100) | Ja | — | — |
| `SpcmLtaId` | nvarchar(10) | Ja | — | — |
| `SpcmMntpId` | nvarchar(11) | Ja | — | — |
| `SpcmProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `SpcmQty` | decimal(21,2) | Nee | ((0)) | — |
| `SpcmRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `SpcmSpcId` | nvarchar(40) | Ja | — | — |
| `SpcmText` | nvarchar(max) | Ja | — | — |
| `SpcmTransferNextTime` | smallint | Nee | ((0)) | — |
| `SpcmWantedMntsId` | nvarchar(11) | Ja | — | — |
| `SpcmYear1` | smallint | Nee | ((0)) | — |
| `SpcmYear10` | smallint | Nee | ((0)) | — |
| `SpcmYear11` | smallint | Nee | ((0)) | — |
| `SpcmYear12` | smallint | Nee | ((0)) | — |
| `SpcmYear13` | smallint | Nee | ((0)) | — |
| `SpcmYear14` | smallint | Nee | ((0)) | — |
| `SpcmYear15` | smallint | Nee | ((0)) | — |
| `SpcmYear16` | smallint | Nee | ((0)) | — |
| `SpcmYear17` | smallint | Nee | ((0)) | — |
| `SpcmYear18` | smallint | Nee | ((0)) | — |
| `SpcmYear19` | smallint | Nee | ((0)) | — |
| `SpcmYear2` | smallint | Nee | ((0)) | — |
| `SpcmYear20` | smallint | Nee | ((0)) | — |
| `SpcmYear21` | smallint | Nee | ((0)) | — |
| `SpcmYear22` | smallint | Nee | ((0)) | — |
| `SpcmYear23` | smallint | Nee | ((0)) | — |
| `SpcmYear24` | smallint | Nee | ((0)) | — |
| `SpcmYear25` | smallint | Nee | ((0)) | — |
| `SpcmYear26` | smallint | Nee | ((0)) | — |
| `SpcmYear27` | smallint | Nee | ((0)) | — |
| `SpcmYear28` | smallint | Nee | ((0)) | — |
| `SpcmYear29` | smallint | Nee | ((0)) | — |
| `SpcmYear3` | smallint | Nee | ((0)) | — |
| `SpcmYear30` | smallint | Nee | ((0)) | — |
| `SpcmYear31` | smallint | Nee | ((0)) | — |
| `SpcmYear32` | smallint | Nee | ((0)) | — |
| `SpcmYear33` | smallint | Nee | ((0)) | — |
| `SpcmYear34` | smallint | Nee | ((0)) | — |
| `SpcmYear35` | smallint | Nee | ((0)) | — |
| `SpcmYear36` | smallint | Nee | ((0)) | — |
| `SpcmYear37` | smallint | Nee | ((0)) | — |
| `SpcmYear38` | smallint | Nee | ((0)) | — |
| `SpcmYear39` | smallint | Nee | ((0)) | — |
| `SpcmYear4` | smallint | Nee | ((0)) | — |
| `SpcmYear40` | smallint | Nee | ((0)) | — |
| `SpcmYear5` | smallint | Nee | ((0)) | — |
| `SpcmYear6` | smallint | Nee | ((0)) | — |
| `SpcmYear7` | smallint | Nee | ((0)) | — |
| `SpcmYear8` | smallint | Nee | ((0)) | — |
| `SpcmYear9` | smallint | Nee | ((0)) | — |