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