IM_ProductLine                         IM Product Line                Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: IM_ProductLine_bus,BM_ProductionRegister_upd
 SQL Def: N  SysDB: N                                        "MAS_"+%C$+"/IM"+%C$+"/IM_ProductLine.M4T"

 KPRIMARY: ProductLine

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  ProductLine . . . . . . . . .     4 SYY  Product Line. . . . . . . . . .PRODUCTLINE
                                                FmtType:CHARNUM Notes:
                                                {IMA$(1,4)}
   2  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .
                                                Notes: {IMA$(5,25)}
   3  ProductType . . . . . . . . .     1 SYY  Product Type. . . . . . . . . .
                                                DfltVal:F Valid:F,R,D,K
                                                Notes: {IMA$(30,1)}F=Finish,
                                                R=Raw,D=Discountinued,K=Kit
   4  Valuation . . . . . . . . . .     1 SYY  Valuation . . . . . . . . . . .
                                                DfltVal:2 Valid:1,2,3,4,5,6
                                                Notes: {IMA$(31,1)}1=Standard
                                                ,2=Average,3=Fifo,4=Lifo,
                                                5=Lot,6=Serial
   5  PriceCode . . . . . . . . . .     4 SYN  Price Code. . . . . . . . . . .PRICECODE
                                                Notes: {IMA$(32,4)}
   6  AllowBackOrders . . . . . . .     1 SYY  Allow Back Orders . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {IMA$(36,1)}
   7  ExplodeKitItems . . . . . . .     1 SYY  Explode Kit Items . . . . . . .
                                                DfltVal:P Valid:A,N,P Notes:
                                                {IMA$(37,1)}A=Always,
                                                N=Never, P=Prompt
   8  CalculateCommission . . . . .     1 SYY  Calculate Commission. . . . . .
                                                DfltVal:N Valid:N,P,C,G,S
                                                Notes: {IMA$(39,1)}N=No,
                                                P=%Price,C=%Cost,G=%Gross
                                                Profit, S=Standard
   9  StandardUnitOfMeasure . . . .     4 SYY  Standard Unit Of Measure. . . .UNITOFMEASURE
                                                DfltVal:EACH DepVal:REQUIRED
                                                Notes: {IMA$(40,4)}
  10  PurchaseUnitOfMeasure . . . .     4 SYN  Purchase Unit Of Measure. . . .UNITOFMEASURE
                                                DfltVal:EACH DepVal:REQUIRED
                                                Notes: {IMA$(44,4)}
  11  SalesUnitOfMeasure. . . . . .     4 SYN  Sales Unit Of Measure . . . . .UNITOFMEASURE
                                                DfltVal:EACH DepVal:REQUIRED
                                                Notes: {IMA$(48,4)}
  12  ProcurementType . . . . . . .     1 SYY  Procurement Type. . . . . . . .
                                                DfltVal:B Valid:M,B,S Notes:
                                                {IMA$(52,1)} M=Make, B=Buy,
                                                S=Subcnt
  13  InventoryCycle. . . . . . . .     1 SNN  Inventory Cycle . . . . . . . .
                                                Notes: {IMA$(114,1)}
  14  AllowTradeDiscount. . . . . .     1 SYY  Allow Trade Discount. . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {IMA$(107,1)}
  15  AllocateLandedCost. . . . . .     1 SYY  Allocate Landed Cost. . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {IMA$(137,1)}
  16  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                DfltVal:NT DepVal:REQUIRED
                                                Notes: {IMA$(138,2)}
  17  PurchasesTaxClass . . . . . .     2 SYN  PurchasesTax Class. . . . . . .TAXCLASS
                                                DfltVal:NT DepVal:REQUIRED
  18  PrintReceiptLabels. . . . . .     1 SYY  Print Receipt Labels. . . . . .
                                                DfltVal:Y Valid:Y,N,I Notes:
                                                {IMA$(115,1)}Y=Yes, N=No,
                                                I=By Item
  19  ConfirmCostIncrInRcptOfGoods.     1 SYY  Confirm Cost Increase In ReceipYESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {IMA$(140,1)}
  20  PostInventoryByWhse . . . . .     1 SYY  Post Inventory By Warehouse . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:PostToGLByWhse
                                                Notes: {IMA$(108,1)}
  21  PostCostOfGoodsSoldByWhse . .     1 SYY  Post Cost Of Goods Sold By WareYESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:PostToGLByWhse
                                                Notes: {IMA$(109,1)}
  22  PostSalesIncomeByWhse . . . .     1 SYY  Post Sales/Income By Warehouse.YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:PostToGLByWhse
                                                Notes: {IMA$(110,1)}
  23  PostReturnsByWhse . . . . . .     1 SYY  Post Returns By Warehouse . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:PostToGLByWhse
                                                Notes: {IMA$(111,1)}
  24  PostAdjustmentByWhse. . . . .     1 SYY  Post Adjustment By Warehouse. .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:PostToGLByWhse
                                                Notes: {IMA$(112,1)}
  25  PostPurchaseByWhse. . . . . .     1 SYY  Post Purchases By Warehouse . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:PostToGLByWhse
                                                Notes: {IMA$(113,1)}
  26  PostPOVarianceByWhse. . . . .     1 SYY  Post Po Variance By Warehouse .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:PostToGLByWhse
                                                Notes: {IMA$(134,1)}
  27  PostMFGVarianceByWhse . . . .     1 SYY  Post Manufacturing Variance By YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:PostToGLByWhse
                                                Notes: {IMA$(135,1)}
  28  InventoryAcctKey. . . . . . .     9 SNN  Inventory Account Key . . . . .ACCOUNT
                                                Notes: {IMA$(53,9)}
  29  CostOfGoodsSoldAcctKey. . . .     9 SNN  Cost Of Goods Sold Account Key.ACCOUNT
                                                Notes: {IMA$(62,9)}
  30  SalesIncomeAcctKey. . . . . .     9 SNN  Sales Income Account Key. . . .ACCOUNT
                                                Notes: {IMA$(71,9)}
  31  ReturnsAcctKey. . . . . . . .     9 SNN  Returns Account Key . . . . . .ACCOUNT
                                                Notes: {IMA$(80,9)}
  32  AdjustmentAcctKey . . . . . .     9 SNN  Adjustment Account Key. . . . .ACCOUNT
                                                Notes: {IMA$(89,9)}
  33  PurchaseAcctKey . . . . . . .     9 SNN  Purchases Account Key . . . . .ACCOUNT
                                                Notes: {IMA$(98,9)}
  34  PurchaseOrderVarianceAcctKey.     9 SNN  Purchase Order Variance AccountACCOUNT
                                                Notes: {IMA$(116,9)}
  35  ManufacturingVarianceAcctKey.     9 SNN  Manufacturing Variance Account ACCOUNT
                                                Notes: {IMA$(125,9)}
  36  WarrantyCode. . . . . . . . .    10 SYN  Warranty Code . . . . . . . . .WARRANTYCODE
                                                Notes: {IMA$(141,10)}
  37  AllowReturns. . . . . . . . .     1 SYY  Allow Returns . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {IMA$(151,1)}
  38  RestockingMethod. . . . . . .     1 SYY  Restocking Method . . . . . . .
                                                DfltVal:N Valid:N,F,C,P
                                                Notes: {IMA$(152,1)} N=None,
                                                F=Fixed, C=%ItemCost,
                                                P=%ItemPrice
  39  ScrapAcctKey. . . . . . . . .     9 SNN  Scrap Account Key . . . . . . .ACCOUNT
                                                Notes: {IMA$(153,9)}
  40  RepairsInProcessAcctKey . . .     9 SNN  Repairs In Process Account Key.ACCOUNT
                                                Notes: {IMA$(162,9)}
  41  RepairsClearingAcctKey. . . .     9 SNN  Repairs Clearing Account Key. .ACCOUNT
                                                Notes: {IMA$(173,9)}
  42  PostScrapByWhse . . . . . . .     1 SYY  Post Scrap by Warehouse . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:PostToGLByWhse,
                                                RMAByWhse Notes: {IMA$(171,
                                                1)}
  43  PostRepairsInProcessByWhse. .     1 SYY  Post Repairs In Process by WareYESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:PostToGLByWhse,
                                                RMAByWhse Notes: {IMA$(172,
                                                1)}
  44  PostRepairsClearingByWhse . .     1 SYY  Post Repairs Clearing by WarehoYESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:PostToGLByWhse,
                                                RMAByWhse Notes: {IMA$(182,
                                                1)}
  45  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .COMMISSIONRATE
                                                Mask:###0.000% Notes:
                                                {IMA[0]}
  46  BaseCommAmt . . . . . . . . . 12.2  NNN  Base Commission Amount. . . . .MISCAMOUNT
                                                Mask:##,###,###.00- Notes:
                                                {IMA[1]}
  47  PurchaseUMConvFctr. . . . . . 12.4  NNN  Purchase Unit Of Measure ConverUMCONVFACTOR
                                                DfltVal:1 Mask:#####0.0000
                                                Notes: {IMA[2]}
  48  SalesUMConvFctr . . . . . . . 12.4  NNN  Sales Unit Of Measure ConversioUMCONVFACTOR
                                                DfltVal:1 Mask:#####0.0000
                                                Notes: {IMA[3]}
  49  RestockingCharge. . . . . . . 11.3  NNN  Restocking Charge . . . . . . .
                                                Mask:#####0.000 Notes:
                                                {IMA[4]}
  50  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  51  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                Read Only:Y
  52  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                Read Only:Y Mask:0000000000
  53  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  54  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                Read Only:Y
  55  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL