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