MAS 90/200 Extended Product Description

I thought I would post a quick note on how to find the extended description of an item in the MAS 90/200 database structure.  I frequently forget which tables are needed in order to get the extended description.

The MAS extended description of a product as shown below

MAS Extended Description

The following tables are needed to retrieve the extended description:

  • IM1_InventoryMasterFile
  • CI_Item
  • CI_ExtendedDescription

The tables are joined in the following fashion:

  • IM1_InventoryMasterFile.ItemNumber -> CI_Item.ItemCode ->
  • CI_Item.ExtendedDescriptionKey -> CI_ExtendedDescription.ExtendedDescriptionKey

The field that holds the extended description is CI_ExtendedDescription.ExtendedDescriptionText.


Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

1 Comment

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!