Finding Record Type and Field Names in suiteQL

SuiteQL queries include references to record types and fields. For example, the following SuiteQL string queries for entityid field values that are included in employee records:

     SELECT employee.entityid AS entityidRAW FROM employee 

Using the SuiteAnalytics Workbook UI

You can use the SuiteAnalytics Workbook UI to find record type and field names. SuiteAnalytics Workbook uses the same data source that SuiteQL does (the analytics data source), so you can use the SuiteAnalytics Workbook UI to explore the available record types and fields before you create your query.

To find record type and field names using the SuiteAnalytics Workbook UI:

1. In your NetSuite account, click the Analytics tab in the NetSuite navigation menu.
2. On the Workbooks page, click New Workbook.
3. Search for the record type that you want to use as the root record of your query.
4. The name of each supported record type is listed in the Record ID column. You can use this page to find all supported record type names, but you cannot use this page to find field names. If you need to find field names, continue to step 4.

Click a record type. A workbook is created with the selected record type as the root record.

The left column lists the record types that you can join with the root record. The middle column lists the fields that are available on the selected record.