Bewerken: SpaceMaintenance

Sectie: Properties

Reden:

## Properties

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