those column names don't exist on the transaction table there's a

toSubsidiary

which might be what you need, but based on my test account data, that's not what you want at all, its probably only used for ICJEs or something there's also a

subsidiary

column on the transactionLine table - that might just make things MORE complicated, but that's probably what you need. there's also a

foreignAmountUnpaid

on the transaction table, but I have no idea what that column even is, but it does seem to have data that looks right, again at least in my toy testdrive account - if you have multicurrency I wouldn't trust this at all 🙂