Purge obsolete database entries |
When obsolete entries are purged, the following actions occur:
All database items that have a transaction date older than the specified retention period are deleted
All closed purchase orders with an order status of CLOSED and all purchase orders on which every line item has a status of CLOSED are deleted if the purchase orders have a date closed older than the specified retention period
All completed general import runs are deleted based on two criteria:
There is a check in the Processing completed field on the Import Data Load tab of the Data -> General Import -> Import screen
The number of days between the import start date/time and the purge run date is greater than the number of days the data is to be retained
All purchase orders with an order status of OPEN on which every line item has a status of CLOSED are closed. They are deleted if they have a date closed older than the specified retention period
For FuelFocus, all posted, re-posted, or skipped rows in FUEL_TRANSACTIONS that are older than the retention period specified for fuel tickets are deleted. Matching records in the FUEL_TRANS_DATA table are also deleted. If the retention parameter is set to 0 (zero), no records are deleted.
Retention information for functional areas is specified on the Retention Levels tab of the System Mgmt -> Setup -> Table Management screen. Import start dates and times and whether processing was completed are specified on the Import Data Load tab of the Data -> General Import -> Import screen.
For a list of screens that generate purchase orders, go to Purchasing.