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