NetSuite Admin Tip | Display Values from the Transaction Record Using SuiteQL BUILTIN.DF

When working with the Transaction record in SuiteQL, some fields return internal values that are not easily understood at a glance. For example:

• The Status field may return a single-letter code.
• Fields like Entity, Employee, and LastModifiedBy return internal IDs.
• The Type field displays abbreviations like SalesOrd or PurchOrd.

These internal values are meaningful to the system but not very useful to end users or admins reviewing query results.

To improve readability, you can use the BUILTIN.DF() function, which translates internal IDs and codes into display-friendly (DF) values—such as customer names, employee names, or transaction types.

Here’s an example query that pulls data from the