UnitOfMeasureConversion

-- ============================================================
-- Table  : UnitOfMeasureConversion Unit conversion rules — factor, numerator/denominator, and offsets for converting between two units, referenced by RecId to UnitOfMeasure on both sides; product-specific conversions carry the product's RecId, standard conversions leave it 0
-- Purpose: Column-selected read of UnitOfMeasureConversion — auto-generated from field metadata
-- Grain  : One row per recid (surrogate key)
-- Notes  : Auto-generated skeleton for Synapse Link / Fabric Link-landed F&O data (lowercase column names). Enums decoded inline where verified; datetimes stored in UTC; 1900-01-01 dates are sentinels mapped to NULL. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
  u.fromunitofmeasure AS "RecId of the unit being converted from — join to UnitOfMeasure to get the symbol",
  u.tounitofmeasure AS "RecId of the unit being converted to",
  u.product AS "RecId of the product this conversion is specific to; 0 (not NULL) means a standard conversion that applies to every product",
  u.factor AS "Multiplicative conversion factor from-unit to to-unit",
  u.numerator AS "Numerator of the conversion ratio when expressed as a fraction",
  u.denominator AS "Denominator of the conversion ratio when expressed as a fraction",
  u.inneroffset AS "Offset applied before the factor (needed for scales like temperature)",
  u.outeroffset AS "Offset applied after the factor",
  CASE u.rounding WHEN 0 THEN 'Nearest' WHEN 1 THEN 'Up' WHEN 2 THEN 'Down' ELSE CAST(u.rounding AS STRING) END AS "How converted quantities are rounded (nearest, up, or down)"  -- enum: UnitOfMeasureConversionRounding
FROM <catalog>.<schema>.unitofmeasureconversion u
-- Resolve UnitOfMeasure (via FromUnitOfMeasure): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.unitofmeasure fromunitofmeasure ON fromunitofmeasure.recid = u.fromunitofmeasure
-- Resolve UnitOfMeasure (via ToUnitOfMeasure): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.unitofmeasure tounitofmeasure ON tounitofmeasure.recid = u.tounitofmeasure
-- Resolve EcoResProduct (via Product): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.ecoresproduct eco ON eco.recid = u.product
;