Connect Schema

Important:

This applies to the NetSuite.com data source only.

As of November 8, 2021, new Connect users can access the Connect Service using the NetSuite2.com data source only. If you gained access to the Connect Service before this date, you can still access the NetSuite.com data source to ensure a smooth transition to NetSuite2.com.

Note that the NetSuite.com data source is no longer being updated with newly exposed tables and columns, and support for this data source will end in a future release. The use of the NetSuite.com data source is no longer considered a best practice, and all Connect users are encouraged to use the NetSuite2.com data source. For more information about this change, see New Accounts and Access to the Connect Data Source.

The following tables describe the Connect schema available to external reporting tools when you work with the Connect Service and the NetSuite.com data source. For each Connect table, exists a list of the names of columns included in the table, column descriptions, and a list of keys, if applicable.

The best way to explore the Connect Schema is to view the standard tables and columns in the Connect Browser. To learn more about the Connect Browser, see Working with the Connect Browser.

SuiteAnalytics Connect introduces terms that differ from the terminology used for the ODBC Connections for the Advanced Reporting feature.

The following is a list of tables that make up the Connect schema.

In addition to standard tables, SuiteAnalytics Connect includes system tables. For more information, see SuiteAnalytics Connect System Tables.

Note:

Additional schema tables are available only if you have the Advanced Revenue Management feature enabled in your account. For more information about those tables, please refer to the Advanced Revenue Management documentation.

Related Topics

Connect Data Source
Changing from NetSuite.com to NetSuite2.com
NetSuite2.com Data Source
SuiteAnalytics Connect System Tables
Querying Data with Connect

General Notices