WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: 1 Cost Ledger - Release Work Order Trans 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) " " First Step (Four Blanks). . . . FirstStep . . . . . . . . . . Zero-Filled *(8,4) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (12,5) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date (17,6) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (23,10) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) 1=Release Work Order. . . . . . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (46,177) 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/C = Material Issue Lot/Serial No. . . . . . . . . . . . . . . . . Memo D/E = Completion Lot/Serial No. . . . . . . . . . . . . . . . . . . Memo F = Labor Crew Transaction. . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 231
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: 2 Cost Ledger - Material Issue Record 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5) Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) 2=Material Issue. . . . . . . . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (46,20) Warehouse . . . . . . . . . . . . . . . WhseNumber. . . . . . . . . . Account (66,3) Unit Of Measure . . . . . . . . . . . . ItemUM. . . . . . . . . . . . Uppercase (69,4) Item Description. . . . . . . . . . . . ItemDescription . . . . . . . String (73,30) Seq Of Associated Type "A" Record . . . AssocSeqNum . . . . . . . . . Zero-Filled (103,5) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (108,55) Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase (163,30) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (193,30) Wip Direct Amount Debited . . . WipDirect . . . . . . . . . . Number [0] 7.2 Wip Fixed Overhead Amount Debited . . . WipFixedOvhd. . . . . . . . . Number [1] 7.2 Wip Variable Overhead Amt Debited . . . WipVariableOvhd . . . . . . . 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 288
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: 3 Cost Ledger - Labor Transaction 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5) Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) 3=Labor Transaction . . . . . . . . . . . . . . . . . . . . . . . . Memo Employee/Crew Division. . . . . . . . . EmployeeCrewDivision. . . . . String (46,2) Blanks when Crew# is used below . . . . . . . . . . . . . . . . . . Memo Employee/Crew Number. . . . . . . . . . EmployeeCrewNumber. . . . . . Uppercase (48,7) When Crew#: "CREW000", 000=Crew# . . . . . . . . . . . . . . . . . Memo Employee/Crew Name. . . . . . . . . . . EmployeeCrewName. . . . . . . String (55,30) Start Date. . . . . . . . . . . . . . . StartDate . . . . . . . . . . Date (85,6) Start Time ("##.###") . . . . . . . . . StartTime . . . . . . . . . . Uppercase (91,6) Stop Date . . . . . . . . . . . . . . . StopDate. . . . . . . . . . . Date (97,6) Stop Time ("##.###"). . . . . . . . . . StopTime. . . . . . . . . . . Uppercase (103,6) Step Complete?. . . . . . . . . . . . . StepComplete. . . . . . . . . Yes/No (109,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (110,113) Wip Direct Amount Debited . . . WipDirect . . . . . . . . . . Number [0] 7.2 Wip Fixed Overhead Amount Debited . . . WipFixedOvhd. . . . . . . . . Number [1] 7.2 Wip Variable Overhead Amt Debited . . . WipVariableOvhd . . . . . . . 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. ________ Total Bytes 276
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: 4 Cost Ledger - Misc Mat'l Or Labor Charge 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5) Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) 4=Misc Labor Charge . . . . . . . . . . . . . . . . . . . . . . . . Memo 5=Misc Material Charge. . . . . . . . . . . . . . . . . . . . . . . Memo Description Of Charge . . . . . . . . . Description . . . . . . . . . String (46,30) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (76,147) Wip Direct Amount Debited . . . WipDirect . . . . . . . . . . Number [0] 7.2 Wip Fixed Overhead Amount Debited . . . WipFixedOvhd. . . . . . . . . Number [1] 7.2 Wip Variable Overhead Amt Debited . . . WipVariableOvhd . . . . . . . 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. ________ Total Bytes 264
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: 6 Cost Ledger - Outside Processing Charge 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5) Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) 6=Outside Processing Charge . . . . . . . . . . . . . . . . . . . . Memo Description Of Product Or Service . . . Description . . . . . . . . . String (46,30) Vendor Division . . . . . . . . . . . . VendorDivision. . . . . . . . Zero-Filled (76,2) Vendor Number . . . . . . . . . . . . . VendorNumber. . . . . . . . . Account (78,7) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (85,138) Wip Direct Amount Debited . . . WipDirect . . . . . . . . . . Number [0] 7.2 Wip Fixed Overhead Amount Debited . . . WipFixedOvhd. . . . . . . . . Number [1] 7.2 Wip Variable Overhead Amt Debited . . . WipVariableOvhd . . . . . . . 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. ________ Total Bytes 264
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: 7 Cost Ledger - Completion Transaction 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) "9999" Last Step. . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(8,4) "ZYYYY" To Force To End . . . . . . . . ForceToEndCodeClosing . . . . Uppercase *(12,5) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) 7=Completion Transaction. . . . . . . . . . . . . . . . . . . . . . Memo Complete To . . . . . . . . . . . . . . CompleteToStock . . . . . . . String (46,1) 1=Stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 2=Sales Order . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 3=Work Order. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 4=Scrap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Complete To Order# (If 2 Or 3). . . . . CompleteToOrderNumber . . . . Uppercase (47,7) Complete To Step # (If 3) . . . . . . . CompleteToStepNumber. . . . . Zero-Filled (54,4) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (58,20) Completed Item Unit Of Measure. . . . . CompletedItemUM . . . . . . . Uppercase (78,4) Completed Item Warehouse. . . . . . . . CompletedItemWhse . . . . . . Uppercase (82,3) Special Item Purchases Acct Debited . . SpecItemPurchsAcct. . . . . . G/L Account (85,9) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (94,23) Original Item Unit Of Measure . . . . . OriginalItemUM. . . . . . . . Uppercase (117,4) S/O Customer Division . . . . . . . . . CustomerDivision. . . . . . . Account (121,2) S/O Customer Number . . . . . . . . . . SOCustomerNumber. . . . . . . Account (123,20) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (143,20) Completed Item Number . . . . . . . . . CompletedItemNumber . . . . . Uppercase (163,30) Original Item Number. . . . . . . . . . OrigItemNum . . . . . . . . . Uppercase (193,30) Inventory/Spec Purch Amnt Debited . . . InvSpecPurchAmnt. . . . . . . Number [0] 7.2 Amount From Fixed Overhead. . . . . . . AmountFromFixedOverhead . . . Number [1] 7.2 Amount From Variable Overhead . . . . . AmountFromVariableOverhead. . 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. . . . . . . . OriginalParentQty . . . . . . Number [5] 6.4 Original Parent Unit Of Measure Con . . OrigParentUMConv. . . . . . . Number [6] 4.0 ________ Total Bytes 300
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: 8 Cost Ledger - Close Work Order Trans. 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) "9999" Last Step. . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(8,4) "ZZZZZ" To Force To End . . . . . . . . ForceToEndCodeClosing . . . . Uppercase *(12,5) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) 8=Close Work Order Transaction. . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (46,177) Direct Cost Amount Debited To Scrap . . DirectCostDebitToScrap. . . . Number [0] 7.2 Fixed Ovrhd Amount Debited To Scrap . . FixedOvrhdDebitedToScrap. . . Number [1] 7.2 Var Overhd Amount Debited To Scrap . . VarOverhdDebitedToScrap . . . 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. . . . . . . . . . . . . . . . . . . . Memo Work Order Is Finally Closed. . . . . . . . . . . . . . . . . . . . Memo If Any Amounts Remain In Wip, . . . . . . . . . . . . . . . . . . . Memo They Are Credited To Wip And. . . . . . . . . . . . . . . . . . . . Memo Debited To The W/O Scrap. . . . . . . . . . . . . . . . . . . . . . Memo Account Defined In The Work . . . . . . . . . . . . . . . . . . . . Memo Order Options.. . . . . . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 264
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: A Cost Ledger - Material Substitution Rec 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5) Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) A=Material Subst Orig Item Number . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (46,20) Issued Item Warehouse . . . . . . . . . WhseNumber. . . . . . . . . . Account (66,3) Issued Item Unit Of Measure . . . . . . ItemUM. . . . . . . . . . . . Uppercase (69,4) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (73,20) Original Item Warehouse Planned . . . . OrigItemWhsePlanned . . . . . Account (93,3) Original Item Unit Of Measure . . . . . OrigItemUM. . . . . . . . . . Uppercase (96,4) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (100,3) Seq Of Associated Type "2" Record . . . AssocSeqNum . . . . . . . . . Zero-Filled (103,5) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (108,55) Issued Item Number. . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase (163,30) Original Item Number Planned. . . . . . OrigItemNumberPlanned . . . . String (193,30) 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 . . . . OrigItemQtyReplaced . . . . . Number [5] 6.4 Original Item Unit Of Meas Convrsn. . . OrigItemUMConversion. . . . . 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 279
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: B Cost Ledger - Material Issue Serial# 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5) Transaction Number From WOR File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) "B" = Serial Number Record. . . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (46,20) Warehouse . . . . . . . . . . . . . . . WhseNumber. . . . . . . . . . Account (66,3) Unit Of Measure . . . . . . . . . . . . ItemUM. . . . . . . . . . . . Uppercase (69,4) Serial Number . . . . . . . . . . . . . LotSerialNumber . . . . . . . String (73,15) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (88,75) Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase (163,30) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (193,30) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Quantity Of This Serial# Issued (=1). . Qty . . . . . . . . . . . . . Number [3] 6.4 Unit Of Measure Conversion Factor . . . UMConvFactor. . . . . . . . . Number [4] 6.4 Total Cost From This Serial#. . . . . . TotalCostLotSerial. . . . . . Number [5] 7.2 This record simply provides . . . . . . . . . . . . . . . . . . . . Memo documentation of the serial number. . . . . . . . . . . . . . . . . Memo that was issued to the work order . . . . . . . . . . . . . . . . . Memo The costs in these records support. . . . . . . . . . . . . . . . . Memo the costs that are saved in the Materi. . . . . . . . . . . . . . . Memo Issue Type 2 record.. . . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 265
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: C Cost Ledger - Material Issue Lot# 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5) Transaction Number From WOR File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) "C" = Lot Number Record . . . . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (46,20) Warehouse . . . . . . . . . . . . . . . WhseNumber. . . . . . . . . . Account (66,3) Unit Of Measure . . . . . . . . . . . . ItemUM. . . . . . . . . . . . Uppercase (69,4) Lot Number. . . . . . . . . . . . . . . LotSerialNumber . . . . . . . String (73,15) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (88,75) Item Number1. . . . . . . . . . . . . . ItemNumber1 . . . . . . . . . Uppercase (163,30) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (193,30) 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. . . . . . TotalCostLotSerial. . . . . . Number [5] 7.2 This record simply provides . . . . . . . . . . . . . . . . . . . . Memo documentation of the Lot numbers. . . . . . . . . . . . . . . . . . Memo that were used in the Work Order. . . . . . . . . . . . . . . . . . Memo The costs in these records support. . . . . . . . . . . . . . . . . Memo the costs that are saved in . . . . . . . . . . . . . . . . . . . . Memo the Material Issue Type 2 record. . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 265
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: D Cost Ledger - Completion Serial Number 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) "9999" Last Step. . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(8,4) "ZZYYY" To Force To End (After Comp . . ForceToEndCodeClosing . . . . Uppercase *(12,5) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5) Transaction Number From WOR File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) "D" = Completion Serial Number. . . . . . . . . . . . . . . . . . . Memo Complete To . . . . . . . . . . . . . . CompleteToStock . . . . . . . String (46,1) 1=Stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 2=Sales Order . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 3=Work Order. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 4=Scrap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Complete To Order# (If 2 Or 3). . . . . CompleteToOrderNumber . . . . Uppercase (47,7) Complete To Step # (If 3) . . . . . . . CompleteToStepNumber. . . . . Zero-Filled (54,4) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (58,20) Completed Item Unit Of Measure. . . . . CompletedItemUM . . . . . . . Uppercase (78,4) Completed Item Warehouse. . . . . . . . CompletedItemWhse . . . . . . Uppercase (82,3) Starting Serial Number. . . . . . . . . StartingLotSerNumber. . . . . Uppercase (85,15) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (100,63) Completed Item Number . . . . . . . . . CompletedItemNumber . . . . . Uppercase (163,30) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (193,30) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Completed Quantity 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 transactions reflects the actual . . . . . . . . . . . . . . . Memo serial number records created or. . . . . . . . . . . . . . . . . . Memo added to when completing to I/M . . . . . . . . . . . . . . . . . . Memo for Stock, S/O, or W/O. . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 255
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: E Cost Ledger - Completion Lot Number 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) "9999" Last Step. . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(8,4) "ZZYYY" To Force To End (After Comp . . ForceToEndCodeClosing . . . . Uppercase *(12,5) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5) Transaction Number From WOR File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) "E" = Completion Lot Number . . . . . . . . . . . . . . . . . . . . Memo Complete To . . . . . . . . . . . . . . CompleteToStock . . . . . . . String (46,1) 1=Stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 2=Sales Order . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 3=Work Order. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo 4=Scrap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Complete To Order# (If 2 Or 3). . . . . CompleteToOrderNumber . . . . Uppercase (47,7) Complete To Step # (If 3) . . . . . . . CompleteToStepNumber. . . . . Zero-Filled (54,4) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (58,20) Completed Item Unit Of Measure. . . . . CompletedItemUM . . . . . . . Uppercase (78,4) Completed Item Warehouse. . . . . . . . CompletedItemWhse . . . . . . Uppercase (82,3) Starting Lot Number . . . . . . . . . . StartingLotSerNumber. . . . . Uppercase (85,15) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (100,63) Completed Item Number1. . . . . . . . . CompletedItemNumber1. . . . . Uppercase (163,30) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (193,30) 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#. . . . . . 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. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo This transaction reflects the actual. . . . . . . . . . . . . . . . Memo Lot# records created or added to. . . . . . . . . . . . . . . . . . Memo when completing to IM for Stock,. . . . . . . . . . . . . . . . . . Memo S/O, or W/O.. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 255
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40 Record Type: F Cost Ledger - Labor Transaction Crew Rec 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6) Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5) Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5) Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7) Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1) F=Crew Name/Time Record . . . . . . . . . . . . . . . . . . . . . . Memo Crew Number (CREW000, 000=Crew#). . . . CrewNumber. . . . . . . . . . Uppercase (46,9) Crew Member Employee Division . . . . . CrewEmpDivision . . . . . . . Zero-Filled (55,2) Crew Member Employee Number . . . . . . CrewMemberEmployeeNo. . . . . Account (57,7) Crew Member Employee Name . . . . . . . CrewMemberName. . . . . . . . String (64,30) Crew Member Start Date. . . . . . . . . CrewMemberStartDate . . . . . Date (94,6) Crew Member Start Time ("##.###") . . . CrewMemberStartTime . . . . . Uppercase (100,6) Crew Member Stop Date . . . . . . . . . CrewMemberStopDate. . . . . . Date (106,6) Crew Member Stop Time ("##.###") . . . CrewMemberStopTime. . . . . . Uppercase (112,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (118,105) 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 . . . . . . . . . . . . . . . . . . . Memo That Worked On A Work Order.. . . . . . . . . . . . . . . . . . . . Memo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo All Costs Are Stored In . . . . . . . . . . . . . . . . . . . . . . Memo Transaction Type 3 Record.. . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 231