How to query CustomerGroupPricing table with suiteql?

AI generated answer (using internal Slack threads):

To query the CustomerGroupPricing table with SuiteQL, you would need to construct a SQL-like query. However, it's important to note that NetSuite's database schema is not publicly available, and the CustomerGroupPricing table is not directly accessible via SuiteQL. You can only query tables and fields that are exposed to SuiteQL. You can find the list of accessible records and fields in the NetSuite Records Browser. Here is a general example of how to construct a SuiteQL query:

sql
SELECT field1, field2, field3
FROM tableName
WHERE condition

Replace

field1

,

field2

,

field3

with the actual field names you want to select,

tableName

with the actual table name, and

condition

with your actual condition. Please note that you might need to join multiple tables to get the desired information if it's not available in a single table. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

Whenever I use the field name “level” or “group” the query crashes