Draft order purge

This purge archives data into history tables after a specified interval, which in turn, reduces the load on frequently accessed tables. For information about purging draft orders from history tables, see Draft order history purge.

Sterling™ Order Management System does not provide a transaction for draft order purges. If you are defining a transaction that purges draft orders, refer to the following Criteria Parameters section for details about the transaction criteria.

If you do not want to define your own transaction to purge draft orders, you can use the Order Purge transaction and specify DRAFTORDERPRG for the PurgeCode. To configure the Order Purge transaction for draft order purges, refer to Order purge for more information.

All the enterprise using the Console must schedule purge transactions.

Draft orders are picked up by the agent for validation when the following conditions are met:

• Draft order flag is set to Y.
• Modifyts is set for the retention date.

After the draft orders are picked up, each draft order is validated for purging based on the following conditions:

• No eligible order release status records (records with a status larger than zero) exist for the order.
• All the open child orders (derived, chained, return, exchange, or refund fulfillment) for the order are already purged.

If a draft order meets the set of conditions for validation listed earlier, the agent continues to verify the draft orders against the following criteria:

• Contains the Draft Created (1000) status, and all the extended Draft Created statuses.
• Does not have an order release status record that does not meet the retention days.
• The order's last modification should be before the lead time (in days) setup.
• In the case when an exchange order is part of a return order, the exchange order should be purged from history tables before the return order is purged.
• In the case of an order line reservation, the draft order cannot be purged.
• If the Draft Order Payment Processing flag is set to N, the draft orders are purged.
• If the Draft Order Payment Processing flag is set to Y and a charge exists on a draft order, the draft order is not purged. However, authorizations are not considered when validating draft orders for purge.
• For order lines, except service order lines:
  • If the Seller inventory update is required, the Status Inventory Type has the Update Seller Supply option turned on, and the Seller Supply Type is Onhand, or blank. (The Seller Supply Type can also be a custom seller supply type, with the Onhand Supply check box enabled.)
  • If the Seller Demand Type is blank.
  • If the Buyer inventory update is required, and the Buyer Supply Type is Onhand, or blank.