Purge Transactional Orphan Entries

Purge Transactional Orphan Entries is initiated from the Supplementary Purge using Request Type "PTOE”

This function removes unreferenced entries from the following tables whose end date is older than the cutoff date:

  • Resources (RSRC_T)
  • Tender Request Resources (TDR_REQ_RSRC_T)
  • Charge Details (CHRG_DETL_T)
  • Transport Orders (TRPT_ODR_T)
  • Driver Activity (DRVR_ACTY_T)

To improve performance, TM will sometimes update transactions to indicate that they are eligible to be purged rather than performing a physical delete of the row. The Purge Transactional Orphan process will handle the formal removal of these rows that are marked for deletion.

See Also