Bewerken: SpaceMaintenanceActivity

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `SpcmaMntpId` | nvarchar(11) | Nee | — | — |
| `SpcmaMntaId` | nvarchar(11) | Nee | — | — |
| `SpcmaSpcmId` | nvarchar(14) | Nee | — | — |
| `SpcmaContext` | bigint | Nee | ((0)) | — |
| `SpcmaRecStatus` | int | Nee | ((0)) | — |
| `SpcmaActive` | smallint | Nee | ((0)) | — |
| `SpcmaAdjConstructionYear` | decimal(21,3) | Nee | ((0)) | — |
| `SpcmaCalcCost` | decimal(21,2) | Nee | ((0)) | — |
| `SpcmaCalculationMethod` | smallint | Nee | ((0)) | — |
| `SpcmaCcrId` | nvarchar(9) | Ja | — | — |
| `SpcmaCompId` | nvarchar(6) | Nee | — | — |
| `SpcmaConditionAftAct` | nvarchar(11) | Ja | — | — |
| `SpcmaCostYear1` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear10` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear11` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear12` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear13` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear14` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear15` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear16` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear17` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear18` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear19` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear2` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear20` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear21` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear22` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear23` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear24` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear25` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear26` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear27` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear28` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear29` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear3` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear30` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear31` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear32` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear33` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear34` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear35` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear36` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear37` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear38` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear39` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear4` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear40` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear5` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear6` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear7` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear8` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCostYear9` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaCsttId` | nvarchar(9) | Ja | — | — |
| `SpcmaDataProvider` | nvarchar(50) | Ja | — | — |
| `SpcmaEndYearMaintFreq` | int | Nee | ((0)) | — |
| `SpcmaExported` | smallint | Nee | ((0)) | — |
| `SpcmaExternalId` | nvarchar(50) | Ja | — | — |
| `SpcmaExternalStatus` | nvarchar(50) | Ja | — | — |
| `SpcmaFixedPrice` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaImplementationPerc` | decimal(21,2) | Nee | ((0)) | — |
| `SpcmaInCurrentYrp` | smallint | Nee | ((0)) | — |
| `SpcmaInPrevYrp` | smallint | Nee | ((0)) | — |
| `SpcmaLabGrossCost` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaLabNettCost` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaLabRaisePercentage` | decimal(21,2) | Nee | ((0)) | — |
| `SpcmaLastInspectionDate` | date | Ja | — | — |
| `SpcmaLastMaintenanceDate` | date | Ja | — | — |
| `SpcmaLastMaintenanceYear` | int | Nee | ((0)) | — |
| `SpcmaLastMaintYearPrevYrp` | int | Nee | ((0)) | — |
| `SpcmaMaintFreq` | smallint | Nee | ((0)) | — |
| `SpcmaMaintFrequencyMethod` | smallint | Nee | ((0)) | — |
| `SpcmaMntsId` | nvarchar(11) | Ja | — | — |
| `SpcmaNextInspectionDate` | date | Ja | — | — |
| `SpcmaNextMaintenanceYear` | int | Nee | ((0)) | — |
| `SpcmaNextMaintYearNEN` | int | Nee | ((0)) | — |
| `SpcmaNextMaintYearPrevYrp` | int | Nee | ((0)) | — |
| `SpcmaNextMntsId` | nvarchar(11) | Ja | — | — |
| `SpcmaNextMntYearInspector` | int | Nee | ((0)) | — |
| `SpcmaNextMntYearInspPrevYrp` | int | Nee | ((0)) | — |
| `SpcmaNextObservationYear` | int | Nee | ((0)) | — |
| `SpcmaObservationsPerCycle` | int | Nee | ((0)) | — |
| `SpcmaPercOfReplacementCost` | decimal(21,2) | Nee | ((0)) | — |
| `SpcmaPrevYrpId` | nvarchar(9) | Ja | — | — |
| `SpcmaPrice` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `SpcmaQty` | decimal(21,2) | Nee | ((0)) | — |
| `SpcmaRaisePercentage` | decimal(21,2) | Nee | ((0)) | — |
| `SpcmaRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `SpcmaStartYear` | smallint | Nee | ((0)) | — |
| `SpcmaStartYearMaintFreq` | int | Nee | ((0)) | — |
| `SpcmaStateImprovement` | smallint | Nee | ((0)) | — |
| `SpcmaStdCostExLab` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaStdTotalCost` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaText` | nvarchar(max) | Ja | — | — |
| `SpcmaTransferNextTime` | smallint | Nee | ((0)) | — |
| `SpcmaUntPrice` | decimal(21,5) | Nee | ((0)) | — |
| `SpcmaUseStandardMaintFreq` | smallint | Nee | ((1)) | — |
| `SpcmaYear1` | smallint | Nee | ((0)) | — |
| `SpcmaYear10` | smallint | Nee | ((0)) | — |
| `SpcmaYear11` | smallint | Nee | ((0)) | — |
| `SpcmaYear12` | smallint | Nee | ((0)) | — |
| `SpcmaYear13` | smallint | Nee | ((0)) | — |
| `SpcmaYear14` | smallint | Nee | ((0)) | — |
| `SpcmaYear15` | smallint | Nee | ((0)) | — |
| `SpcmaYear16` | smallint | Nee | ((0)) | — |
| `SpcmaYear17` | smallint | Nee | ((0)) | — |
| `SpcmaYear18` | smallint | Nee | ((0)) | — |
| `SpcmaYear19` | smallint | Nee | ((0)) | — |
| `SpcmaYear2` | smallint | Nee | ((0)) | — |
| `SpcmaYear20` | smallint | Nee | ((0)) | — |
| `SpcmaYear21` | smallint | Nee | ((0)) | — |
| `SpcmaYear22` | smallint | Nee | ((0)) | — |
| `SpcmaYear23` | smallint | Nee | ((0)) | — |
| `SpcmaYear24` | smallint | Nee | ((0)) | — |
| `SpcmaYear25` | smallint | Nee | ((0)) | — |
| `SpcmaYear26` | smallint | Nee | ((0)) | — |
| `SpcmaYear27` | smallint | Nee | ((0)) | — |
| `SpcmaYear28` | smallint | Nee | ((0)) | — |
| `SpcmaYear29` | smallint | Nee | ((0)) | — |
| `SpcmaYear3` | smallint | Nee | ((0)) | — |
| `SpcmaYear30` | smallint | Nee | ((0)) | — |
| `SpcmaYear31` | smallint | Nee | ((0)) | — |
| `SpcmaYear32` | smallint | Nee | ((0)) | — |
| `SpcmaYear33` | smallint | Nee | ((0)) | — |
| `SpcmaYear34` | smallint | Nee | ((0)) | — |
| `SpcmaYear35` | smallint | Nee | ((0)) | — |
| `SpcmaYear36` | smallint | Nee | ((0)) | — |
| `SpcmaYear37` | smallint | Nee | ((0)) | — |
| `SpcmaYear38` | smallint | Nee | ((0)) | — |
| `SpcmaYear39` | smallint | Nee | ((0)) | — |
| `SpcmaYear4` | smallint | Nee | ((0)) | — |
| `SpcmaYear40` | smallint | Nee | ((0)) | — |
| `SpcmaYear5` | smallint | Nee | ((0)) | — |
| `SpcmaYear6` | smallint | Nee | ((0)) | — |
| `SpcmaYear7` | smallint | Nee | ((0)) | — |
| `SpcmaYear8` | smallint | Nee | ((0)) | — |
| `SpcmaYear9` | smallint | Nee | ((0)) | — |
| `SpcmaYrpId` | nvarchar(9) | Ja | — | — |