IM_SalesHistoryWrk IM Sales History Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_SalesHistoryReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_SalesHistoryWrk"+%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 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 4 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 5 StandardUnitOfMeasure . . . . 4 SNN Standard Unit of Measure. . . . 6 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 7 ProductLineDesc . . . . . . . 25 SNN Product Line Description. . . . 8 ProductType . . . . . . . . . 1 SNN Product Type. . . . . . . . . . 9 PrimaryAPDivisionNo . . . . . 2 SNN Primary AP Division Number. . . 10 PrimaryVendorNo . . . . . . . 7 SNN Primary Vendor Number . . . . . 11 PrimaryVendorName . . . . . . 30 SNN Primary Vendor Name . . . . . . 12 Category1Desc . . . . . . . . 15 SNN Category 1 Description. . . . . 13 Category1 . . . . . . . . . . 10 SNN Category 1. . . . . . . . . . . 14 Category2Desc . . . . . . . . 15 SNN Category 2 Description. . . . . 15 Category2 . . . . . . . . . . 10 SNN Category 2. . . . . . . . . . . 16 Category3Desc . . . . . . . . 15 SNN Category 3 Description. . . . . 17 Category3 . . . . . . . . . . 10 SNN Category 3. . . . . . . . . . . 18 Category4Desc . . . . . . . . 15 SNN Category 4 Description. . . . . 19 Category4 . . . . . . . . . . 10 SNN Category 4. . . . . . . . . . . 20 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 21 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 22 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 23 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . . 24 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 25 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . . 26 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . . 27 FiscalCalYear . . . . . . . . 4 SNN Fiscal Calendar Year. . . . . . 28 QuantitySoldPer1. . . . . . . 16.6 NNN Quantity Sold Period 1. . . . . 29 QuantitySoldPer2. . . . . . . 16.6 NNN Quantity Sold Period 2. . . . . 30 QuantitySoldPer3. . . . . . . 16.6 NNN Quantity Sold Period 3. . . . . 31 QuantitySoldPer4. . . . . . . 16.6 NNN Quantity Sold Period 4. . . . . 32 QuantitySoldPer5. . . . . . . 16.6 NNN Quantity Sold Period 5. . . . . 33 QuantitySoldPer6. . . . . . . 16.6 NNN Quantity Sold Period 6. . . . . 34 QuantitySoldPer7. . . . . . . 16.6 NNN Quantity Sold Period 7. . . . . 35 QuantitySoldPer8. . . . . . . 16.6 NNN Quantity Sold Period 8. . . . . 36 QuantitySoldPer9. . . . . . . 16.6 NNN Quantity Sold Period 9. . . . . 37 QuantitySoldPer10 . . . . . . 16.6 NNN Quantity Sold Period 10 . . . . 38 QuantitySoldPer11 . . . . . . 16.6 NNN Quantity Sold Period 11 . . . . 39 QuantitySoldPer12 . . . . . . 16.6 NNN Quantity Sold Period 12 . . . . 40 QuantitySoldPer13 . . . . . . 16.6 NNN Quantity Sold Period 13 . . . . 41 DollarsSoldPer1 . . . . . . . 15.2 NNN Dollars Sold Period 1 . . . . . 42 DollarsSoldPer2 . . . . . . . 15.2 NNN Dollars Sold Period 2 . . . . . 43 DollarsSoldPer3 . . . . . . . 15.2 NNN Dollars Sold Period 3 . . . . . 44 DollarsSoldPer4 . . . . . . . 15.2 NNN Dollars Sold Period 4 . . . . . 45 DollarsSoldPer5 . . . . . . . 15.2 NNN Dollars Sold Period 5 . . . . . 46 DollarsSoldPer6 . . . . . . . 15.2 NNN Dollars Sold Period 6 . . . . . 47 DollarsSoldPer7 . . . . . . . 15.2 NNN Dollars Sold Period 7 . . . . . 48 DollarsSoldPer8 . . . . . . . 15.2 NNN Dollars Sold Period 8 . . . . . 49 DollarsSoldPer9 . . . . . . . 15.2 NNN Dollars Sold Period 9 . . . . . 50 DollarsSoldPer10. . . . . . . 15.2 NNN Dollars Sold Period 10. . . . . 51 DollarsSoldPer11. . . . . . . 15.2 NNN Dollars Sold Period 11. . . . . 52 DollarsSoldPer12. . . . . . . 15.2 NNN Dollars Sold Period 12. . . . . 53 DollarsSoldPer13. . . . . . . 15.2 NNN Dollars Sold Period 13. . . . . 54 CostOfGoodsSoldPer1 . . . . . 15.2 NNN Cost of Goods Sold Period 1 . . 55 CostOfGoodsSoldPer2 . . . . . 15.2 NNN Cost of Goods Sold Period 2 . . 56 CostOfGoodsSoldPer3 . . . . . 15.2 NNN Cost of Goods Sold Period 3 . . 57 CostOfGoodsSoldPer4 . . . . . 15.2 NNN Cost of Goods Sold Period 4 . . 58 CostOfGoodsSoldPer5 . . . . . 15.2 NNN Cost of Goods Sold Period 5 . . 59 CostOfGoodsSoldPer6 . . . . . 15.2 NNN Cost of Goods Sold Period 6 . . 60 CostOfGoodsSoldPer7 . . . . . 15.2 NNN Cost of Goods Sold Period 7 . . 61 CostOfGoodsSoldPer8 . . . . . 15.2 NNN Cost of Goods Sold Period 8 . . 62 CostOfGoodsSoldPer9 . . . . . 15.2 NNN Cost of Goods Sold Period 9 . . 63 CostOfGoodsSoldPer10. . . . . 15.2 NNN Cost of Goods Sold Period 10. . 64 CostOfGoodsSoldPer11. . . . . 15.2 NNN Cost of Goods Sold Period 11. . 65 CostOfGoodsSoldPer12. . . . . 15.2 NNN Cost of Goods Sold Period 12. . 66 CostOfGoodsSoldPer13. . . . . 15.2 NNN Cost of Goods Sold Period 13. . 67 QuantityReturnedPer1. . . . . 16.6 NNN Quantity Returned Period 1. . . 68 QuantityReturnedPer2. . . . . 16.6 NNN Quantity Returned Period 2. . . 69 QuantityReturnedPer3. . . . . 16.6 NNN Quantity Returned Period 3. . . 70 QuantityReturnedPer4. . . . . 16.6 NNN Quantity Returned Period 4. . . 71 QuantityReturnedPer5. . . . . 16.6 NNN Quantity Returned Period 5. . . 72 QuantityReturnedPer6. . . . . 16.6 NNN Quantity Returned Period 6. . . 73 QuantityReturnedPer7. . . . . 16.6 NNN Quantity Returned Period 7. . . 74 QuantityReturnedPer8. . . . . 16.6 NNN Quantity Returned Period 8. . . 75 QuantityReturnedPer9. . . . . 16.6 NNN Quantity Returned Period 9. . . 76 QuantityReturnedPer10 . . . . 16.6 NNN Quantity Returned Period 10 . . 77 QuantityReturnedPer11 . . . . 16.6 NNN Quantity Returned Period 11 . . 78 QuantityReturnedPer12 . . . . 16.6 NNN Quantity Returned Period 12 . . 79 QuantityReturnedPer13 . . . . 16.6 NNN Quantity Returned Period 13 . .