NetSuite Admin Tip | SuiteQL: Getting the List of Customer Statuses

In NetSuite, each customer record is assigned a status—such as Qualified, Close Won, or Renewal—based on their position in your sales pipeline. These statuses are stored internally using numerical IDs, which can be unclear when building reports or SuiteQL queries.

To help with this, you can use the SuiteQL query below to generate a list of customer statuses. It allows you to easily reference the internal IDs alongside their display values—making it especially useful for reporting, scripting, or understanding your data structure.

SELECT 
  entitystatus AS Customer_Status_ID,
  BUILTIN.DF(entitystatus) AS Customer_Status
FROM 
  customer
GROUP BY