IM_SalesAnalysisWrk IM Sales Analysis Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_SalesAnalysis_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_SalesAnalysisWrk"+%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 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 21 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . . 22 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . . 23 QuantitySoldPTD . . . . . . . 16.6 NNN Quantity Sold Period to Date. . 24 QuantitySoldYTD . . . . . . . 16.6 NNN Quantity Sold Year to Date. . . 25 QuantitySoldPY. . . . . . . . 16.6 NNN Quantity Sold Prior Year. . . . 26 QuantityReturnedPTD . . . . . 16.6 NNN Quantity Returned Period to Dat 27 QuantityReturnedYTD . . . . . 16.6 NNN Quantity Returned Year to Date. 28 QuantityReturnedPY. . . . . . 16.6 NNN Quantity Returned Prior Year. . 29 DollarsSoldPTD. . . . . . . . 16.6 NNN Dollars Sold Period to Date . . 30 DollarsSoldYTD. . . . . . . . 16.6 NNN Dollars Sold Year to Date . . . 31 DollarsSoldPY . . . . . . . . 16.6 NNN Dollars Sold Prior Year . . . . 32 CostOfGoodsSoldPTD. . . . . . 16.6 NNN Cost of Goods Sold Period to Da 33 CostOfGoodsSoldYTD. . . . . . 16.6 NNN Cost of Goods Sold Year to Date 34 CostOfGoodsSoldPY . . . . . . 16.6 NNN Cost of Goods Sold Prior Year .