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