in suitesql how can i get the field ID and the display text

AI generated answer (using internal Slack threads):

In SuiteQL, you can get the display text of a field by using the

BUILTIN.DF()

function. This function returns the display value of a field from the target record type without having to join the target record type explicitly. Here is an example of how you can use it:

sql
SELECT BUILTIN.DF(Transaction.Status) AS OrderStatus
FROM Transaction

In this example,

BUILTIN.DF(Transaction.Status)

will return the display text of the

Status

field from the

Transaction

record. Similarly, if you want to get the field ID, you can directly select that field from the record. For example:

sql
SELECT Transaction.Status AS StatusID
FROM Transaction

In this example,

Transaction.Status

will return the internal ID of the

Status

field from the

Transaction

record. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******