I have some custom fields defined on the item object in my Netsuite but I don't see them appearing in SuitQL response. I do see the custom fields in the REST API responses. What could be the reason?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** The issue you're experiencing with not being able to see custom fields in SuiteQL responses, while they are visible in REST API responses, could be due to a few reasons: 1. Unsupported Fields: Not all fields are supported in SuiteQL. If the custom fields are not in the list of supported fields, they won't be accessible via SuiteQL. You can confirm this by using the Dataset Builder in NetSuite which provides a searchable list of fields. 2. Non-Stored Value Fields: If the custom field is a non-stored value field, you would need to repeat the lookup in the query. For example, if sourcing and filtering is set to Customer : Field, you would have to join on the entity and pull in that field in the query from the Customer table, and not rely on the custom field you created. 3. Permissions Issue: There could be a permissions issue preventing you from accessing the custom fields via SuiteQL. You can check this by navigating to Setup > Records Catalog in NetSuite and switching over to the “Fields” search to see if the field is missing. If none of the above solutions work, it's possible that there's a limitation with SuiteQL in accessing certain custom fields.

How do I know if they are non stored value fields?