Skip to main content

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.

NameClassAffected Table
ExFlow AP - Log cleanupEXF_cLogCleanupEXF_tLoggingWeb
EXF_tDocumentLineApproverLog
EXF_tDocumentLineDimensionLogHead
EXF_tDeletedLinesInvoiceHistory
ExFlow AP - Import history data cleanupEXF_cImportTableLogCleanUpEXF_tImportTableLog (Only the contents of the XML / XMLRaw fields are cleaned for old records)
ExFlow AP - Web log cleanupEXF_cWebLogCleanupEXF_tLoggingWeb
ExFlow AP - Invoice line history cleanupEXF_cInvoiceLineHistoryLogCleanupEXF_tDocumentLineApproverLog
EXF_tDocumentLineDimensionLogHead
EXF_tDeletedLinesInvoiceHistory
ExFlow AP - Delete temporary journals separatelyEXF_cNoPostingAtArrivalDeleteTempJournalsLedgerJournalTable (Related journal transaction data is deleted indirectly through the standard LedgerJournalDeleteTransaction process)
ExFlow AP - Clean up duplicate attachmentsEXF_cDocuRefCleanupDocuRef