WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: 1 Op Code Sort By Desc (Sort of WOB) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"1" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Operation Description . . . . . . . . . OperationDescription. . . . . Uppercase *(2,30) Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase *(32,5) Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase *(37,5) ________ Total Bytes 43
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: 2 Work Center Sort By Desc (Sort of WOA) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"2" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Work Center Description . . . . . . . . WorkCenterDescription . . . . Uppercase *(2,30) Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase *(32,5) ________ Total Bytes 38
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: 3 Routing Sort By Desc (Sort of WOC-1) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"3" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Routing Description . . . . . . . . . . RoutingDescription. . . . . . Uppercase *(2,30) Routing Number. . . . . . . . . . . . . RoutingNumber . . . . . . . . Uppercase *(32,20) "4 Blanks" = Header Flag. . . . . . . . HeaderFlag. . . . . . . . . . String *(52,4) ________ Total Bytes 57
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: 4 Tool Number Sort By Desc (Sort of WOF) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"4" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Tool Number Description . . . . . . . . ToolNumberDescription . . . . Uppercase *(2,30) Tool Number . . . . . . . . . . . . . . ToolNumber. . . . . . . . . . Uppercase *(32,20) ________ Total Bytes 53
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: 5 W/O Prod Emp Sort By Name (Sort of WOG) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"5" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Employee Last Name. . . . . . . . . . . EmployeeLastName. . . . . . . Uppercase *(2,15) Employee First Name . . . . . . . . . . EmployeeFirstName . . . . . . Uppercase *(17,15) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(32,9) ________ Total Bytes 42
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: 6 W/O Prod Emp Crew Sort (Sort of WOH - 1) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"6" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Crew Description. . . . . . . . . . . . CrewDescription . . . . . . . Uppercase *(2,30) Crew Number . . . . . . . . . . . . . . CrewNumber. . . . . . . . . . Zero-Filled *(32,3) ________ Total Bytes 36
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: 7 Wo Sort By Item Desc (Sort of WO1/WO5) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"7" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Item Description. . . . . . . . . . . . ItemDescription . . . . . . . Uppercase *(2,30) Work Order/Template Number. . . . . . . WorkOrderTemplateNumber . . . Uppercase *(32,7) ________ Total Bytes 40
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: 8 Routing Step Sort by Op Code (From WOC) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"8" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase *(2,5) Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase *(7,5) Routing Number. . . . . . . . . . . . . RoutingNumber . . . . . . . . Uppercase *(12,20) Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled *(32,4) ________ Total Bytes 37
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: 9 W/O Routing Sort by Tooling Number (WO3) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"9" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Tooling Number. . . . . . . . . . . . . ToolingNumber . . . . . . . . Uppercase *(2,20) Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Zero-Filled *(22,7) Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled *(29,4) Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase *(33,1) Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled *(34,4) ________ Total Bytes 39
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: A W/O Matrl Sort by Step/Item (WO2 & WO6) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"A" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Work Order Number (Or T & 6 Chars). . . WorkOrderNumber . . . . . . . Zero-Filled *(2,7) Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled *(9,4) Component Item Number . . . . . . . . . ComponentItemNumber . . . . . Uppercase *(13,30) Line Index Into The WO2 Or WO6 File . . LineIndexIntoTheWo2 . . . . . Zero-Filled *(43,6) ________ Total Bytes 50
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: B W/O Matrl Sort by Item/Step (WO1, WO2) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"B" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Component / Header Item Number. . . . . ComponentHeaderItemNumber . . Uppercase *(2,30) Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase *(32,7) Step Number (Blank For W/O Header). . . StepNumber. . . . . . . . . . Zero-Filled *(39,4) Line Index Into WO2 File. . . . . . . . LineIndexIntoWo2File. . . . . Zero-Filled *(43,6) (Blank For W/O Header). . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 50
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: C Template Matrl Sort by Item/Step (WO5,6) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"C" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Component Item Number . . . . . . . . . ComponentItemNumber . . . . . Uppercase *(2,30) Template Number . . . . . . . . . . . . TemplateNumber. . . . . . . . Zero-Filled *(32,7) Step Number (Blank For W/O Header). . . StepNumber. . . . . . . . . . Zero-Filled *(39,4) Line Index Into WO6 File. . . . . . . . LineIndexIntoWo6File. . . . . Zero-Filled *(43,6) (Blank For W/O Header). . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 50
WOY Work Order Generic Sort File (WOY_GenericSort) Level: 4.40 Record Type: D W/O Matrl Srt by Ord/Comp/Step (WO2) 08/28/2009 File Type: Sort Key Size: 65 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"D" - Prefix. . . . . . . . . . . . . Prefix. . . . . . . . . . . . Uppercase *(1,1) Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase *(2,7) Component Item Number . . . . . . . . . ComponentItemNumber . . . . . Uppercase *(9,30) Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled *(39,4) Line Index Into WO2 File. . . . . . . . LineIndexIntoWo2File. . . . . Zero-Filled *(43,6) ________ Total Bytes 50