EcoResStorageDimensionGroup

-- ============================================================
-- Table  : EcoResStorageDimensionGroup Storage dimension group master — shared setup that decides which storage dimensions (site, warehouse, location) are active and mandatory for the products assigned to it, including whether advanced warehousing applies
-- Purpose: Column-selected read of EcoResStorageDimensionGroup — 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 storage dimension group name — the natural key products reference through their group assignment",
  e.description AS "Description of the group",
  e.iswarehousewhsenabled AS "Whether items in this group run through advanced warehouse management (WHS) processes — splits the item population between WMS-managed and basic warehousing",  -- enum: decode e.iswarehousewhsenabled via GlobalOptionsetMetadata join — see quirks guide #enums
  e.iswarehousemandatoryenabled AS "Whether the warehouse dimension must be specified on transactions for this group",  -- enum: decode e.iswarehousemandatoryenabled via GlobalOptionsetMetadata join — see quirks guide #enums
  e.iswarehouseprimarystockingenabled AS "Whether warehouse is a primary stocking dimension for this group"  -- enum: decode e.iswarehouseprimarystockingenabled via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.ecoresstoragedimensiongroup e
ORDER BY e.name;