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