What does BUILTIN.DF mean in SuiteQL?

AI generated answer (using internal Slack threads):

In SuiteQL,

BUILTIN.DF

is a function that returns the display value of a field from the target record type without having to join the target record type explicitly. This is particularly useful when you want to retrieve the text representation of a select field, rather than its internal ID. For example, if you have a transaction record and you want to get the status as a text value, you can use

BUILTIN.DF(Transaction.Status)

in your SuiteQL query. Here is an example of how you can use it in a SuiteQL query:

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

In this example,

BUILTIN.DF(receivablesaccount)

will return the display value of the

receivablesaccount

field for the customer with ID

3231

. The exact meaning of

DF

in

BUILTIN.DF

is not officially documented by Oracle, but it is commonly thought to stand for "Display Field" or "Display Format". ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******