Affiliates mark as paid

When marking an affiliate as paid does the individual transactions in the DB get marked as well? Is there a reference of some sort? If so can you point me in the right direction in the mapping? The reason I ask is we are trying to wrap our head around accounting and so far if there is a discrepancy there is no way to look up on an individual transaction basis. It would be helpful if this data was available to admins and also affiliates. As well as be able to show on an individual transaction basis if there was a charge back or any other issues. If the data is in the database I will have a local dev here create the reporting needed, I just need to know if it is in fact there.

Thank you