Bewerken: SpaceMaintenanceActivity

Sectie: Properties

Reden:

## Properties

| 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 | , ,  |