Hello experts, we are struggling to extract Currency Revaluation Transactions using SuiteQL queries. They are not in default transaction/ transaction-line tables. Though the transactions are recorded in those tables, amounts are null for them. Anyone here experience this before?? Any insights are helpful.

Looks like you can get amounts from the GL impact (transaction accountline)

SELECT BUILTIN.DF(transactionAccountingLine.account), transactionAccountingLine.amount
FROM
        transaction
        JOIN transactionline ON transaction.id = transactionline.transaction
        JOIN transactionAccountingLine ON  transactionAccountingLine.transactionline = transactionLine.id AND transactionAccountingLine.transaction = transactionLine.transaction
WHERE transaction.id = ?

Thanks @michoel yes, I found the same and data is reconciling 100%. It was bit tricky to found the amounts in this table. But all good. Thanks for response.