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