InventModelGroup

-- ============================================================
-- Table  : InventModelGroup Item model group master — one row per company and model group, controlling inventory policy for its items: costing model, negative-stock rules, and whether the product is stocked at all
-- Purpose: Column-selected read of InventModelGroup — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + ModelGroupId
-- 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.modelgroupid AS "The item model group code — inventory policy bucket assigned to items via InventModelGroupItem",
  i.name AS "Model group name",
  i.inventmodel AS "Costing / inventory valuation model for the group (FIFO, weighted average, standard cost…)",  -- enum: decode i.inventmodel via GlobalOptionsetMetadata join — see quirks guide #enums
  i.stockedproduct AS "Whether items in this group are stocked — non-stocked items never hit the on-hand tables",  -- enum: decode i.stockedproduct via GlobalOptionsetMetadata join — see quirks guide #enums
  i.negativephysical AS "Whether physical inventory is allowed to go negative for this group",  -- enum: decode i.negativephysical via GlobalOptionsetMetadata join — see quirks guide #enums
  i.negativefinancial AS "Whether financial inventory is allowed to go negative for this group",  -- enum: decode i.negativefinancial via GlobalOptionsetMetadata join — see quirks guide #enums
  i.standardcost AS "Whether the group is standard-cost valued",  -- enum: decode i.standardcost via GlobalOptionsetMetadata join — see quirks guide #enums
  i.quarantinecontrol AS "Whether receipts for this group are quarantine-managed"  -- enum: decode i.quarantinecontrol via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.inventmodelgroup i
WHERE
  i.dataareaid = '<company>'
ORDER BY i.modelgroupid;