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