I need information from PM Apply to History and PM Paid Transaction History. I also want to get the account number in there that the transactions are posted to. There is a TRXSource field in the PM Paid Transaction History table that looks like the only possible conduit to the account number. Is there another table(s) to link to in order to get the account number?
I know it can be done from the PM Distribution History, I want the other 2 tables.