using sql, is there a builtin function that i can display another field instead of the display name?

AI generated answer (using internal Slack threads):

In SQL, there is a built-in function that allows you to display another field instead of the display name. This function is called

BUILTIN.DF()

. This function returns the display value of a field from the target record type without having to join the target record type explicitly. For example, if you want to get the display value of the 'receivablesaccount' field from the 'customer' table, you can use the following SQL query:

sql
SELECT BUILTIN.DF(receivablesaccount) FROM customer WHERE id = 3231

This will return the display value of the 'receivablesaccount' field for the customer with the ID of 3231. Please note that this function is specific to NetSuite's SQL implementation and may not be available in other SQL dialects. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******