web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Is there documentation...
Microsoft Dynamics AX (Archived)

Is there documentation on AX table names, column definitions, and their relations?

(0) ShareShare
ReportReport
Posted on by Peter McKinney 510

We are using Atlas for AX and a big part of getting up to speed on this, is knowing where the data is.

Is there documentation on AX table names, column definitions, and their relations?

Thank you in advance for your assistance

Peter

*This post is locked for comments

I have the same question (0)
  • Suresh Kotapalle Profile Picture
    Suresh Kotapalle Microsoft Employee on at

    Not sure about all the way till relations.. but here is a good start..

    msdn.microsoft.com/.../aa852568

  • Akhwand Usman Profile Picture
    Akhwand Usman 1,032 on at

    Peter

    MSDN have all information you are asking just BING through and you'll get the result.

  • Suggested answer
    Denis Patrakov Profile Picture
    Denis Patrakov on at

    If you're looking for a complete data model manual then there's only one for AX 4.0. There's no such official manual for later versions as far as I know. But for a limited subset of tables you can always use a Reverse Engineering tool and create a data model using the application metadata. Note that you'll need Visio to view the generated model. Just create a new project, drag tables of interest into it, right-click on the project and select Add-ins/Reverse Engineer/Data model. Note that you can also use a wildcard in the GroupMask property of a project group node to add all the AOT objects which names match the wildcard instead of dragging them into the project.

  • Community Member Profile Picture
    Community Member on at

    Hi Peter

    Take a look at the Perspectives tree node in the AOT Data Dictionary.  This lists the main tables used fror most of the modules.   AX uses these perspectives to build the OLAP cubes etc.

    You can also emal helpdesk@globesoftware.com.au and request a data source list the module you're after.

    Steve.

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans