Published on April 24, 2024.

The most commonly asked question that I get from NetSuite developers regarding SuiteQL is something along the lines of, "What table are {some transaction type} stored in?"

A lot of developers that I speak with are expecting to find specific tables for each transaction type. However, all NetSuite transactions are stored in a generic "Transaction" table, and are categorized based on their type.

Transaction Types In Your NetSuite Instance

To see a list of all of the types of transactions that are currently stored in your NetSuite instance, you can run this query.

SELECT DISTINCT
	BUILTIN.DF( Type ) AS Name,
	Type
FROM 
	Transaction 
ORDER BY
	BUILTIN.DF( Type ) 

The results will look something like this.

Identifying A Transaction's Type

If you have the internal ID of a transaction, but aren't sure of its type, then you can run a query like this to determine its type.

SELECT
	TranID,
	BUILTIN.DF( Type ) AS TypeName,
	Type
FROM 
	Transaction 
WHERE
	ID = 33213

Permissions

If you're querying the Transaction table via an integration, you'll need permission to query not only the Transaction table itself, but also the specific types of transactions that you want to access.

To query the Transaction table, you'll want to assign this permission: Transactions - Find Transaction

Then assign permissions for each transaction type that you want access to. For example, to query for Sales Orders, you'd assign: Transactions - Sales Order

For a list of tables and the permissions that are needed to access them, see: SuiteQL Tables & Permissions Reference

Other Transaction Table Resources

Here are some previous posts that discuss the Transaction table:
• Querying Transactions With SuiteQL
• SuiteQL, the Transaction Table, Statuses, and Built-In Functions