Finding Record Type and Field Names

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 

        

To create a query using SuiteQL, you must know the names of the record types and fields that you want to use in your query. You can find these names in several ways:

• Using the NetSuite UI

• Using the SuiteAnalytics Workbook UI

• Using the Export Option from SuiteAnalytics Workbook

• Using the Records Catalog

Related Topics

• Using SuiteQL
• Using SuiteQL with the Connect Service
• Using SuiteQL with the N/query Module in SuiteScript
• Using SuiteQL with SuiteTalk REST Web Services

General Notices