     MP_06  Work Order Materials File (MP_06WorkOrderMaterials)                      Level: 4.40
            Record Type: 1    Wo Material File                                       08/28/2009

     File Type: Mkeyed   Key Size: 67   Rec Len: 168     Min Len: 142    Define: Y

     Main Key (KNO=0)ItemNumber(33,30)+ParentItemNumber(63,30)+WO_NumberIssuedTo(23,7)

     Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

     Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (1,15)
     Completed To SO/WO. . . . . . . . . . . CompletedToSO_WO. . . . . . . Uppercase   *(16,7)
       Remainder of key is Parent Item No. . . . . . . . . . . . . . . . . Memo
     WO Number Issued To . . . . . . . . . . WO_NumberIssuedTo . . . . . . Uppercase   (23,7)
     WO or SO. . . . . . . . . . . . . . . . WO_Or_SO. . . . . . . . . . . Uppercase   (30,1)
     Part Not In WO. . . . . . . . . . . . . PartNotInWo . . . . . . . . . Yes/No      (31,1)
     Part Not In Bill. . . . . . . . . . . . PartNotInBill . . . . . . . . Yes/No      (32,1)
     Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase   *(33,30)
     Parent Item Number. . . . . . . . . . . ParentItemNumber. . . . . . . Uppercase   *(63,30)
     Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (93,50)
     Quantity Per Parent . . . . . . . . . . QuantityPerParent . . . . . . Number      [0]       6.3
     Quantity Issued . . . . . . . . . . . . QuantityIssued. . . . . . . . Number      [1]       6.3
                                                                                       ________
                                                                          Total Bytes  168