Table Groups in D365 F&O
Table of Content:
Table Groups in D365 F&O
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. These table contains only few columns. |
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. When you are creating a TempDB as table type then select table group as |
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.