uom - Unit of Measure Conversion (Data Source)

The uom table is used for automatic conversion of the Quantity field between different units of measure (UOM) in Datamart.

This table contains only the common conversions for units which are the same for all the products, e.g. kg → lb, in → cm, etc.

If you need product specific conversions (e.g. 1 package of product X == 20 pieces), you can implement them, for example, via a data enrichment task (i.e. Calculation Data Load).

Fields

UomFrom – Symbol of the unit of measure from which we convert.

UomTo – Symbol of the unit of measure to which we convert.

UomConversionFactor – When converting quantity which is in the unit UomFrom to quantity in the unit UomTo, the quantity will be multiplied by this factor.

Data

Here are some rules for records in the uom Data Source table. You should always have records which will convert:

• From all UOMs found in Datamart rows into the the Base UOM of the Datamart in which you will use it.

• 1:1 for Datamart’s BaseUOM (e.g. EA → EA).