This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

When using SuiteQL, does anyone know what the "`DF`" stands for in `BUILTIN.DF()`?

my opinion/guess is that stands for "Display Format"

since it reveals the text 'display' version of a field value rather than internal id

That works for my purpose of associating it correctly in my mind

In a SuiteAnalytics API presentation back in SuiteWorld 2019, "DF" was described as "display field." But I like "display format" better!

yeah, I seem to recall 'display field' as well for some reason

any guesses for `CF`? I think in my head 'code format'

Per the documentation - `CF Sets the field usage context to CRITERIA`
So maybe Criteria... something?
I just dipped my toes into SuiteQL for the first time today so I have no idea what `<http://BUILTIN.CF|BUILTIN.CF>()` even does :slightly_smiling_face:

Just read some of tim's blogs, it'll be clear how its useful.

Oh, I'm on it <@U7XBU8Y3B>
Left Monitor - <@U856E2SEA>'s SuiteQL Query Tool
Right Monitor - <@U856E2SEA>'s  SuiteQL blog

yeah if the `C` in `CF` means 'criteria' no thanks - wouldn't be the first time NS docs don't make sense to me.