ExFlow AP - Log cleanup
Class
EXF_cLogCleanup
Affected tables
- EXF_tLoggingWeb - web log records are deleted for the selected date range.
- EXF_tDocumentLineApproverLog
- EXF_tDocumentLineDimensionLogHead
- EXF_tDeletedLinesInvoiceHistory
Functional explanation
This job has two cleanup areas. It removes web log entries within the date range entered by the user. It also removes older document-related approval, dimension, and deleted-line history based on the selected number of years. For document-related history, cleanup is performed only when newer rows exist for the same document context.
Important note Web logs use a From date and To date. Document-related history uses a years-based retention value, with 10 years shown as the default.
| Name | Class | Affected Table |
|---|---|---|
| ExFlow AP - Log cleanup | EXF_cLogCleanup | EXF_tLoggingWeb EXF_tDocumentLineApproverLog EXF_tDocumentLineDimensionLogHead EXF_tDeletedLinesInvoiceHistory |
| ExFlow AP - Import history data cleanup | EXF_cImportTableLogCleanUp | EXF_tImportTableLog (Only the contents of the XML / XMLRaw fields are cleaned for old records) |
| ExFlow AP - Web log cleanup | EXF_cWebLogCleanup | EXF_tLoggingWeb |
| ExFlow AP - Invoice line history cleanup | EXF_cInvoiceLineHistoryLogCleanup | EXF_tDocumentLineApproverLog EXF_tDocumentLineDimensionLogHead EXF_tDeletedLinesInvoiceHistory |
| ExFlow AP - Delete temporary journals separately | EXF_cNoPostingAtArrivalDeleteTempJournals | LedgerJournalTable (Related journal transaction data is deleted indirectly through the standard LedgerJournalDeleteTransaction process) |
| ExFlow AP - Clean up duplicate attachments | EXF_cDocuRefCleanup | DocuRef |