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