Orphaned Address Utility (uxaddrfix.p)
To be converted, all customer, supplier, end user, and remit-to addresses must have a related Address List Detail (ls_mstr). The Data Preparation Report indicates if you must run this utility.
This utility reports and creates missing Address List Details (ls_mstr) in the following scenarios:
• A customer exists with Customer Master (cm_mstr) and Address Master (ad_mstr) but no ls_mstr record for type “customer.”
• A supplier exists with Supplier Master (vd_mstr) and ad_mstr but no ls_mstr record for type “supplier.”
• An end user exists with Service/Support End User Master (eu_mstr) and ad_mstr but no ls_mstr record for type “enduser.”
• A supplier exists and has a reference to a remit-to address (vd_remit <> “ “) that has a valid address but no ls_mstr record for type “remit-to.”
• A site exists with an address, but no ls_mstr of type “company” is found.
The utility provides a simulation mode that allows you to preview the effects of the update.
For eB2.1 and later, one execution processes all active domains.
The report output file name is uxaddrfix-<dbname>-<date>_<time>.prn.
This utility can affect the system by making previously unusable addresses usable.