106 SuiteQL queries are currently available.

Account Subsidiary Map
Returns a list of general ledger accounts and the subsidiaries that they are mapped to.

Accounting Periods
Returns basic information about accounting periods.

Accounts Payable: Aging Details
Returns detailed Accounts Payable information based on a specific vendor.

Accounts Payable: Aging Summary
Returns summarized Accounts Payable information based on a specific vendor.

Accounts Receivable: Aging Details
Returns detailed Accounts Receivable information based on a specific customer.

Accounts Receivable: Aging Summary
Returns summarized Accounts Receivable information based on a specific customer.

Assembly Item With Components
Returns an Assembly Item and its components.

Bins: By Location
Returns a list of bins in a specified warehouse (location).

Bins: Content
Returns the contents of a specified bin.

Bins: Empty
Returns a list of empty warehouse bins.

BUILTIN.RELATIVE_RANGES Examples
Returns the start and end values for all relative date ranges that the BUILTIN.RELATIVE_RANGES function currently supports.

Company Contacts
Returns contacts associated with a specified company, including contact names and roles.

Company Features
Returns a list of NetSuite features that are avaialble and/or enabled in the account.

Countries
Returns a list of countries that NetSuite supports.

Currencies
Returns a list of currencies, with symbols, latest exchange rates, etc.

Currency Rates
Returns historical currency exchange rates.

Custom Fields
Returns all custom fields in the account.

Custom Lists
Returns all custom lists in the account.

Custom Record Types
Returns all custom record types in the account.

Custom Segments
Returns all custom segments, including the names of the tables in which the segment values are stored.

Customer Deposits
Returns all deposits received from a specific customer.

Customer Invoices: By Date Range
Returns all customer (accounts receivable) invoices for a given date range, with totals and statuses.

Customer Payments: Application Details
Returns the invoices to which a customer payment was applied, including sales order numbers, customer PO numbers, and the amounts applied.

Customers: Billing Addresses
Returns a list of customers and their default billto addresses.

Customers: Transaction Ledgers
Used for generatin a transaction ledger for a specified customer.

Customers: With Overdue Balances
Returns customers that have overdue balances.

Dates and Times: Creation Examples
Shows how you can create dates and timestamps based on strings.

Dates and Times: Format Models
Returns examples of datetime format elements.

Deleted Records
Returns information about records that have been deleted.

Employees: Emergency Contacts
Returns emergency contact information for employees.

Employees: Last Logins
Returns all employees that have NetSuite access, and the date/time that they last logged in.

Employees: No Recent Logins
Returns employees that have not logged in recently.

Employees: Roles and Permissions
Returns all employees, their assigned roles, and the permissions granted.

Employees: With Edit, View, Email URLs
Returns all employees, with edit, view, and email URLs in the results.

Entities: Types
Returns all entity types, with BUILTIN.DF and BUILTIN.CF values.

File Cabinet: Files By Name
Returns information about a file stored in the File Cabinet, based on a specified file name.

File Cabinet: Top Level Folders
Returns a list of folders in the root of the File Cabinet.

General Ledger Impact by Transaction Type
Returns all transaction types and the general ledger accounts that they post to.

General Ledger Transactions by Account and Date Range
Returns all of the transactions that were posted to a specified general ledger account in a specified date range.

Hello World
An obligatory "Hello World" query in SuiteQL fashion.

HTTP Requests - Outbound
Returns information about outbound HTTP requests being made.

Item Fulfillments: for Specified Sales Order
Returns all item fulfillments for a specified Sales Order ID.

Items: Aggregate Information by Location
Returns location-specific inventory information for a specified item.

Items: Customer Upsells
Returns a list of potential upsell items and item categories for a specific customer.

Items: Customers That Purchased A Specific Item
Returns a list of customers that purchased a specified item.

Items: Expired or Expiring Soon
Returns items that have expired, or are about to expire within a certain number of days.

Items: Frequently Sold Together
Returns a list of items that are frequently sold along with a specified item. This can be used to implement the "cross-selling" sales technique.

Items: Inventory Impact Transactions
Returns transactions that impacted an item's inventory level.

Items: In Alternate Warehouse Bins
Returns items that are in stock and stored in bins that are not the item's primary bin.

Items: Inventory Analysis
Designed for inventory analysis, this query returns active items, various quantities (on hand, committed, available, reorder point, preferred stock level), the preferred vendor, the average resale price and purchase cost, quantities sold (in the last 30 days, 90 days, year, and lifetime), and more.

Items: Item Group Members
Returns members of an Item Group, including their list prices.

Items: Item Group Prices
Returns the price for a specified Item Group.

Items: Item Groups
Returns a list of items that are setup as Item Groups.

Items: Item Information
Returns detailed information about items that have been created or updated in the past 7 days. Item information includes the preferred vendor. Used in project involving development of a custom Product Information Manager (PIM).

Items: Pricing
Returns price information, including price levels, for a given item.

