Purge Criteria business rules are used to define qualifications around each type of purge.
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. In Purge Criteria Rules, default purge rules are provided. These can be modified for your system operations.
Table 1 lists the purge rules provided for order document types in Sterling Selling and Fulfillment Foundation.
Rule | Description | Default Retention Days |
---|---|---|
PRG_SHIP_STATS | Purges shipment statistics and archives them in the history tables. | 30 |
STATUSAUDITPRG | Purges order age alerts (if you have configured the system to trigger alerts when the order document type stays in a particular status for a specified time period). | 30 |
NEGOTIATIONPRG | Purges negotiation information and archives it in the history tables. | 30 |
NEGOTIATIONHISTPRG | Purges negotiation information from the negotiation history tables. | 30 |
RECEIPTPRG | Purges receipt information and archives it in the history tables. | 30 |
RECEIPTHISTPRG | Purges receipt information from the receipt history tables. | 30 |
ORDERHISTPRG | Purges order information from the order history tables. | 30 |
ORDERPRG | Purges order information and archives it in the history tables. | 30 |
ORDER_RELEASE_STATUS_PURGE | Purges order release status records with a quantity of 0. | 30 |
PICKLISTPRG | Purges pick list information. | 30 |
SHIPMENTHISTPRG | Purges shipment information from the shipment history tables. | 30 |
SHIPMENTPRG | Purges shipment information and archives it in the history tables. | 30 |
DRAFTORDERNOLINEPRG | Purges draft orders that do not have any order lines. | 30 |
DRAFTORDERNOLINEHISTPRG | Purges draft orders without any order lines from the history table. | 30 |
DRAFTORDERHISTPRG | Purges draft order information from the draft order history tables. | 30 |
DRAFTORDERPRG | Purges draft order information and archives it in the history tables. | 30 |
Table 2 lists the purge rules provided for the opportunity document type in Sterling Selling and Fulfillment Foundation.
Rule | Description | Default Retention Days |
---|---|---|
OPPORTUNITYPRG | Purges opportunity information and archives it in the history tables. | 30 |
OPPORTUNITYHISTPRG | Purges opportunity information from the opportunity history tables. | 30 |