Understanding Address Book and Message Log Purges

Use the Purge Address Book Records program to purge records from the Address Book Master table and the following related tables:

• F0030 - Bank Transit Master.

• F0030W - Bank Account/Supplier Number Worktable.

• F01092 - Supplemental Database - Code.

• F01093 - Supplemental Database - Narrative.

• F0111 - Address Book - Who's Who.

• F0115 - Address Book - Contact Phone Numbers.

• F01151 - Electronic Address.

• F01112 - Related Person.

• F0116 - Address by Date.

• F01161 - Alternate Address.

• F0150 - Address Organization Structure Master.

• F03012 - Customer Master by Line of Business.

• F0401 - Supplier Master.

• F01815 - AB Word Search Master.

The system does not purge an address book record if any related payor or address book records are in a transaction table. If you set the processing option to run the report in final mode, the system deletes records from the database if no corresponding records are in other tables. You should run this report in proof mode before running it in final mode if you are uncertain about the corresponding tables.

If you use the JD Edwards Electronic Mail system, you should periodically purge the message log records from the PPAT Message Control File (F01131) and JDEM Multi Level Message (F01131M) tables by running the Purge Message Log program (R01131P). Use processing options to specify whether to purge messages by date regardless of their status and, if so, the range of dates to purge. If a range of dates is not specified, the system purges only deleted tasks.