EcoResTrackingDimensionGroup

-- ============================================================
-- Table  : EcoResTrackingDimensionGroup Tracking dimension group master — shared setup that decides whether batch and serial tracking are active for the products assigned to it, and where serials are captured
-- Purpose: Column-selected read of EcoResTrackingDimensionGroup — auto-generated from field metadata
-- Grain  : One row per Name
-- 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
  e.name AS "The tracking dimension group name — the natural key products reference through their group assignment",
  e.description AS "Description of the group",
  e.isserialnumbercontrolenabled AS "Whether serial number control is enforced for items in this group",  -- enum: decode e.isserialnumbercontrolenabled via GlobalOptionsetMetadata join — see quirks guide #enums
  e.isserialatconsumptionenabled AS "Whether serials are captured at consumption rather than at receipt",  -- enum: decode e.isserialatconsumptionenabled via GlobalOptionsetMetadata join — see quirks guide #enums
  e.captureserial AS "Where in the process the serial number is captured for this group"  -- enum: decode e.captureserial via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.ecorestrackingdimensiongroup e
ORDER BY e.name;