Purging Joint Venture Transactions

You use the Purge Joint Venture Transactions program (R09J403) to purge Joint Venture Account Ledger (F09J11) and related Joint Venture Distribution Detail (F09J12) records. The program purges only those selected records that fulfil these criteria:

  • The transaction status for the joint venture account ledger records in the F09J11 table = Process Complete

  • The transaction status for the related distribution records in the F09J12 table = Process Complete

  • There is no record in the F0911 table for the selected F09J11 records

When you process records to purge, the system also purges the media objects from the F09J11 and F09J12 tables that are associated with the records. The system prints a report with the number of F09J11 records that are purged successfully.