Anyone know why the SuiteQL query

select location from transaction where id = xxxxxx

results in “Unknown identifier ‘location’“? Record browser (analytics) shows that should be a column. Also,

select *

doesn’t show it. Trying to

join

with

transaction

and include the location column results in “Field ‘location’ for record ‘transaction’ was not found. Reason: REMOVED - Field is removed”