ICM Query-The Hierarchies of Inventory Tables in ManEx
Inventory tables in ManEx:
1.  Inventor - Table contains Part number, type, class, revision, etc information.  Unique identifier for each record is the value of the UNIQ_KEY

2.  Invtmfhd - Table contains MPN information.  Unique identifier of each record in the table is UNIQMFGRHD. Link to the Inventor table by UNIQ_KEY.

3.  InvtMfgr - Table contains WH/Location and quantities information for each MPN.  Unique identifier of each record W_KEY.  Link to the InvtMfhd using UNIQMFGHD.