WO_WorkOrderOperationDetail Work Order Operation Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/WO"+%C$+"/WO_WorkOrderOperationDetail.M4T"
KPRIMARY: WorkOrderNo+StepNo+SubStepPrefix+SubStepSuffix
Fld Column Name M/L TUR Description/Notes Class
1 WorkOrderNo . . . . . . . . . 7 SYY Work Order Number . . . . . . .WORKORDERNO Notes: WO3$(1,7) 2 StepNo. . . . . . . . . . . . 4 SNN Step Number . . . . . . . . . . Mask:0000 Notes: WO3$(8,4) 3 SubStepPrefix . . . . . . . . 1 SYN Sub Step Prefix . . . . . . . . Notes: WO3$(12,1) 4 SubStepSuffix . . . . . . . . 4 SNN Sub Step Suffix . . . . . . . . Mask:000 Notes: WO3$(13,4) 5 WorkCenter. . . . . . . . . . 5 SYN Work Center . . . . . . . . . . Notes: WO3$(17,5) 6 OperationCode . . . . . . . . 5 SYN Operation Code. . . . . . . . . Notes: WO3$(22,5) 7 StepDesc. . . . . . . . . . . 30 SNN Step Description. . . . . . . .DESCRIPTION Notes: WO3$(27,30) 8 SytextDesc. . . . . . . . . . 1 SYN Sytext Description. . . . . . .YESNO DfltVal:N Valid:Y,N Notes: WO3$(57,1) 9 IgnoreQueueTime . . . . . . . 1 SYN Ignore Queue Time . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: WO3$(58,1) 10 StandardRunTimeType . . . . . 1 SYN Standard Run Time Type. . . . . Valid:L,O,H Notes: WO3$(59, 1) 11 ParentItemType. . . . . . . . 1 SNN Parent Item Type. . . . . . . . Valid:O,P Notes: WO3$(60,1) 12 ToolingNo . . . . . . . . . . 20 SNN Tooling Number. . . . . . . . . Notes: WO3$(61,20) 13 ScheduledRunStartDate . . . . 8 SNN Scheduled Run Start Date. . . .DATE Notes: WO3$(101,6) 14 ScheduledCompletionDate . . . 8 SNN Scheduled Completion Date . . .DATE Notes: WO3$(107,6) 15 ActualStartDate . . . . . . . 8 SNN Actual Start Date . . . . . . .DATE Notes: WO3$(113,6) 16 LastActivityDate. . . . . . . 8 SNN Last Activity Date. . . . . . .DATE Notes: WO3$(119,6) 17 StepComplete. . . . . . . . . 1 SYN Step Complete . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: WO3$(125,1) 18 ScheduledQueueStartDate . . . 8 SNN Scheduled Queue Start Date. . .DATE Notes: WO3$(126,6) 19 OutsideProcessing . . . . . . 1 SYN Outside Processing. . . . . . .YESNO DfltVal:N Valid:Y,N Notes: WO3$(132,1) 20 ScheduleOverlapPercent. . . . 10.2 NNN Schedule Overlap Percent. . . .PERCENTAGE Mask:###,###.00- Notes: WO3$[0] 21 StandardRunTime . . . . . . . 12.2 NNN Standard Run Time . . . . . . . Mask:#######0.00 Notes: WO3$[1] 22 ParentQuantityFactor. . . . . 5.0 NNN Parent Quantity Factor. . . . . Mask:####0 Notes: WO3$[2] 23 ExtendedStandardTime. . . . . 12.2 NNN Extended Standard Time. . . . . Mask:#######0.00 Notes: WO3$[3] 24 OperationCyclesPlannedForStep 12.2 NNN Operation Cycles Planned For St Mask:#######0.00 Notes: WO3$[4] 25 ActualRunTime . . . . . . . . 12.2 NNN Actual Run Time . . . . . . . . Mask:#######0.00 Notes: WO3$[6] 26 StandardMaterialFixedOvhdCost 16.6 NNN Standard Material Fixed OverheaCOST Mask:##,###,###.000000- Notes: WO3$[8] 27 StandardMaterialVarOvhdCost . 16.6 NNN Standard Material Variable OverCOST Mask:##,###,###.000000- Notes: WO3$[9] 28 QuantityCompleted . . . . . . 16.6 NNN Quantity Completed. . . . . . .QUANTITY Mask:##,###,###.000000- Notes: WO3$[10] 29 ActualMaterialFixedOvhdCost . 16.6 NNN Actual Material Fixed Overhead COST Mask:##,###,###.000000- Notes: WO3$[11] 30 ActualMaterialVarOvhdCost . . 16.6 NNN Actual Material Variable OverheCOST Mask:##,###,###.000000- Notes: WO3$[12] 31 StandardLaborCostForStep. . . 16.6 NNN Standard Labor Cost For Step. .COST Mask:##,###,###.000000- Notes: WO3$[13] 32 StandardMaterialCost. . . . . 16.6 NNN Standard Material Cost. . . . .COST Mask:##,###,###.000000- Notes: WO3$[14] 33 StandardOutsideProcessCost. . 16.6 NNN Standard Outside Process Cost .COST Mask:##,###,###.000000- Notes: WO3$[15] 34 StandardLaborFixedOvhdCost. . 16.6 NNN Standard Labor Fixed Overhead CCOST Mask:##,###,###.000000- Notes: WO3$[16] 35 StandardLaborVarOvhdCost. . . 16.6 NNN StandardLaborVariableOverheadCoCOST Mask:##,###,###.000000- Notes: WO3$[17] 36 ActualLaborCostForStep. . . . 16.6 NNN Actual Labor Cost For Step. . .COST Mask:##,###,###.000000- Notes: WO3$[18] 37 ActualMaterialCost. . . . . . 16.6 NNN Actual Material Cost. . . . . .COST Mask:##,###,###.000000- Notes: WO3$[19] 38 ActualOutsideProcessCost. . . 16.6 NNN Actual Outside Process Cost . .COST Mask:##,###,###.000000- Notes: WO3$[20] 39 ActualLaborFixedOvhdCost. . . 16.6 NNN Actual Labor Fixed Overhead CosCOST Mask:##,###,###.000000- Notes: WO3$[21] 40 ActualLaborVariableOvhdCost . 16.6 NNN Actual Labor Variable Overhead COST Mask:##,###,###.000000- Notes: WO3$[22] 41 RunHoursScheduledOnStartDate. 10.3 NNN Run Hours Scheduled On Start Da Notes: WO3$[23] 42 DateCreated . . . . . . . . . 8 SNN Date Created. . . . . . . . . .DATE 43 TimeCreated . . . . . . . . . 8 SNN Time Created. . . . . . . . . .TIME 44 UserCreatedKey. . . . . . . . 10 SNN User Created Key. . . . . . . .USER Mask:0000000000 45 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE 46 TimeUpdated . . . . . . . . . 8 SNN TimeUpdated . . . . . . . . . .TIME 47 UserUpdatedKey. . . . . . . . 10 SNN User Updated Key. . . . . . . .USER Mask:0000000000