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