WO3 Work Order Operation Detail (WO3_WorkOrderOperationDetail) Level: 4.40 Record Type: 1 Operation (Step) Detail 08/28/2009 File Type: Direct Key Size: 16 Rec Len: 435 Min Len: 150 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase (17,5) Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase (22,5) Step Description. . . . . . . . . . . . StepDescription . . . . . . . String (27,30) Sytext Description? (Y/N) . . . . . . . SytextDesc. . . . . . . . . . Yes/No (57,1) Ignore Queue Time?. . . . . . . . . . . IgnoreQueueTime . . . . . . . Yes/No (58,1) Std Run Time Type (Loh) . . . . . . . . StdRunTimeType. . . . . . . . Uppercase (59,1) (Lot, Operatns/Hr, Hours/Operatn) . . . . . . . . . . . . . . . . . Memo Parent Item Type (O/P). . . . . . . . . ParentItemType. . . . . . . . Uppercase (60,1) (Operation/Parent, Parents/Op). . . . . . . . . . . . . . . . . . . Memo Tooling Number. . . . . . . . . . . . . ToolingNumber . . . . . . . . Uppercase (61,20) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (81,20) Scheduled Start Date (Run). . . . . . . SchedStartDate. . . . . . . . Date (101,6) Scheduled Completion Date . . . . . . . SchedCompletionDate . . . . . Date (107,6) Actual Start Date . . . . . . . . . . . ActualStartDate . . . . . . . Date (113,6) Last Activity Date. . . . . . . . . . . LastActivityDate. . . . . . . Date (119,6) Step Complete? (Y/N). . . . . . . . . . StepComplete. . . . . . . . . Yes/No (125,1) Scheduled Start Date (Queue). . . . . . SchedStartDateQueue . . . . . Date (126,6) Outside Processing? (Y/N) . . . . . . . OutsideProcessing . . . . . . Yes/No (132,1) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (133,18) Schedule Overlap Percent. . . . . . . . ScheduleOverlapPercent. . . . Number [0] 3.0 Std Run Time - Lot: Hours/Lot. . . . StdRunTime. . . . . . . . . . Number [1] 7.2 - Opertns/Hr: Cycles/Hour. . . . . . . . . . . . . . . . . . . . Memo - Hrs/Opertn: Hours/Cycle. . . . . . . . . . . . . . . . . . . . Memo Parent Qty Factor . . . . . . . . . . . ParentQtyFactor . . . . . . . Number [2] 5.0 Extended Standard Time. . . . . . . . . ExtdStdTime . . . . . . . . . Number [3] 6.3 Op Cycles Planned For This Step . . . . OpCyclesPlanned . . . . . . . Number [4] 6.3 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [5] 0. Actual Run Time (Jtd) . . . . . . . . . ActualRunTime . . . . . . . . Number [6] 7.2 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [7] 0. Std Material Fixed Overhead Cost. . . . StdMateriaLFixedOH. . . . . . Number [8] 5.4 Std Material Variable Overhead Cost . . StdMaterialVariableOH . . . . Number [9] 5.4 Qty Completed . . . . . . . . . . . . . QtyCompleted. . . . . . . . . Number [10] 6.4 Actual Material Fixed Overhead Cost . . ActualMaterialFixedOH . . . . Number [11] 5.4 Actual Material Variable Ovrhd Cost . . ActualMaterialVariableOH. . . Number [12] 5.4 Standard Labor Cost For This Step . . . StdLaborCost. . . . . . . . . Number [13] 5.4 Std Material Cost . . . . . . . . . . . StdMaterialCost . . . . . . . Number [14] 5.4 Std Outside Processing Cost . . . . . . StdOutsideProcessCost . . . . Number [15] 5.4 Std Labor Fixed Overhead Cost . . . . . StdLaborFixedOHCost . . . . . Number [16] 5.4 Std Labor Variable Overhead Cost. . . . StdLaborVariableOHCost. . . . Number [17] 5.4 Actual Labor Cost For This Step . . . . ActualLaborCost . . . . . . . Number [18] 5.4 Actual Material Cost. . . . . . . . . . ActualMaterialCost. . . . . . Number [19] 5.4 Actual Outside Processing Cost. . . . . ActualOutsideProcessCost. . . Number [20] 5.4 Actual Labor Fixed Overhead Cost. . . . ActualLaborFixedOH. . . . . . Number [21] 5.4 Actual Labor Variable Overhead Cost . . ActualLaborVariableOHCost . . Number [22] 5.4 Run Hours Scheduled On Start Date . . . RunHoursSchedOnStartDate. . . Number [23] 7.2 [Sched Start Date (Run Time)] . . . . . . . . . . . . . . . . . . . Memo Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [24] 0. ________ Total Bytes 410