title: "SpaceMaintenanceActivity" category: reference tags: [entity, space-maintenance-activity, datamodel] source: Entities.xml date: 2026-04-17 status: published
SpaceMaintenanceActivity
Type: Entity Properties: 139 Contexts: 4 Statussen: 6
DB-schema:
lookup_table_schema("SpaceMaintenanceActivity")· ../tables/SpaceMaintenanceActivity
Contextsbewerken
- 0: Standaard (
SpaceMaintenanceActivityContext.None) - 1: Standaard (
SpaceMaintenanceActivityContext.Standard) - 2: MJOP (
SpaceMaintenanceActivityContext.LongTermMaintenancePlan) - 4: LTAP (
SpaceMaintenanceActivityContext.LongTermAssetPlan)
Statussenbewerken
- -1: Trash (
SpaceMaintenanceActivityStatus.Trash) - 0: None (
SpaceMaintenanceActivityStatus.None) - 1: Open (
SpaceMaintenanceActivityStatus.Created) - 2: Goedgekeurd (
SpaceMaintenanceActivityStatus.Scheduled) - 4: Actief (
SpaceMaintenanceActivityStatus.Active) - 8: Vervallen (
SpaceMaintenanceActivityStatus.Expired)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id.MaintenancePartActivity | MaintenancePartActivity | SPCMAMNTPID, SPCMAMNTAID | false | , | |
| Id.SpaceMaintenance | SpaceMaintenance | SPCMASPCMID | false | ||
| Active | Boolean | SPCMAACTIVE | false | 0 | |
| ActivityMoments | List[SpaceMaintenanceActivityMoment] | SPCMAMSPCMMNTPID, SPCMAMSPCMMNTAID, SPCMAMSPCMID | false | , , | |
| AdjustedConstructionYear | Decimal | SPCMAADJCONSTRUCTIONYEAR | false | 0 | |
| CalculatedCost | Decimal | SPCMACALCCOST | false | ||
| CalculationMethod | SpaceMaintenanceActivityCalculationMethod | SPCMACALCULATIONMETHOD | false | ||
| ConditionScore | UltimoString | SPCMACONDITIONAFTACT | 11 | true | |
| Context | Context | SPCMACONTEXT | false | ||
| CostCenter | CostCenter | SPCMACCRID | true | ||
| CostType | CostType | SPCMACSTTID | true | ||
| CostYear1 | CompanyMoney | SPCMACOSTYEAR1 | false | 0 | |
| CostYear10 | CompanyMoney | SPCMACOSTYEAR10 | false | 0 | |
| CostYear11 | CompanyMoney | SPCMACOSTYEAR11 | false | 0 | |
| CostYear12 | CompanyMoney | SPCMACOSTYEAR12 | false | 0 | |
| CostYear13 | CompanyMoney | SPCMACOSTYEAR13 | false | 0 | |
| CostYear14 | CompanyMoney | SPCMACOSTYEAR14 | false | 0 | |
| CostYear15 | CompanyMoney | SPCMACOSTYEAR15 | false | 0 | |
| CostYear16 | CompanyMoney | SPCMACOSTYEAR16 | false | 0 | |
| CostYear17 | CompanyMoney | SPCMACOSTYEAR17 | false | 0 | |
| CostYear18 | CompanyMoney | SPCMACOSTYEAR18 | false | 0 | |
| CostYear19 | CompanyMoney | SPCMACOSTYEAR19 | false | 0 | |
| CostYear2 | CompanyMoney | SPCMACOSTYEAR2 | false | 0 | |
| CostYear20 | CompanyMoney | SPCMACOSTYEAR20 | false | 0 | |
| CostYear21 | CompanyMoney | SPCMACOSTYEAR21 | false | 0 | |
| CostYear22 | CompanyMoney | SPCMACOSTYEAR22 | false | 0 | |
| CostYear23 | CompanyMoney | SPCMACOSTYEAR23 | false | 0 | |
| CostYear24 | CompanyMoney | SPCMACOSTYEAR24 | false | 0 | |
| CostYear25 | CompanyMoney | SPCMACOSTYEAR25 | false | 0 | |
| CostYear26 | CompanyMoney | SPCMACOSTYEAR26 | false | 0 | |
| CostYear27 | CompanyMoney | SPCMACOSTYEAR27 | false | 0 | |
| CostYear28 | CompanyMoney | SPCMACOSTYEAR28 | false | 0 | |
| CostYear29 | CompanyMoney | SPCMACOSTYEAR29 | false | 0 | |
| CostYear3 | CompanyMoney | SPCMACOSTYEAR3 | false | 0 | |
| CostYear30 | CompanyMoney | SPCMACOSTYEAR30 | false | 0 | |
| CostYear31 | CompanyMoney | SPCMACOSTYEAR31 | false | 0 | |
| CostYear32 | CompanyMoney | SPCMACOSTYEAR32 | false | 0 | |
| CostYear33 | CompanyMoney | SPCMACOSTYEAR33 | false | 0 | |
| CostYear34 | CompanyMoney | SPCMACOSTYEAR34 | false | 0 | |
| CostYear35 | CompanyMoney | SPCMACOSTYEAR35 | false | 0 | |
| CostYear36 | CompanyMoney | SPCMACOSTYEAR36 | false | 0 | |
| CostYear37 | CompanyMoney | SPCMACOSTYEAR37 | false | 0 | |
| CostYear38 | CompanyMoney | SPCMACOSTYEAR38 | false | 0 | |
| CostYear39 | CompanyMoney | SPCMACOSTYEAR39 | false | 0 | |
| CostYear4 | CompanyMoney | SPCMACOSTYEAR4 | false | 0 | |
| CostYear40 | CompanyMoney | SPCMACOSTYEAR40 | false | 0 | |
| CostYear5 | CompanyMoney | SPCMACOSTYEAR5 | false | 0 | |
| CostYear6 | CompanyMoney | SPCMACOSTYEAR6 | false | 0 | |
| CostYear7 | CompanyMoney | SPCMACOSTYEAR7 | false | 0 | |
| CostYear8 | CompanyMoney | SPCMACOSTYEAR8 | false | 0 | |
| CostYear9 | CompanyMoney | SPCMACOSTYEAR9 | false | 0 | |
| DataProvider | UltimoString | SPCMADATAPROVIDER | 50 | true | |
| EndYearMaintenanceFrequency | Int32 | SPCMAENDYEARMAINTFREQ | false | ||
| Exported | Boolean | SPCMAEXPORTED | false | ||
| ExternalId | UltimoString | SPCMAEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | SPCMAEXTERNALSTATUS | 50 | true | |
| FixedPrice | CompanyMoney | SPCMAFIXEDPRICE | false | 0 | |
| ImplementationPercentage | Decimal | SPCMAIMPLEMENTATIONPERC | false | ||
| InCurrentYearPlan | Boolean | SPCMAINCURRENTYRP | false | ||
| InPreviousYearPlan | Boolean | SPCMAINPREVYRP | false | ||
| LabourGrossCost | CompanyMoney | SPCMALABGROSSCOST | false | 0 | |
| LabourNetCost | CompanyMoney | SPCMALABNETTCOST | false | 0 | |
| LabourRaisePercentage | Decimal | SPCMALABRAISEPERCENTAGE | false | ||
| LastInspectionDate | Date? | SPCMALASTINSPECTIONDATE | true | ||
| LastMaintenanceDate | Date? | SPCMALASTMAINTENANCEDATE | true | ||
| LastMaintenanceYear | Int32 | SPCMALASTMAINTENANCEYEAR | false | ||
| LastMaintenanceYearPreviousYearPlan | Int32 | SPCMALASTMAINTYEARPREVYRP | false | ||
| MaintenanceFrequency | Int16 | SPCMAMAINTFREQ | false | ||
| MaintenanceFrequencyMethod | SpaceMaintenanceActivityMaintenanceFrequencyMethod | SPCMAMAINTFREQUENCYMETHOD | false | ||
| MaintenanceState | MaintenanceState | SPCMAMNTSID | true | ||
| MaintenanceStateImprovement | Int16 | SPCMASTATEIMPROVEMENT | false | 0 | |
| NextInspectionDate | Date? | SPCMANEXTINSPECTIONDATE | true | ||
| NextMaintenanceState | MaintenanceState | SPCMANEXTMNTSID | true | ||
| NextMaintenanceYear | Int32 | SPCMANEXTMAINTENANCEYEAR | false | ||
| NextMaintenanceYearInspector | Int32 | SPCMANEXTMNTYEARINSPECTOR | false | ||
| NextMaintenanceYearInspectorPreviousYearPlan | Int32 | SPCMANEXTMNTYEARINSPPREVYRP | false | ||
| NextMaintenanceYearNEN | Int32 | SPCMANEXTMAINTYEARNEN | false | ||
| NextMaintenanceYearPreviousYearPlan | Int32 | SPCMANEXTMAINTYEARPREVYRP | false | ||
| NextObservationYear | Int32 | SPCMANEXTOBSERVATIONYEAR | false | 0 | |
| ObservationsPerCycle | Int32 | SPCMAOBSERVATIONSPERCYCLE | false | ||
| PercentageOfReplacementCost | Decimal | SPCMAPERCOFREPLACEMENTCOST | false | ||
| PreviousYearPlan | YearPlan | SPCMAPREVYRPID | true | ||
| Price | CompanyMoney | SPCMAPRICE | false | 0 | |
| ProviderMutationDate | DateTime? | SPCMAPROVIDERMUTDATE | true | ||
| Quantity | Decimal | SPCMAQTY | false | ||
| RaisePercentage | Decimal | SPCMARAISEPERCENTAGE | false | 0 | |
| RecordCreateDate | DateTime? | SPCMARECCREATEDATE | true | SYSDATETIME | |
| StandardCostExcludingLabour | CompanyMoney | SPCMASTDCOSTEXLAB | false | 0 | |
| StandardTotalCost | CompanyMoney | SPCMASTDTOTALCOST | false | 0 | |
| StartYear | Int16 | SPCMASTARTYEAR | false | ||
| StartYearMaintenanceFrequency | Int32 | SPCMASTARTYEARMAINTFREQ | false | ||
| Status | Status | SPCMARECSTATUS | false | ||
| SystemCompany | Company | SPCMACOMPID | false | ||
| Text | UltimoString | SPCMATEXT | true | ||
| TransferNextTime | Boolean | SPCMATRANSFERNEXTTIME | false | 0 | |
| UnitPrice | CompanyMoney | SPCMAUNTPRICE | false | 0 | |
| UseStandardMaintenanceFrequency | Boolean | SPCMAUSESTANDARDMAINTFREQ | false | 1 | |
| Year1 | Int16 | SPCMAYEAR1 | false | ||
| Year10 | Int16 | SPCMAYEAR10 | false | ||
| Year11 | Int16 | SPCMAYEAR11 | false | ||
| Year12 | Int16 | SPCMAYEAR12 | false | ||
| Year13 | Int16 | SPCMAYEAR13 | false | ||
| Year14 | Int16 | SPCMAYEAR14 | false | ||
| Year15 | Int16 | SPCMAYEAR15 | false | ||
| Year16 | Int16 | SPCMAYEAR16 | false | ||
| Year17 | Int16 | SPCMAYEAR17 | false | ||
| Year18 | Int16 | SPCMAYEAR18 | false | ||
| Year19 | Int16 | SPCMAYEAR19 | false | ||
| Year2 | Int16 | SPCMAYEAR2 | false | ||
| Year20 | Int16 | SPCMAYEAR20 | false | ||
| Year21 | Int16 | SPCMAYEAR21 | false | ||
| Year22 | Int16 | SPCMAYEAR22 | false | ||
| Year23 | Int16 | SPCMAYEAR23 | false | ||
| Year24 | Int16 | SPCMAYEAR24 | false | ||
| Year25 | Int16 | SPCMAYEAR25 | false | ||
| Year26 | Int16 | SPCMAYEAR26 | false | ||
| Year27 | Int16 | SPCMAYEAR27 | false | ||
| Year28 | Int16 | SPCMAYEAR28 | false | ||
| Year29 | Int16 | SPCMAYEAR29 | false | ||
| Year3 | Int16 | SPCMAYEAR3 | false | ||
| Year30 | Int16 | SPCMAYEAR30 | false | ||
| Year31 | Int16 | SPCMAYEAR31 | false | ||
| Year32 | Int16 | SPCMAYEAR32 | false | ||
| Year33 | Int16 | SPCMAYEAR33 | false | ||
| Year34 | Int16 | SPCMAYEAR34 | false | ||
| Year35 | Int16 | SPCMAYEAR35 | false | ||
| Year36 | Int16 | SPCMAYEAR36 | false | ||
| Year37 | Int16 | SPCMAYEAR37 | false | ||
| Year38 | Int16 | SPCMAYEAR38 | false | ||
| Year39 | Int16 | SPCMAYEAR39 | false | ||
| Year4 | Int16 | SPCMAYEAR4 | false | ||
| Year40 | Int16 | SPCMAYEAR40 | false | ||
| Year5 | Int16 | SPCMAYEAR5 | false | ||
| Year6 | Int16 | SPCMAYEAR6 | false | ||
| Year7 | Int16 | SPCMAYEAR7 | false | ||
| Year8 | Int16 | SPCMAYEAR8 | false | ||
| Year9 | Int16 | SPCMAYEAR9 | false | ||
| YearPlan | YearPlan | SPCMAYRPID | true | ||
| YearPlanScenarioLines | List[YearPlanScenarioLine] | YRPSLSPCMAMNTPID, YRPSLSPCMAMNTAID, YRPSLSPCMASPCMID | true | , , |
Brondatabewerken
- Entity-definitie —
lookup_entity("SpaceMaintenanceActivity")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("SpaceMaintenanceActivity")· ../tables/SpaceMaintenanceActivity DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="SpaceMaintenanceActivity")Before/After Save events voor SpaceMaintenanceActivity. Bron:workflows.xml.