Announcing the “AxErd” Website for Dynamics AX 2012

We have created about 30 database ERDs (entity relationship diagrams) for tables of Microsoft Dynamics AX 2012 R2.  The ERDs are useful to AX developers when they need to customize a given application module (such as Accounts payable or General ledger).

The ERDs are part of our “AxErd” website, which can be reached at the following Http URL:

     AxErd website:


Design Principle for ERDs

Dynamics AX has several thousand tables. It is impossible to construct one ERD that contains every table. And it is impossible to construct enough specialized ERDs that foresee every precise need of every partner developer. So the many ERDs we provide were designed to capture the core tables of each module, and to include some major tables from other related modules.

Minor compromises were made so that each ERD can fit onto one side of a standard sheet of paper when printed.


Support Files for ERD Extension

The AxErd website also contains hundreds of inter-linked support .htm files designed to assist the partner developer who needs to extend one of the ERDs that AxErd provides. In AX, the partner developer can easily look up all the parent tables of a given table, by navigating:

      AOT > Data Dictionary > Tables > MyTable > Relations > MyRelation


However, it is much harder for the developer to look up all the child tables of that same given table. Cross-reference does technically provide this information, but laborious clicks and scrolls are required to perform the look ups. In contrast, the AxErd website performs this look up with one click.

For instructions on how you can semi-automate the task of extending or creating an ER diagram with Dynamics AX 2012, click the 'Help' link on the AxErd Home page.


Tables and ERDs are Categorized by Module

For each table, the AxErd webpages indicate which module the table is categorized into. And in the reverse direction, for any one module there is a webpage that lists all the tables which are categorized into the module.


Example ERD

Here is one ERD from the AxErd website. The image has been reduced in size for display here.




The next image shows an AxErd webpage that lists all the child tables of the InventTable table, meaning tables that have a foreign key column that references the values in the primary key of the InventTable table.

The portion that is circled in red shows that the AgreementLine table is a child of the InventTable table. The arrow always points from child to parent.

In the image, every word that is blue is a clickable link to related information.




Gene Milener , 2013-May-23

Comments (9)
  1. awesome you guys! I was looking for something like that for months… its great for educating our clients about the data structure!

  2. TommySkaue says:

    This is good stuff!! *thumbs up*

  3. Beat Pallagi says:

    Wow – you actually simplified my life 🙂

  4. jaestevan says:

    thanks! this has been heavily requested over time!

  5. Mohamed Aamer says:

    Thanks..! Great Job, that really gives a lot of help…!

  6. Muhammad Aijaz says:

    Thanks.This is good stuff.

  7. Jeremy Lee says:

    Are you able to explain how the status columns link from numeric to text values?

    I am looking for information on Dynamics AX 2009 and 2012.



  8. IJZ says:

    Dear Lee,

    They use Enumerations to map numeric values to String representatives.

    Thanks and Regards,

  9. Aravindraj says:

    It saves me a day.

Comments are closed.

Skip to main content