Column Joins in the Connect Service
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 example shows the relationship between tables in the Connect schema. This applies to the NetSuite.com data source only.
The Transactions table contains the accounting_period_id column. The arrows show the foreign key between the accounting_period_id column in the Transactions table and the corresponding column in the Accounting Periods table.
The Transactions table also contains an entity_id column. In NetSuite, entities are defined as companies, contacts, customers, employees, leads, partners, prospects, and vendors, and have records stored in NetSuite. When browsing the schema, the entity_id column may be listed for multiple tables. In the case of the Transactions table, this column is linked to the customer_id column in the Customers table, but this column can also be linked to other tables, depending on the table in which the column is listed.
The following graphic contains portions of eight different tables and columns within the table. The schema can be listed similarly in a reporting tool.
The following graphic shows the Transactions table with a table of its corresponding columns. The table contains three columns: Column Name, Descriptions, and Links to.... In the Links to... column, if there is a link to a column in another table, the name of the other table and the column linked to within that table appears.
