IM_ItemListingWrk IM Inventory Item Listing Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_ItemListing_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_ItemListingWrk"+%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 ReportSection . . . . . . . . 1 SNN Report Section. . . . . . . . . 4 SequenceNo. . . . . . . . . . 14 SNN Sequence Number . . . . . . . . 5 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 6 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 7 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . . 8 ExtendedDescriptionText . . . 4096 SNN Extended Description Text . . . 9 CalculateCommission . . . . . 1 SNN Calculate Commission. . . . . . 10 DropShip. . . . . . . . . . . 1 SNN Drop Ship . . . . . . . . . . . 11 EBMEnabled. . . . . . . . . . 1 SNN e-Business Manager Enabled. . . 12 AllowReturns. . . . . . . . . 1 SNN Allow Returns . . . . . . . . . 13 PriceCode . . . . . . . . . . 4 SNN Price Code. . . . . . . . . . .PRICECODE 14 PriceCodeDesc . . . . . . . . 25 SNN Price Code Description. . . . . 15 AllowTradeDiscount. . . . . . 1 SNN Allow Trade Discount. . . . . . 16 PrintReceiptLabels. . . . . . 1 SNN Print Receipt Labels. . . . . . 17 AllocateLandedCost. . . . . . 1 SNN Allocate Landed Cost. . . . . . 18 ConfirmCostIncrInRcptOfGoods. 1 SNN Confirm Cost Increase in Receip 19 WarrantyCode. . . . . . . . . 10 SNN Warranty Code . . . . . . . . . 20 WarrantyCodeDesc. . . . . . . 30 SNN Warranty Code Description . . . 21 SalesUnitOfMeasure. . . . . . 4 SNN Sales Unit of Measure . . . . . 22 PurchaseUnitOfMeasure . . . . 4 SNN Purchase Unit of Measure. . . . 23 StandardUnitOfMeasure . . . . 4 SNN Standard Unit of Measure. . . . 24 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 25 TaxClassDesc. . . . . . . . . 30 SNN Tax Class Description . . . . . 26 PurchasesTaxClass . . . . . . 2 SNN Purchases Tax Class . . . . . . 27 PurchasesTaxClassDesc . . . . 30 SNN Purchases Tax Class Description 28 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 29 ProductLineDesc . . . . . . . 25 SNN Product Line Description. . . . 30 ProductType . . . . . . . . . 1 SNN Product Type. . . . . . . . . . 31 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . . 32 DefaultWarehouseCode. . . . . 3 SNN Default Warehouse Code. . . . . 33 DefaultWarehouseDesc. . . . . 30 SNN Default Warehouse Description . 34 PrimaryAPDivisionNo . . . . . 2 SNN Primary AP Division Number. . . 35 PrimaryVendorNo . . . . . . . 7 SNN Primary Vendor Number . . . . . 36 PrimaryVendorName . . . . . . 30 SNN Primary Vendor Name . . . . . . 37 ImageFile . . . . . . . . . . 30 SNN Image File. . . . . . . . . . . 38 LastSoldDate. . . . . . . . . 8 SNN Last Sold Date. . . . . . . . .DATE 39 LastReceiptDate . . . . . . . 8 SNN Last Receipt Date . . . . . . .DATE 40 Category1Desc . . . . . . . . 15 SNN Category1Desc . . . . . . . . . 41 Category1 . . . . . . . . . . 10 SNN Category 1. . . . . . . . . . . 42 Category2Desc . . . . . . . . 15 SNN Category2Desc . . . . . . . . . 43 Category2 . . . . . . . . . . 10 SNN Category 2. . . . . . . . . . . 44 Category3Desc . . . . . . . . 15 SNN Category3Desc . . . . . . . . . 45 Category3 . . . . . . . . . . 10 SNN Category 3. . . . . . . . . . . 46 Category4Desc . . . . . . . . 15 SNN Category4Desc . . . . . . . . . 47 Category4 . . . . . . . . . . 10 SNN Category 4. . . . . . . . . . . 48 SalesPromotionCode. . . . . . 10 SNN Sales Promotion Code. . . . . . 49 SaleStartingDate. . . . . . . 8 SNN Sale Starting Date. . . . . . .DATE 50 SaleEndingDate. . . . . . . . 8 SNN Sale Ending Date. . . . . . . .DATE 51 SaleMethod. . . . . . . . . . 1 SNN Sale Method . . . . . . . . . . 52 ExplodeKitItems . . . . . . . 1 SNN Explode Kit Items . . . . . . . 53 ShipWeight. . . . . . . . . . 10 SNN Ship Weight . . . . . . . . . . 54 AllowBackOrders . . . . . . . 1 SNN Allow Back Orders . . . . . . . 55 RestockingMethod. . . . . . . 1 SNN Restocking Method . . . . . . . 56 NextLotSerialNo . . . . . . . 15 SNN Next Lot/Serial Number. . . . . 57 InventoryCycle. . . . . . . . 1 SNN Inventory Cycle . . . . . . . . 58 RoutingNo . . . . . . . . . . 20 SNN Routing Number. . . . . . . . . 59 ProcurementType . . . . . . . 1 SNN Procurement Type. . . . . . . . 60 PlannerCode . . . . . . . . . 3 SNN Planner Code. . . . . . . . . . 61 PlannerLastName . . . . . . . 15 SNN Planner Last Name . . . . . . . 62 PlannerFirstName. . . . . . . 15 SNN Planner First Name. . . . . . . 63 BuyerCode . . . . . . . . . . 3 SNN Buyer Code. . . . . . . . . . . 64 BuyerLastName . . . . . . . . 15 SNN Buyer Last Name . . . . . . . . 65 BuyerFirstName. . . . . . . . 15 SNN Buyer First Name. . . . . . . . 66 ThumbnailImage. . . . . . . . 30 SNN Thumbnail Image File Name . . . 67 AttachmentHREF1 . . . . . . . 128 SNN Attachment HREF 1 . . . . . . . 68 AttachmentHREF2 . . . . . . . 128 SNN Attachment HREF 2 . . . . . . . 69 AttachmentHREF3 . . . . . . . 128 SNN Attachment HREF 3 . . . . . . . 70 AttachmentHREF4 . . . . . . . 128 SNN Attachment HREF 4 . . . . . . . 71 AttachmentHREF5 . . . . . . . 128 SNN Attachment HREF 5 . . . . . . . 72 AttachmentHREF6 . . . . . . . 128 SNN Attachment HREF 6 . . . . . . . 73 AttachmentHREF7 . . . . . . . 128 SNN Attachment HREF 7 . . . . . . . 74 AttachmentHREF8 . . . . . . . 128 SNN Attachment HREF 8 . . . . . . . 75 AttachmentDesc1 . . . . . . . 128 SNN Attachment Description 1. . . . 76 AttachmentDesc2 . . . . . . . 128 SNN Attachment Description 2. . . . 77 AttachmentDesc3 . . . . . . . 128 SNN Attachment Description 3. . . . 78 AttachmentDesc4 . . . . . . . 128 SNN Attachment Description 4. . . . 79 AttachmentDesc5 . . . . . . . 128 SNN Attachment Description 5. . . . 80 AttachmentDesc6 . . . . . . . 128 SNN Attachment Description 6. . . . 81 AttachmentDesc7 . . . . . . . 128 SNN Attachment Description 7. . . . 82 AttachmentDesc8 . . . . . . . 128 SNN Attachment Description 8. . . . 83 CategoryCode. . . . . . . . . 10 SNN Category Code . . . . . . . . . 84 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 85 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . . 86 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . . 87 ReorderMethod . . . . . . . . 1 SNN Reorder Method. . . . . . . . . 88 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 89 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 90 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 91 VendorAliasItemNo . . . . . . 30 SNN Vendor Alias Item Number. . . . 92 VendorLastReceiptType . . . . 1 SNN Vendor Last Receipt Type. . . . 93 VendorLastReceiptNo . . . . . 6 SNN Vendor Last Receipt Number. . . 94 VendorLastReceiptDate . . . . 8 SNN Vendor Last Receipt Date. . . .DATE 95 VendorLastReturnDate. . . . . 8 SNN Vendor Last Return Date . . . .DATE 96 VendorLastReturnType. . . . . 1 SNN Vendor Last Return Type . . . . 97 VendorLastReturnNo. . . . . . 6 SNN Vendor Last Return Number . . . 98 VendorWarrantyCode. . . . . . 10 SNN Vendor Warranty Code. . . . . . 99 VendorWarrantyCodeDesc. . . . 30 SNN Vendor Warranty Code Descriptio 100 VendorLastUnitCost. . . . . . 16.6 NNN Vendor Last Unit Cost . . . . . 101 VendorLastAllocatedUnitCost . 16.6 NNN Vendor Last Allocated Unit Cost 102 PriceCodeRecord . . . . . . . 1 SNN Price Code Record . . . . . . . 103 CustomerPriceLevel. . . . . . 1 SNN Customer Price Level. . . . . . 104 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 105 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 106 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 107 PricingMethod . . . . . . . . 1 SNN Pricing Method. . . . . . . . . 108 AlternateItem . . . . . . . . 30 SNN Alternate Inventory Item Code . 109 AlternateItemDesc . . . . . . 30 SNN Alternate Inventory ItemCode De 110 AlternateItemPriority . . . . 14 SNN Alternate Item Priority . . . . 111 MemoCode. . . . . . . . . . . 10 SNN Memo Code . . . . . . . . . . . 112 MemoDesc. . . . . . . . . . . 30 SNN Memo Description. . . . . . . . 113 MemoDate. . . . . . . . . . . 8 SNN Memo Date . . . . . . . . . . .DATE 114 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE 115 ReminderStartDate . . . . . . 8 SNN Reminder Start Date . . . . . .DATE 116 ReminderEndDate . . . . . . . 8 SNN Reminder End Date . . . . . . .DATE 117 AutoDisplaySetting. . . . . . 1 SNN Auto Display Setting. . . . . . 118 MemoText. . . . . . . . . . . 7168 SNN Memo Text . . . . . . . . . . . 119 Attachment. . . . . . . . . . 128 SNN Attachment. . . . . . . . . . . 120 StandardUnitCost. . . . . . . 16.6 NNN Standard Unit Cost. . . . . . . 121 StandardUnitPrice . . . . . . 16.6 NNN Standard Unit Price . . . . . . 122 LastTotalUnitCost . . . . . . 16.6 NNN Last Total Unit Cost. . . . . . 123 AverageUnitCost . . . . . . . 16.6 NNN Average Unit Cost . . . . . . . 124 SalesPromotionPrice . . . . . 16.6 NNN Sales Promotion Price . . . . . 125 SuggestedRetailPrice. . . . . 16.6 NNN Suggested Retail Price. . . . . 126 SalesPromotionDiscountPercent 12.3 NNN Sales Promotion Discount Percen 127 LastAllocatedUnitCost . . . . 16.6 NNN Last Allocated Unit Cost. . . . 128 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . . 129 BaseCommAmt . . . . . . . . . 12.2 NNN Base Commission Amount. . . . . 130 PurchaseUMConvFctr. . . . . . 12.4 NNN Purchase Unit of Measure Conver 131 SalesUMConvFctr . . . . . . . 12.4 NNN Sales Unit of Measure Conversio 132 Volume. . . . . . . . . . . . 11.4 NNN Volumne . . . . . . . . . . . . 133 RestockingCharge. . . . . . . 11.3 NNN Restocking Charge . . . . . . . 134 EconomicOrderQty. . . . . . . 16.6 NNN Economic Order Quantity . . . . 135 ReorderPointQty . . . . . . . 16.6 NNN Reorder Point Quantity. . . . . 136 MinimumOrderQty . . . . . . . 16.6 NNN Minimum Order Quantity. . . . . 137 MaximumOnHandQty. . . . . . . 16.6 NNN Maximum On Hand Quantity. . . . 138 VendorLastReceiptQuantity . . 16.6 NNN Vendor Last Receipt Quantity. . 139 VendorStandardLeadTime. . . . 6.0 NNN Vendor Standard Lead Time . . . 140 VendorLastLeadTime. . . . . . 6.0 NNN Vendor Last Lead Time . . . . . 141 BreakQuantity1. . . . . . . . 8.0 NNN Break Quantity 1. . . . . . . . Mask:######## 142 BreakQuantity2. . . . . . . . 8.0 NNN Break Quantity 2. . . . . . . . Mask:######## 143 BreakQuantity3. . . . . . . . 8.0 NNN Break Quantity 3. . . . . . . . Mask:######## 144 BreakQuantity4. . . . . . . . 8.0 NNN Break Quantity 4. . . . . . . . Mask:######## 145 BreakQuantity5. . . . . . . . 8.0 NNN Break Quantity 5. . . . . . . . Mask:######## 146 DiscountMarkup1 . . . . . . . 16.6 NNN Discount Markup 1 . . . . . . . 147 DiscountMarkup2 . . . . . . . 16.6 NNN Discount Markup 2 . . . . . . . 148 DiscountMarkup3 . . . . . . . 16.6 NNN Discount Markup 3 . . . . . . . 149 DiscountMarkup4 . . . . . . . 16.6 NNN Discount Markup 4 . . . . . . . 150 DiscountMarkup5 . . . . . . . 16.6 NNN Discount Markup 5 . . . . . . .