Units

[Former Member]

Weight, Volume, and Size units return a Long Integer

how do we convert that integer back to its value?

or is there a list of what the long stands for somewhere?

are those numbers static?

[former_member183864]

The information you're looking for is in the OWGT and OLGT tables.  Best way to get at this information is to open the window where users can maintain this information (Administration > Definitions > Inventory > Define Length and Width UoM), turn on "Display Debug Information" (under Tools > User Tools). Then hover the mouse over the field you're interested in. This will show you the table name & field name in the lower left corner of the screen (last 2 pieces of information in the bottom line of text).

To get Units of Length/Width or Weight, make a SELECT statement from the OWGT and OLGT tables, respectively.  Example: the following query returns the Purchasing Weight of Item A00001:

SELECT T1.ItemCode, T1.BWeight1, T2.UnitDisply, (T1.BWeight1 * T2.WightInMG) as ItemWeightInMG

FROM OITM T1, OWGT T2

WHERE T1.BWght1Unit = T2.UnitCode

AND ItemCode = 'A00001'