InventTable

-- ============================================================
-- Table  : InventTable Released product master — one row per item within a company, carrying the RecId link to its shared product; item group and model group are assigned in the InventItemGroupItem / InventModelGroupItem link tables, not here
-- Purpose: Column-selected read of InventTable — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + ItemId
-- 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
  it.itemid AS "The item number — the natural key analysts join every inventory and order table on",
  it.product AS "RecId of the shared product in EcoResProduct this released item points back to",
  it.netweight AS "Net weight of one inventory unit of the item",
  it.itemtype AS "Whether the item is stocked, a service, or a BOM",  -- enum: decode it.itemtype via GlobalOptionsetMetadata join — see quirks guide #enums
  it.namealias AS "Search alias for the item",
  it.defaultdimension AS "RecId of the item's default financial-dimension value set in DimensionAttributeValueSet",
  it.primaryvendorid AS "Primary vendor account for the item — the default sourcing join to VendTable",
  it.bomunitid AS "Unit the item is measured in on bills of materials",
  it.height AS "Net height of one unit",
  it.depth AS "Net depth of one unit",
  it.width AS "Net width of one unit",
  it.unitvolume AS "Volume of one unit — with net weight, the basis for load and freight math",
  it.taraweight AS "Packaging (tare) weight of one unit; gross weight = net + tare",
  it.density AS "Density of the item, used in catch-weight and process scenarios",
  it.grossheight AS "Packed (gross) height of one unit — note the lowercase g in the physical column name",
  it.grossdepth AS "Packed (gross) depth of one unit",
  it.grosswidth AS "Packed (gross) width of one unit",
  it.costgroupid AS "Cost group for standard-cost breakdown and calculation grouping",
  it.prodgroupid AS "Production group linking the item to production posting profiles",
  it.prodpoolid AS "Production pool used to bucket production orders for scheduling and reporting",
  it.reqgroupid AS "Coverage group driving master-planning policy (period, min/max, requirement) for the item",
  it.itembuyergroupid AS "Buyer group — who plans and purchases the item; a common planner-level reporting slice",
  it.batchnumgroupid AS "Number sequence group for batch numbers, set when the item is batch-tracked",
  it.serialnumgroupid AS "Number sequence group for serial numbers, set when the item is serial-tracked",
  it.pdsshelflife AS "Shelf life in days from manufacturing to expiry for batch-tracked items",
  it.pdsbestbefore AS "Days before expiry at which a batch is best-before flagged",
  it.pdsshelfadvice AS "Days before expiry at which a shelf-advice date is raised for a batch",
  it.abcvalue AS "ABC classification of the item by inventory value",  -- enum: decode it.abcvalue via GlobalOptionsetMetadata join — see quirks guide #enums
  it.abcrevenue AS "ABC classification of the item by revenue contribution",  -- enum: decode it.abcrevenue via GlobalOptionsetMetadata join — see quirks guide #enums
  it.abccontributionmargin AS "ABC classification of the item by contribution margin",  -- enum: decode it.abccontributionmargin via GlobalOptionsetMetadata join — see quirks guide #enums
  it.abctieup AS "ABC classification of the item by capital tie-up (carrying cost)",  -- enum: decode it.abctieup via GlobalOptionsetMetadata join — see quirks guide #enums
  it.productlifecyclestateid AS "Product lifecycle state of the released item (active, phase-out, obsolete…) — the standard filter for excluding dead items from planning analytics",
  it.phantom AS "Whether the item is a phantom in BOM explosion (exploded through, never planned itself)",  -- enum: decode it.phantom via GlobalOptionsetMetadata join — see quirks guide #enums
  it.altitemid AS "Alternative item suggested or used when this item is unavailable"
FROM <catalog>.<schema>.inventtable it
-- Resolve EcoResProduct (via Product): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.ecoresproduct eco ON eco.recid = it.product
WHERE
  it.dataareaid = '<company>'
  -- AND it.itemid = '<ItemId>'
ORDER BY it.itemid;