     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