The Open Development Tool utility for generating the Purge routines is to be used for the initial purge parameter configuration. The tool generates the packages that will have the purge logic based on the criteria. The tool will be used for the following:

1. Maintaining the list of entities that need to be purged. This includes maintaining the Master-Child relationship between the tables. Each entity will have the following:
   • Parent table
   • Primary key for the parent table and the data types of the key fields.
   • List of child tables.
   • Relation with the parent tables and the data types of the key fields.
2. Maintaining the purge behavior – whether the data must be deleted or archived.
3. Maintaining the mode of purge – whether it is bulk or record level.
4. Maintaining the archive table suffix if the purge behavior is to archive the data.
5. Maintaining the filter criteria to determine what data to purge. These filter criteria are applied on the parent table to identify the data to purge, and based on the setup, corresponding data will also be purged from the child tables.