InventItemGroupItem

-- ============================================================
-- Table  : InventItemGroupItem The link table that assigns each released item to its item group — in D365 the item group is NOT a column on InventTable; this table is where the assignment lives. Cross-company: it carries explicit ItemDataAreaId / ItemGroupDataAreaId columns instead of a DataAreaId partition
-- Purpose: Column-selected read of InventItemGroupItem — auto-generated from field metadata
-- Grain  : One row per ItemId + ItemDataAreaId
-- 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.itemid AS "Item being assigned; pair with ItemDataAreaId when joining to InventTable — the table has no DataAreaId of its own",
  i.itemdataareaid AS "Company the item row belongs to — the explicit company column that replaces DataAreaId on this cross-company link table; always include it in the InventTable join",
  i.itemgroupid AS "Item group the item is assigned to",
  i.itemgroupdataareaid AS "Company the item group row belongs to; pair it with ItemGroupId when joining to InventItemGroup"
FROM <catalog>.<schema>.inventitemgroupitem i
WHERE
  i.itemid = '<ItemId>'
ORDER BY i.itemid;