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. . . .