D365 Reference

CompanyInfo

mainShared across companies

The legal-entity master — one row per company, carrying its DataArea code, registration and tax numbers, and the address-book party details behind the company name

Module: Organization AdministrationNo company partition
Notes

Global table in the DirPartyTable lineage (a legal entity is a party), which is why party fields like PartyNumber and Name appear directly on it. Joins to DataArea 1:1 on its DataArea field.

Fields

8 fields · 1 key

KeyFieldEDTDescriptionTypeLengthFlags
KeyDataAreaDataAreaIdThe company code this legal entity owns — the natural join to DataArea and to every table's dataareaidstring
NameLegal-entity name, inherited from the company's address-book party recordstring
PartyNumberPartyNumberGlobal-address-book party number of the legal entitystring
LanguageIdDefault language of the companystring
RegNumCompany registration numberstring
VATNumTax-registration (VAT) numberstring
IsConsolidationCompanyWhether the company exists only to receive consolidations — exclude from operational reportingenum
Enum
IsEliminationCompanyWhether the company is an elimination company used in consolidation processingenum
Enum

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading CompanyInfoon 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
-- ============================================================
-- Table  : CompanyInfo The legal-entity master — one row per company, carrying its DataArea code, registration and tax numbers, and the address-book party details behind the company name
-- Purpose: Column-selected read of CompanyInfo — auto-generated from field metadata
-- Grain  : One row per DataArea
-- 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
  c.dataarea AS "The company code this legal entity owns — the natural join to DataArea and to every table's dataareaid",
  c.name AS "Legal-entity name, inherited from the company's address-book party record",
  c.partynumber AS "Global-address-book party number of the legal entity",
  c.languageid AS "Default language of the company",
  c.regnum AS "Company registration number",
  c.vatnum AS "Tax-registration (VAT) number",
  c.isconsolidationcompany AS "Whether the company exists only to receive consolidations — exclude from operational reporting",  -- enum: decode c.isconsolidationcompany via GlobalOptionsetMetadata join — see quirks guide #enums
  c.iseliminationcompany AS "Whether the company is an elimination company used in consolidation processing"  -- enum: decode c.iseliminationcompany via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.companyinfo c
ORDER BY c.dataarea;

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