Skip to Content
Former Member
Feb 06, 2015 at 11:46 PM

UoM database fields


Trying to extract UoM data from the item master and running into an issue locating the proper table for the dimension UoMs. The graphic shown is from the Purchasing Data tab of the item master. The fields--the Length field, for example--is actually concatenated from BLength1 and BLen1Unit out of the OITM table. BLen1Unit is a code (Foreign Key) from another table, but I cannot locate that table. It has not been documented properly in the database help file. And it is not located in the following tables: OUOM, ITM12, OUGP, UGP1.

Anybody happen to know this one?

Randy Davis