Reference Data

Reference Data is a powerful tool designed to simplify and streamline the process of converting values between different units of measure. It provides a versatile function "convert_value" that allows users to perform precise and accurate unit conversions directly within SQL queries, eliminating the need for complex external tools or manual calculations. Whether you're dealing with metrics related to weight, length, volume, or any other unit, this function provides a seamless solution for data transformation, analytics, and reporting tasks.

Tables and Functions INCLUDED
- Unit of Measure with predefined more than 100 units
- Dimensions with predefined dimenions
- convert_value functions that converts units with the same numerators/denominators

The codbex_uoms table contains essential fields that define the units of measure and their conversion factors. Here's a brief description of the sample fields:

- UOM_ISO: The ISO code representing the unit of measure (e.g., 'GRM' for grams, 'KGM' for kilograms).
- UOM_DESCRIPTION: A descriptive label for the unit of measure.
- UOM_DIMENSION: The dimension or category to which the unit of measure belongs (e.g., weight, length, volume).
- UOM_NUMERATOR: The numerator of the conversion factor used for converting from the base unit to the specified unit.
- UOM_DENOMINATOR: The denominator of the conversion factor used for converting from the base unit to the specified unit.