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. The submitted job does not produce 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 chapter:

• Purge Orders Screen (MPOR)

• Order-Related Tables

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.

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 History1	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
On Line Authorization	CCOLAT
Order Additional Charge	OEOADC
Order Broker	oeorbk
Order Broker History	oeorbh
Order Contribution	OEOCFP
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 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

---

1. 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.