InventItemGroup

-- ============================================================
-- Table  : InventItemGroup Item group master — one row per company and item group, the reporting and posting bucket items are assigned to via InventItemGroupItem
-- Purpose: Column-selected read of InventItemGroup — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + ItemGroupId
-- 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
  i.itemgroupid AS "The item group code — the reporting bucket InventItemGroupItem assigns items into",
  i.name AS "Item group name",
  i.standarditemallocateid AS "Default item allocation key for forecast allocation over this group"
FROM <catalog>.<schema>.inventitemgroup i
WHERE
  i.dataareaid = '<company>'
ORDER BY i.itemgroupid;