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
The following tables are needed to retrieve the extended description:
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.