I have a query where I want to get the location in the transaction records, but I get an error “Unknown identifier ‘LOCATION’“, despite location being a field in the transaction record if I just query for a given transaction. What I really want is to handle location like I am handling entity, but I don’t understand why it’s working for entity but not location. Anybody have any insight?

"SELECT id, tranid, location, entity, BUILTIN.DF(entity) AS entity_name FROM transaction WHERE type = 'SalesOrd'"