Hello, I am trying to get journals that have the name or entity field filled on the lines, I tried this

select * from transaction where type = 'Journal' AND entity IS NOT NULL;

but it doesn't return anything. I guess the lines are not in the

transaction

table, correct?

Transactionline

Got it, thanks. This is what you can find in the table reference in the SuiteQL plugin, not sure why it has a different id, or maybe this is a totally different table.