NSC | SuiteQL: How to Get the List of Existing Transaction Types Being Used in a NetSuite Account

Scenario:

A NetSuite Client wanted to filter transactions based on their types via SuiteQL, that will later be a basis for their other business processes.

Solution:

Sample query that can be used as a reference:

SELECT DISTINCT type, BUILTIN.DF(type) as type_description FROM transaction;

The sample code described herein is provided on an "as is" basis, without warranty of any kind, to the fullest extent permitted by law. Oracle + NetSuite Inc. does not warrant or guarantee the individual success developers may have in implementing the sample code on their development platforms or in using their own Web server configurations.