Export (0) Print
Expand All

Table and table group reference [AX 2012]

Updated: April 1, 2014

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.

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.

NoteNote

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.

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.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft