What Fields Can I Use in my Search?

ve you memorized all 150 native record types and all their hundreds of fields, sublists, joins, filters, and columns yet?

I hope not. If you have, please write in and tell me how you did it; the mnemonic device for that would have to be insane!

I don’t have a good way of keeping all that information in your head, so instead, you’re much better served by getting really, really good with NetSuite’s Records Browser.

In case you’re not familiar, the Records Browser is NetSuite’s published schema for all of the native Fields, Sublists, Search Joins, Search Filters, and Search Columns available on each and every native Record Type. It tells you each field’s default UI label, its field type, its script internal ID, whether it is mandatory, and whether it is inline editable.

You need all of this information, and the know-how to apply it, in order to build effective searches in SuiteScript.

To brush up on how to use the Records Browser, I recommend you read through the following:

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Related posts

January 7, 2021

Anything I wrote today about business would both feel and be inadequate. I simply can’t arrive at the words to express how I feel in this moment. So instead, here are a few helpful ...

Read More

December 20, 2020

2020 was a hundred swift kicks to the shorts and one giant kick in the ass. If you’ve lost people you love, if you’ve gotten sick or hurt, if you’ve lost your job, if ...

Read More

December 16, 2020

“I’ve been meaning to learn SuiteScript, but it’s hard to find the time …”“We’re slammed, and I just don’t have the time …”“I haven’t made the time …” All are variations of a theme ...

Read More

December 14, 2020

Last week we looked at mimicking the functionality of a REST endpoint with its own module (e.g. retrieving a User, or a list of Users, refreshing a token, etc). For complex integrations that rely on a large ...

Read More