SAMC Technologies staff feel it's important to share our experiences with others as part of our open communication approach.  Please feel free to send us any comments you have regarding our blogs. 

Here is useful query to find all of the metadata in the GP system for a given item number.
Item number '12345' should be replaced with your item number. The single quotes should be present.

SELECT *
FROM IV00101
WHERE ITEMNMBR = '12345'

With this table we can get some good reporting data and start it spinning. An excelent and quick eaxmple would be as SSRS report that queries item categories by input parameter...

SELECT *
FROM IV00101
WHERE USCATVLS_1 = @param

There are 6 USCATVLS_# fileds.
They correspond directly to the item category field in Item>>Cards in GP.