Defining purge criteria

Transactional data collected by Sterling Order Management System Software during the execution are periodically removed from the 'live' transactional tables.

It is common to retain order related information for extended period of time. There are history tables provided for relevant transactional tables to move data from the day-to-day "live" tables to a historical table.

Purges are the process by which old data is removed from the system database. Purges minimize the number of unused database records to increase search efficiency and reduce the size of the required physical disk.