Is there a way to get the

fxreval

transaction detail lines through SuiteQL (i.e. what gain/loss has been applied to each invoice/payment). There doesn't seem be a table that contains that detail

You can get join the

TransactionAccountingLine

table to get the GL impact but I'm not sure if you can do better.