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