Address Purge

Job type: Java A widely used object-oriented programming language that is designed for use in the distributed environment of the internet. It is the most popular programming language for Android smartphone applications

Archive: None

For more information on this job, see the Job Details in the Administration Console An operations web console that allows batch jobs to be scheduled, run manually and monitored. The console also provides for viewing and modification of business and user applicable system configuration.: In the console, navigate to System Maintenance > Jobs. In the Job List, click the name of job to open its Job Details screen.

Selection criteria

Deletes every record from table COCVREP (Delivery Address) where Delivery Address Number (CVCACD) is NOT present in ANY of the following tables (it compares CVCACD to the equivalent xxCACD value unless noted otherwise):

Name	Description	Notes
COGDREP	Account Extension	Also checks against field GDVONB.
COEDREP	Agreement	Also checks against field EDH2NB.
CXGJREP	Agreement Extension	Checks field GJKDNR instead.
COA8REP	Company Parameters
COC1REP	Corporate Header
COFNREP	Diary Event
CSOQREP	Order
COC0REP	Group
COGJREP	Invoice Header
COC5REP	Payment Type
COGNREP	Pending Invoice Header
COE9REP	Sales Force
COGPREP	Subs Detailed Bill Hist
COCXREP	Subscription	Also checks against field CXH1NB.

Associated tables are purged using Delivery Address Number (CVCACD) as the key from STATEMENTHEADER table and checks against DELIVERYADDRESSNUMBER.

Tables Impacted
Name	Description
COCVREP	Delivery Address
CSO9CPP	Company Address
CZIZCPP	Address Audit History
CSQCCPP	Personal Address

Running the purge job

In the Administration Console, you can create a schedule for the purge job or run it as needed.

To run a job:

Navigate to Daily Operations > Jobs.
In the Job List, select the checkbox for the job that you want run.
Click Run Now.