Import history data clean up
ExFlow | Periodic tasks | Clean up | Import history data clean-up
Purpose
The Import History Data Clean-up process focuses on managing the XML files associated with invoices in the import history. This batch aims to enhance database efficiency by cleaning up unnecessary XML data.
Step by step process
Invoice history batch data clean-up
- Go to ExFlow – Periodic tasks – Clean up – Import history data clean-up.
- Input days which are required for the clean up in the History limit(days).
- Enable Batch processing.
- Select
OK
After batch processing is completed lines in line history is deleted.
Class
EXF_cImportTableLogCleanUp
Affected tables
- EXF_tImportTableLog - only the XML and XMLRaw field contents are cleared; the record itself remains.
Functional explanation
The job clears the XML and raw XML content from import history records older than the history limit. The import history record is retained, so users can still see that the import occurred, but the detailed XML payload is no longer available.
Important note The default history limit is 30 days. No records are deleted, and the XML-only behavior is fixed for this job.
| 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 |