NetSuite: SuiteQL and Accounting Lists

I was recently giving a NetSuite partner a SuiteQL consulting session. During the session, one of developers asked if it was possible to query the table that international commercial terms are stored in. International commercial terms (also referred to as "incoterms") are used on transfer orders to indicate where a customer legally takes ownership of the products. You can learn more about NetSuite's support for In-Transit Ownership by clicking here.

Incoterms is just one of several lists that NetSuite refers to as Accounting Lists. Assuming that you have permission to manage the lists, you can get to them by navigating to: Setup > Accounting > Accounting Lists

You can use SuiteQL to query these lists, and each list is stored in its own table. For example, the Incoterms values are stored in a table named "Incoterm."

This query...

SELECT
	*
FROM
	Incoterm

... returns this result.

Click the image to view a larger version.

Here's a list of some of the other accounting lists (and their corresponding table names) that you can query with SuiteQL.

Note that some of the tables listed above might not be available in your NetSuite instance. It depends on how your instance is configured.

Also, if you are querying these tables via an integration, the role that you're using will need the following permission: Setup - Accounting Lists