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

Notifications

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 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans