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