Table distribution (form)
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack
Click Retail > Setup > Retail scheduler > Table distribution. Click New to create a new entry in a table distribution.
Use this form to set up and modify table distributions.
Note
This form is not available if Microsoft Dynamics AX 2012 R3 is installed.
A table distribution is the hierarchy that is used to distribute data from the Microsoft Dynamics AX database to store locations. For each table that is included in the table distribution, you specify the type of distribution that occurs. You also define the parent/child relationships for the tables in the table distribution.
Important
Setting up table distributions is a complex task. We recommend that this task be completed only by a person who is experienced in Microsoft SQL Server administration, and who also has detailed knowledge of the tables and fields in the Microsoft Dynamics AX database.
Task that uses this form
Set up or modify table distributions
Navigating the form
The following tables provide descriptions for the controls in this form.
Buttons
Button |
Description |
|---|---|
Table links |
View or assign a parent table relationship for the selected table. |
Insert default setup |
Insert the default setup for table distribution. The default setup is appropriate for most organizations. Even if you want to customize the table distribution, you can save time by inserting the default setup first. |
Check parent table setup |
Verify that the hierarchy, and the relationships that are set up between the parent table and the child tables, are valid. |
Fields
Field |
Description |
|---|---|
List view |
Before you create a new entry in a table distribution, select this check box. After you create a new entry, clear the check box to view the parent and child tables in a hierarchical structure. |
Parent table |
The name of the parent table. |
Parent distribution |
The level of the selected table distribution in the hierarchy. If the selected table distribution is at the top of the hierarchy, the value is 0 (zero). |
Table ID |
The identifier that is used for the table in the Application Object Tree (AOT). Click the arrow to open the Tables form, where you can select a table in a list. When you select a table in the Tables form, the Table ID value is set automatically. |
Table name |
The name of the selected table. When you select a table in the Tables form, this value is set automatically. |
Distribution type |
Select the method that is used to distribute the changes that are made in a table to distribution locations. By default, the distribution type is All distribution locations. The following options are also available:
|
No actions |
Select this check box to indicate that changes that are made to a table in the hierarchy are not distributed. |
Parent to another table |
A selected check box indicates that the selected table is the parent of another table. |
Table links |
The number of links that the selected table has to a parent table. |
Linked actions on insert |
Select this check box to indicate that specific records in child tables are distributed when a record is added to the selected parent table. Note If the selected parent table does not have child tables, this check box does not affect distributions. |
Linked actions on update |
Select this check box to indicate that specific records in child tables are distributed when a record in the selected parent table is modified. Note If the selected parent table does not have child tables, this check box does not affect distributions. |
Linked actions on delete |
Select this check box to indicate that specific records in child tables are distributed when a record in the selected parent table is deleted. Note If the selected parent table does not have child tables, this check box does not affect distributions. |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).