Hello, I am trying to put together a list of all of the columns available on a Vendor returned from a search in a Schedule Event script (and whether or not the available columns are required). I am basing my current attempts on this document: http://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2018_1/script/record/vendor.html . It seems that in this document, all of the columns available on a vendor returned from a search would be in the “Fields” table. However, I know that is not the case, because

address

is available (I discovered this field from the “Search Columns” table and I was able to get it as a column on a vendor record in the script.) In addition, many of the columns from the “Fields” and “Search Columns” table result in something like a “SSS_INVALID_SRCH_COL” error… Is there a reliable way to know what all of the available columns are, (and whether they are required) from this document? If not, where can I get this information? Any help would be really appreciated.

I would not trust the record browser for this task

I can see why. What would you use?

Create the search in the ui

Hm okay

I truly hope you don't have to get multiple joins

Lol I have no idea if I do

I recommend using the Chrome Search Export Extension

I will look into that as well. Thanks

@John-Paul Jorissen that plugin is awesome! However take into account that it only shows the fields that has a value setup, on the URL record that you want to check, add this at the end: &xml=T , then you will get more fields even if they do not have a value setup. good luck!

@eminero I’m not entirely sure what you mean when you say “has a value setup”

by 'value setup' I think he means columns added to the search results tab

@John-Paul Jorissen what I meant was if the field is empty the plugin will not list that field, only fields with a value will be displayed.

Keep in mind that record fields are not the same as search fields. There is some overlap but not everything you see with

&xml=T

is searchable, and there are additional fields you won't see there. The record browser documents search fields seperately from record fields.