D365 Reference

DimensionAttributeValueSet

mainShared across companies

A stored set of financial-dimension values referenced by masters and transactions via a RecId; the first hop when decoding default dimensions into columns

Module: FinanceNo company partition

What the badges mean

main: Table group: how F&O categorizes the table's role — main entity, group/header, transaction, worksheet header, worksheet line, reference, parameter, or framework.
Shared across companies: The table carries no DataAreaId— rows aren’t partitioned per company, so a query never needs (and can’t use) a company filter here (see the quirks guide).
Date-effective: The table carries a ValidFrom/ValidTo effectivity window — a join without a date filter multiplies every key by its history (see the quirks guide).

Header & line

DimensionAttributeValueSet is the header for its lines in DimensionAttributeValueSetItem.

Fields

5 fields · 1 key

5 fields.

Table fields: key flag, field name, extended data type, description, data type, length, and quirk flags. 5 fields.
Key	Field	EDT	Description	Type	Flags
Key	Hash		A hash of the contained dimension values that uniquely identifies the set — CDM types this binary; confirm the landed type in your lake	container
	RecId	RecId	The 64-bit surrogate key masters and transactions reference via DefaultDimension / LedgerDimension	int64	RecId
	ImpliedDataAreaId		Company implied by any company-specific values contained in the set	string
	MainAccount	RecId	RecId of the main account when the set carries one (MainAccount is outside this reference's table scope)	int64	RecId
	MainAccountValue		Main-account code stored denormalized on the set	string

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading DimensionAttributeValueSet on Databricks — enums are decoded, 1900-01-01 dates are wrapped to NULL, and the DataAreaId anchor is in place. Set your Unity Catalog location, company, and filter values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogSchema

2 parameters not filled: <catalog>, <schema>

-- ============================================================
-- 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 — CDM types this binary; confirm the landed type in your lake",
  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;

Verified September 2026

Relationships

Diagram of 1-hop neighbors — join details below. RecId and InventDim edges are highlighted; they’re the joins newcomers most often get wrong.

Join details

InventJournalTransDimensionAttributeValueSetRecId ref · N:1
ON inventjournaltrans.defaultdimension = dimensionattributevalueset.recid
InventSiteDimensionAttributeValueSetRecId ref · N:1
ON inventsite.defaultdimension = dimensionattributevalueset.recid
CustTableDimensionAttributeValueSetRecId ref · N:1
ON custtable.defaultdimension = dimensionattributevalueset.recid
CustGroupDimensionAttributeValueSetRecId ref · N:1
ON custgroup.defaultdimension = dimensionattributevalueset.recid
VendTableDimensionAttributeValueSetRecId ref · N:1
ON vendtable.defaultdimension = dimensionattributevalueset.recid
ProdTableDimensionAttributeValueSetRecId ref · N:1
ON prodtable.defaultdimension = dimensionattributevalueset.recid
ForecastSalesDimensionAttributeValueSetRecId ref · N:1
ON forecastsales.defaultdimension = dimensionattributevalueset.recid
DimensionAttributeValueSetItemDimensionAttributeValueSetRecId ref · N:1
ON dimensionattributevaluesetitem.dimensionattributevalueset = dimensionattributevalueset.recid
CustTransDimensionAttributeValueSetRecId ref · N:1
ON custtrans.defaultdimension = dimensionattributevalueset.recid
VendTransDimensionAttributeValueSetRecId ref · N:1
ON vendtrans.defaultdimension = dimensionattributevalueset.recid

Data Entities That Expose This Table

No standard export entity — land the raw framework tables to decode dimensions.

Browse more finance tables