UnitOfMeasureConversionEntity

-- ============================================================
-- Entity : UnitOfMeasureConversionEntity
-- Purpose: Rebuild UnitOfMeasureConversionEntity from landed F&O tables — auto-generated from table-entity-map
-- Grain  : UnitOfMeasureConversion × UnitOfMeasure — 1:N joins yield one row per line
-- Tables : UnitOfMeasureConversion, UnitOfMeasure
-- 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. Company-partitioned tables are joined on DataAreaId to prevent cross-company fan-out. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
  fromunitofmeasure.symbol AS "FromUnitOfMeasure — The unit symbol (kg, ea, hr) — the natural key, and the value unit columns across the lake resolve to",
  tounitofmeasure.symbol AS "ToUnitOfMeasure — The unit symbol (kg, ea, hr) — the natural key, and the value unit columns across the lake resolve to"
FROM <catalog>.<schema>.unitofmeasureconversion h
LEFT JOIN <catalog>.<schema>.unitofmeasure fromunitofmeasure
  ON fromunitofmeasure.recid = h.fromunitofmeasure
LEFT JOIN <catalog>.<schema>.unitofmeasure tounitofmeasure
  ON tounitofmeasure.recid = h.tounitofmeasure
;