How to get Conversion Ratio information from UnitOfMeasureSetRelatedUnit Table in QODBC

Conversion ratio information is stored in a table called UnitOfMeasureSetRelatedUnit.

Problem:

How to get Conversion Ratio information from UnitOfMeasureSetRelatedUnit Table in QODBC.

Solution:

We can get conversion ratio information by using INNER JOIN on SalesOrderLine Table.

We can get conversion ratio information by comparing UnitOfMeasureSetRelatedUnit.ListID and SalesOrderLine.ListID

Please refer below-mentioned query for conversion ratio information:

Select S.RefNumber, S.TxnDate, S.SalesOrderLineItemRefFullName, S.SalesOrderLineQuantity,
S.SalesOrderLineRate, U.UnitOfMeasureType, U.Name, U.BaseUnitName, U.RelatedUnitName,
U.RelatedUnitConversionRatio From UnitOfMeasureSetRelatedUnit U
INNER JOIN SalesOrderLine S ON S.SalesOrderLineOVerrideUOMSetRefListID = U.ListID