WOQ W/O Work Order Memo Sort File (WOQ_WorkOrderMemoSort) Level: 4.40 Record Type: 1 Memo Header By W/O & Invrs Date 08/28/2009 File Type: Sort Key Size: 26 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type (1=By W/O & Date) . . . . . RecordType. . . . . . . . . . Uppercase *(1,1) Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase *(2,7) Inverse Memo Year . . . . . . . . . . . InverseMemoYear . . . . . . . Zero-Filled *(9,4) Inverse Memo Month. . . . . . . . . . . InverseMemoMonth. . . . . . . Zero-Filled *(13,2) Inverse Memo Day. . . . . . . . . . . . InverseMemoDay. . . . . . . . Zero-Filled *(15,2) Memo Number . . . . . . . . . . . . . . MemoNumber. . . . . . . . . . Uppercase *(17,10) ________ Total Bytes 28
WOQ W/O Work Order Memo Sort File (WOQ_WorkOrderMemoSort) Level: 4.40 Record Type: 2 Memo Header By Invrs Date & W/O 08/28/2009 File Type: Sort Key Size: 26 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type (2=By Date & W/O) . . . . . RecordType. . . . . . . . . . Uppercase *(1,1) Inverse Memo Year . . . . . . . . . . . InverseMemoYear . . . . . . . Zero-Filled *(2,4) Inverse Memo Month. . . . . . . . . . . InverseMemoMonth. . . . . . . Zero-Filled *(6,2) Inverse Memo Day. . . . . . . . . . . . InverseMemoDay. . . . . . . . Zero-Filled *(8,2) Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase *(10,7) Memo Number . . . . . . . . . . . . . . MemoNumber. . . . . . . . . . Uppercase *(17,10) ________ Total Bytes 28