title: "SpaceMaintenance" category: reference tags: [entity, space-maintenance, datamodel] source: Entities.xml date: 2026-04-17 status: published
SpaceMaintenance
Type: Entity Properties: 108 Contexts: 4 Statussen: 2
DB-schema:
lookup_table_schema("SpaceMaintenance")· ../tables/SpaceMaintenance
Contextsbewerken
- 0: Standaard (
SpaceMaintenanceContext.None) - 1: Standaard (
SpaceMaintenanceContext.Standard) - 2: MJOP (
SpaceMaintenanceContext.LongTermMaintenancePlan) - 4: LTAP (
SpaceMaintenanceContext.LongTermAssetPlan)
Statussenbewerken
- -1: Trash (
SpaceMaintenanceStatus.Trash) - 0: None (
SpaceMaintenanceStatus.None)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | SPCMID | 14 | false | |
| Activities | List[SpaceMaintenanceActivity] | SPCMASPCMID | false | ||
| BuildingFloorId | UltimoString | SPCMBLDFID | 23 | true | |
| BuildingId | UltimoString | SPCMBLDID | 11 | true | |
| BuildingPartId | UltimoString | SPCMBLDPID | 11 | true | |
| ConditionMeasurements | List[ConditionMeasurement] | CONMSPCMID | true | ||
| Context | Context | SPCMCONTEXT | false | 1 | |
| CostYear1 | CompanyMoney | SPCMCOSTYEAR1 | false | 0 | |
| CostYear10 | CompanyMoney | SPCMCOSTYEAR10 | false | 0 | |
| CostYear11 | CompanyMoney | SPCMCOSTYEAR11 | false | 0 | |
| CostYear12 | CompanyMoney | SPCMCOSTYEAR12 | false | 0 | |
| CostYear13 | CompanyMoney | SPCMCOSTYEAR13 | false | 0 | |
| CostYear14 | CompanyMoney | SPCMCOSTYEAR14 | false | 0 | |
| CostYear15 | CompanyMoney | SPCMCOSTYEAR15 | false | 0 | |
| CostYear16 | CompanyMoney | SPCMCOSTYEAR16 | false | 0 | |
| CostYear17 | CompanyMoney | SPCMCOSTYEAR17 | false | 0 | |
| CostYear18 | CompanyMoney | SPCMCOSTYEAR18 | false | 0 | |
| CostYear19 | CompanyMoney | SPCMCOSTYEAR19 | false | 0 | |
| CostYear2 | CompanyMoney | SPCMCOSTYEAR2 | false | 0 | |
| CostYear20 | CompanyMoney | SPCMCOSTYEAR20 | false | 0 | |
| CostYear21 | CompanyMoney | SPCMCOSTYEAR21 | false | 0 | |
| CostYear22 | CompanyMoney | SPCMCOSTYEAR22 | false | 0 | |
| CostYear23 | CompanyMoney | SPCMCOSTYEAR23 | false | 0 | |
| CostYear24 | CompanyMoney | SPCMCOSTYEAR24 | false | 0 | |
| CostYear25 | CompanyMoney | SPCMCOSTYEAR25 | false | 0 | |
| CostYear26 | CompanyMoney | SPCMCOSTYEAR26 | false | 0 | |
| CostYear27 | CompanyMoney | SPCMCOSTYEAR27 | false | 0 | |
| CostYear28 | CompanyMoney | SPCMCOSTYEAR28 | false | 0 | |
| CostYear29 | CompanyMoney | SPCMCOSTYEAR29 | false | 0 | |
| CostYear3 | CompanyMoney | SPCMCOSTYEAR3 | false | 0 | |
| CostYear30 | CompanyMoney | SPCMCOSTYEAR30 | false | 0 | |
| CostYear31 | CompanyMoney | SPCMCOSTYEAR31 | false | 0 | |
| CostYear32 | CompanyMoney | SPCMCOSTYEAR32 | false | 0 | |
| CostYear33 | CompanyMoney | SPCMCOSTYEAR33 | false | 0 | |
| CostYear34 | CompanyMoney | SPCMCOSTYEAR34 | false | 0 | |
| CostYear35 | CompanyMoney | SPCMCOSTYEAR35 | false | 0 | |
| CostYear36 | CompanyMoney | SPCMCOSTYEAR36 | false | 0 | |
| CostYear37 | CompanyMoney | SPCMCOSTYEAR37 | false | 0 | |
| CostYear38 | CompanyMoney | SPCMCOSTYEAR38 | false | 0 | |
| CostYear39 | CompanyMoney | SPCMCOSTYEAR39 | false | 0 | |
| CostYear4 | CompanyMoney | SPCMCOSTYEAR4 | false | 0 | |
| CostYear40 | CompanyMoney | SPCMCOSTYEAR40 | false | 0 | |
| CostYear5 | CompanyMoney | SPCMCOSTYEAR5 | false | 0 | |
| CostYear6 | CompanyMoney | SPCMCOSTYEAR6 | false | 0 | |
| CostYear7 | CompanyMoney | SPCMCOSTYEAR7 | false | 0 | |
| CostYear8 | CompanyMoney | SPCMCOSTYEAR8 | false | 0 | |
| CostYear9 | CompanyMoney | SPCMCOSTYEAR9 | false | 0 | |
| CurrentMaintenanceState | MaintenanceState | SPCMCURRENTMNTSID | true | ||
| DataProvider | UltimoString | SPCMDATAPROVIDER | 50 | true | |
| DeletedByInspector | Boolean | SPCMDELETEDBYINSPECTOR | false | 0 | |
| ElementQuantity | Decimal | SPCMELEMENTQTY | false | ||
| Equipment | Equipment | SPCMEQMID | true | ||
| ExistByInspector | Boolean | SPCMEXISTBYINSPECTOR | false | 1 | |
| Exported | Boolean | SPCMEXPORTED | false | ||
| ExternalId | UltimoString | SPCMEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | SPCMEXTERNALSTATUS | 50 | true | |
| Location | UltimoString | SPCMLOCATION | 100 | true | |
| LongTermAsset | LongTermAsset | SPCMLTAID | true | ||
| MaintenancePart | MaintenancePart | SPCMMNTPID | true | ||
| ProviderMutationDate | DateTime? | SPCMPROVIDERMUTDATE | true | ||
| Quantity | Decimal | SPCMQTY | false | ||
| RecordCreateDate | DateTime? | SPCMRECCREATEDATE | true | SYSDATETIME | |
| Space | Space | SPCMSPCID | true | ||
| Status | Status | SPCMRECSTATUS | false | ||
| SystemCompany | Company | SPCMCOMPID | false | ||
| Text | UltimoString | SPCMTEXT | true | ||
| TransferNextTime | Boolean | SPCMTRANSFERNEXTTIME | false | 0 | |
| WantedMaintenanceState | MaintenanceState | SPCMWANTEDMNTSID | true | ||
| Year1 | Int16 | SPCMYEAR1 | false | ||
| Year10 | Int16 | SPCMYEAR10 | false | ||
| Year11 | Int16 | SPCMYEAR11 | false | ||
| Year12 | Int16 | SPCMYEAR12 | false | ||
| Year13 | Int16 | SPCMYEAR13 | false | ||
| Year14 | Int16 | SPCMYEAR14 | false | ||
| Year15 | Int16 | SPCMYEAR15 | false | ||
| Year16 | Int16 | SPCMYEAR16 | false | ||
| Year17 | Int16 | SPCMYEAR17 | false | ||
| Year18 | Int16 | SPCMYEAR18 | false | ||
| Year19 | Int16 | SPCMYEAR19 | false | ||
| Year2 | Int16 | SPCMYEAR2 | false | ||
| Year20 | Int16 | SPCMYEAR20 | false | ||
| Year21 | Int16 | SPCMYEAR21 | false | ||
| Year22 | Int16 | SPCMYEAR22 | false | ||
| Year23 | Int16 | SPCMYEAR23 | false | ||
| Year24 | Int16 | SPCMYEAR24 | false | ||
| Year25 | Int16 | SPCMYEAR25 | false | ||
| Year26 | Int16 | SPCMYEAR26 | false | ||
| Year27 | Int16 | SPCMYEAR27 | false | ||
| Year28 | Int16 | SPCMYEAR28 | false | ||
| Year29 | Int16 | SPCMYEAR29 | false | ||
| Year3 | Int16 | SPCMYEAR3 | false | ||
| Year30 | Int16 | SPCMYEAR30 | false | ||
| Year31 | Int16 | SPCMYEAR31 | false | ||
| Year32 | Int16 | SPCMYEAR32 | false | ||
| Year33 | Int16 | SPCMYEAR33 | false | ||
| Year34 | Int16 | SPCMYEAR34 | false | ||
| Year35 | Int16 | SPCMYEAR35 | false | ||
| Year36 | Int16 | SPCMYEAR36 | false | ||
| Year37 | Int16 | SPCMYEAR37 | false | ||
| Year38 | Int16 | SPCMYEAR38 | false | ||
| Year39 | Int16 | SPCMYEAR39 | false | ||
| Year4 | Int16 | SPCMYEAR4 | false | ||
| Year40 | Int16 | SPCMYEAR40 | false | ||
| Year5 | Int16 | SPCMYEAR5 | false | ||
| Year6 | Int16 | SPCMYEAR6 | false | ||
| Year7 | Int16 | SPCMYEAR7 | false | ||
| Year8 | Int16 | SPCMYEAR8 | false | ||
| Year9 | Int16 | SPCMYEAR9 | false |
Brondatabewerken
- Entity-definitie —
lookup_entity("SpaceMaintenance")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("SpaceMaintenance")· ../tables/SpaceMaintenance DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="SpaceMaintenance")Before/After Save events voor SpaceMaintenance. Bron:workflows.xml.