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