IM_ItemListingWithSalesHistWrk IM Item Listing With Sales History Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_ItemListingWithSalesHist_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_ItemListingWithSalesHistWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN SortField . . . . . . . . . . . 2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . . 3 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 4 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 5 CalculateCommission . . . . . 1 SNN Calculate Commission. . . . . . 6 EBMEnabled. . . . . . . . . . 1 SNN e-Business Manager Enabled. . . 7 AllowReturns. . . . . . . . . 1 SNN Allow Returns . . . . . . . . . 8 PriceCode . . . . . . . . . . 4 SNN Price Code. . . . . . . . . . . 9 PriceCodeDesc . . . . . . . . 25 SNN Price Code Description. . . . . 10 AllowTradeDiscount. . . . . . 1 SNN Allow Trade Discount. . . . . . 11 PrintReceiptLabels. . . . . . 1 SNN Print Receipt Labels. . . . . . 12 AllocateLandedCost. . . . . . 1 SNN Allocate Landed Cost. . . . . . 13 ConfirmCostIncrInRcptOfGoods. 1 SNN Confirm Cost Increase in Receip 14 WarrantyCode. . . . . . . . . 10 SNN Warranty Code . . . . . . . . . 15 WarrantyCodeDesc. . . . . . . 30 SNN Warranty Code Description . . . 16 SalesUnitOfMeasure. . . . . . 4 SNN Sales Unit of Measure . . . . . 17 PurchaseUnitOfMeasure . . . . 4 SNN Purchase Unit of Measure. . . . 18 StandardUnitOfMeasure . . . . 4 SNN Standard Unit of Measure. . . . 19 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 20 TaxClassDesc. . . . . . . . . 30 SNN Tax Class Description . . . . . 21 PurchasesTaxClass . . . . . . 2 SNN Purchases Tax Class . . . . . . 22 PurchasesTaxClassDesc . . . . 30 SNN Purchases Tax Class Description 23 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 24 ProductLineDesc . . . . . . . 25 SNN Product Line Description. . . . 25 ProductType . . . . . . . . . 1 SNN Product Type. . . . . . . . . . 26 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . . 27 DefaultWarehouseCode. . . . . 3 SNN Default Warehouse Code. . . . . 28 DefaultWarehouseDesc. . . . . 30 SNN Default Warehouse Description . 29 PrimaryAPDivisionNo . . . . . 2 SNN Primary AP Division Number. . . 30 PrimaryVendorNo . . . . . . . 7 SNN Primary Vendor Number . . . . . 31 PrimaryVendorName . . . . . . 30 SNN Primary Vendor Name . . . . . . 32 ImageFile . . . . . . . . . . 30 SNN Image File. . . . . . . . . . . 33 Category1Desc . . . . . . . . 15 SNN Category1Desc . . . . . . . . . 34 Category1 . . . . . . . . . . 10 SNN Category 1. . . . . . . . . . . 35 Category2Desc . . . . . . . . 15 SNN Category2Desc . . . . . . . . . 36 Category2 . . . . . . . . . . 10 SNN Category 2. . . . . . . . . . . 37 Category3Desc . . . . . . . . 15 SNN Category3Desc . . . . . . . . . 38 Category3 . . . . . . . . . . 10 SNN Category 3. . . . . . . . . . . 39 Category4Desc . . . . . . . . 15 SNN Category4Desc . . . . . . . . . 40 Category4 . . . . . . . . . . 10 SNN Category 4. . . . . . . . . . . 41 ExplodeKitItems . . . . . . . 1 SNN Explode Kit Items . . . . . . . 42 ShipWeight. . . . . . . . . . 10 SNN Ship Weight . . . . . . . . . . 43 AllowBackOrders . . . . . . . 1 SNN Allow Back Orders . . . . . . . 44 RestockingMethod. . . . . . . 1 SNN Restocking Method . . . . . . . 45 NextLotSerialNo . . . . . . . 15 SNN Next Lot/Serial Number. . . . . 46 InventoryCycle. . . . . . . . 1 SNN Inventory Cycle . . . . . . . . 47 RoutingNo . . . . . . . . . . 20 SNN Routing Number. . . . . . . . . 48 ProcurementType . . . . . . . 1 SNN Procurement Type. . . . . . . . 49 PlannerCode . . . . . . . . . 3 SNN Planner Code. . . . . . . . . . 50 PlannerLastName . . . . . . . 15 SNN Planner Last Name . . . . . . . 51 PlannerFirstName. . . . . . . 15 SNN Planner First Name. . . . . . . 52 BuyerCode . . . . . . . . . . 3 SNN Buyer Code. . . . . . . . . . . 53 BuyerLastName . . . . . . . . 15 SNN Buyer Last Name . . . . . . . . 54 BuyerFirstName. . . . . . . . 15 SNN Buyer First Name. . . . . . . . 55 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 56 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . . 57 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . . 58 BaseCommAmt . . . . . . . . . 12.2 NNN Base Commission Amount. . . . . 59 PurchaseUMConvFctr. . . . . . 12.4 NNN Purchase Unit of Measure Conver 60 SalesUMConvFctr . . . . . . . 12.4 NNN Sales Unit of Measure Conversio 61 Volume. . . . . . . . . . . . 11.4 NNN Volume. . . . . . . . . . . . . 62 RestockingCharge. . . . . . . 11.3 NNN Restocking Charge . . . . . . . 63 QuantityOnHand. . . . . . . . 16.6 NNN Quantity On Hand. . . . . . . . 64 QuantityOnPurchaseOrder . . . 16.6 NNN Quantity On Purchase Order. . . 65 QuantityOnSalesOrder. . . . . 16.6 NNN Quantity On Sales Order . . . . 66 QuantityOnBackOrder . . . . . 16.6 NNN Quantity On Back Order. . . . . 67 AverageCost . . . . . . . . . 16.6 NNN Average Cost. . . . . . . . . . 68 QuantityOnWorkOrder . . . . . 16.6 NNN Quantity On Work Order. . . . . 69 QuantityRequiredForWO . . . . 16.6 NNN Quantity Required For Work Orde 70 QuantityInShipping. . . . . . 16.6 NNN Quantity In Shipping. . . . . . 71 BeginningBalQty . . . . . . . 16.6 NNN Beginning Balance Quantity. . . 72 BeginningBalDollarAmt . . . . 15.2 NNN Beginning Balance Dollar Amount 73 QuantitySold. . . . . . . . . 16.6 NNN Quantity Sold . . . . . . . . . 74 QuantitySoldYTD . . . . . . . 16.6 NNN Quantity Sold Year To Date. . . 75 QuantitySoldPY. . . . . . . . 16.6 NNN Quantity Sold Prior Year. . . . 76 DollarsSoldPTD. . . . . . . . 15.2 NNN Dollars Sold Period To Date . . 77 DollarsSoldYTD. . . . . . . . 15.2 NNN Dollars Sold Year To Date . . . 78 DollarsSoldPY . . . . . . . . 15.2 NNN Dollars Sold Prior Year . . . . 79 CostOfGoodsSoldPTD. . . . . . 15.2 NNN Cost Of Goods Sold Period To Da 80 CostOfGoodsSoldYTD. . . . . . 16.2 NNN Cost Of Goods Sold Year To Date 81 CostOfGoodsSoldPY . . . . . . 16.2 NNN Cost Of Goods Sold Prior Year . 82 QuantityReturnedCustomer. . . 16.6 NNN Quantity Returned Customer. . . 83 QuantityReturnedCustomerYTD . 16.6 NNN Quantity Returned Customer Year 84 QuantityReturnedCustomerPY. . 16.6 NNN Quantity Returned Customer Prio 85 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . . 86 QuantityIssued. . . . . . . . 16.6 NNN Quantity Issued . . . . . . . . 87 QuantityIssuedYTD . . . . . . 16.6 NNN Quantity Issued Year To Date. . 88 QuantityIssuedPY. . . . . . . 16.6 NNN Quantity Issued Prior Year. . . 89 QuantityAdjusted. . . . . . . 16.6 NNN Quantity Adjusted . . . . . . . 90 QuantityTransferred . . . . . 16.6 NNN Quantity Transferred. . . . . . 91 QuantitySoldAsKits. . . . . . 16.6 NNN Quantity Sold As Kits . . . . . 92 EndingQuantity. . . . . . . . 16.6 NNN Ending Quantity . . . . . . . . 93 QuantityProduced. . . . . . . 16.6 NNN Quantity Produced . . . . . . . 94 QuantityReturnedVendor. . . . 16.6 NNN Quantity Returned Vendor. . . .