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