Items: Item Types and Counts
Returns a list of the types of items that are setup, and the count for each item type.

Items: Returned Items by Date Range
Returns a list of items that were returned the most frequently in the previous year.

Items: Quantity Available Has Changed
Returns a list of items whose quantity available has changed since a specified date.

Items: Running Inventory Balance
Returns the running inventory balance for a specified item.

Items: Standalone Items
Returns a list of items that exist entirely on their own, independent of a parent or child item.

Items: Summarized by Type
Returns the number of active items group by item type.

Items: Vendors
Returns a list of vendors that can provide a specified item.

Items: With Expiration Dates
Returns items that have expiration dates.

Items: Without Preferred Bins
Returns items that do not have a preferred bin.

Journal Entries: In Date Range
Returns journal entry transactions in a given date range.

Journal Entries: With Details
Returns journal entry transactions in a given date range, with line level details.

Leads: For A Specific Sales Rep
Returns leads assigned to a specified sales rep.

Leads: Summarized by Sales Rep
Returns a summarized list of sales reps and the number of leads that they've been assigned.

Locations
Returns a list of locations, including the main address.

Matrix Items: Child Items by Parent
Returns all child items for a specified parent item.

Matrix Items: Child Items
Returns a child item and its parent item.

Matrix Items: Parent Items
Returns all parent items.

Packages: Pacejet Package Information
Returns information about item fulfillments and related Pacejet packages.

Pagination and Record Count Example
Returns paginated results that includes the total number of rows found.

Payment Methods
Returns a list of active payment methods.

Phone Calls
Returns calls related to a specific company, contact, etc.

Purchase Orders: Summarized by Status
Returns the various statuses of purchase orders, with the number of orders in each status, and the total amounts.

Purchase Orders: Item Receipts
Returns items that have been received against POs in a given date range.

Purchase Orders: Related Transactions
Returns a list of a purchase order's related transactions, including prepayments, item receipts, vendor bills, and more.

Returns Authorizations: In Date Range
Returns a list of Return Authorizations (RAs / RMAs) that have been issued in a specified date range.

Returns Authorizations: Summarized by Customer
Returns a list of Return Authorizations (RAs / RMAs) that have been issued in a specified date range, summarized by customer.

Returns Authorizations: Summarized by Item
Returns a list of Return Authorizations (RAs / RMAs) that have been issued in a specified date range, summarized by item.

Roles: Active Roles Not Used Recently
Returns the active roles that haven't been used in the past 90 days.

Roles: Active Roles And The Date Last Used
Returns all active roles, and includes the date that each role was most recently used.

ROLLUP: Oracle Command Example
Used to append a summary row to the result set.

Sales Order: With Sales Tax
Returns header-level values for a specified Sales Order, including the Tax Total value sourced from the related TransactionLine records.

Sales Orders: Shipped
Returns sales orders that shipped in a specified date range.

Sales Orders: Summarized by Status
Returns the various statuses of sales orders, with the number of orders in each status, and the total amounts.

Sales Orders: Top Orders for the Current Day
Returns the top sales orders of the day, based on the estimated gross profit.

Sales Pipeline
Returns a list of sales orders that are scheduled to ship in a specified date range.

Sales Terms
Returns a list of sales terms (also referred to as "Terms of Payment") that are setup in the instance.

Shipments: Details
Returns detailed shipment information based on date criteria. Includes the customer, sales order, customer po, the warehouse, that it shipped from, carrier / method, total weight, number of items shipped, tracking number(s), and the items / quantities that shipped.

Shipments: Inbound
Returns all inbound shipments, including expected and actual ship dates, expected delivery dates, and more.

Shipments: Outbound
Returns all shipments (item fulfillments) made within a specified date range. Includes tracking numbers, package information (ship from and to addresses, weight, shipping / handles charges), and more.

States
Returns a list of states that NetSuite supports.

Support Cases: Closed: Summarized by Assignee
Returns closed support cases summarized by the employee that they are assigned to.

Support Cases: Open: Detailed
Returns details about open support cases.

Support Cases: Open: Summarized by Assignee
Returns open support cases summarized by the employee that they are assigned to.

Support Cases: Open: Summarized by Status
Returns open support cases summarized by status.

Taxes - AvaTax Transaction Logs
Returns information about the AvaTax API calls that were made for a specified transaction.

Transaction Line Usage
Returns the number of Transaction Lines generated in the last 6 months, grouped by transaction type.

Transaction Counts: By Type and Status
Returns the total number of transactions in each type / status combination.

Transactions: GL Impact
Returns the GL impact for a specified transaction.

Transactions: GL Impact: Revisited
Returns the GL impact for a specified transaction.

Transactions: Statuses
Returns a list status codes for all transaction types.

Vendors: Vendor Information
Returns detailed information about vendors that have been created or updated in the past 7 days. Used in project involving development of a custom Product Information Manager (PIM).