Notifications
Announcements
No record found.
Hi,
Whether Legal Entities in D365 f&o are Stored in Tables ?
If Yes, May I know what is the name of the Tables which contains Legal Entities name and the Details about the Legal Entities.
And is there is any shortcut to find the table names in f&o ?
The table name is "Data Area"
Use the below link and replace the XXXX with your environment link.
XXXXXX.dynamics.com/
Hi Binit Shah,
Thanks . I can able to access that link but I am unable to see the Data Area table in AOT?
How to you navigate to that Link ?
The ID & Name field are stored in 'DataArea' system table which you can't extend it & stored under system documentation. All the details which you find in the legal entities form is stored in the 'companyinfo' table. In order to find the table name, get the form name first from UI & check it's data sources in VS.
Hi Abdul,
Thanks for the Info, and this Helped me a lot . But I can find Companyinfo table in AOT but not in sql server table
and I can find DataArea table in sql server table but not in AOT. whether System related information will be stored in different Database in SQL Server ? Am I missing anything ?
In SQL, you'll find the table name starting from ax.companyinfo instead of dbo.companyinfo.
Companyinfo table extends multiple table which falls under inheritance category. For better understanding refer this post.
community2.dynamics-int.com/.../queries-to-tables-with-inheritance
use the following URL to open a web based table browser
environment url/?mi=SysTableBrowser&tableName=companyinfo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
