Vendor Administrator Purge Inactive APEI Records overview

Vendor > Administration > APA Reports > APAP

Function acronym: APAP

Use this report to remove inactive internal APEI and subordinate records created in Vendor Invoice Center Entry from the database.

Each APEI record can have these subordinate records:

  • APEIA: Stores information about addons that were part of the AP invoice.
  • APEID: Stores information about purchase orders that were costed against the AP invoice.
  • APEIS: Stores the serial numbers that were received in an EDI 810 invoice document, or manually entered in Vendor Invoice Center Entry. The serial numbers apply to Direct Order purchase orders only.
  • APEIL: Stores information about lot products that were entered in Vendor Invoice Center Entry. The lot numbers apply to Direct Order purchase orders only.
  • APEIG: Stores the general ledger postings for the AP invoice.
  • APEIE: Stores the exceptions that were found when the AP invoice was processed.

If these conditions are met, the APEI and subordinate records are deleted:

  • The APEI record is inactive.
  • The subordinate records are inactive.
  • The APEI records that have the same group name and group sequence number are inactive.

Use these ranges to determine which inactive records to delete: Group Name, Created Date, and Vendor Number. This report does not have options.