SO_CustomerSlsHistByProdLnWrk      SO Customer Sales By Product Line WRel: 4.40  Bld: 398  8/28/2009
 Bus Obj: SO_CustomerSlsHistByProdLn_rpt
 SQL Def: Y  SysDB: N                  "MAS_"+%C$+"/SO"+%C$+"/SO_CustomerSlsHistByProdLnWrk"+%S$+".M4T"

 KPRIMARY: SortField

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
   2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
   3  GroupField2 . . . . . . . . .     9 SNN  Group Field 2 . . . . . . . . .
   4  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
   5  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
   6  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
   7  ARDivisionDesc. . . . . . . .    30 SNN  AR Division Description . . . .
   8  CustomerType. . . . . . . . .     4 SNN  Customer Type . . . . . . . . .
   9  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
  10  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .
  11  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
  12  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .
  13  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .
  14  PriceLevel. . . . . . . . . .     1 SNN  Price Level . . . . . . . . . .
  15  StandardUnitOfMeasure . . . .     4 SNN  Standard Unit of Measure. . . .
  16  QuantitySoldPeriod1 . . . . . 16.6  NNN  Quantity Sold Period 1. . . . .
  17  QuantitySoldPeriod2 . . . . . 16.6  NNN  Quantity Sold Period 2. . . . .
  18  QuantitySoldPeriod3 . . . . . 16.6  NNN  Quantity Shipped Period 3 . . .
  19  QuantitySoldPeriod4 . . . . . 16.6  NNN  Quantity Shipped Period 4 . . .
  20  QuantitySoldPeriod5 . . . . . 16.6  NNN  Quantity Shipped Period 5 . . .
  21  QuantitySoldPeriod6 . . . . . 16.6  NNN  Quantity Shipped Period 6 . . .
  22  QuantitySoldPeriod7 . . . . . 16.6  NNN  Quantity Shipped Period 7 . . .
  23  QuantitySoldPeriod8 . . . . . 16.6  NNN  Quantity Shipped Period 8 . . .
  24  QuantitySoldPeriod9 . . . . . 16.6  NNN  Quantity Shipped Period 9 . . .
  25  QuantitySoldPeriod10. . . . . 16.6  NNN  Quantity Shipped Period 10. . .
  26  QuantitySoldPeriod11. . . . . 16.6  NNN  Quantity Shipped Period 11. . .
  27  QuantitySoldPeriod12. . . . . 16.6  NNN  Quantity Shipped Period 12. . .
  28  QuantitySoldPeriod13. . . . . 16.6  NNN  Quantity Shipped Period 13. . .
  29  QuantitySoldPeriod1PY . . . . 16.6  NNN  Quantity Shipped Period 1 Prior
  30  QuantitySoldPeriod2PY . . . . 16.6  NNN  Quantity Shipped Period 2 Prior
  31  QuantitySoldPeriod3PY . . . . 16.6  NNN  Quantity Shipped Period 3 Prior
  32  QuantitySoldPeriod4PY . . . . 16.6  NNN  Quantity Shipped Period 4 Prior
  33  QuantitySoldPeriod5PY . . . . 16.6  NNN  Quantity Shipped Period 5 Prior
  34  QuantitySoldPeriod6PY . . . . 16.6  NNN  Quantity Shipped Period 6 Prior
  35  QuantitySoldPeriod7PY . . . . 16.6  NNN  Quantity Shipped Period 7 Prior
  36  QuantitySoldPeriod8PY . . . . 16.6  NNN  Quantity Shipped Period 8 Prior
  37  QuantitySoldPeriod9PY . . . . 16.6  NNN  Quantity Shipped Period 9 Prior
  38  QuantitySoldPeriod10PY. . . . 16.6  NNN  Quantity Shipped Period 10 Prio
  39  QuantitySoldPeriod11PY. . . . 16.6  NNN  Quantity Shipped Period 11 Prio
  40  QuantitySoldPeriod12PY. . . . 16.6  NNN  Quantity Shipped Period 12 Prio
  41  QuantitySoldPeriod13PY. . . . 16.6  NNN  Quantity Shipped Period 13 Prio
  42  DollarsSoldPeriod1. . . . . . 15.2  NNN  Dollars Sold Period 1 . . . . .
  43  DollarsSoldPeriod2. . . . . . 15.2  NNN  Dollars Sold Period 2 . . . . .
  44  DollarsSoldPeriod3. . . . . . 15.2  NNN  Dollars Sold Period 3 . . . . .
  45  DollarsSoldPeriod4. . . . . . 15.2  NNN  Dollars Sold Period 4 . . . . .
  46  DollarsSoldPeriod5. . . . . . 15.2  NNN  Dollars Sold Period 5 . . . . .
  47  DollarsSoldPeriod6. . . . . . 15.2  NNN  Dollars Sold Period 6 . . . . .
  48  DollarsSoldPeriod7. . . . . . 15.2  NNN  Dollars Sold Period 7 . . . . .
  49  DollarsSoldPeriod8. . . . . . 15.2  NNN  Dollars Sold Period 8 . . . . .
  50  DollarsSoldPeriod9. . . . . . 15.2  NNN  Dollars Sold Period 9 . . . . .
  51  DollarsSoldPeriod10 . . . . . 15.2  NNN  Dollars Sold Period 10. . . . .
  52  DollarsSoldPeriod11 . . . . . 15.2  NNN  Dollars Sold Period 11. . . . .
  53  DollarsSoldPeriod12 . . . . . 15.2  NNN  Dollars Sold Period 12. . . . .
  54  DollarsSoldPeriod13 . . . . . 15.2  NNN  Dollars Sold Period 13. . . . .
  55  DollarsSoldPeriod1PY. . . . . 15.2  NNN  Dollars Sold Period 1 Prior Yea
  56  DollarsSoldPeriod2PY. . . . . 15.2  NNN  Dollars Sold Period 2 Prior Yea
  57  DollarsSoldPeriod3PY. . . . . 15.2  NNN  Dollars Sold Period 3 Prior Yea
  58  DollarsSoldPeriod4PY. . . . . 15.2  NNN  Dollars Sold Period 4 Prior Yea
  59  DollarsSoldPeriod5PY. . . . . 15.2  NNN  Dollars Sold Period 5 Prior Yea
  60  DollarsSoldPeriod6PY. . . . . 15.2  NNN  Dollars Sold Period 6 Prior Yea
  61  DollarsSoldPeriod7PY. . . . . 15.2  NNN  Dollars Sold Period 7 Prior Yea
  62  DollarsSoldPeriod8PY. . . . . 15.2  NNN  Dollars Sold Period 8 Prior Yea
  63  DollarsSoldPeriod9PY. . . . . 15.2  NNN  Dollars Sold Period 9 Prior Yea
  64  DollarsSoldPeriod10PY . . . . 15.2  NNN  Dollars Sold Period 10 Prior Ye
  65  DollarsSoldPeriod11PY . . . . 15.2  NNN  Dollars Sold Period 11 Prior Ye
  66  DollarsSoldPeriod12PY . . . . 15.2  NNN  Dollars Sold Period 12 Prior Ye
  67  DollarsSoldPeriod13PY . . . . 15.2  NNN  Dollars Sold Period 13 Prior Ye
  68  CostOfGoodsSoldPeriod1. . . . 15.2  NNN  Cost of Goods Sold Period 1 . .
  69  CostOfGoodsSoldPeriod2. . . . 15.2  NNN  Cost of Goods Sold Period 2 . .
  70  CostOfGoodsSoldPeriod3. . . . 15.2  NNN  Cost of Goods Sold Period 3 . .
  71  CostOfGoodsSoldPeriod4. . . . 15.2  NNN  Cost of Goods Sold Period 4 . .
  72  CostOfGoodsSoldPeriod5. . . . 15.2  NNN  Cost of Goods Sold Period 5 . .
  73  CostOfGoodsSoldPeriod6. . . . 15.2  NNN  Cost of Goods Sold Period 6 . .
  74  CostOfGoodsSoldPeriod7. . . . 15.2  NNN  Cost of Goods Sold Period 7 . .
  75  CostOfGoodsSoldPeriod8. . . . 15.2  NNN  Cost of Goods Sold Period 8 . .
  76  CostOfGoodsSoldPeriod9. . . . 15.2  NNN  Cost of Goods Sold Period 9 . .
  77  CostOfGoodsSoldPeriod10 . . . 15.2  NNN  Cost of Goods Sold Period 10. .
  78  CostOfGoodsSoldPeriod11 . . . 15.2  NNN  Cost of Goods Sold Period 11. .
  79  CostOfGoodsSoldPeriod12 . . . 15.2  NNN  Cost of Goods Sold Period 12. .
  80  CostOfGoodsSoldPeriod13 . . . 15.2  NNN  Cost of Goods Sold Period 13. .
  81  CostOfGoodsSoldPeriod1PY. . . 15.2  NNN  Cost of Goods Sold Period 1 Pri
  82  CostOfGoodsSoldPeriod2PY. . . 15.2  NNN  Cost of Goods Sold Period 2 Pri
  83  CostOfGoodsSoldPeriod3PY. . . 15.2  NNN  Cost of Goods Sold Period 3 Pri
  84  CostOfGoodsSoldPeriod4PY. . . 15.2  NNN  Cost of Goods Sold Period 4 Pri
  85  CostOfGoodsSoldPeriod5PY. . . 15.2  NNN  Cost of Goods Sold Period 5 Pri
  86  CostOfGoodsSoldPeriod6PY. . . 15.2  NNN  Cost of Goods Sold Period 6 Pri
  87  CostOfGoodsSoldPeriod7PY. . . 15.2  NNN  Cost of Goods Sold Period 7 Pri
  88  CostOfGoodsSoldPeriod8PY. . . 15.2  NNN  Cost of Goods Sold Period 8 Pri
  89  CostOfGoodsSoldPeriod9PY. . . 15.2  NNN  Cost of Goods Sold Period 9 Pri
  90  CostOfGoodsSoldPeriod10PY . . 15.2  NNN  Cost of Goods Sold Period 10 Pr
  91  CostOfGoodsSoldPeriod11PY . . 15.2  NNN  Cost of Goods Sold Period 11 Pr
  92  CostOfGoodsSoldPeriod12PY . . 15.2  NNN  Cost of Goods Sold Period 12 Pr
  93  CostOfGoodsSoldPeriod13PY . . 15.2  NNN  Cost of Goods Sold Period 13 Pr
  94  QuantityReturnedPeriod1 . . . 16.6  NNN  Quantity Returned Period 1. . .
  95  QuantityReturnedPeriod2 . . . 16.6  NNN  Quantity Returned Period 2. . .
  96  QuantityReturnedPeriod3 . . . 16.6  NNN  Quantity Returned Period 3. . .
  97  QuantityReturnedPeriod4 . . . 16.6  NNN  Quantity Returned Period 4. . .
  98  QuantityReturnedPeriod5 . . . 16.6  NNN  Quantity Returned Period 5. . .
  99  QuantityReturnedPeriod6 . . . 16.6  NNN  Quantity Returned Period 6. . .
 100  QuantityReturnedPeriod7 . . . 16.6  NNN  Quantity Returned Period 7. . .
 101  QuantityReturnedPeriod8 . . . 16.6  NNN  Quantity Returned Period 8. . .
 102  QuantityReturnedPeriod9 . . . 16.6  NNN  Quantity Returned Period 9. . .
 103  QuantityReturnedPeriod10. . . 16.6  NNN  Quantity Returned Period 10 . .
 104  QuantityReturnedPeriod11. . . 16.6  NNN  Quantity Returned Period 11 . .
 105  QuantityReturnedPeriod12. . . 16.6  NNN  Quantity Returned Period 12 . .
 106  QuantityReturnedPeriod13. . . 16.6  NNN  Quantity Returned Period 13 . .
 107  QuantityReturnedPeriod1PY . . 16.6  NNN  Quantity ReturnedPeriod 1 Prior
 108  QuantityReturnedPeriod2PY . . 16.6  NNN  Quantity Returned Period 2 Prio
 109  QuantityReturnedPeriod3PY . . 16.6  NNN  Quantity Returned Period 3 Prio
 110  QuantityReturnedPeriod4PY . . 16.6  NNN  Quantity Returned Period 4 Prio
 111  QuantityReturnedPeriod5PY . . 16.6  NNN  Quantity Returned Period 5 Prio
 112  QuantityReturnedPeriod6PY . . 16.6  NNN  Quantity Returned Period 6 Prio
 113  QuantityReturnedPeriod7PY . . 16.6  NNN  Quantity Returned Period 7 Prio
 114  QuantityReturnedPeriod8PY . . 16.6  NNN  Quantity Returned Period 8 Prio
 115  QuantityReturnedPeriod9PY . . 16.6  NNN  Quantity Returned Period 9 Prio
 116  QuantityReturnedPeriod10PY. . 16.6  NNN  Quantity Returned Period 10 Pri
 117  QuantityReturnedPeriod11PY. . 16.6  NNN  Quantity Returned Period 11 Pri
 118  QuantityReturnedPeriod12PY. . 16.6  NNN  Quantity Returned Period 12 Pri
 119  QuantityReturnedPeriod13PY. . 16.6  NNN  Quantity Returned Period 13 Pri
 120  GrossProfitAmountPeriod1. . . 15.2  NNN  Gross Profit Amount Period 1. .
 121  GrossProfitAmountPeriod2. . . 15.2  NNN  Gross Profit Amount Period 2. .
 122  GrossProfitAmountPeriod3. . . 15.2  NNN  Gross Profit Amount Period 3. .
 123  GrossProfitAmountPeriod4. . . 15.2  NNN  Gross Profit Amount Period 4. .
 124  GrossProfitAmountPeriod5. . . 15.2  NNN  Gross Profit Amount Period 5. .
 125  GrossProfitAmountPeriod6. . . 15.2  NNN  Gross Profit Amount Period 6. .
 126  GrossProfitAmountPeriod7. . . 15.2  NNN  Gross Profit Amount Period 7. .
 127  GrossProfitAmountPeriod8. . . 15.2  NNN  Gross Profit Amount Period 8. .
 128  GrossProfitAmountPeriod9. . . 15.2  NNN  Gross Profit Amount Period 9. .
 129  GrossProfitAmountPeriod10 . . 15.2  NNN  Gross Profit Amount Period 10 .
 130  GrossProfitAmountPeriod11 . . 15.2  NNN  Gross Profit Amount Period 11 .
 131  GrossProfitAmountPeriod12 . . 15.2  NNN  Gross Profit Amount Period 12 .
 132  GrossProfitAmountPeriod13 . . 15.2  NNN  Gross Profit Amount Period 13 .
 133  GrossProfitAmountPeriod1PY. . 15.2  NNN  Gross Profit Amount Period 1 Pr
 134  GrossProfitAmountPeriod2PY. . 15.2  NNN  Gross Profit Amount Period 2 Pr
 135  GrossProfitAmountPeriod3PY. . 15.2  NNN  Gross Profit Amount Period 3 Pr
 136  GrossProfitAmountPeriod4PY. . 15.2  NNN  Gross Profit Amount Period 4 Pr
 137  GrossProfitAmountPeriod5PY. . 15.2  NNN  Gross Profit Amount Period 5 Pr
 138  GrossProfitAmountPeriod6PY. . 15.2  NNN  Gross Profit Amount Period 6 Pr
 139  GrossProfitAmountPeriod7PY. . 15.2  NNN  Gross Profit Amount Period 7 Pr
 140  GrossProfitAmountPeriod8PY. . 15.2  NNN  Gross Profit Amount Period 8 Pr
 141  GrossProfitAmountPeriod9PY. . 15.2  NNN  Gross Profit Amount Period 9 Pr
 142  GrossProfitAmountPeriod10PY . 15.2  NNN  Gross Profit Amount Period 10 P
 143  GrossProfitAmountPeriod11PY . 15.2  NNN  Gross Profit Amount Period 11 P
 144  GrossProfitAmountPeriod12PY . 15.2  NNN  Gross Profit Amount Period 12 P
 145  GrossProfitAmountPeriod13PY . 15.2  NNN  Gross Profit Amount Period 13 P
 146  GrossProfitPercentPeriod1 . .  9.3  NNN  Gross Profit Percent Period 1 .
 147  GrossProfitPercentPeriod2 . .  9.3  NNN  Gross Profit Percent Period 2 .
 148  GrossProfitPercentPeriod3 . .  9.3  NNN  Gross Profit Percent Period 3 .
 149  GrossProfitPercentPeriod4 . .  9.3  NNN  Gross Profit Percent Period 4 .
 150  GrossProfitPercentPeriod5 . .  9.3  NNN  Gross Profit Percent Period 5 .
 151  GrossProfitPercentPeriod6 . .  9.3  NNN  Gross Profit Percent Period 6 .
 152  GrossProfitPercentPeriod7 . .  9.3  NNN  Gross Profit Percent Period 7 .
 153  GrossProfitPercentPeriod8 . .  9.3  NNN  Gross Profit Percent Period 8 .
 154  GrossProfitPercentPeriod9 . .  9.3  NNN  Gross Profit Percent Period 9 .
 155  GrossProfitPercentPeriod10. .  9.3  NNN  Gross Profit Percent Period 10.
 156  GrossProfitPercentPeriod11. .  9.3  NNN  Gross Profit Percent Period 11.
 157  GrossProfitPercentPeriod12. .  9.3  NNN  Gross Profit Percent Period 12.
 158  GrossProfitPercentPeriod13. .  9.3  NNN  Gross Profit Percent Period 13.
 159  GrossProfitPercentPeriod1PY .  9.3  NNN  Gross Profit Percent Period 1 P
 160  GrossProfitPercentPeriod2PY .  9.3  NNN  Gross Profit Percent Period 2 P
 161  GrossProfitPercentPeriod3PY .  9.3  NNN  Gross Profit Percent Period 3 P
 162  GrossProfitPercentPeriod4PY .  9.3  NNN  Gross Profit Percent Period 4 P
 163  GrossProfitPercentPeriod5PY .  9.3  NNN  Gross Profit Percent Period 5 P
 164  GrossProfitPercentPeriod6PY .  9.3  NNN  Gross Profit Percent Period 6 P
 165  GrossProfitPercentPeriod7PY .  9.3  NNN  Gross Profit Percent Period 7 P
 166  GrossProfitPercentPeriod8PY .  9.3  NNN  Gross Profit Percent Period 8 P
 167  GrossProfitPercentPeriod9PY .  9.3  NNN  Gross Profit Percent Period 9 P
 168  GrossProfitPercentPeriod10PY.  9.3  NNN  Gross Profit Percent Period 10
 169  GrossProfitPercentPeriod11PY.  9.3  NNN  Gross Profit Percent Period 11
 170  GrossProfitPercentPeriod12PY.  9.3  NNN  Gross Profit Percent Period 12
 171  GrossProfitPercentPeriod13PY.  9.3  NNN  Gross Profit Percent Period 13
 172  TotalQuantitySold . . . . . . 16.6  NNN  Total Quantity Sold . . . . . .
 173  TotalQuantitySoldPY . . . . . 16.6  NNN  Total Quantity Sold Prior Year.
 174  TotalDollarsSold. . . . . . . 15.2  NNN  Total Dollars Sold. . . . . . .
 175  TotalDollarsSoldPY. . . . . . 15.2  NNN  Total Dollars Sold Prior Year .
 176  TotalCostOfGoodsSold. . . . . 15.2  NNN  Total Cost Of Goods Sold. . . .
 177  TotalCostOfGoodsSoldPY. . . . 15.2  NNN  Total Cost Of Goods Sold Prior
 178  TotalQuantityReturned . . . . 16.6  NNN  Total Quantity Returned . . . .
 179  TotalQuantityReturnedPY . . . 16.6  NNN  Total Quantity Returned Prior Y
 180  TotalGrossProfitAmount. . . . 15.2  NNN  Total Gross Profit Amount . . .
 181  TotalGrossProfitAmountPY. . . 15.2  NNN  Total Gross Profit Amount Prior
 182  TotalGrossProfitPercent . . .  9.3  NNN  Total Gross Profit Percent. . .
 183  TotalGrossProfitPercentPY . .  9.3  NNN  Total Gross Profit Percent Prio