D365 Reference
UnitOfMeasureEntity
Units — the unit-of-measure master export (displayed as 'Units'), one record per unit symbol with class, system of units, and precision
Tables vs entities
This entity is an export-shaped view over the tables below. When you land raw F&O tables instead of the entity, the SQL further down rebuilds it — joining the backing tables on their keys and DataAreaId. When to land tables vs entities
Notes
CDM-confirmed (Entities/SupplyChain/ProductInformationManagement).
Rebuild-from-tables SQL
Databricks SQLStarting point for reconstructing this entity from landed tables — the backing tables joined on their keys and DataAreaId. Set your Unity Catalog location, company, and filter values below.
Query parameters
2 parameters not filled: <catalog>, <schema>
-- ============================================================
-- Entity : UnitOfMeasureEntity
-- Purpose: Rebuild UnitOfMeasureEntity from landed F&O tables — auto-generated from table-entity-map
-- Grain : One row per UnitOfMeasure record
-- Tables : 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
h.symbol AS "The unit symbol (kg, ea, hr) — the natural key, and the value unit columns across the lake resolve to"
FROM <catalog>.<schema>.unitofmeasure h
ORDER BY h.symbol;