Cancelled Orders Purge (OEDOA1.PURGE)

The Cancelled Orders Purge (ibis_oedoa1.purge) table allows you to purge cancelled orders. Once the cancelled orders are purged, all data is removed from the following cancel order archive file(s):

  • OEDOA1 - Canceled Order Archive Header
  • OEDOA2 - Canceled Order Archive Header 2
  • OEDOAC - Canceled Order Archive Comments
  • OEDOAD - Canceled Order Archive Detail
  • OEDOAM - Canceled Order Archive Manual Ship To's
  • OEDOAN - Canceled Order Archive Notes
  • OEDOAP - Canceled Order Archive Products
  • OEDOAS - Canceled Order Archive Supplementary Charges

To purge cancelled orders:

  1. Select the criteria for the cancelled orders you want to purge.

  2. If you are purging a single order, using the Use Row as Criteria for Action icon next to the order to be purged, select the Delete option.

  3. If you are purging multiple orders, click the Select All Rows check box to select all rows or select the check box for each individual order you wish to purge.

  4. Once the orders are selected, click on the Use Selected Rows as Criteria for action icon at the top of the grid and select the Delete option.

  5. A confirmation message displays: "Are you sure you want to delete these records? Yes/No". Click Yes to delete the record(s) or click No to cancel the transaction.

The following list defines every field available in the Cancelled Orders Purge (oedoa1) table in alphabetical order; the value for each field is taken from the cancelled sales order, if applicable:

  • Accept Backorders

  • Cancellation Reason Code

  • Cancelled By

  • Cancelled On

  • CM Contact Key

  • Comment Details

  • Company

  • Customer

  • Customer PO Number

  • EC Order Number

  • Has Order Been Scheduled?

  • Import Order

  • Invoice To

  • Last Used Line Number

  • Lock ID

  • Manual Hold Held By

  • Manual Shipping Document Number

  • Order Lock

  • Order Type

  • Product Details

  • Reorder

  • Review Flagged Order Cleared

  • Revised By

  • Sales Order Number

  • Sales Rep 1

  • Ship B/O Complete?

  • Ship Complete Order

  • Ship Via

  • Shipping Document Number

  • Summary Invoice Type

  • Supplementary Charge Details

  • Tax License 1

  • Tax License 2

  • Trade Show

  • Whse

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.