IM_ProductLineListingWrk              IM Product Line Listing Work    Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: IM_ProductLineListing_rpt
 SQL Def: Y  SysDB: N                       "MAS_"+%C$+"/IM"+%C$+"/IM_ProductLineListingWrk"+%S$+".M4T"

 KPRIMARY: ProductLine

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
   2  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .
   3  ProductType . . . . . . . . .     1 SNN  Product Type. . . . . . . . . .
   4  Valuation . . . . . . . . . .     1 SNN  Valuation . . . . . . . . . . .
   5  PriceCode . . . . . . . . . .     4 SNN  Price Code. . . . . . . . . . .
   6  PriceCodeDesc . . . . . . . .    25 SNN  Price Code Description. . . . .
   7  AllowBackOrders . . . . . . .     1 SNN  Allow Back Orders . . . . . . .
   8  ExplodeKitItems . . . . . . .     1 SNN  Explode Kit Items . . . . . . .
   9  CalculateCommission . . . . .     1 SNN  Calculate Commission. . . . . .
  10  StandardUnitOfMeasure . . . .     4 SNN  Standard Unit Of Measure. . . .
  11  PurchaseUnitOfMeasure . . . .     4 SNN  Purchase Unit Of Measure. . . .
  12  SalesUnitOfMeasure. . . . . .     4 SNN  Sales Unit Of Measure . . . . .
  13  ProcurementType . . . . . . .     1 SNN  Procurement Type. . . . . . . .
  14  InventoryCycle. . . . . . . .     1 SNN  Inventory Cycle . . . . . . . .
  15  AllowTradeDiscount. . . . . .     1 SNN  Allow Trade Discount. . . . . .
  16  AllocateLandedCost. . . . . .     1 SNN  Allocate Landed Cost. . . . . .
  17  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .
  18  TaxClassDesc. . . . . . . . .    30 SNN  Tax Class Description . . . . .
  19  PurchasesTaxClass . . . . . .     2 SNN  Purchases Tax Class . . . . . .
  20  PurchasesTaxClassDesc . . . .    30 SNN  Purchases Tax Class Description
  21  PrintReceiptLabels. . . . . .     1 SNN  Print Receipt Labels. . . . . .
  22  ConfirmCostIncrInRcptOfGoods.     1 SNN  Confirm Cost Increase In Receip
  23  PostInventoryByWhse . . . . .     1 SNN  Post Inventory By Warehouse . .
  24  PostCostOfGoodsSoldByWhse . .     1 SNN  Post Cost Of Goods Sold By Ware
  25  PostSalesIncomeByWhse . . . .     1 SNN  Post Sales Income By Warehouse.
  26  PostReturnsByWhse . . . . . .     1 SNN  Post Returns By Warehouse . . .
  27  PostAdjustmentByWhse. . . . .     1 SNN  Post Adjustment By Warehouse. .
  28  PostPurchaseByWhse. . . . . .     1 SNN  Post Purchase By Warehouse. . .
  29  PostPOVarianceByWhse. . . . .     1 SNN  Post Po Variance By Warehouse .
  30  PostMFGVarianceByWhse . . . .     1 SNN  Post Manufacturing Variance By
  31  InventoryAcctKey. . . . . . .     9 SNN  Inventory Account Key . . . . .
  32  InventoryAccount. . . . . . .    41 SNN  Fully Formatted Inventory Accou
  33  InventoryAccountDesc. . . . .    50 SNN  Inventory Account Description .
  34  CostOfGoodsSoldAcctKey. . . .     9 SNN  Cost Of Goods Sold Account Key.
  35  CostOfGoodsSoldAccount. . . .    41 SNN  Fully Formatted Cost Of Goods S
  36  CostOfGoodsSoldAccountDesc. .    50 SNN  Cost Of Goods Sold Account Desc
  37  SalesIncomeAcctKey. . . . . .     9 SNN  Sales Income Account Key. . . .
  38  SalesIncomeAccount. . . . . .    41 SNN  Fully Formatted Sales Income Ac
  39  SalesIncomeAccountDesc. . . .    50 SNN  Sales Income Account Number . .
  40  ReturnsAcctKey. . . . . . . .     9 SNN  Returns Account Key . . . . . .
  41  ReturnsAccount. . . . . . . .    41 SNN  Fully Formatted Returns Account
  42  ReturnsAccountDesc. . . . . .    50 SNN  Returns Account Number. . . . .
  43  AdjustmentAcctKey . . . . . .     9 SNN  Adjustment Account Key. . . . .
  44  AdjustmentAccount . . . . . .    41 SNN  Fully Formatted Adjustment Acco
  45  AdjustmentAccountDesc . . . .    50 SNN  Adjustment Account Number . . .
  46  PurchaseAcctKey . . . . . . .     9 SNN  Purchase Account Key. . . . . .
  47  PurchaseAccount . . . . . . .    41 SNN  Fully Formatted Purchase Accoun
  48  PurchaseAccountDesc . . . . .    50 SNN  Purchase Account Number . . . .
  49  PurchaseOrderVarianceAcctKey.     9 SNN  Purchase Order Variance Account
  50  PurchaseOrderVarianceAccount.    41 SNN  Fully Formatted Purchase Order
  51  PurchaseOrderVarianceAcctDesc    50 SNN  Purchase Order Variance Account
  52  ManufacturingVarianceAcctKey.     9 SNN  Manufacturing Variance Account
  53  ManufacturingVarianceAccount.    41 SNN  Fully Formatted Manufacturing V
  54  ManufacturingVarianceAcctDesc    50 SNN  Manufacturing Variance Account
  55  WarrantyCode. . . . . . . . .    10 SNN  Warranty Code . . . . . . . . .
  56  WarrantyCodeDesc. . . . . . .    30 SNN  Warranty Code Description . . .
  57  AllowReturns. . . . . . . . .     1 SNN  Allow Returns . . . . . . . . .
  58  RestockingMethod. . . . . . .     1 SNN  Restocking Method . . . . . . .
  59  ScrapAcctKey. . . . . . . . .     9 SNN  Scrap Account Key . . . . . . .
  60  ScrapAccount. . . . . . . . .    41 SNN  Fully Formatted Scrap Account N
  61  ScrapAccountDesc. . . . . . .    50 SNN  Scrap Account Description . . .
  62  RepairsInProcessAcctKey . . .     9 SNN  Repairs In Process Account Key.
  63  RepairsInProcessAccount . . .    41 SNN  Fully Formatted Repairs In Proc
  64  RepairsInProcessAccountDesc .    50 SNN  Repairs In Process Account Desc
  65  RepairsClearingAcctKey. . . .     9 SNN  Repairs Clearing Account Key. .
  66  RepairsClearingAccount. . . .    41 SNN  Fully Formatted Repairs Clearin
  67  RepairsClearingAccountDesc. .    50 SNN  Repairs Clearing Account Descri
  68  PostScrapByWhse . . . . . . .     1 SNN  Post Scrap By Warehouse . . . .
  69  PostRepairsInProcessByWhse. .     1 SNN  Post Repairs In Process By Ware
  70  PostRepairsClearingByWhse . .     1 SNN  Post Repairs Clearing By Wareho
  71  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .
  72  BaseCommAmt . . . . . . . . . 12.2  NNN  Base Commission Amount. . . . .
  73  PurchaseUMConvFctr. . . . . . 12.4  NNN  Purchase Unit Of Measure Conver
  74  SalesUMConvFctr . . . . . . . 12.4  NNN  Sales Unit Of Measure Conversio
  75  RestockingCharge. . . . . . . 11.3  NNN  Restocking Charge . . . . . . .