Skip to Content
author's profile photo Former Member
Former Member

Units

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 29, 2003 at 07:48 PM

    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'

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.