how to get 'text' with N/query module after using SQL query? in defualt i get just values

BUILTIN.DF( Transaction.Status ) AS OrderStatus

The BUILTIN.DF(FIELD) should get you the text

BUILTIN.DF(customer.receivablesaccount) didnt work

var sql = 'select BUILTIN.DF(receivablesaccount) from customer where id = 3231'
var results = query.runSuiteQL({query: sql, params: []}).asMappedResults()

Can you enter an example customers ID in the

3231

and try this? It returned the string name like I would expect and not the account ID.

it may not be true, but in my head I think of the

DF

as meaning Display Field

They define it as `Returns the display value of a field from the target record type without having to join the target record type explicitly`` , so I'm assuming they decided it's Display Field