InventSite

-- ============================================================
-- Table  : InventSite Site master — one row per operational site, the top of the inventory dimension hierarchy that warehouses roll up to
-- Purpose: Column-selected read of InventSite — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + SiteId
-- 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.siteid AS "The site code — the top inventory dimension; other tables reference it as InventSiteId",
  i.name AS "Site name",
  i.timezone AS "Time zone of the site, used when converting order dates across sites",  -- enum: decode i.timezone via GlobalOptionsetMetadata join — see quirks guide #enums
  i.defaultdimension AS "RecId of the site's default financial-dimension value set in DimensionAttributeValueSet",
  i.defaultinventstatusid AS "Default inventory status applied to receipts at the site",
  i.orderentrydeadlinegroupid AS "Order-entry deadline group governing same-day cutoffs for the site",
  i.taxbranchrefrecid AS "RecId of the tax branch (fiscal establishment) tied to the site, where localizations use it",
  i.isreceivingwarehouseoverrideallowed AS "Whether transfer receipts may override the receiving warehouse at this site"  -- enum: decode i.isreceivingwarehouseoverrideallowed via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.inventsite i
-- Resolve DimensionAttributeValueSet (via DefaultDimension): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.dimensionattributevalueset dim ON dim.recid = i.defaultdimension
WHERE
  i.dataareaid = '<company>'
  -- AND i.siteid = '<InventSiteId>'
ORDER BY i.siteid;