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.

• Views are referred to as tables.

• Fields are referred to as columns.

• The entire group of the tables available through the NetSuite.com data source are known as the Connect schema.

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

• Account Activity

• Account Period Activity

• Account Period Activity - Period End Journal

• Account Subsidiary Map

• Accounting Books

• Accounting Periods

• Accounts

• Activities

• Address Book

• Addresses

• Amortization Schedule Lines

• Amortization Schedules

• Assembly Bill of Materials

• Bill of Distributions

• Bill of Materials

• Bill of Materials Revision

• Bill of Materials Revision Components

• Billing Accounts

• Billing Class Rates

• Billing Classes

• Billing Rate Cards

• Billing Rate Card Prices

• Billing Rate Card Versions

• Billing Schedule

• Billing Schedule Descriptions

• Billing Subscription Lines

• Billing Subscriptions

• Bin Number

• Bin Number Counts

• Bins

• Budget

• Budget Category

• Calls

• Campaign Audiences

• Campaign Categories

• Campaign Channel

• Campaign Event

• Campaign Families

• Campaign Item

• Campaign Offer

• Campaign Response

• Campaign Response History

• Campaign Search Engine

• Campaign Subscription Statuses

• Campaign Subscriptions

• Campaign Verticals

• Campaigns

• Case Escalation History

• Case Issue

• Case Origin

• Case Origins

• Case Stage Changes

• Case Type

• Case Types

• Charges

• Classes

• Commission Authorization Link

• Commission Plan

• Commission Rate

• Commission Schedule

• Companies

• Company Contact Map

• Company Status

• Competitor

• Competitor Opportunity Map

• Components Per Routing Steps

• Components Per Routing Steps - Advanced Bill of Materials

• Consolidated Exchange Rates

• Contact Role

• Contact Types

• Contacts

• Countries

• Coupon Codes

• CRM Group

• CRM Group Map

• CRM Template

• Currencies

• Currency Exchange Rates

• Currency Exchange Rate Types

• Custom Lists

• Custom Record Types

• Customer Currencies

• Customer Group Pricing

• Customer Item Pricing

• Customer Partner Sales Teams

• Customer Sales Teams

• Customer Subsidiary Map

• Customer Types

• Customers

• Deleted Records

• Departments

• Distribution Categories

• Distribution Networks

• Employee Corporate Cards

• Employee Currencies

• Employee Expenses Sources

• Employee Time

• Employee Types

• Employees

• Entity

• Entity Category

• Entity Event Map

• Entity Role Map

• Entity Status

• Entity Status History

• Entity Territory Map

• Event Attendees

• Events

• Expense Accounts

• Expense Amortization Rules

• Expense Based Charge Rules

• Expense Categories

• Expense Categories Rates

• Expense Categories Subsidiary Map

• Expense Detail

• Expense Plan Lines

• Expense Plans

• Expense Reports

• Fair Value Prices

• Fixed Fee Charge Rules

• Generic Resources

• Gift Certificates

• Global Account Map

• Global Inventory Relationships

• Group Test Cell

• Imported Employee Expenses

• Inbound Shipments

• Inbound Shipment Items

• Income Accounts

• Inventory Cost Template

• Inventory Cost Template Items

• Inventory Items

• Inventory Number

• Inventory Statuses

• Item Account Map

• Item Billing Rates

• Item Collection Map

• Item Collections

• Item Demand Plan Lines

• Item Demand Plans

• Item Fulfillments

• Item Group

• Item Location Map

• Item Price History

• Item Prices

• Item Quantity

• Item Revisions

• Item Ship Methods

• Item Site Categories

• Item Subsidiary Map

• Item Supply Plan Attributes

• Item Supply Plan Lines

• Item Supply Plan Source

• Item Supply Plan Source Types

• Item Supply Plans

• Item Vendor Map

• Item Vendor Pricing

• Items

• Job Resource Role

• Job Resources

• Job Types

• Location Costing Groups

• Location Costing Groups -Locations

• Locations

• Memorized Transactions

• Message

• Message Recipient

• MFG Cost Template

• MFG Cost Template Items

• MFG Routing

• MFG Routing Steps

• Nexus

• NLCompany

• Note Type

• Notes User

• Opportunities

• Opportunity Contact Map

• Opportunity Lines

• Order Allocation Strategies

• Originating Leads

• Other Names

• Partner Sales Roles

• Partner Types

• Partners

• Payment Methods

• Payment Terms

• Payroll Item Types

• Payroll Items

• Percent Complete Overrides

• Plan Assignment Map

• Plan Schedule Map

• Planned Standard Costs

• Posting Account Activity

• Posting Account Activity - Period End Journal

• Price Book Line Intervals

• Price Books

• Price Plans

• Price Tiers

• Price Types

• Pricing Groups

• Project Billing Budgets

• Project Cost Budgets

• Project Cost Categories

• Project Expense Types

• Project Revenue Rule Types

• Project Charge Rules - Project Revenue Rules

• Project Revenue Rules

• Project Task Assignments

• Project Task Billing Budgets

• Project Task Cost Budgets

• Project Task Dependencies

• Project Tasks

• Project Templates

• Project Time Approval Types

• Promotion Codes

• Purchase Charge Rules

• Quota

• Resource Allocations

• Resource Group Entities

• Resource Groups

• Revaluation

• Revenue Elements

• Revenue Plan Lines

• Revenue Plan Version Lines

• Revenue Plan Versions

• Revenue Plans

• Revenue Recognition Rules

• Revenue Recognition Schedule Lines

• Revenue Recognition Schedules

• Role Subsidiary Map

• Roles

• Sales Channel

• Sales Forecast

• Sales Reps

• Sales Roles

• Sales Territories

• Service Items

• Shipment Packages

• Shipping Items

• Solution

• Solution Case Map

• Solution Topic Map

• Standard Cost Components

• States

• Subscription Line Price Intervals

• Subscription Line Revisions

• Subscription Change Orders

• Subscription Change Order Lines

• Subscription Plan Lines

• Subscription Plans

• Subscription Terms

• Subsidiaries

• Subsidiary Book Map

• Subsidiary Class Map

• Subsidiary Department Map

• Subsidiary Location Map

• Subsidiary Nexus Map

• Supplier Categories

• Support Case History

• Support Incidents (Cases)

• Support Reps

• Support Territories

• System Notes

• System Notes Custom

• Task Contacts

• Tasks

• Tax Items

• Territory

• Time Based Charge Rules

• Timesheet

• Topic

• Transaction Address

• Transaction Bin Numbers

• Transaction Book Map

• Transaction Cost Components

• Transaction History

• Transaction Inventory Numbers

• Transaction Line Book Map

• Transaction Lines

• Transaction Links

• Transaction Partner Sales Teams

• Transaction Sales Teams

• Transaction Shipping Groups

• Transaction Tax Detail

• Transaction Tracking Numbers

• Transactions

• Units Type

• Unlocked Time Periods

• UOM

• Usages

• Vendor Currencies

• Vendor Subsidiary Map

• Vendor Types

• Vendors

• Win Loss Reason

• Work Calendar Holidays

• Work Calendars

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