Before running this batch process, TMA Resources recommends that you have at least 6 columns defined for this process on the Duplicate Customer Maintenance (CUS101) screen. For more information, please see Defining Duplicate Matching Rules.
This batch process populates the Cus_Dup_Cust_Group and Cus_Dup_Cust_Group_Detail tables with suspected duplicate records. Records are divided into groups for each unique set of potential duplicate records. Groupings are determined by the match key setup to work with CUS590 or ALL processes.
Two reports are generated from this process:
· Potential Duplicate Listing
· Duplicate Customer Merged Listing
For more information on running this report, please see Running the CUS590 Report.
Parameter |
Description |
Required? |
Subtitle |
This field is used to enter in a subtitle that appears underneath the report heading.
Defaults to “Potential Duplicate Customers”. |
No |
Run Mode |
The mode in which the report runs:
|
Yes |
Threshold |
The number of items defined on the Duplicate Customer Setup screen for CUS590 that should match between records to be considered a duplicate record. For example, if you enter 5 in this field, then 5 parameters defined on the Duplicate Customer Setup screen for CUS590 must match to be considered a duplicate. You cannot add a threshold higher than 6. |
Yes |
Ignore not a duplicate flag |
If the “Exclude from Duplicate Processing” checkbox is checked on the Customer Demographics screen, but you want to override that here, then enter “Y” as the value for this field. If you want to retain the original selection, then enter “N” as the value for this field. |
Yes |