D365 Reference

DataArea

frameworkShared across companies

The kernel table that lists every company (legal entity data area) in the environment — the source of every dataareaid value used to partition application tables

Module: Organization AdministrationNo company partition

Notes

Kernel (system) table, so it is absent from the CDM application schema; field list verified against the F&O system-tables reference. Kernel fields use lowercase names (id, name, isVirtual).

Fields

3 fields · 1 key

Key	Field	EDT	Description	Type	Flags
Key	id	DataAreaId	The company code — the value application tables carry in dataareaid	string
	name		Company name as registered when the data area was created	string
	isVirtual		Whether this is a virtual company (shared-data container) rather than a real operating company — exclude virtual rows when listing legal entities	enum	Enum

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading DataAreaon 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

-- ============================================================
-- Table  : DataArea The kernel table that lists every company (legal entity data area) in the environment — the source of every dataareaid value used to partition application tables
-- Purpose: Column-selected read of DataArea — auto-generated from field metadata
-- Grain  : One row per id
-- 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
  d.id AS "The company code — the value application tables carry in dataareaid",
  d.name AS "Company name as registered when the data area was created",
  d.isvirtual AS "Whether this is a virtual company (shared-data container) rather than a real operating company — exclude virtual rows when listing legal entities"  -- enum: decode d.isvirtual via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.dataarea d
ORDER BY d.id;

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

Relationships

1-hop neighbors — click a table to navigate there. RecId and InventDim edges are highlighted; they’re the joins newcomers most often get wrong.

Join details

CompanyInfoDataAreaforeign key · 1:1
ON companyinfo.dataarea = dataarea.id

Data Entities That Expose This Table

No export entity — DATAAREA is a kernel table. Synapse Link syncs kernel tables on a 24-hour cadence; land it raw, or derive the company list from any table's dataareaid.