ExFlow AP - Clean up duplicate attachments
Class
EXF_cDocuRefCleanup
Affected tables
- DocuRef - duplicate attachment references are deleted.
Functional explanation
The job reviews attachments connected to qualifying posted journals. It keeps the attachment identified as the invoice attachment. Another attachment is removed only when the same file is already owned by another voucher, indicating duplicate ownership.
Important note Dry run is enabled by default. In dry-run mode, the job reports what would be removed without deleting it.
| 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 |