WON Work Order History Line Detail (WON_HistoryLineDetail) Level: 4.40 Record Type: 1 Routing (Step) Detail 08/28/2009 File Type: Direct Key Size: 44 Rec Len: 412 Min Len: 188 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Header Sequence. . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) Record Type "R" For Routing . . . . . . RecordType. . . . . . . . . . Uppercase *(11,1) Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled *(12,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(16,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(17,4) Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase *(21,5) Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase *(26,5) Key Blanks. . . . . . . . . . . . . . . KeyBlanks . . . . . . . . . . String *(31,14) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (45,16) Sytext Description? (Y/N) . . . . . . . SytextDesc. . . . . . . . . . Yes/No (61,1) Std Run Time Type (Loh) . . . . . . . . StdRunTimeType. . . . . . . . Uppercase (62,1) (Lot, Operatns/Hr, Hours/Operatn) . . . . . . . . . . . . . . . . . Memo Parent Item Type (O/P). . . . . . . . . ParentItemType. . . . . . . . Uppercase (63,1) (Operation/Parent, Parents/Op). . . . . . . . . . . . . . . . . . . Memo Tooling Number. . . . . . . . . . . . . ToolingNumber . . . . . . . . Uppercase (64,20) Scheduled Start Date. . . . . . . . . . SchedStartDat . . . . . . . . Date (84,6) Scheduled Completion Date . . . . . . . SchedCompDate . . . . . . . . Date (90,6) Actual Start Date . . . . . . . . . . . ActualStartDate . . . . . . . Date (96,6) Last Activity Date. . . . . . . . . . . LastActivityDate. . . . . . . Date (102,6) Step Complete? (Y/N). . . . . . . . . . StepComplete. . . . . . . . . Yes/No (108,1) Step Description. . . . . . . . . . . . StepDescription . . . . . . . String (109,30) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (139,50) Schedule Overlap Percent. . . . . . . . SchedOverlapPcnt. . . . . . . Number [0] 3.0 Std Run Time - Lot: Hours/Lot . . . . . StdRunTimeLot . . . . . . . . Number [1] 7.2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo - Opertns/Hr: Cycles/Hour. . . . . . . . . . . . . . . . . . . . . Memo - Hrs/Opertn: Hours/Cycle. . . . . . . . . . . . . . . . . . . . . Memo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Parent Qty Factor . . . . . . . . . . . ParentQtyFactor . . . . . . . Number [2] 5.0 Extended Standard Time. . . . . . . . . ExtdStdTime . . . . . . . . . Number [3] 6.3 Op Cycles Planned For This Step . . . . OpCyclesPlannedThisStep . . . Number [4] 6.3 Actual Run Time (Jtd) . . . . . . . . . ActualRunTime . . . . . . . . Number [5] 6.3 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [6] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [7] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [8] 0. Qty Completed . . . . . . . . . . . . . QtyCompleted. . . . . . . . . Number [9] 6.4 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [10] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [11] 0. Standard Labor Cost For This Step . . . StdLaborCostThisStep. . . . . Number [12] 7.2 Std Material Cost . . . . . . . . . . . StdMaterialCost . . . . . . . Number [13] 7.2 Std Outside Processing Cost . . . . . . StdOutsideProcessCost . . . . Number [14] 7.2 Std Fixed Overhead Cost . . . . . . . . StdFixedOverheadCost. . . . . Number [15] 7.2 Std Variable Overhead Cost. . . . . . . StdVariableOverheadCost . . . Number [16] 7.2 Actual Labor Cost For This Step . . . . ActualLaborCost . . . . . . . Number [17] 7.2 Actual Material Cost. . . . . . . . . . ActualMaterialCost. . . . . . Number [18] 7.2 Actual Outside Processing Cost. . . . . ActualOutsideProcessCost. . . Number [19] 7.2 Actual Fixed Overhead Cost. . . . . . . ActualFixedOverheadCost . . . Number [20] 7.2 Actual Variable Overhead Cost . . . . . ActualVariableOHCost. . . . . Number [21] 7.2 Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [22] 0. Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [23] 0. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Only The Routing Steps In The . . . . . . . . . . . . . . . . . . . Memo Work Order Accumulate The Costs.. . . . . . . . . . . . . . . . . . Memo The Material Steps Are For. . . . . . . . . . . . . . . . . . . . . Memo Indicating What Materials Were. . . . . . . . . . . . . . . . . . . Memo Needed And Are Not Used To. . . . . . . . . . . . . . . . . . . . . Memo Accumulate Costs Or Times.. . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 392
WON Work Order History Line Detail (WON_HistoryLineDetail) Level: 4.40 Record Type: 2 Work Order Material Line Detail 08/28/2009 File Type: Direct Key Size: 44 Rec Len: 412 Min Len: 188 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Header Sequence. . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) Record Type "M" For Material. . . . . . RecordType. . . . . . . . . . Uppercase *(11,1) Component Item Number . . . . . . . . . ComponentItemNumber . . . . . Uppercase *(12,30) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(42,3) Revision. . . . . . . . . . . . . . . . Revision. . . . . . . . . . . Uppercase (45,3) Step Number . . . . . . . . . . . . . . MaterialStepNumber. . . . . . Zero-Filled (48,4) U/M . . . . . . . . . . . . . . . . . . UM. . . . . . . . . . . . . . Uppercase (52,4) Item Description (Blank = CI_Item Desc) ItemDescription . . . . . . . String (56,30) Warehouse . . . . . . . . . . . . . . . Whse. . . . . . . . . . . . . Account (86,3) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (89,100) Qty/Parent. . . . . . . . . . . . . . . QtyParent . . . . . . . . . . Number [0] 6.4 U/M Conversion Factor . . . . . . . . . UMConvFctr. . . . . . . . . . Number [1] 6.4 Unit Cost (Specials Only) . . . . . . . UnitCost. . . . . . . . . . . Number [2] 5.4 Scrap Percent . . . . . . . . . . . . . ScrapPercent. . . . . . . . . Number [3] 3.4 Extended Qty Required . . . . . . . . . ExtdQtyRequired . . . . . . . Number [4] 6.4 Qty Issued. . . . . . . . . . . . . . . QtyIssued . . . . . . . . . . Number [5] 6.4 Direct Costs Incurred . . . . . . . . . DirectCostsIncurred . . . . . Number [6] 7.2 Fixed Overhead Costs Incurred . . . . . FixedOverheadCostsIncurred. . Number [7] 7.2 Variable Overhead Costs Incurred. . . . VariableOHCostsIncurred . . . Number [8] 7.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [9] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [10] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [11] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [12] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [13] 0. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [14] 0. Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [15] 0. Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [16] 0. Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [17] 0. Open Number . . . . . . . . . . . . . . _N10. . . . . . . . . . . . . Open Number [18] 0. Open Number . . . . . . . . . . . . . . _N11. . . . . . . . . . . . . Open Number [19] 0. Open Number . . . . . . . . . . . . . . _N12. . . . . . . . . . . . . Open Number [20] 0. Open Number . . . . . . . . . . . . . . _N13. . . . . . . . . . . . . Open Number [21] 0. Open Number . . . . . . . . . . . . . . _N14. . . . . . . . . . . . . Open Number [22] 0. Open Number . . . . . . . . . . . . . . _N15. . . . . . . . . . . . . Open Number [23] 0. ________ Total Bytes 315