Can some tell me how to get body level field location When I am querying in transaction record where type is sales order? I can get the name of the location by joining the location record, but I am not even getting the internalid of the location from the below query

SELECT
    t.id,
    t.location
FROM
    transaction as t
WHERE
    t.type = 'SalesOrd'
    AND BUILTIN.DF (t.status) IN ('Sales Order : Pending Fulfillment')

An error is coming

Search error occurred: Field 'location' for record 'transaction' was not found. Reason: REMOVED - Field is removed

You need to get the

location

from

transactionline

that is

mainline

Thank You, worked