InventModelGroupItem

-- ============================================================
-- Table  : InventModelGroupItem The link table that assigns each released item to its item model group — like the item group, the model group is not a column on InventTable. Cross-company, with explicit ItemDataAreaId / ModelGroupDataAreaId columns
-- Purpose: Column-selected read of InventModelGroupItem — 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",
  i.itemdataareaid AS "Company the item row belongs to — the explicit company column on this cross-company link table",
  i.modelgroupid AS "Item model group the item is assigned to",
  i.modelgroupdataareaid AS "Company the model group row belongs to; pair it with ModelGroupId when joining to InventModelGroup"
FROM <catalog>.<schema>.inventmodelgroupitem i
WHERE
  i.itemid = '<ItemId>'
ORDER BY i.itemid;