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