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 . . . . . . .