Overview

This section shows the available Views for the following SuiteQL Schema.

The CData JDBC Driver for NetSuite models NetSuite entities in relational Tables, Views, and Stored Procedures. The table definitions are dynamically obtained based on your NetSuite account.

Tables

Table definitions are dynamically retrieved. This section lists sample table definitions that are included in the NetSuite development environment.

Views

Views are tables that cannot be modified. Typically, data that are read-only and cannot be updated are shown as views.

Stored Procedures

Stored procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Using Query Processing

The driver offloads as much of the SELECT statement processing as possible to the NetSuite APIs and then processes the rest of the query within the driver. The following sections document API limitations and requirements. See SupportEnhancedSQL for more information on how the driver circumvents API limitations with in-memory client-side processing.