X++: Announcing the “AxErd” Website for Dynamics AX 2012

[Blog bot]

Источник: http://blogs.msdn.com/b/x/archive/20...s-ax-2012.aspx
==============

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: http://go.microsoft.com/fwlink/p/?linkid=296623




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.







Gene Milener , 2013-May-23




Источник: http://blogs.msdn.com/b/x/archive/20...s-ax-2012.aspx