Tuesday, July 13, 2021

Table Group Property in Dynamics 365 finance and operations

 

Table Group

description

Examples

Framework

Tables that are used by the underlying Dynamics 365 FOframeworks,such as Workflow. These tables are typically created during installation and are not associated with configuration  keys.

NumberSequenceTable,
WorkflowElementTable

Group

Tables used to categorize the tables that are in the Table Group:  Main.

CustGroup,
VendGroup

Main

Master or master tables that contain data for a central business object. These tables typically contain basic and static information.

CustTable,
VendTable

Miscellaneous

Tables that do not fall into any of the other categories. This is the default value in a new table. Avoid using this  Table Group.

TableExpImpDef

Parameter

Tables that contain data used primarily as parameters or configuration information for one of the main tables (a table that has  the  Table Group:  Mainproperty).
Tables that typically  contain only one record per company.

CustParameters,
VendParameters

Reference

Tables that contain reference data.

ExchangeRate,
FiscalCalendar

Transaction, Transaction
Header,  
and  TransactionLine

Tables that contain d dataand transactions.
These tables  are not used for data entry directly.
A  TransactionHeader table  categorizes  the information from the tables  that are in the Table Group:  TransactionLine.

CustTrans,
VendTrans

Worksheet, Worksheet
Header,  
and  WorksheetLine

Tables that contain information that will be validated and transformed into transactions.
A  WorksheetHeader table  categorizes the information of the tables that are in the Table Group:  WorksheetLine.
Compared to the data contained in a Transaction table, the data in the  Worksheet tables is temporary and can be deleted without affecting system stability.

SalesTable,
SalesLine

No comments:

Post a Comment