WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: 1 W/O Release Detail (Trans Type 1) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (8,94)
Record Type ("1" = Release) . . . . . . RecordType. . . . . . . . . . Uppercase (102,1)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (103,8)
Auto Issue Matl Tran Num (Not Used) . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num (Not Used). . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Gen Outs Proc Tran Num (Not Used). AutoGenOutsProcTranNum. . . . Uppercase (125,7)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (132,110)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [4] 0.
Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [5] 0.
Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [6] 0.
Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [7] 0.
Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 275
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: 2 W/O Material Issue Detail (Trans Type 2) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled (8,4)
Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase (12,1)
Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled (13,4)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (17,20)
Issue Unit Of Measure . . . . . . . . . IssueUnitOfMeasure. . . . . . Uppercase (37,4)
Issue Warehouse . . . . . . . . . . . . IssueWarehouse. . . . . . . . Account (41,3)
Item Costing Method (1-6) . . . . . . . ItemCostingMethod . . . . . . Zero-Filled (44,1)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (45,1)
Substitute Material . . . . . . . . . . SubstituteMaterial. . . . . . Yes/No (46,1)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (47,20)
Original Unit Of Measure. . . . . . . . OriginalUM. . . . . . . . . . Uppercase (67,4)
Original Warehouse. . . . . . . . . . . OriginalWarehouse . . . . . . Account (71,3)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (74,28)
Record Type ("2" = Material Issue). . . RecordType. . . . . . . . . . Uppercase (102,1)
Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (103,7)
Distribution Complete . . . . . . . . . DistributionComplete. . . . . Yes/No (110,1)
Auto Issue Matl Tran Num (Not Used) . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num (Not Used). . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Gen Outs Proc Tran Num (Not Used). AutoGenOutsProcTranNum. . . . Uppercase (125,7)
Issue Item Number . . . . . . . . . . . IssueItemNumber . . . . . . . Uppercase (132,30)
Original Item Number. . . . . . . . . . OriginalItemNumber. . . . . . Uppercase (162,30)
Open String . . . . . . . . . . . . . . _S6 . . . . . . . . . . . . . Open String (192,50)
Issue Quantity. . . . . . . . . . . . . IssueQuantity . . . . . . . . Number [0] 6.4
Issue U/M Conversion. . . . . . . . . . IssueUMConversion . . . . . . Number [1] 6.4
Issue Unit Cost (Calc @ Pre-Update) . . IssueUnitCost . . . . . . . . Number [2] 6.4
Original Quantity . . . . . . . . . . . OriginalQuantity. . . . . . . Number [3] 6.4
Original U/M Conversion . . . . . . . . OriginalUMConversion. . . . . Number [4] 6.4
Total Cost (Calc @ Pre-Update). . . . . TotalCost . . . . . . . . . . Number [5] 7.2
Fix Ovrhd (Calc @ Pre-Update). . . . . FixedOH . . . . . . . . . . . Number [6] 7.2
Var Ovrhd (Calc @ Pre-Update). . . . . VariableOH. . . . . . . . . . Number [7] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 369
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: 3 W/O Labor Trans Detail (Type 3/Non-Crew) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled (8,4)
Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase (12,1)
Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled (13,4)
Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase (17,5)
Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase (22,5)
Start Date. . . . . . . . . . . . . . . StartDate . . . . . . . . . . Date (27,6)
Stop Date . . . . . . . . . . . . . . . StopDate. . . . . . . . . . . Date (33,6)
Step Complete? (Y/N). . . . . . . . . . StepComplete. . . . . . . . . Yes/No (39,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (40,62)
Record Type ("3" = Labor, Non-Crew) . . RecordType. . . . . . . . . . Uppercase (102,1)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (103,8)
Auto Issue Matl Tran Num (Not Used) . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num (Not Used). . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Gen Outs Proc Tran Num (Not Used). AutoGenOutsProcTranNum. . . . Uppercase (125,7)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (132,110)
Start Time. . . . . . . . . . . . . . . StartTime . . . . . . . . . . Number [0] 2.3
Stop Time . . . . . . . . . . . . . . . StopTime. . . . . . . . . . . Number [1] 2.3
Quantity Complete . . . . . . . . . . . QuantityComplete. . . . . . . Number [2] 6.4
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0.
Direct Labor Cost (Calc @ Pre-Updt) . . TotalCost . . . . . . . . . . Number [5] 7.2
Fixed Overhead (Calc @ Pre-Updt) . . FixedOH . . . . . . . . . . . Number [6] 7.2
Variable Overhead (Calc @ Pre-Updt) . . VariableOH. . . . . . . . . . Number [7] 7.2
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 335
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: 4 W/O Labor Trans Detail (Type 3/Crew) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Employee Division . . . . . . . . . . . EmployeeDivision. . . . . . . Account (1,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account (3,7)
Start Date. . . . . . . . . . . . . . . CrewStartDate . . . . . . . . Date (10,6)
Stop Date . . . . . . . . . . . . . . . CrewStopDate. . . . . . . . . Date (16,6)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (22,80)
Record Type ("4" = Labor, Crew) . . . . RecordType. . . . . . . . . . Uppercase (102,1)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (103,8)
Auto Issue Matl Tran Num (Not Used) . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num (Not Used). . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Gen Outs Proc Tran Num (Not Used). AutoGenOutsProcTranNum. . . . Uppercase (125,7)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (132,110)
Start Time. . . . . . . . . . . . . . . StartTime . . . . . . . . . . Number [0] 3.3
Stop Time . . . . . . . . . . . . . . . StopTime. . . . . . . . . . . Number [1] 3.3
Quantity Complete . . . . . . . . . . . QuantityComplete. . . . . . . Number [2] 6.4
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0.
Direct Labor Cost (Calc @ Pre-Updt) . . TotalCost . . . . . . . . . . Number [5] 7.2
Fixed Overhead (Calc @ Pre-Updt)FixedOH . . . . . . . . . . . Number [6] 7.2
Variable Overhead (Calc @ Pre-Updt)VariableOH. . . . . . . . . . Number [7] 7.2
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [8] 0.
If Labor Is not charged at Employee . . . . . . . . . . . . . . . . Memo
Rate, then Numerics [2] - [8] above . . . . . . . . . . . . . . . . Memo
are zero. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 337
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: 5 W/O Misc Labor Trans Detail (Type 4) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled (8,4)
Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase (12,1)
Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled (13,4)
Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase (17,5)
Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase (22,5)
Labor Description . . . . . . . . . . . LaborMaterialProductDescr . . String (27,30)
Labor Transaction Date. . . . . . . . . LaborMaterialProdTransDate. . Date (57,6)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (63,39)
Record Type ("5" = Misc Labor Charge) . RecordType. . . . . . . . . . Uppercase (102,1)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (103,8)
Auto Issue Matl Tran Num (Not Used) . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num (Not Used). . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Gen Outs Proc Tran Num (Not Used). AutoGenOutsProcTranNum. . . . Uppercase (125,7)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (132,110)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [4] 0.
Total Labor Cost. . . . . . . . . . . . TotalCost . . . . . . . . . . Number [5] 7.2
Fixed Overhead (Calc @ Pre-Update) . . FixedOH . . . . . . . . . . . Number [6] 7.2
Variable Ovrhd (Calc @ Pre-Update) . . VariableOH. . . . . . . . . . Number [7] 7.2
Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 309
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: 6 W/O Misc Mat Chrge Trans Detail (Type 5) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled (8,4)
Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase (12,1)
Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled (13,4)
Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase (17,5)
Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase (22,5)
Material Description. . . . . . . . . . LaborMaterialProductDescr . . String (27,30)
Transaction Date. . . . . . . . . . . . LaborMaterialProdTransDate. . Date (57,6)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (63,39)
Record Type ("6" = Misc. Mat'l Charge). RecordType. . . . . . . . . . Uppercase (102,1)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (103,8)
Auto Issue Matl Tran Num (Not Used) . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num (Not Used). . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Issue Outs Proc Tran Num (Not Used)AutoIssueOutsProcTranNum. . . Uppercase (125,7)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (132,110)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [4] 0.
Total Material Cost . . . . . . . . . . TotalCost . . . . . . . . . . Number [5] 7.2
Fixed Overhead (Calc @ Pre-Update) . . FixedOH . . . . . . . . . . . Number [6] 7.2
Variable Ovrhd (Calc @ Pre-Update) . . VariableOH. . . . . . . . . . Number [7] 7.2
Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 309
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: 7 W/O Outside Proces Trans Detail (Type 6) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled (8,4)
Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase (12,1)
Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled (13,4)
Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase (17,5)
Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase (22,5)
Product/Services Provided . . . . . . . LaborMaterialProductDescr . . String (27,30)
Transaction Date. . . . . . . . . . . . LaborMaterialProdTransDate. . Date (57,6)
Vendor Division . . . . . . . . . . . . VendorDivision. . . . . . . . Account (63,2)
Vendor Number (Optional)1 . . . . . . . VendorNumber. . . . . . . . . Account (65,7)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (72,30)
Record Type ("7" = Outs. Proc. Charge). RecordType. . . . . . . . . . Uppercase (102,1)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (103,8)
Auto Issue Matl Tran Num (Not Used) . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num (Not Used). . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Gen Outs Proc Tran Num (Not Used). AutoGenOutsProcTranNum. . . . Uppercase (125,7)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (132,110)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [4] 0.
Total Product/Service Cost. . . . . . . TotalCost . . . . . . . . . . Number [5] 7.2
Fixed Overhead (Calc @ Pre-Update) . . FixedOH . . . . . . . . . . . Number [6] 7.2
Variable Ovrhd (Calc @ Pre-Update) . . VariableOH. . . . . . . . . . Number [7] 7.2
Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 309
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: 8 W/O Complete To Stock Inv Item (Type 7) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Complete-To Code ("1" = Stock). . . . . CompleteToCode. . . . . . . . Uppercase (8,1)
1=Stock 2=Sales Order . . . . . . . . . . . . . . . . . . . . Memo
3=Work Order 4=Scrap . . . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (9,20)
Item Number Type (1=Regular). . . . . . ItemNumberType. . . . . . . . Zero-Filled (29,1)
Complete Unit Of Measure. . . . . . . . CompleteUM. . . . . . . . . . Uppercase (30,4)
Parent Unit Of Measure. . . . . . . . . ParentUM. . . . . . . . . . . Uppercase (34,4)
Complete Warehouse. . . . . . . . . . . CompleteWarehouse . . . . . . Account (38,3)
Complete Item Cost Method (1-6) . . . . CompleteItemCostMethod. . . . Zero-Filled (41,1)
Beginning Lot/Ser Number. . . . . . . . BeginLotSerialNumber. . . . . Uppercase (42,15)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (57,45)
Record Type ("8" = Compl. To Inventory) RecordType. . . . . . . . . . Uppercase (102,1)
Regular Items Only. . . . . . . . . . . . . . . . . . . . . . . . . Memo
Use All WIP . . . . . . . . . . . . . . UseAllWIP . . . . . . . . . . Yes/No (103,1)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (104,7)
Auto Issue Matl Tran Num. . . . . . . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num . . . . . . . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Gen Outs Proc Tran Num . . . . . . AutoGenOutsProcTranNum. . . . Uppercase (125,7)
Complete Item Number. . . . . . . . . . CompleteItemNumber. . . . . . Uppercase (132,30)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (162,80)
Completed Quantity. . . . . . . . . . . CompletedQuantity . . . . . . Number [0] 6.4
Completed U/M Conversion. . . . . . . . CompletedUMConversion . . . . Number [1] 6.4
Unit Cost (Zero Or Overriden) . . . . . UnitCost. . . . . . . . . . . Number [2] 6.4
Parent Item Quantity. . . . . . . . . . ParentItemQty . . . . . . . . Number [3] 6.4
Parent Item U/M Conversion. . . . . . . ParentItemUMConversion. . . . Number [4] 6.4
Total Cost (Calc @ Pre-Update) . . TotalCost . . . . . . . . . . Number [5] 7.2
Cost From Fix Ovrhd (Calc @ Pre-Up) . . FixedOH . . . . . . . . . . . Number [6] 7.2
Cost From Var Ovrhd (Calc @ Pre-Up) . . VariableOH. . . . . . . . . . Number [7] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 369
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: 9 W/O Complete To Stock Spec Item (Type 7) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Complete-To Code ("1" = Stock). . . . . CompleteToCode. . . . . . . . Uppercase (8,1)
1=Stock 2=Sales Order . . . . . . . . . . . . . . . . . . . . Memo
3=Work Order 4=Scrap . . . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (9,20)
Item Number Type (2=Special Items). . . ItemNumberType. . . . . . . . Zero-Filled (29,1)
Complete Unit Of Measure. . . . . . . . CompleteUM. . . . . . . . . . Uppercase (30,4)
Parent Unit Of Measure. . . . . . . . . ParentUM. . . . . . . . . . . Uppercase (34,4)
Purchases Account . . . . . . . . . . . SpecialPurchasesGLAccount . . G/L Account (38,9)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (47,3)
Special Item Description. . . . . . . . SpecialItemDescription. . . . String (50,30)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (80,22)
Record Type ("9" = Compl. To Inventory) RecordType. . . . . . . . . . Uppercase (102,1)
Special Items . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Use All WIP . . . . . . . . . . . . . . UseAllWIP . . . . . . . . . . Yes/No (103,1)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (104,7)
Auto Issue Matl Tran Num (Not Used) . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num (Not Used). . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Issue Outs Proc Tran Num (Not Used)AutoIssueOutsProcTranNum. . . Uppercase (125,7)
Complete Item Number. . . . . . . . . . CompleteItemNumber. . . . . . Uppercase (132,30)
Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (162,80)
Completed Quantity. . . . . . . . . . . CompletedQuantity . . . . . . Number [0] 6.3
Completed U/M Conversion. . . . . . . . CompletedUMConversion . . . . Number [1] 6.4
Unit Cost (Zero Or Overriden) . . . . . UnitCost. . . . . . . . . . . Number [2] 6.4
Parent Item Quantity. . . . . . . . . . ParentItemQty . . . . . . . . Number [3] 6.4
Parent Item U/M Conversion. . . . . . . ParentItemUMConversion. . . . Number [4] 6.4
Total Cost (Calc @ Pre-Update) . . TotalCost . . . . . . . . . . Number [5] 7.2
Cost From Fix Ovrhd (Calc @ Pre-Up) . . FixedOH . . . . . . . . . . . Number [6] 7.2
Cost From Var Ovrhd (Calc @ Pre-Up) . . VariableOH. . . . . . . . . . Number [7] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 368
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: A W/O Complete To SO/WO Inv Item (Type 7) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Complete-To Code (2 = SO, 3 = WO) . . . CompleteToCode. . . . . . . . Uppercase (8,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (9,20)
Item Number Type (1=Regular Item) . . . ItemNumberType. . . . . . . . Zero-Filled (29,1)
Complete Unit Of Measure. . . . . . . . CompleteUM. . . . . . . . . . Uppercase (30,4)
Parent Unit Of Measure. . . . . . . . . ParentUM. . . . . . . . . . . Uppercase (34,4)
Complete To Order Number. . . . . . . . CompleteToOrderNumber . . . . Uppercase (38,7)
Index Of So2 Line . . . . . . . . . . . IndexNumberSO2OrWO2 . . . . . Zero-Filled (45,6)
(Or W/O Step Number + 2 Blanks) . . . . . . . . . . . . . . . . . . Memo
Complete Warehouse. . . . . . . . . . . CompleteWarehouse . . . . . . Account (51,3)
Complete Item Cost Method (1-6) . . . . CompleteToSOWOItemCostMethod. Zero-Filled (54,1)
Beginning Lot/Ser Number. . . . . . . . CompleteToSOWOBegLotSerialNo. Uppercase (55,15)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (70,32)
Record Type ("A" = Comp. To SO/WO). . . RecordType. . . . . . . . . . Uppercase (102,1)
Regular Items Only. . . . . . . . . . . . . . . . . . . . . . . . . Memo
Use All WIP . . . . . . . . . . . . . . UseAllWIP . . . . . . . . . . Yes/No (103,1)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (104,7)
Auto Issue Matl Tran Num. . . . . . . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num . . . . . . . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Gen Outs Proc Tran Num . . . . . . AutoGenOutsProcTranNum. . . . Uppercase (125,7)
Complete Item Number. . . . . . . . . . CompleteItemNumber. . . . . . Uppercase (132,30)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (162,80)
Completed Quantity. . . . . . . . . . . CompletedQuantity . . . . . . Number [0] 6.4
Completed U/M Conversion. . . . . . . . CompletedUMConversion . . . . Number [1] 6.4
Unit Cost (Zero Or Overriden) . . . . . UnitCost. . . . . . . . . . . Number [2] 6.4
Parent Item Quantity. . . . . . . . . . ParentItemQty . . . . . . . . Number [3] 6.4
Parent Item U/M Conversion. . . . . . . ParentItemUMConversion. . . . Number [4] 6.4
Total Cost (Calc @ Pre-Update) . . TotalCost . . . . . . . . . . Number [5] 7.2
Cost From Fix Ovrhd (Calc @ Pre-Up) . . FixedOH . . . . . . . . . . . Number [6] 7.2
Cost From Var Ovrhd (Calc @ Pre-Up) . . VariableOH. . . . . . . . . . Number [7] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 369
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: B W/O Complete To SO/WO Spec Item (Type 7) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Complete-To Code (2-3 = S/O - W/O). . . CompleteToCode. . . . . . . . Uppercase (8,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (9,20)
Item Number Type (2=Special Item) . . . ItemNumberType. . . . . . . . Zero-Filled (29,1)
Complete Unit Of Measure. . . . . . . . CompleteUM. . . . . . . . . . Uppercase (30,4)
Parent Unit Of Measure. . . . . . . . . ParentUM. . . . . . . . . . . Uppercase (34,4)
Complete To Order Number. . . . . . . . CompleteToOrderNumber . . . . Uppercase (38,7)
Index Of So2 Line . . . . . . . . . . . IndexNumberSO2OrWO2 . . . . . Zero-Filled (45,6)
(Or W/O Step Number + 2 Blanks) . . . . . . . . . . . . . . . . . . Memo
Special Item Purchases Account. . . . . ComplToSOWOSpecPurchGLAcct. . G/L Account (51,9)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (60,3)
Special Item Description. . . . . . . . ComplToSOWOSpecItemDesc . . . String (63,30)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (93,9)
Record Type ("B" = Compl. To SO/WO) . . RecordType. . . . . . . . . . Uppercase (102,1)
Special Items . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Use All WIP . . . . . . . . . . . . . . UseAllWIP . . . . . . . . . . Yes/No (103,1)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (104,7)
Auto Issue Matl Tran Num (Not Used) . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num (Not Used). . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Gen Outs Proc Tran Num (Not Used). AutoGenOutsProcTranNum. . . . Uppercase (125,7)
Complete Item Number. . . . . . . . . . CompleteItemNumber. . . . . . Uppercase (132,30)
Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (162,80)
Completed Quantity. . . . . . . . . . . CompletedQuantity . . . . . . Number [0] 6.4
Completed U/M Conversion. . . . . . . . CompletedUMConversion . . . . Number [1] 6.4
Unit Cost (Zero Or Overriden) . . . . . UnitCost. . . . . . . . . . . Number [2] 6.4
Parent Item Quantity. . . . . . . . . . ParentItemQty . . . . . . . . Number [3] 6.4
Parent Item U/M Conversion. . . . . . . ParentItemUMConversion. . . . Number [4] 6.4
Total Cost (Calc @ Pre-Update) . . TotalCost . . . . . . . . . . Number [5] 7.2
Cost From Fix Ovrhd (Calc @ Pre-Up) . . FixedOH . . . . . . . . . . . Number [6] 7.2
Cost From Var Ovrhd (Calc @ Pre-Up) . . VariableOH. . . . . . . . . . Number [7] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 369
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: C W/O Complete To Scrap (Trans Type 7) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Complete-To Code ("4" = Scrap). . . . . CompleteToCode. . . . . . . . Uppercase (8,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (9,4)
Complete Unit Of Measure. . . . . . . . ScrapCompleteUM . . . . . . . Uppercase (13,4)
First W/O Step For Scrap Costs. . . . . FirstWOStepForScrapCost . . . Zero-Filled (17,4)
Last W/O Step For Scrap Costs . . . . . LastWOStepForScrapCost. . . . Zero-Filled (21,4)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (25,77)
Record Type ("C" = Compl. To Scrap) . . RecordType. . . . . . . . . . Uppercase (102,1)
Use All WIP . . . . . . . . . . . . . . UseAllWIP . . . . . . . . . . Yes/No (103,1)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (104,7)
Auto Issue Matl Tran Num. . . . . . . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num . . . . . . . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Gen Outs Proc Tran Num . . . . . . AutoGenOutsProcTranNum. . . . Uppercase (125,7)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (132,110)
Scrapped Quantity . . . . . . . . . . . QuantityScrapped. . . . . . . Number [0] 6.4
Scrapped U/M Conversion . . . . . . . . ScrappedUMConversion. . . . . Number [1] 6.4
Unit Cost (Calc @ Pre-Update) . . . . . UnitCostPreUpdate . . . . . . Number [2] 6.4
Unit Cost (Maintained). . . . . . . . . UnitCostMaintained. . . . . . Number [3] 6.4
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [4] 0.
Total Scrap Cost. . . . . . . . . . . . TotalCost . . . . . . . . . . Number [5] 7.2
Cost From Fix Ovrhd (Calc @ Pre-Up) . . FixedOH . . . . . . . . . . . Number [6] 7.2
Cost From Var Ovrhd (Calc @ Pre-Up) . . VariableOH. . . . . . . . . . Number [7] 7.2
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 357
WOS W/O Transaction Entry Detail (WOS_TransEntryDetail) Level: 4.40
Record Type: D W/O Close Detail (Trans Type 8) 08/28/2009
File Type: Indexed Key Size: Rec Len: 388 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tag Field (Transaction Number). . . . . TransNumber . . . . . . . . . Uppercase (1,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase (1,7)
Last Activity Date. . . . . . . . . . . LastActivitydate. . . . . . . Date (8,6)
Copied From WO1 At The Time This. . . . . . . . . . . . . . . . . . Memo
This Line Is Entered. . . . . . . . . . . . . . . . . . . . . . . . Memo
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled (14,5)
(From Update Of WO9). . . . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (19,83)
Record Type ("D" = Close) . . . . . . . RecordType. . . . . . . . . . Uppercase (102,1)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (103,8)
Auto Issue Matl Tran Num (Not Used) . . AutoIssueMatlTranNum. . . . . Uppercase (111,7)
Auto Gen Lab Tran Num (Not Used). . . . AutoGenLabTranNum . . . . . . Uppercase (118,7)
Auto Gen Outs Proc Tran Num (Not Used). AutoGenOutsProcTranNum. . . . Uppercase (125,7)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (132,110)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [4] 0.
Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [5] 0.
Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [6] 0.
Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [7] 0.
Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [8] 0.
________
Total Bytes 276