Previous  Next          Contents  Index  Navigation  Glossary  Library

Payables Open Interface Purge Program

Use the Payables Open Interface Purge Program after you have submitted Payables Open Interface Import program. This program purges records from the Payables Open Interface tables (AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE). You can either purge only invoices that you have successfully imported, or you can enter Yes for Purge All to purge all records in the table that match the Source and Group parameters you enter.

Report Submission

You submit this program from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.

Selected Report Parameters

Source. Choose the source of the invoices you want to purge from the list of values. Use EDI Gateway, or a Source type QuickCode you defined in the Payables QuickCodes window. The source must exactly match the Source in the Payables Open Interface tables. This parameter is required.

Group. (Optional) To limit the purge to invoices with a particular group, enter the GROUP_ID. The Group must exactly match the GROUP_ID in the Payables Open Interface tables. You can purge data in concurrent processes for the same source by specifying a unique Group for each request. This will reduce the time of your purge process. The Payables Open Interface Purge Program purges data with the source and group combination you specify.

Purge All. Enter Yes if you want to purge all records in the Payables Open Interface tables that match the Source and Group you enter above. These records include successfully imported records, records rejected during import, and records that you have not tried to import yet. Enter No if you want to purge only records that have been successfully imported.

See Also

Payables Open Interface Import

         Previous  Next          Contents  Index  Navigation  Glossary  Library