     IM_ItemListingWithSalesHistWrk     IM Item Listing With Sales History Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: IM_ItemListingWithSalesHist_rpt
     SQL Def: Y  SysDB: N                 "MAS_"+%C$+"/IM"+%C$+"/IM_ItemListingWithSalesHistWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  SortField . . . . . . . . . . .
       2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
       3  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
       4  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
       5  CalculateCommission . . . . .     1 SNN  Calculate Commission. . . . . .
       6  EBMEnabled. . . . . . . . . .     1 SNN  e-Business Manager Enabled. . .
       7  AllowReturns. . . . . . . . .     1 SNN  Allow Returns . . . . . . . . .
       8  PriceCode . . . . . . . . . .     4 SNN  Price Code. . . . . . . . . . .
       9  PriceCodeDesc . . . . . . . .    25 SNN  Price Code Description. . . . .
      10  AllowTradeDiscount. . . . . .     1 SNN  Allow Trade Discount. . . . . .
      11  PrintReceiptLabels. . . . . .     1 SNN  Print Receipt Labels. . . . . .
      12  AllocateLandedCost. . . . . .     1 SNN  Allocate Landed Cost. . . . . .
      13  ConfirmCostIncrInRcptOfGoods.     1 SNN  Confirm Cost Increase in Receip
      14  WarrantyCode. . . . . . . . .    10 SNN  Warranty Code . . . . . . . . .
      15  WarrantyCodeDesc. . . . . . .    30 SNN  Warranty Code Description . . .
      16  SalesUnitOfMeasure. . . . . .     4 SNN  Sales Unit of Measure . . . . .
      17  PurchaseUnitOfMeasure . . . .     4 SNN  Purchase Unit of Measure. . . .
      18  StandardUnitOfMeasure . . . .     4 SNN  Standard Unit of Measure. . . .
      19  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .
      20  TaxClassDesc. . . . . . . . .    30 SNN  Tax Class Description . . . . .
      21  PurchasesTaxClass . . . . . .     2 SNN  Purchases Tax Class . . . . . .
      22  PurchasesTaxClassDesc . . . .    30 SNN  Purchases Tax Class Description
      23  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
      24  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .
      25  ProductType . . . . . . . . .     1 SNN  Product Type. . . . . . . . . .
      26  Valuation . . . . . . . . . .     1 SNN  Valuation . . . . . . . . . . .
      27  DefaultWarehouseCode. . . . .     3 SNN  Default Warehouse Code. . . . .
      28  DefaultWarehouseDesc. . . . .    30 SNN  Default Warehouse Description .
      29  PrimaryAPDivisionNo . . . . .     2 SNN  Primary AP Division Number. . .
      30  PrimaryVendorNo . . . . . . .     7 SNN  Primary Vendor Number . . . . .
      31  PrimaryVendorName . . . . . .    30 SNN  Primary Vendor Name . . . . . .
      32  ImageFile . . . . . . . . . .    30 SNN  Image File. . . . . . . . . . .
      33  Category1Desc . . . . . . . .    15 SNN  Category1Desc . . . . . . . . .
      34  Category1 . . . . . . . . . .    10 SNN  Category 1. . . . . . . . . . .
      35  Category2Desc . . . . . . . .    15 SNN  Category2Desc . . . . . . . . .
      36  Category2 . . . . . . . . . .    10 SNN  Category 2. . . . . . . . . . .
      37  Category3Desc . . . . . . . .    15 SNN  Category3Desc . . . . . . . . .
      38  Category3 . . . . . . . . . .    10 SNN  Category 3. . . . . . . . . . .
      39  Category4Desc . . . . . . . .    15 SNN  Category4Desc . . . . . . . . .
      40  Category4 . . . . . . . . . .    10 SNN  Category 4. . . . . . . . . . .
      41  ExplodeKitItems . . . . . . .     1 SNN  Explode Kit Items . . . . . . .
      42  ShipWeight. . . . . . . . . .    10 SNN  Ship Weight . . . . . . . . . .
      43  AllowBackOrders . . . . . . .     1 SNN  Allow Back Orders . . . . . . .
      44  RestockingMethod. . . . . . .     1 SNN  Restocking Method . . . . . . .
      45  NextLotSerialNo . . . . . . .    15 SNN  Next Lot/Serial Number. . . . .
      46  InventoryCycle. . . . . . . .     1 SNN  Inventory Cycle . . . . . . . .
      47  RoutingNo . . . . . . . . . .    20 SNN  Routing Number. . . . . . . . .
      48  ProcurementType . . . . . . .     1 SNN  Procurement Type. . . . . . . .
      49  PlannerCode . . . . . . . . .     3 SNN  Planner Code. . . . . . . . . .
      50  PlannerLastName . . . . . . .    15 SNN  Planner Last Name . . . . . . .
      51  PlannerFirstName. . . . . . .    15 SNN  Planner First Name. . . . . . .
      52  BuyerCode . . . . . . . . . .     3 SNN  Buyer Code. . . . . . . . . . .
      53  BuyerLastName . . . . . . . .    15 SNN  Buyer Last Name . . . . . . . .
      54  BuyerFirstName. . . . . . . .    15 SNN  Buyer First Name. . . . . . . .
      55  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .
      56  WarehouseDesc . . . . . . . .    30 SNN  Warehouse Description . . . . .
      57  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .
      58  BaseCommAmt . . . . . . . . . 12.2  NNN  Base Commission Amount. . . . .
      59  PurchaseUMConvFctr. . . . . . 12.4  NNN  Purchase Unit of Measure Conver
      60  SalesUMConvFctr . . . . . . . 12.4  NNN  Sales Unit of Measure Conversio
      61  Volume. . . . . . . . . . . . 11.4  NNN  Volume. . . . . . . . . . . . .
      62  RestockingCharge. . . . . . . 11.3  NNN  Restocking Charge . . . . . . .
      63  QuantityOnHand. . . . . . . . 16.6  NNN  Quantity On Hand. . . . . . . .
      64  QuantityOnPurchaseOrder . . . 16.6  NNN  Quantity On Purchase Order. . .
      65  QuantityOnSalesOrder. . . . . 16.6  NNN  Quantity On Sales Order . . . .
      66  QuantityOnBackOrder . . . . . 16.6  NNN  Quantity On Back Order. . . . .
      67  AverageCost . . . . . . . . . 16.6  NNN  Average Cost. . . . . . . . . .
      68  QuantityOnWorkOrder . . . . . 16.6  NNN  Quantity On Work Order. . . . .
      69  QuantityRequiredForWO . . . . 16.6  NNN  Quantity Required For Work Orde
      70  QuantityInShipping. . . . . . 16.6  NNN  Quantity In Shipping. . . . . .
      71  BeginningBalQty . . . . . . . 16.6  NNN  Beginning Balance Quantity. . .
      72  BeginningBalDollarAmt . . . . 15.2  NNN  Beginning Balance Dollar Amount
      73  QuantitySold. . . . . . . . . 16.6  NNN  Quantity Sold . . . . . . . . .
      74  QuantitySoldYTD . . . . . . . 16.6  NNN  Quantity Sold Year To Date. . .
      75  QuantitySoldPY. . . . . . . . 16.6  NNN  Quantity Sold Prior Year. . . .
      76  DollarsSoldPTD. . . . . . . . 15.2  NNN  Dollars Sold Period To Date . .
      77  DollarsSoldYTD. . . . . . . . 15.2  NNN  Dollars Sold Year To Date . . .
      78  DollarsSoldPY . . . . . . . . 15.2  NNN  Dollars Sold Prior Year . . . .
      79  CostOfGoodsSoldPTD. . . . . . 15.2  NNN  Cost Of Goods Sold Period To Da
      80  CostOfGoodsSoldYTD. . . . . . 16.2  NNN  Cost Of Goods Sold Year To Date
      81  CostOfGoodsSoldPY . . . . . . 16.2  NNN  Cost Of Goods Sold Prior Year .
      82  QuantityReturnedCustomer. . . 16.6  NNN  Quantity Returned Customer. . .
      83  QuantityReturnedCustomerYTD . 16.6  NNN  Quantity Returned Customer Year
      84  QuantityReturnedCustomerPY. . 16.6  NNN  Quantity Returned Customer Prio
      85  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .
      86  QuantityIssued. . . . . . . . 16.6  NNN  Quantity Issued . . . . . . . .
      87  QuantityIssuedYTD . . . . . . 16.6  NNN  Quantity Issued Year To Date. .
      88  QuantityIssuedPY. . . . . . . 16.6  NNN  Quantity Issued Prior Year. . .
      89  QuantityAdjusted. . . . . . . 16.6  NNN  Quantity Adjusted . . . . . . .
      90  QuantityTransferred . . . . . 16.6  NNN  Quantity Transferred. . . . . .
      91  QuantitySoldAsKits. . . . . . 16.6  NNN  Quantity Sold As Kits . . . . .
      92  EndingQuantity. . . . . . . . 16.6  NNN  Ending Quantity . . . . . . . .
      93  QuantityProduced. . . . . . . 16.6  NNN  Quantity Produced . . . . . . .
      94  QuantityReturnedVendor. . . . 16.6  NNN  Quantity Returned Vendor. . . .