This field specifies what the replicator should do when updating data in the To-Table ID field.
This field only applies if the data exchange is between tables and if the Replication Method is Normal.
If the replication method is is By Actions, this field is not relevant. In that case, the Action field in the Actions table contains the information about what to do.
The options are:
Empty - Nothing is specified.
Add - Only new records in From Table are added to To Table.
Update-Add - Only changed and new records in From Table are updated/added to To Table.
Delete - Only records that do not exist in From Table anymore are deleted from To Table.
Update-Delete - Changed records and non-existing records in From Table are updated/deleted from To
Table.
Add-Delete - Only new records and non-existing records in From Table are added/deleted from To Table.
Update-Add-Delete - All changes, deletions and additions to From Table are copied to To Table.
The resulting tables are identical.
Add-Only - Only new records are added to the To Table, if the record already exists the program will return an error message and will not replicate the scheduler
job.
Note - It is extremely important to select the right option in this field.
For example, it is more safe to use the Add-Only option when replicating entries from store to head office, than using the Add
option. The reason is that if for some reason the number series for the records being replicated,
overlap for two distribution locations, the Add-Only option will return an error, while the Add option will not.