Table Groups [AX 2012]

Updated: February 21, 2012

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

Table groups provide a method for categorizing tables according to the type of data they contain. Determining group membership is not an exact science but more of a conceptual definition. When determining group membership for your own tables, follow the standards in the Microsoft Dynamics AX application.

When exporting data, you can use table groups to filter records. For example, if you wanted to specify that customers should be exported but customer transactions should not. The table group that a table belongs to is defined by the TableGroup property of the table.

The available table group values are listed in the following table.

Table group

Use this group for a table with these characteristics

Examples

Parameter

The table contains data primarily used as parameters or setup information for one of the main tables (a table that has a TableGroup property of Main).

The table typically contains only one record per company.

CustParameters, VendParameters

Group

The table contains data primarily used to categorize one of the main tables (a table that has a TableGroup property of Main).

There is a one-to-many relationship between a Group table and a Main table.

CustGroup, VendGroup

Main

The table is one of the principal tables in the application and contains data for a central business object.

The table typically holds static, base information.

There is a one-to-many relationship between a Main table and a Transaction table.

CustTable, VendTable

Transaction

The table contains transaction data.

The table is typically not used for data entry directly.

CustTrans, VendTrans

WorksheetHeader

The table typically categorizes information in the WorkSheetLine tables.

There is a one-to-many relationship between a WorkSheetHeader table and a WorkSheetLine table.

SalesTable

WorksheetLine

The table contains information to be validated and made into transactions.

In comparison to the data contained in a Transaction table, the data in WorkSheetLine tables is temporary and may be deleted without affecting system stability.

SalesLine

Miscellaneous

The table does not fit in any of the other categories. This is the default value for a new table.

TableExpImpDef

Typically, the table groups Miscellaneous, Transaction, WorksheetHeader, and WorksheetLine are used for large tables. If you have checked the fields Use literals in complex joins from X++ or Use literals in join queries from forms and reports in the server configuration, then the kernel will add a forceliterals statement to the SQL query if two or more large tables have been joined.

The groups available are defined by the system enum TableGroup.

You can specify by table group whether a prompt is displayed when records are deleted or updated in a table. These prompts are defined by navigating to Tools > Options > Confirmation.

NoteNote

Regardless of what table group prompts you define, explicitly defined delete actions are respected.


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