Table Distribution Setup

You use the Table Distribution Setup table to define how selected tables should be distributed to a Distribution Location.

The distribution setup of a table contains its Distribution Type and the program uses this type to create the appropriate distribution for each record.
The Distribution Type defines:

If the table's distribution is constructed by the program only.
If the table's distribution is inherited from another table.
If the program constructs a default distribution that you are able to change.
If the distribution should be specified manually for each record in the table.

The Distribution Type also defines how the program should construct the location distribution list automatically, whether it should denote all locations or be the same as the related record in the table's Master Table ID.

If a table does not have an entry in the Distribution Setup table the system will assume that no distribution restrictions exist for this table. What happens in this case is that the table is distributed to all locations.

The tables that form the basis for distribution of data in the system are as follows:

Table Distribution Setup (this table).
Distribution List
Distribution Subgroup
Distribution Group Member

The program uses these tables to construct a Location Group Filter in the Action table, created for a table that has an entry in the Distribution Setup table. When replication takes place by actions, the replication process uses this filter to filter out the actions that only belong to the location being replicated to.

If a table does not have an entry in the Location Distribution Setup table and the program produces Actions for the table, the program constructs a Location Group Filter in the Actions table that consists of the combined No Filter and its corresponding Distribution Subgroup. This means that the table is distributed to all locations and is valid everywhere.