DimensionAttributeValueSet

-- ============================================================
-- Table  : DimensionAttributeValueSet A stored set of financial-dimension values referenced by masters and transactions via a RecId; the first hop when decoding default dimensions into columns
-- Purpose: Column-selected read of DimensionAttributeValueSet — auto-generated from field metadata
-- Grain  : One row per Hash
-- 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
  davs.hash AS "A hash of the contained dimension values that uniquely identifies the set",
  davs.recid AS "The 64-bit surrogate key masters and transactions reference via DefaultDimension / LedgerDimension",
  davs.implieddataareaid AS "Company implied by any company-specific values contained in the set",
  davs.mainaccount AS "RecId of the main account when the set carries one (MainAccount is outside this reference's table scope)",
  davs.mainaccountvalue AS "Main-account code stored denormalized on the set"
FROM <catalog>.<schema>.dimensionattributevalueset davs
ORDER BY davs.hash;