how to get all the custom field id and standard id of the item using suiteql

AI generated answer (using internal Slack threads):

To get all the custom field id and standard id of the item using SuiteQL, you can use the

CustomField

table. Here is a sample query:

sql
SELECT scriptid FROM CustomField WHERE fieldtype = 'COLUMN'

This query will return all the custom field ids (scriptids) that are of type 'COLUMN'. However, please note that not all fields may be accessible via SuiteQL. If a field is not listed in the searchable list of fields in the Dataset Builder, it is not supported in SuiteQL. Also, if you are trying to access a custom field and you get a 'field not found' error, it could be due to a permissions issue, or the field might be a calculated field or comes from somewhere else (i.e., if it's not stored on the record in the first place, just shown on that form). ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******