Hi. I am able to find payment records using the

nexttransactionlinelink

table, but how can I see what account the payment is assigned to?

you want to join transactionline and look for expenseaccount on the joined transactionline.