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