Table and table group reference
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Table groups are defined by the TableGroup property of tables. You can use table groups to select sets of tables when you define a table definition group for export. You can also use table groups to manage which tables are stored in the cache.
There are approximately 7,900 tables in Microsoft Dynamics AX 2012 R3, organized into table groups.
Spreadsheet of all tables and table groups
A spreadsheet that lists all core Microsoft Dynamics AX data tables is available from the Download Center: Microsoft Dynamics AX 2012 Tables and Table Groups.
The spreadsheet lists the following information for each table, includes a pivot table, as well as a list of all the tables that were removed from AX 2012 between the initial release and AX 2012 R3.
Column |
Description |
|---|---|
Table name |
AOT name of the table |
Table group |
Associated table group |
Table type |
The TableType property of a table determines where the table is stored. The following options are available: Regular – The table is stored in the Microsoft Dynamics AX database. TempDB – The table is stored in the TempDB database. When you restart Application Object Server (AOS) or the database, all tables in the TempDB database are dropped and recreated. InMemory – The table is held in memory only during the current Microsoft Dynamics AX session. |
System table |
A system table is used by the Microsoft Dynamics AX system, not for customer data. |
Visible |
A table that can be seen in the AOT. |
Shared? (SaveDataPerCompany = No) |
Shared tables are used by multiple companies. Tables that are not shared pertain to a single company. |
Release table was added in |
Lists the release in which a table was added was added to AX 2012. |
Note
The workbook does not include Kernel tables because Kernel tables are not associated with table groups. Additionally, we do not recommend that you export or import Kernel tables.
The workbook also does not include any DEL_ tables.
Types of table groups
The following table groups are available in Microsoft Dynamics AX:
Table group |
Description |
|---|---|
Framework |
Tables that are used by the underlying Microsoft Dynamics AX frameworks, such as Application Integration Framework (AIF). These tables are created during installation and are not associated with configuration keys. |
Group |
Tables that are used to categorize the tables in the Main table group. |
Main |
Principal or master tables that contain data for central business objects. These tables typically hold static, base information. |
Miscellaneous |
Tables that have not been otherwise categorized. Miscellaneous is the default table group for new tables. |
Parameter |
Tables that contain parameters or setup information for tables in the Main table group. |
Reference |
Tables that contain reference data. |
Transaction, Transaction header, and Transaction line |
Tables that contain transaction data. The tables in the Transaction header table group categorize the tables in the Transaction line table group. There is a one-to-many relationship between a Transaction header table and Transaction line tables. |
Worksheet, Worksheet header, and Worksheet line |
Tables that contain information that is validated and made into transactions. Unlike the data that is contained in the tables in the Transaction table groups, data in the Worksheet table groups is temporary. |