Purpose of this query
This SuiteQL statement provides a clean inventory of active custom lists from the CustomList table. It returns the list name, description, script ID, owner (display name), and whether the list is ordered. Use this report to audit configuration, confirm ownership, document business logic tied to lists, and compare environments such as sandbox versus production. By filtering to IsInactive = ‘F’, the query focuses only on lists currently in use.
SuiteQL
SELECT
Name,
Description,
ScriptID,
BUILTIN.DF( Owner ) AS Owner,
IsOrdered
FROM
CustomList
WHERE
( IsInactive = 'F' )
ORDER BY
Name;
Sample Output
How the query works
Reading custom list metadata
The query selects from the CustomList table, which stores definitions for all custom lists in NetSuite.
Returning key configuration fields
Name shows the list label.
Description provides context or business purpose.
ScriptID is the technical identifier used in SuiteScript and integrations.
BUILTIN.DF(Owner) converts the internal owner ID into a readable name.
IsOrdered indicates whether the list values are manually ordered.
Filtering to active lists only
The WHERE clause excludes inactive lists so the report reflects only lists currently available in the account.
Sorting alphabetically
ORDER BY Name makes the output predictable and easy to review or compare across environments.
Why this report is useful
• Configuration governance: quickly see which custom lists exist and who owns them.
• Environment comparison: export from multiple accounts and compare by ScriptID to detect differences.
• Cleanup initiatives: identify outdated or unused lists (by temporarily removing the inactive filter).
• Integration validation: confirm ScriptID values referenced in SuiteScript or external integrations.
• Documentation support: maintain an up-to-date catalog of business-controlled list values.
Customization notes
• Include inactive lists: remove the WHERE (IsInactive = ‘F’) filter.
• Filter by owner: add WHERE Owner = <internal_id>.
• Join to list values: join to the custom list value table if you need to audit list entries.
• Add last modified date: include lastmodifieddate if you want to track recent changes.
• Export to Excel and group by Owner to see which teams control which lists.