Purging Orders (MPOR)
Purpose: Use the Purge Orders screen to purge closed and canceled orders that have been inactive for a given period.
Which orders are purged? In addition to being closed or cancelled, the order must:
-
not have had any activity for the Order Purge Days (C62) defined in the System Control table. For example, if the order purge days is 365, a closed or canceled order will be eligible for purging if the order has not been entered, shipped, or maintained for one year. The system checks the Order date from the Order Header table and the dates from the Order Transaction History table for the most recent activity.
-
not have any pending returns or refunds.
Additional purge option: You can also use the PURGEOR periodic function. This function also uses the rules described above to determine whether an order is eligible for purge.
Purged Order List? If you use the PURGEOR periodic function and set the function’s Parameter to Y, the submitted job also produces the Purged Order List when you use the Purge Orders Screen (MPOR).
Purging an individual order: To purge an individual order, use the Purge Orders by Order Number (MORP) option. With this option, you can delete an order even if there has been activity more recently than the Order Purge Days (C62).
Updated tables: See the Order-Related Tables for a listing of the tables purged through the Purge Orders Screen (MPOR), the Purge Orders by Order Number (MORP) option, or the PURGEOR periodic function.
The system does not delete the customer's order, item, or correspondence history; you can review this information through the Work with Customers function.
Note:
When you purge orders through the Purge Orders screen or the PURGEOR periodic function, the system does not create records in the Deleted Order Table.
In this topic:
For more information: See:
-
How to Schedule a Job for information on scheduling a periodic process that includes the PURGEOR periodic function
-
Working with Periodic Functions (WPER) for information on setting up periodic functions
-
Purge Orders by Order Number (MORP) for information on the screen you can use to purge individual orders
Purge Orders Screen (MPOR)
How to display this screen: Enter MPOR in the Fast path field at the top of any menu or select Purge Orders from a menu.
Field | Description |
---|---|
Purge date |
The system subtracts the Order purge days from this date to calculate a cutoff date for purging orders. For example, if the purge date is 9/30, and the order purge days are 30, the system subtracts 30 days from 9/30 to arrive at a cutoff date of 8/31. Closed and canceled orders that have not been entered, shipped, or updated in any way since the cutoff date will be purged. See the discussion above under Purging Orders (MPOR) for more information. The system defaults the current date into this field; however, you can override it with an earlier date. Numeric, 6 positions (in user date format); required. |
Order purge days (Highlighted number in the narrative on the center of the screen) |
The number of days an order must have been inactive since the purge date to be eligible for purging. From the Order Purge Days (C62) system control value. Numeric, 7 positions; display-only. |
Completing this screen: Optionally, enter an earlier date in the Purge date field and click OK, then select Accept. The system submits the ORDER_PURG job and returns you to the previous screen. This job purges all orders inactive since the calculated cutoff date (Purge date - Order purge days).
Note:
This job does not update the Deleted Order Table.
Possible errors: The screen might display an error message if, for example, there is a communication failure with EFTConnect. In this case, because payment-related records for orders cannot be purged, the order purge fails. See the Payment Configurations screen in Modern View for background.
Order-Related Tables
Purpose: The system purges records in the following order-related tables when you use the PURGEOR periodic function, the Purging Orders (MPOR) option, or the Purge Orders by Order Number (MORP) option.
Table Name | System Name |
---|---|
AA Void |
AAVOID |
Authorization History |
AUTHHS |
Auto Soldout |
CSAUSO |
Backorder Cancellation Pending |
BOCANP |
Carton Contents |
CartonContents |
CC Deposit History |
CCDPHI |
Correspondence History Note: The associated record in this table and in the Correspondence History Detail table are not deleted; however, the system deletes the order number. The correspondence history is still available for review by inquiring on the customer(s) on the order. |
MSCOHS |
Customer Sold To Promotion |
OECSPR |
Drop Ship Pending |
FLDSPN |
Drop Ship Work |
DRPSHW |
Expected Ship Date |
CSEXSD |
Invoice Address |
OEINAD |
Invoice Cross Reference |
FLINXR |
Invoice Currency |
MSINCU |
Invoice Detail |
OEINDT |
Invoice Detail Charge |
INIDCP |
Invoice Detail Cost |
INIVCP |
Invoice Detail Pay Method |
CSINDP |
Invoice Header |
OEINHD |
Invoice Payment Method |
CSINVP |
Invoice Ship To |
OEINSH |
Manifest |
FLMANF |
Narvar Export Errors |
INT_NARVAR_EXPORT_ERROR |
On Line Authorization |
CCOLAT |
Order Additional Charge |
OEOADC |
Order Orchestration |
oeorbk |
Order Orchestration History |
oeorbh |
Order Coupon Discount |
OEOCDP |
Order Cross Reference |
OEORXR |
Order Detail |
OEORDT |
Order Detail Coupon |
OECPDC |
Order Detail Deal Audit |
OEDDAU |
Order Discount Audit |
OEODIS |
Order Free Gift |
FREGFT |
Order Header |
OEORDR |
Order Header Extended |
OEOHEP |
Order Header User Field |
OEORHU |
Order I/T Line |
CSIOTL |
Order Line History |
OEOLHS |
Order Line Message |
OELNMS |
Order Message |
OEOMSG |
Order Payment History |
OEPAYH |
Order Payment Method |
OEPAYM |
Order Promotion |
OEORPR |
Order Ship To |
OEORST |
Order Ship To Address |
OEOSTA |
Order Shipment Details |
ORDER_SHIPMENT_DETAILS |
Order Special Format |
OESHFM |
Order Special Handling |
OESHIN |
Order Transaction History |
OEOTHI |
P/O Detail D/S Order |
PODTDS |
Pick Slip Gen Sel Order |
PSGORD |
RA Detail |
CSRADT |
RA Exch Payment Method |
CSRAPM |
RA Exchange Item |
CSRAXI |
RA Header |
CSRAHD |
Refund |
CSRFND |
Refund Message |
CSRMFF |
Return Notifications |
OERSCP |
Refund Print |
CSRFPT |
Refund Print Detail |
CSRDTP |
Reserved Order Line |
FLRSOL |
Sold Out Notification |
SONTFY |
Stored Value Card |
OESVCD |
Tax Exception |
OETXEX |
Tickler |
MSTKLR |
Tickler History |
MSTKHS |
Variable Set Order Hold |
VSHOLD |
WMS Carton Header Detail |
WMCAHD |