WOX W/O Work Order/Template Sort File (WOX_WorkOrderTemplateSort) Level: 4.40 Record Type: 1 Sort By User Fld 1 (Sort Of WO1/WO5) 08/28/2009 File Type: Sort Key Size: 38 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"1" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) User Defined Field 1. . . . . . . . . . UserDefinedField1 . . . . . . Uppercase *(2,10) Work Order/Template Number. . . . . . . WorkOrderTemplateNumber . . . Uppercase *(12,7) ________ Total Bytes 20
WOX W/O Work Order/Template Sort File (WOX_WorkOrderTemplateSort) Level: 4.40 Record Type: 2 Sort By User Fld 2 (Sort Of WO1/WO5) 08/28/2009 File Type: Sort Key Size: 38 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"2" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) User Defined Field 2. . . . . . . . . . UserDefinedField2 . . . . . . Uppercase *(2,10) Work Order/Template Number. . . . . . . WorkOrderTemplateNumber . . . Uppercase *(12,7) ________ Total Bytes 20
WOX W/O Work Order/Template Sort File (WOX_WorkOrderTemplateSort) Level: 4.40 Record Type: 3 Sort By User Fld 3 (Sort Of WO1/WO5) 08/28/2009 File Type: Sort Key Size: 38 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"3" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) User Defined Field 3. . . . . . . . . . UserDefinedField3 . . . . . . Uppercase *(2,10) Work Order/Template Number. . . . . . . WorkOrderTemplateNumber . . . Uppercase *(12,7) ________ Total Bytes 20
WOX W/O Work Order/Template Sort File (WOX_WorkOrderTemplateSort) Level: 4.40 Record Type: 4 Sort By User Fld 4 (Sort Of WO1/WO5) 08/28/2009 File Type: Sort Key Size: 38 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"4" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) User Defined Field 4. . . . . . . . . . UserDefinedField4 . . . . . . Uppercase *(2,10) Work Order/Template Number. . . . . . . WorkOrderTemplateNumber . . . Uppercase *(12,7) ________ Total Bytes 20
WOX W/O Work Order/Template Sort File (WOX_WorkOrderTemplateSort) Level: 4.40 Record Type: 5 Sort By Item Number (Sort Of WO1/WO5) 08/28/2009 File Type: Sort Key Size: 38 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"5" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Item/Bill Number. . . . . . . . . . . . ItemBillNumber. . . . . . . . Uppercase *(2,30) Work Order/Template Number. . . . . . . WorkOrderTemplateNumber . . . Uppercase *(32,7) ________ Total Bytes 40
WOX W/O Work Order/Template Sort File (WOX_WorkOrderTemplateSort) Level: 4.40 Record Type: 6 Sort By Op Code (Sort Of WO3/WO7) 08/28/2009 File Type: Sort Key Size: 38 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"6" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase *(2,5) Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase *(7,5) Work Order/Template Number. . . . . . . WorkOrderTemplateNumber . . . Uppercase *(12,7) Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled *(19,4) Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase *(23,1) Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled *(24,4) ________ Total Bytes 29
WOX W/O Work Order/Template Sort File (WOX_WorkOrderTemplateSort) Level: 4.40 Record Type: 7 W/O Material Sort By Step # (WO2 & WO6) 08/28/2009 File Type: Sort Key Size: 38 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"7" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Work Order Number (Or T & 6 Chars). . . WorkOrderNumber . . . . . . . Zero-Filled *(2,7) Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled *(9,4) Line Index Into the WO2 or WO6 File . . LineIndexIntoTheWo2 . . . . . Zero-Filled *(13,6) ________ Total Bytes 20
WOX W/O Work Order/Template Sort File (WOX_WorkOrderTemplateSort) Level: 4.40 Record Type: 8 Trans Entry Released Work Orders 08/28/2009 File Type: Sort Key Size: 38 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"8" = W/O'S Being Released. . . . . . . Released. . . . . . . . . . . Zero-Filled *(1,1) Work Order Number Being Released. . . . WorkOrderNumberBeingReleased. Uppercase *(2,7) Transaction Number Releasing W/O. . . . TransactionNumberRel. . . . . Uppercase *(9,7) Line Index Of W/O Being Released. . . . LineIndexOfWOBeingReleased. . Zero-Filled *(16,6) ________ Total Bytes 23
WOX W/O Work Order/Template Sort File (WOX_WorkOrderTemplateSort) Level: 4.40 Record Type: 9 Trans Entry Closed Work Orders 08/28/2009 File Type: Sort Key Size: 38 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"9" = W/O'S Being Closed. . . . . . . . Closed. . . . . . . . . . . . Zero-Filled *(1,1) Work Order Number Being Closed. . . . . WorkOrderNumberBeingClosed. . Uppercase *(2,7) Transaction Number Closing W/O. . . . . TransactionNumberClosingWO. . Uppercase *(9,7) Line Index Of W/O Being Closed. . . . . LineIndexOfWOBeingClosed. . . Zero-Filled *(16,6) ________ Total Bytes 23