Bewerken: PmWorkOrder

Sectie: Properties

Reden:

## Properties

| Property | Type | Kolom | Width | Nullable | Default |
|----------|------|-------|-------|----------|---------|
| Id | UltimoString | PMWID | 5 | false |  |
| AutoClose | Boolean | PMWAUTOCLOSE |  | false |  |
| AutoPmActive | Boolean | PMWAUTOPMACTIVE |  | false | 0 |
| AutoPmTimeUnit | TimeUnit | PMWAUTOPMTIMUID |  | true |  |
| AutoPmTimeUnitQuantity | Int16 | PMWAUTOPMTIMUQTY |  | false | 0 |
| BelongsToSchema | Boolean | PMWBELONGSTOSCHEMA |  | false | 0 |
| ChangeDateIndicatorValueLastMaintenance | DateTime? | PMWSTATEDATE |  | true |  |
| ChangeDateManualNextMaintenanceDate | DateTime? | PMWMANUALNEXTMAINTDATEDATE |  | true |  |
| ChangeEmployeeIndicatorValueLastMaintenance | Employee | PMWSTATEEMPID |  | true |  |
| ChangeEmployeeManualNextMaintenanceDate | Employee | PMWMANUALNEXTMAINTDATEEMPID |  | true |  |
| Context | Context | PMWCONTEXT |  | false | 1 |
| CostCenter | CostCenter | PMWCCRID |  | true |  |
| CostType | CostType | PMWCSTTID |  | true |  |
| DataProvider | UltimoString | PMWDATAPROVIDER | 50 | true |  |
| DaysAWeek | Int16 | PMWDAYSAWEEK |  | false | 7 |
| Department | Department | PMWDEPID |  | true |  |
| Description | UltimoString | PMWDESCR | 250 | true |  |
| DeviateFromMaintenanceClassification | Boolean | PMWDEVIATEFROMMNTC |  | false | 0 |
| Dynamic | Boolean | PMWFRQCODE |  | false | 0 |
| Employee | Employee | PMWEMPID |  | true |  |
| Equipment | Equipment | PMWEQMID |  | true |  |
| EquipmentMeasurementPoint | EquipmentMeasurementPoint | PMWEQMMSPEQMID, PMWEQMMSPMSPID |  | true | ,  |
| ExecuteOnDay | Day | PMWSTARTDAYID |  | true |  |
| ExecuteOnDayOccurrence | Int16 | PMWDAYOCCURRENCE |  | false |  |
| ExecutionDays | Int32 | PMWEXECUTIONDAYS |  | false | 0 |
| ExecutionPercentage | Int32 | PMWEXECUTIONPERCENTAGE |  | false | 0 |
| Exported | Boolean | PMWEXPORTED |  | false |  |
| ExternalCalculateFromPmWorkOrder | CompanyMoney | PMWSUBEXTCALC |  | false |  |
| ExternalId | UltimoString | PMWEXTERNALID | 50 | true |  |
| ExternalsCalculated | CompanyMoney | PMWEXTCALC |  | false | 0 |
| ExternalStatus | UltimoString | PMWEXTERNALSTATUS | 50 | true |  |
| Extra1 | Int16 | PMWEXTRA1 |  | false |  |
| Extra10 | UltimoString | PMWEXTRA10 | 5 | true |  |
| Extra11 | UltimoString | PMWEXTRA11 | 5 | true |  |
| Extra12 | Decimal | PMWEXTRA12 |  | false |  |
| Extra2 | Int32 | PMWEXTRA2 |  | false |  |
| Extra3 | UltimoString | PMWEXTRA3 | 5 | true |  |
| Extra4 | UltimoString | PMWEXTRA4 | 5 | true |  |
| Extra5 | Int32 | PMWEXTRA5 |  | false |  |
| Extra6 | Int32 | PMWEXTRA6 |  | false |  |
| Extra7 | Int32 | PMWEXTRA7 |  | false |  |
| Extra8 | UltimoString | PMWEXTRA8 | 5 | true |  |
| Extra9 | UltimoString | PMWEXTRA9 | 5 | true |  |
| Frequency | Int32 | PMWDAYS |  | false |  |
| FrequencyPeriod | Frequency | PMWFRQID |  | true |  |
| GenerateImmediately | Boolean | PMWMAINTNEC |  | false | 0 |
| GroupPmWorkOrder | PmWorkOrder | PMWGROUPPMWID |  | true |  |
| Hierarchy | Int16 | PMWHIERARCHY |  | false |  |
| Impact | Impact | PMWIMPID |  | true |  |
| IndicatorAttentionValue | Decimal | PMWSTARTSTATE |  | false |  |
| IndicatorMaintenanceInterval | Decimal | PMWHOURS |  | false |  |
| IndicatorNextMaintenanceDate | Date? | PMWSTATESTARTDATE |  | true |  |
| IndicatorValueLastMaintenance | Decimal | PMWSTATE |  | false |  |
| IndicatorValueNextMaintenance | Decimal | PMWSTATENEXTEXECUTION |  | false | 0 |
| InspectionLines | List[InspectionLine] | ISLPMWID |  | true |  |
| IsBulk | Boolean | PMWISBULK |  | false | 0 |
| JobPlan | JobPlan | PMWJPID |  | true |  |
| Jobs | List[Job] | JOBPMID |  | true |  |
| LastJobsGeneratedDate | DateTime? | PMWLASTJOBSGENERATEDDATE |  | true |  |
| LastMaintenanceDate | Date? | PMWENDDATE |  | true |  |
| LastRunDate | DateTime? | PMWLASTRUNDATE |  | true |  |
| LastRunStatus | UltimoString | PMWLASTRUNSTATUS |  | true |  |
| LastRunSuccess | Boolean | PMWLASTRUNSUCCESS |  | false | 0 |
| LastRunSuccessDate | DateTime? | PMWLASTRUNSUCCESSDATE |  | true |  |
| MaintenanceClassification | MaintenanceClassification | PMWMNTCID |  | true |  |
| ManualNextMaintenanceDate | Date? | PMWMANUALNEXTMAINTDATE |  | true |  |
| MarginAfterQuantity | Int16 | PMWMARGINAFTERQUANTITY |  | false | 0 |
| MarginAfterTimeUnit | TimeUnit | PMWMARGINAFTERTIMUID |  | true |  |
| MarginBeforeQuantity | Int16 | PMWMARGINBEFOREQUANTITY |  | false | 0 |
| MarginBeforeTimeUnit | TimeUnit | PMWMARGINBEFORETIMUID |  | true |  |
| MaterialCalculateFromPmWorkOrder | CompanyMoney | PMWSUBMATCALC |  | false |  |
| MaterialsCalculated | CompanyMoney | PMWMATCALC |  | false | 0 |
| MeterEquipment | Equipment | PMWMETEREQMID |  | true |  |
| NextMaintenanceDate | Date? | PMWSTARTDATE |  | true |  |
| NextRunDate | DateTime? | PMWNEXTRUNDATE |  | true |  |
| ParentPeriodicActivity | Boolean | PMWPARENTPERIODICACTIVITY |  | false | 0 |
| PmJobs | List[PmJob] | PMJPMWID |  | false |  |
| PmWorkOrdersInGroup | List[PmWorkOrder] | PMWGROUPPMWID |  | true |  |
| Priority | Priority | PMWPRIID |  | true |  |
| ProcessFunction | ProcessFunction | PMWPRFID |  | true |  |
| ProcessFunctionMeasurementPoint | ProcessFunctionMeasurementPoint | PMWPRFMSPPRFID, PMWPRFMSPMSPID |  | true | ,  |
| ProviderMutationDate | DateTime? | PMWPROVIDERMUTDATE |  | true |  |
| PurchaseRequestCalculated | CompanyMoney | PMWPURCHASEREQUESTCALC |  | false | 0 |
| PurchaseRequestCalculateFromPmWorkOrder | CompanyMoney | PMWSUBPURCHASEREQUESTCALC |  | false |  |
| RecordChangeDate | DateTime? | PMWRECCHANGEDATE |  | true |  |
| RecordCreateDate | DateTime? | PMWRECCREATEDATE |  | true | SYSDATETIME |
| ReopenedAutomatically | Boolean | PMWREOPENEDAUTOMATICALLY |  | false | 0 |
| ResourceCalculateFromPmWorkOrder | CompanyMoney | PMWSUBRESCALC |  | false |  |
| ResourcesCalculated | CompanyMoney | PMWRESCALC |  | false | 0 |
| ServiceContract | ServiceContract | PMWSVCID |  | true |  |
| Site | Site | PMWSITID |  | true |  |
| SkillCategory | SkillCategory | PMWSKCID |  | true |  |
| Space | Space | PMWSPCID |  | true |  |
| Status | Status | PMWRECSTATUS |  | false |  |
| StatusApprovedDate | DateTime? | PMWAPPRVDATE |  | true |  |
| StatusApprovedEmployee | Employee | PMWAPPRVEMPID |  | true |  |
| StopRelated | Boolean | PMWSTOPRELATED |  | false | 0 |
| SystemCompany | Company | PMWCOMPID |  | false |  |
| TimeNextMaintenanceDate | Date? | PMWFREQSTARTDATE |  | true |  |
| ToolCalculateFromPmWorkOrder | CompanyMoney | PMWSUBTLSCALC |  | false |  |
| ToolsCalculated | CompanyMoney | PMWTLSCALC |  | false | 0 |
| TotalCalculated | CompanyMoney | PMWTOTALCALC |  | false | 0 |
| TransferNextTime | Boolean | PMWTRANSFERNEXTTIME |  | false | 0 |
| Urgency | Urgency | PMWURGID |  | true |  |
| UseExecutionPercentage | Boolean | PMWUSEEXECUTIONPERCENTAGE |  | false | 1 |
| Vendor | Vendor | PMWVDRID |  | true |  |
| Week | WeekOfYear | PMWWEEK |  | false |  |
| Weeks | List[PmWeekScheme] | PMWSPMWID |  | false |  |
| WorkOrder | WorkOrder | PMWWOID |  | true |  |
| WorkOrderType | WorkOrderType | PMWWOTID |  | true |  |