WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: 1 Release Work Order Transaction 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) " " First Record (Four Blanks) . . . FirstRecordRelease. . . . . . Zero-Filled *(11,4) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (15,5) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date (20,6) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (26,5) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled (36,5) Transaction Number From WOR File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) 1=Release Work Order. . . . . . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (49,155) 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. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo There Are No Direct Costs . . . . . . . . . . . . . . . . . . . . . Memo Associated With Releasing A Work. . . . . . . . . . . . . . . . . . Memo Order. This Transaction Simply . . . . . . . . . . . . . . . . . . Memo Records The Date. . . . . . . . . . . . . . . . . . . . . . . . . . Memo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Other Transaction Types:. . . . . . . . . . . . . . . . . . . . . . Memo 2 = Material Issue. . . . . . . . . . . . . . . . . . . . . . . . . Memo 3 = Labor, 4 = Misc Labor . . . . . . . . . . . . . . . . . . . . . Memo 5 = Misc. Material Issue. . . . . . . . . . . . . . . . . . . . . . Memo 6 = Outside Processing. . . . . . . . . . . . . . . . . . . . . . . Memo 7 = Completion Record, 8 = Closing. . . . . . . . . . . . . . . . . Memo A = Material Substitution . . . . . . . . . . . . . . . . . . . . . Memo B = Material Issue - Serial No.. . . . . . . . . . . . . . . . . . Memo C = Material Issue - Lot. . . . . . . . . . . . . . . . . . . . . . Memo D = Completion - Serial No. . . . . . . . . . . . . . . . . . . . . Memo E = Completion - Lot. . . . . . . . . . . . . . . . . . . . . . . . Memo F = Labor Crew Transaction. . . . . . . . . . . . . . . . . . . . . Memo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 212
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: 2 Material Issue Transaction History 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(11,4) Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase *(15,1) Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled *(16,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(26,5) Op Code Actually Performed. . . . . . . OpCode. . . . . . . . . . . . Uppercase *(31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled *(36,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) 2=Material Issue. . . . . . . . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (49,20) Warehouse . . . . . . . . . . . . . . . Whse. . . . . . . . . . . . . Account (69,3) Unit Of Measure . . . . . . . . . . . . UnitOfMeasure . . . . . . . . Uppercase (72,4) Item Description. . . . . . . . . . . . ItemDescription . . . . . . . String (76,30) Seq Of Associated Type "A" Record . . . SeqNumAssocRec. . . . . . . . Zero-Filled (106,5) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (111,13) Item Number1. . . . . . . . . . . . . . ItemNumber1 . . . . . . . . . Uppercase (124,30) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (154,50) Wip Direct Amount Debited. . . DirectAmount. . . . . . . . . Number [0] 7.2 Wip Fixed Overhead Amount Debited. . . FixedOverhead . . . . . . . . Number [1] 7.2 Wip Variable Overhead Amt Debited. . . VariableOverhead. . . . . . . Number [2] 7.2 Quantity. . . . . . . . . . . . . . . . Qty . . . . . . . . . . . . . Number [3] 6.4 Unit Of Measure Conversion Factor . . . UMConvFactor. . . . . . . . . Number [4] 6.4 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [6] 0. ________ Total Bytes 269
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: 3 Labor Transaction 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(11,4) Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase *(15,1) Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled *(16,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(26,5) Op Code Actually Performed. . . . . . . OpCode. . . . . . . . . . . . Uppercase *(31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled *(36,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) 3=Labor Transaction . . . . . . . . . . . . . . . . . . . . . . . . Memo Employee/Crew Division. . . . . . . . . EmployeeCrewDivision. . . . . String (49,2) Blanks when Crew# is used below . . . . . . . . . . . . . . . . . . Memo Employee/Crew Number. . . . . . . . . . EmployeeCrewNumber. . . . . . Uppercase (51,7) When Crew#: "CREW000", 000=Crew#. . . . . . . . . . . . . . . . . . Memo Employee/Crew Name. . . . . . . . . . . EmployeeCrewName. . . . . . . String (58,30) Start Date. . . . . . . . . . . . . . . StartDate . . . . . . . . . . Date (88,6) Start Time. . . . . . . . . . . . . . . StartTime . . . . . . . . . . Uppercase (94,6) Stop Date . . . . . . . . . . . . . . . StopDate. . . . . . . . . . . Date (100,6) Stop Time . . . . . . . . . . . . . . . StopTime. . . . . . . . . . . Uppercase (106,6) Step Complete . . . . . . . . . . . . . StepComplete. . . . . . . . . Yes/No (112,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (113,91) Wip Direct Amount Debited. . . DirectAmount. . . . . . . . . Number [0] 7.2 Wip Fixed Overhead Amount Debited. . . FixedOverhead . . . . . . . . Number [1] 7.2 Wip Variable Overhead Amt Debited. . . VariableOverhead. . . . . . . Number [2] 7.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0. Quantity Complete . . . . . . . . . . . QtyComplete . . . . . . . . . Number [5] 6.4 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [6] 0. Documentation Of The Serial/Lot . . . . . . . . . . . . . . . . . . Memo Numbers That Were Issued To The . . . . . . . . . . . . . . . . . . Memo Work Order. The Costs In These . . . . . . . . . . . . . . . . . . Memo Records Support The Costs That. . . . . . . . . . . . . . . . . . . Memo Are Saved In The Material Issue . . . . . . . . . . . . . . . . . . Memo Type 2 Record.. . . . . . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 257
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: 4 Misc Material Or Labor 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(11,4) Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase *(15,1) Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled *(16,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(26,5) Op Code Actually Performed. . . . . . . OpCode. . . . . . . . . . . . Uppercase *(31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled *(36,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) 4=Misc Labor Charge . . . . . . . . . . . . . . . . . . . . . . . . Memo 5=Misc Material Charge. . . . . . . . . . . . . . . . . . . . . . . Memo Description Of Charge . . . . . . . . . Description . . . . . . . . . String (49,30) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (79,125) Wip Direct Amount Debited. . . DirectAmount. . . . . . . . . Number [0] 7.2 Wip Fixed Overhead Amount Debited. . . FixedOverhead . . . . . . . . Number [1] 7.2 Wip Variable Overhead Amt Debited. . . VariableOverhead. . . . . . . Number [2] 7.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [6] 0. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo This Transaction Stores What Was. . . . . . . . . . . . . . . . . . Memo Originally Planned To Be Issued . . . . . . . . . . . . . . . . . . Memo And What Was Substituted. . . . . . . . . . . . . . . . . . . . . . Memo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo This Record Does Not Store Any. . . . . . . . . . . . . . . . . . . Memo Cost Info. Cost Info Is Stored . . . . . . . . . . . . . . . . . . Memo In The Type 2 Record. . . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 245
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: 6 Outside Processing Charge 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(11,4) Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase *(15,1) Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled *(16,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(26,5) Op Code Actually Performed. . . . . . . OpCode. . . . . . . . . . . . Uppercase *(31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled *(36,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) 6=Outside Processing Charge . . . . . . . . . . . . . . . . . . . . Memo Description Of Product Or Service . . . Description . . . . . . . . . String (49,30) Vendor Division . . . . . . . . . . . . VendorDivision. . . . . . . . Account (79,2) Vendor Number . . . . . . . . . . . . . VendorNumber. . . . . . . . . Account (81,7) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (88,116) Wip Direct Amount Debited. . . DirectAmount. . . . . . . . . Number [0] 7.2 Wip Fixed Overhead Amount Debited. . . FixedOverhead . . . . . . . . Number [1] 7.2 Wip Variable Overhead Amt Debited. . . VariableOverhead. . . . . . . Number [2] 7.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [6] 0. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo This Transaction Stores The Time. . . . . . . . . . . . . . . . . . Memo For An Individual Crew Member That. . . . . . . . . . . . . . . . . Memo Worked On A Work Order. . . . . . . . . . . . . . . . . . . . . . . Memo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo All Costs Are Stored In Transaction . . . . . . . . . . . . . . . . Memo Type 3 Record . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 245
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: 7 Completion Transaction 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) "9999". . . . . . . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(11,4) "ZYYYY" To Force To End . . . . . . . . ForceToEnd. . . . . . . . . . Uppercase *(15,5) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (26,5) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled (36,5) Transaction Number From WOR File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) 7=Completion Transaction. . . . . . . . . . . . . . . . . . . . . . Memo Complete To . . . . . . . . . . . . . . CompleteToStock . . . . . . . String (49,1) 1=Stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 2=Sales Order . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 3=Work Order. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 4=Scrap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Complete To Order#(If 2 Or 3) . . . . . CompleteToOrderNumber . . . . Uppercase (50,7) Complete To Step #(If #3) . . . . . . . CompleteToStepNumber. . . . . Zero-Filled (57,4) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (61,20) Completed Item Unit Of Measure. . . . . CompletedItemUM . . . . . . . Uppercase (81,4) Completed Item Warehouse. . . . . . . . CompletedItemWhse . . . . . . Uppercase (85,3) Special Item Purchases Acct Debited . . CompletionSpecItemPurchAcct . G/L Account (88,9) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (97,23) Original Item Unit Of Measure . . . . . CompletionOriginalItemUM. . . Uppercase (120,4) Completed Item Number (Or *Special) . . CompletedItemNum. . . . . . . Uppercase (124,30) Original Item Number. . . . . . . . . . CompletionOrigItemNum . . . . Uppercase (154,30) Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (184,20) Inventory/Spec Purch Amt Debited. . . . InvSpecPurcAmtDebit . . . . . Number [0] 7.2 Amount From Fixed Overhead . . . . . . AmtFromFixedOverhead. . . . . Number [1] 7.2 Amount From Variable Overhead . . . . . AmtFromVariableOverhead . . . Number [2] 7.2 Completed Quantity. . . . . . . . . . . Qty . . . . . . . . . . . . . Number [3] 6.4 Completed Item Unit Of Measure Conv . . UMConvFactor. . . . . . . . . Number [4] 4.0 Original Parent Quantity. . . . . . . . OriginalQty . . . . . . . . . Number [5] 6.4 Original Parent Unit Of Measure Con . . OriginalUMConv. . . . . . . . Number [6] 4.0 ________ Total Bytes 281
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: 8 Close Work Order Trans. 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) "9999". . . . . . . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(11,4) "ZZZZZ" To Force To End . . . . . . . . ForceToEnd. . . . . . . . . . Uppercase *(15,5) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (26,10) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled (36,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) 8=Close Work Order Transaction. . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (49,155) Direct Cost Amount Debited To Scrap . . DirectAmount. . . . . . . . . Number [0] 7.2 Fixed Ovrhd Amount Debited To Scrap . . FixedOverhead . . . . . . . . Number [1] 7.2 Var Overhd Amount Debited To Scrap. . . VariableOverhead. . . . . . . Number [2] 7.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [6] 0. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo These transactions reflect The. . . . . . . . . . . . . . . . . . . Memo cost removed from WIP when a Work . . . . . . . . . . . . . . . . . Memo Order is finanly closed. If any. . . . . . . . . . . . . . . . . . Memo amounts remain In WIP, they are . . . . . . . . . . . . . . . . . . Memo credited to WIP and debited . . . . . . . . . . . . . . . . . . . . Memo to the W/O Scrap account. . . . . . . . . . . . . . . . . . . . . . Memo defined in the Work Order Options.. . . . . . . . . . . . . . . . . Memo ________ Total Bytes 245
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: A Material Substitution Record 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(11,4) Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase *(15,1) Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled *(16,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(26,5) Op Code Actually Performed. . . . . . . OpCode. . . . . . . . . . . . Uppercase *(31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled *(36,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) A=Material Subst Orig Item Number . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (49,20) Issued Item Warehouse . . . . . . . . . Whse. . . . . . . . . . . . . Account (69,3) Issued Item Unit Ofmeasure. . . . . . . UnitOfMeasure . . . . . . . . Uppercase (72,4) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (76,20) Original Item Warehouse Planned . . . . OrigItemWhsePlanned . . . . . String (96,3) Original Item Unit Of Measure . . . . . OriginalItemUM. . . . . . . . Uppercase (99,4) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (103,3) Seq Of Associated Type "2" Record . . . SeqNumAssocRec. . . . . . . . Zero-Filled (106,5) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (111,13) Issued Item Number1 . . . . . . . . . . ItemNumber1 . . . . . . . . . Uppercase (124,30) Original Item Number Planned1 . . . . . OrigItemNumPlanned1 . . . . . String (154,30) Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (184,20) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Issued Item Quantity. . . . . . . . . . Qty . . . . . . . . . . . . . Number [3] 6.4 Issued Item Unit Of Meas Convrsn. . . . UMConvFactor. . . . . . . . . Number [4] 6.4 Original Item Quantity Replaced . . . . OriginalQty . . . . . . . . . Number [5] 6.4 Original Item Unit Of Meas Convrsn. . . OriginalUMConv. . . . . . . . Number [6] 6.4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo This Transaction Stores What Was. . . . . . . . . . . . . . . . . . Memo Originally Planned To Be Issued . . . . . . . . . . . . . . . . . . Memo And What Was Substituted. . . . . . . . . . . . . . . . . . . . . . Memo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo This Record Does Not Store Any. . . . . . . . . . . . . . . . . . . Memo Cost Info. Cost Info Is Stored . . . . . . . . . . . . . . . . . . Memo In The Type 2 Record. . . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 260
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: B Material Issue Serial # 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(11,4) Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase *(15,1) Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled *(16,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(26,5) Op Code Actually Performed. . . . . . . OpCode. . . . . . . . . . . . Uppercase *(31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled *(36,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) B=Serial Number Record. . . . . . . . . . . . . . . . . . . . . . . Memo C=Lot Number Record . . . . . . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (49,20) Warehouse . . . . . . . . . . . . . . . Whse. . . . . . . . . . . . . Account (69,3) Unit Of Measure . . . . . . . . . . . . UnitOfMeasure . . . . . . . . Uppercase (72,4) Serial Number . . . . . . . . . . . . . SerialNumber. . . . . . . . . String (76,15) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (91,33) Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase (124,30) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (154,50) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Quantity Of This Lot/Serial# Issued . . Qty . . . . . . . . . . . . . Number [3] 6.4 Unit Of Measure Conversion Factor . . . UMConvFactor. . . . . . . . . Number [4] 6.4 Total Cost From This Lot/Ser. . . . . . TotalCost . . . . . . . . . . Number [5] 7.2 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [6] 0. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo These Two Records Simply Provide. . . . . . . . . . . . . . . . . . Memo Documentation Of The Serial/Lot . . . . . . . . . . . . . . . . . . Memo Numbers That Were Issued To The . . . . . . . . . . . . . . . . . . Memo Work Order. The Costs In These . . . . . . . . . . . . . . . . . . Memo Records Support The Costs That. . . . . . . . . . . . . . . . . . . Memo Are Saved In The Material Issue . . . . . . . . . . . . . . . . . . Memo Type 2 Record.. . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Actual Lot/Serial # Records Created . . . . . . . . . . . . . . . . Memo Or Added To When Completing To I/M. . . . . . . . . . . . . . . . . Memo (For Stock, S/O,Or W/O) . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 247
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: C Material Issue Lot # 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(11,4) Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase *(15,1) Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled *(16,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(26,5) Op Code Actually Performed. . . . . . . OpCode. . . . . . . . . . . . Uppercase *(31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled *(36,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) B=Serial Number Record. . . . . . . . . . . . . . . . . . . . . . . Memo C=Lot Number Record . . . . . . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (49,20) Warehouse . . . . . . . . . . . . . . . Whse. . . . . . . . . . . . . Account (69,3) Unit Of Measure . . . . . . . . . . . . UnitOfMeasure . . . . . . . . Uppercase (72,4) Lot Number. . . . . . . . . . . . . . . LotNumber . . . . . . . . . . String (76,15) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (91,33) Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase (124,30) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (154,50) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Quantity Of This Lot/Serial# Issued . . Qty . . . . . . . . . . . . . Number [3] 6.4 Unit Of Measure Conversion Factor . . . UMConvFactor. . . . . . . . . Number [4] 6.4 Total Cost From This Lot/Ser. . . . . . TotalCost . . . . . . . . . . Number [5] 7.2 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [6] 0. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo These Two Records Simply Provide. . . . . . . . . . . . . . . . . . Memo Documentation Of The Serial/Lot . . . . . . . . . . . . . . . . . . Memo Numbers That Were Issued To The . . . . . . . . . . . . . . . . . . Memo Work Order. The Costs In These . . . . . . . . . . . . . . . . . . Memo Records Support The Costs That. . . . . . . . . . . . . . . . . . . Memo Are Saved In The Material Issue . . . . . . . . . . . . . . . . . . Memo Type 2 Record.. . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Actual Lot/Serial # Records Created . . . . . . . . . . . . . . . . Memo Or Added To When Completing To I/M. . . . . . . . . . . . . . . . . Memo (For Stock, S/O,Or W/O) . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 247
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: D Completion Serial Number 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) "9999". . . . . . . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(11,4) "ZZYYY" To Force To End (After Comp . . ForceToEnd. . . . . . . . . . Uppercase *(15,5) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (26,5) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled (36,5) Transaction Number From WOR File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) "D" = Completion Serial Number. . . . . . . . . . . . . . . . . . . Memo Complete To . . . . . . . . . . . . . . CompleteToStock . . . . . . . String (49,1) 1=Stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 2=Sales Order . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 3=Work Order. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 4=Scrap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Complete To Order#(If 2 Or 3) . . . . . CompleteToOrderNumber . . . . Uppercase (50,7) Complete To Step #(If #3) . . . . . . . CompleteToStepNumber. . . . . Zero-Filled (57,4) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (61,20) Completed Item Unit Of Measure. . . . . CompletedItemUM . . . . . . . Uppercase (81,4) Completed Item Warehouse. . . . . . . . CompletedItemWhse . . . . . . Uppercase (85,3) Starting Serial Number. . . . . . . . . StartingSerLotNumber. . . . . Uppercase (88,15) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (103,21) Completed Item Number (Or *Special) . . CompletedItemNum. . . . . . . Uppercase (124,30) Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (154,50) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Completed Quantity This Serial # (=1) . Qty . . . . . . . . . . . . . Number [3] 6.4 Completed Item Unit Of Measure Conv . . UMConvFactor. . . . . . . . . Number [4] 6.4 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [6] 0. This transaction reflects the actual. . . . . . . . . . . . . . . . Memo Serial No. records created or added to. . . . . . . . . . . . . . . Memo when completing to I/M for Stock, . . . . . . . . . . . . . . . . . Memo S/O, or W/O.. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 236
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: E Completion Lot Number 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) "9999". . . . . . . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(11,4) "ZZYYY" To Force To End (After Comp . . ForceToEnd. . . . . . . . . . Uppercase *(15,5) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (26,5) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled (36,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) "E" = Completion Lot Number . . . . . . . . . . . . . . . . . . . . Memo Complete To . . . . . . . . . . . . . . CompleteToStock . . . . . . . String (49,1) 1=Stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 2=Sales Order . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 3=Work Order. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 4=Scrap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Complete To Order#(If 2 Or 3) . . . . . CompleteToOrderNumber . . . . Uppercase (50,7) Complete To Step #(If #3) . . . . . . . CompleteToStepNumber. . . . . Zero-Filled (57,4) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (61,20) Completed Item Unit Of Measure. . . . . CompletedItemUM . . . . . . . Uppercase (81,4) Completed Item Warehouse. . . . . . . . CompletedItemWhse . . . . . . Uppercase (85,3) Starting Lot Number . . . . . . . . . . StartingSerLotNumber. . . . . Uppercase (88,15) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (103,51) Completed Item Number (Or *Special) . . CompletedItemNum. . . . . . . Uppercase (154,30) Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (184,50) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Completed Quantity This Lot Number. . . Qty . . . . . . . . . . . . . Number [3] 6.4 Completed Item Unit Of Measure Conv . . UMConvFactor. . . . . . . . . Number [4] 6.4 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [6] 0. This transaction reflects the actual. . . . . . . . . . . . . . . . Memo Lot Number records created or added to. . . . . . . . . . . . . . . Memo when completing to I/M for Stock, . . . . . . . . . . . . . . . . . Memo S/O,or W/O. . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 266
WOO Work Order History Transaction File (WOO_HistoryTransaction) Level: 4.40 Record Type: F Labor Crew Transaction Record 08/28/2009 File Type: Direct Key Size: 40 Rec Len: 294 Min Len: 203 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence. . . . . . . . . . . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(11,4) Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase *(15,1) Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled *(16,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(20,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(26,5) Op Code Actually Performed. . . . . . . OpCode. . . . . . . . . . . . Uppercase *(31,5) Sequence Number . . . . . . . . . . . . TransSeqNumber. . . . . . . . Zero-Filled *(36,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (41,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (48,1) F=Crew Name/Time Record . . . . . . . . . . . . . . . . . . . . . . Memo Crew Number ( CREW000, 000=Crew#). . . CrewNumber. . . . . . . . . . Uppercase (49,9) Crew Member Employee Division . . . . . CrewEmpDivision . . . . . . . Zero-Filled (58,2) Crew Member Employee Number . . . . . . CrewMemberEmployeeNo. . . . . Account (60,7) Crew Member Employee Name . . . . . . . CrewMemberName. . . . . . . . String (67,30) Crew Member Start Date. . . . . . . . . CrewMemberStartDate . . . . . Date (97,6) Crew Member Start Time ("##.###") . . . CrewMemberStartTime . . . . . Uppercase (103,6) Crew Member Stop Date . . . . . . . . . CrewMemberStopDate. . . . . . Date (109,6) Crew Member Stop Time ("##.###") . . . CrewMemberStopTime. . . . . . Uppercase (115,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (121,113) 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. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo This Transaction Stores The Time. . . . . . . . . . . . . . . . . . Memo For An Individual Crew Member That. . . . . . . . . . . . . . . . . Memo Worked On A Work Order. . . . . . . . . . . . . . . . . . . . . . . Memo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo All Costs Are Stored In Transaction . . . . . . . . . . . . . . . . Memo Type 3 Record . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 242