DB Management
Use this tab to manage the databases used by your Kofax AP Agility solution.
The database purging available on this tab does not apply to your vendor master data.
Depending on your configuration, the following groups may be available:
Database Tables |
Availability | Description |
---|---|---|
Invoice Status Entries |
Always available. |
Entries for each document are written to database tables related to the document status, field status, and any invalid reasons. |
Invoices in Workflow |
Available if there is at least one organization using an ERP connector. |
Entries are recorded in multiple tables whenever an invoice is passed to the AP Workflow. For solutions not using an ERP connector, such as Process Director or MarkView integrations, these tables remain empty. |
Master Data Import Log |
Available if there is at least one organization using an ERP connector. |
Entries are added each time the AP Data Import job is run. For solutions not using an ERP connector, such as Process Director or MarkView integrations, these tables remain empty. |
Invoice Export Log |
Available if there is at least one organization using an ERP connector. |
Entries are added each time a document is exported via an ERP connector. For solutions not using an ERP connector, such as Process Director or MarkView integrations, these tables remain empty. |
General Log Entries |
Available for OPMT and Azure environments only. |
This is a single table where log entries are written. |
The following settings are available for each of the above database table types:
- Number of Entries
-
The total number of entries in the database.
- Oldest
-
The date of the oldest record in the database.
- Newest
-
The date of the most recent record in the database.
- Automatic Purging
-
Enables you to configure automatic purging of the log. (Default: Cleared)
When selected, the following setting is displayed:
- Entries older than X days
-
Specify which entries are deleted automatically. For example, if you set the value to 7 then database entries older than 7 days will be purged regularly. (Default: 0)
The following buttons are available for the invoice status entries:
- Update
-
Applies any changes made to automatic purging.
- Purge Now
-
When you click this button, the Purge entries before setting is displayed so that you can enter a date.
The following buttons are available:
- OK
-
Immediately removes any records from the database that were written before the specified date.
It is not possible to remove entries from the Invoices in Workflow log that are still in progress. This means that records are removed only if an invoice is exported or canceled.
- Cancel
-
Cancels the purge request.