Best Practices for Table Collections

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Several standard table collections have been created in the standard application. Go to AOT > Data Dictionary > Table Collections to see the list of table collections.

These table collections must be updated by any solution that changes or adds new tables to the application. By using these collections, the most common shared data or virtual company situations can be set up at the installation.

Add tables to the Global collection if the data is not company-specific. Examples are State and Unit.

There must not be a foreign key in a table in a virtual company, where the key is in the (non-virtual) company.

To get the most use of the standard table collections, it might be necessary to adjust the data model. For example, you might have to split data that would all be in one table if all data was stored under one company.

See also

Data Dictionary Best Practices

Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.