Hello, I am poking around with the various transactions tables in SuiteQL and I was wondering how to find out what currency a transaction is in?

I mean like….

SELECT currency FROM transaction WHERE id = 12345

??

You might not be necessarily, I am just starting out with SuiteQL so I am pretty clueless. I think I figured that there’s a currency table that I can join on transaction and get the currency by key

are you trying to get the name of the currency?