Print Purged Coupons Report | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Flag Orders for Purge Screen (FORP) |
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.
• not have any A/R open items in an open status, with the exception of deferred liability (DL) open items created because of cash payment methods.
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 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
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 |
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 (MMDDYY 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.
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 |
Gift Certificate |
OEGFCT |
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 Pending Check2 |
OEPNCK |
Order Promotion |
OEORPR |
Order Rewards Certificate |
OERWCT |
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 |
Phone Error |
PHERRS |
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 |
Store Restock Confirm |
INSTRC |
Stored Value Card |
OESVCD |
Tax Exception |
OETXEX |
Tickler |
MSTKLR |
Tickler History |
MSTKHS |
Variable Set Order Hold |
VSHOLD |
WMS Carton Header Detail |
WMCAHD |
Print Purged Coupons Report | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Flag Orders for Purge Screen (FORP) |
MPOR OROMS 5.0 2018 OTN