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 .