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 entitystatus, BUILTIN.DF(entitystatus)
- entitystatus returns the internal ID of each customer status.
- BUILTIN.DF(entitystatus) returns the display name of that status.
- GROUP BY ensures that you only get one row per unique status.
To easily execute a SuiteQL query, see NetSuite Admin Tip | Running SUITEQL Using a Suitelet