     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