title: "SpaceMaintenanceActivity (table)" category: reference tags: [table, spacemaintenanceactivity, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.SpaceMaintenanceActivity
Schema: dba
Aantal kolommen: 138
Zie ook de entity-pagina: ../entities/SpaceMaintenanceActivity
Kolommenbewerken
| 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 | — | — |
Trigger-gevulde kolommenbewerken
SpcmaEndYearMaintFreq← TRGU_Company
Brondatabewerken
- DB-schema —
lookup_table_schema("SpaceMaintenanceActivity")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("SpaceMaintenanceActivity")· ../entities/SpaceMaintenanceActivity Properties, contexts, statussen. Bron:Entities.xml.