BOMTable

-- ============================================================
-- Table  : BOMTable Bill of materials header — one row per BOM identifier, with its name, approval state, and production site; versions in BOMVersion decide which items use it and when
-- Purpose: Column-selected read of BOMTable — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + BOMId
-- 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
  b.bomid AS "The BOM identifier — the natural key BOM lines and versions join on",
  b.name AS "BOM name",
  b.itemgroupid AS "Item group used to filter and organize BOMs",
  b.siteid AS "Production site the BOM applies to; blank means site-independent",
  b.approved AS "Whether the BOM header is approved for use",  -- enum: decode b.approved via GlobalOptionsetMetadata join — see quirks guide #enums
  b.approver AS "RecId of the worker who approved the BOM",
  b.checkbom AS "Whether circular-reference checking is enforced for this BOM",  -- enum: decode b.checkbom via GlobalOptionsetMetadata join — see quirks guide #enums
  b.pmfbomformula AS "Whether the record is a discrete BOM or a process-manufacturing formula"  -- enum: decode b.pmfbomformula via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.bomtable b
WHERE
  b.dataareaid = '<company>'
ORDER BY b.bomid;