MP_08 Work Order Traversal Order File (MP_08WorkOrderTraversalOrder) Level: 4.40 Record Type: 1 WO Traversal File 08/28/2009 File Type: Mkeyed Key Size: 8 Rec Len: 152 Min Len: 132 Define: Y
Main Key (KNO=0)WO_SequenceNumber(1,7)+TransactionType(8,1) 2nd Key (KNO=1) ItemNumber(53,30) 3rd Key (KNO=2) WO_SequenceNumber(1,7)+TransactionType(8,1)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
WO Sequence Number. . . . . . . . . . . WO_SequenceNumber . . . . . . Uppercase *(1,7) Transaction Type. . . . . . . . . . . . TransactionType . . . . . . . Uppercase *(8,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (9,15) Required Date . . . . . . . . . . . . . RequiredDate. . . . . . . . . Date (24,6) Linked Order Type . . . . . . . . . . . LinkedOrderType . . . . . . . Uppercase (30,1) Linked WO/SO. . . . . . . . . . . . . . Linked_WO_SO. . . . . . . . . Uppercase (31,7) Line Number/Step Number . . . . . . . . LineNumber_StepNumber . . . . Zero-Filled (38,6) Bill Revision . . . . . . . . . . . . . BillRevision. . . . . . . . . Uppercase (44,3) Release Date. . . . . . . . . . . . . . ReleaseDate . . . . . . . . . Date (47,6) Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase (53,30) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (83,50) Quantity. . . . . . . . . . . . . . . . Quantity. . . . . . . . . . . Number [0] 6.3 Days Change . . . . . . . . . . . . . . DaysChange. . . . . . . . . . Number [1] 3.0 ________ Total Bytes 152