If the CLASS field is on the header and therefore in transaction table, has anyone found it? Its on the lines but not on transaction. Any idea how to go from transaction to the header class via SuiteQL?

It will be in transactionline table with mainline = T

Thank you works like a treat