Best Practices for Table Collections [AX 2012]
Updated: June 14, 2012
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.
Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. get your copy at the MS Press Store