SuiteQL Overview

SuiteQL provides SQL-like query capabilities against NetSuite's record database via SuiteScript and REST API.

SELECT
  Transaction.tranid,
  Transaction.entity,
  TransactionLine.item,
  TransactionLine.amount
FROM Transaction
INNER JOIN TransactionLine ON
  Transaction.id = TransactionLine.transaction
WHERE Transaction.type = 'SalesOrd'
ℹī¸ Coming Soon
This appendix is under development. Full content will include comprehensive query examples and schema reference.

Query Syntax

SuiteQL supports SELECT, FROM, WHERE, JOIN, GROUP BY, ORDER BY, and subqueries. Uses analytical record names.

Joins & Relations

Join transaction headers to lines, entities to addresses, custom records to standard records.

Functions

Aggregate functions (SUM, COUNT, AVG), date functions (TO_DATE, ADD_MONTHS), string functions (CONCAT, UPPER).

Common Query Examples

Ready-to-use queries for sales analysis, inventory reports, AR aging, and financial summaries.