When querying the

Transaction

and

TransactionLines

tables, is there anyway to figure out in SuiteQL what "Entity" is referring to? Sometimes it's vendor, sometimes it is something else...

You can join to the entity table and check the type

I seem not to be able to access the 'entity' table -- do you have any idea (if it's a permission issue) what permission that would be on a role?

Yup, that looks like a permission issue. Each entity type would be it's own permission (Lists > Customers, Lists > Suppliers, etc..)

Does this mean joining to 'Entity' would fail if any row in the results belongs to a list type that I don't have permissions to? Also, is it a fixed set of possible lists I would need permissions to in order to be able to consistently JOIN to entity?

My guess is that if you have permissions for some of the entity types you wouldn't get an error but will just get no results for records you don't have permission to

It does seem to be the case that the query fails (as in the screenshot above) even when I have access to some of the underlying lists (e.g. vendor, customer, employee, partner)

Do you have

Lists - Perform Search

permission?

Woah, that is a helpful post. I do not have 'Perform Search', will report back in a moment!