NetSuite Suite Analytics (v1) | Stitch Documentation

NetSuite Suite Analytics extraction is supported by Stitch
This integration is powered by Singer's NetSuite Suite Analytics tap and certified by Stitch.

For support, contact Stitch support.

NetSuite Suite Analytics integration summary

Stitch’s NetSuite Suite Analytics integration replicates data using the SuiteAnalytics Connect JDBC driver. Using this integration requires that the SuiteAnalytics feature be enabled in your NetSuite account.

Refer to the Schema section for a list of objects available for replication.

NetSuite Suite Analytics feature snapshot

A high-level look at Stitch's NetSuite Suite Analytics (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Released on June 4, 2020	Supported by	Stitch
Stitch plan	Standard	API availability	Available
Singer GitHub repository
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Supported	Configurable Replication Methods	Supported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting NetSuite Suite Analytics

NetSuite Suite Analytics setup requirements

To set up NetSuite Suite Analytics in Stitch, you need:

Administrator permissions in NetSuite.. This is required to complete the setup steps in NetSuite.
Access to the SuiteAnalytics feature in NetSuite. Suite Analytics is a premium NetSuite feature. Contact your NetSuite administrator if you have questions about this feature.

Step 1: Create a Stitch NetSuite role and configure permissions

To connect NetSuite Suite Analytics to Stitch, we recommend that you create a Stitch-specific role and user for us.

Using the global search, type page: new role and click the Page: New Role result.
In the General section, enter a name for the role in the Name field. For example: Stitch SuiteAnalytics
Scroll down to the Permissions tab and click the Setup subtab, if it isn’t already open.
Using the Permission dropdown, search for SuiteAnalytics Connect:
Click Add to add the permission to the role.
When finished, click Save to create the role.

Step 2: Get the role's internal ID

Using the global search, type page: manage roles and click the Page: Manage Roles result.
Locate the role you created in the previous step.
Locate the role’s Internal ID:

Note: If you don’t see the Internal ID column, click the Edit View button to add it.

Keep this info handy - you’ll need it to complete the setup in Stitch.

Step 3: Create a Stitch NetSuite user and assign the role

Next, you’ll create a dedicated NetSuite Suite Analytics user for Stitch and assign the Stitch role to it.

Using the global search, type page: new employee and click the Page: New Employees result.
In the Employee page, fill in the Name, Email, and any other required fields.
Click the Access tab, located in the bottom half of the page.
In the Access tab:
1. Check the Give Access box.
2. Check the Manually assign or change password box to create a password for the Stitch user.
3. Enter a password in the Password field, then again in the Confirm Password field.
4. In the Roles section, search the dropdown menu to locate the Stitch role you created in Step 1.
5. Click Add once you’ve located the role.
When finished, click Save to create the user.

Step 4: Retrieve SuiteAnalytics Connect details

In this step, you’ll retrieve the details required to connect to NetSuite Suite Analytics from NetSuite.

On the home page of your NetSuite account, click Settings > Set Up SuiteAnalytics Connect:
The next page will display the connection details in the Your Configuration section:

Keep this page open - you’ll need it in the next step.

Step 5: Add NetSuite Suite Analytics as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the NetSuite Suite Analytics icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch NetSuite Suite Analytics” would create a schema called stitch_netsuite_suite_analytics in the destination. Note: Schema names cannot be changed after you save the integration.
In the Host field, paste the host value from Step 4.
In the Port field, paste the port value from Step 4.
In the Account ID field, paste the account ID field from Step 4.
In the Role ID field, enter the role’s internal ID from Step 2.
In the Username and Password fields, enter the Stitch user’s username and password from Step 1.

Step 6: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your NetSuite Suite Analytics integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond NetSuite Suite Analytics’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 7: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

NetSuite Suite Analytics integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 8: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For NetSuite Suite Analytics integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Optional: To define a table’s Replication Method, click Table Settings on the right side of the page.

Whenever possible, Stitch will default to using Key-based Incremental Replication. In some cases, you may be prompted to select a Replication Key for the table.

To change the table’s Replication Method:
1. Select the Replication Method you want the table to use. Note: Some tables can only be replicated using Full Table Replication. Key-based Incremental Replication will be greyed out when this is applicable.
2. If required, select a Replication Key for the table.
3. Click Update Settings.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up NetSuite Suite Analytics, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

NetSuite Suite Analytics replication

In this section:

Details about Extraction, including object discovery, data typing, and selecting data for replication
Details about how data replicated from NetSuite Suite Analytics is loaded into a destination

Extraction

For every table set to replicate, Stitch will perform the following during Extraction:

Discover tables, their schemas, and data type columns
Select records for replication

Discovery

During Discovery, Stitch will:

Discover tables and their schemas
Identify Primary Keys
Type the data in discovered columns

Discover tables

To discover tables and their schemas, Stitch queries the OA_COLUMNS system table in the Connect Schema for the following info:

Column name	Description
table_name	The name of the table.
table_qualifer	The name of the table qualifier. Stitch uses this data to filter out system tables.
table_owner	The name of the table owner. Stitch uses this data to filter out system tables.
column_name	The name of a column in the table.
type_name	The data type of the `column_name` column. Stitch uses this data to type columns.
oa_scale	For `NUMBER` data types, the scale of the data in the `column_name` column. Stitch uses this data to type columns.

All tables where table_qualifer != SCHEMA and table_owner != SYSTEM will be returned and displayed in Stitch as avaiilable for replication.

Refer to NetSuite’s documentation for more info about the OA_COLUMNS system table.

Identifying Primary Keys

Stitch’s approach to Primary Keys for NetSuite Suite Analytics is a bit different than other integrations. In NetSuite Suite Analytics, we’ve found that some tables might not have Primary Keys at all, or Primary Key columns may sometimes contain NULL values.

To determine if a table has Primary Keys, Stitch queries the OA_FKEYS system table. If the table has Primary Keys, Stitch will:

Combine all Primary Key column values on a per record basis
Hash the result and place the hash in a system column named _sdc_record_hash
Designate _sdc_record_hash as the table’s Primary Key. Primary Key columns will have a icon next to their name in Stitch.
Automatically set _sdc_record_hash and the table’s Primary Key columns to replicate

Note: The presence of Primary Keys partially determines how data is loaded into your destination.

Refer to NetSuite’s documentation for more info about the OA_FKEYS system table.

Data typing

Next, Stitch will assign data types to columns. To determine data types, Stitch uses the type_name and oa_scale columns returned from the OA_COLUMNS system table during table discovery.

In the following table:

NetSuite data type: The data type in NetSuite, based on the column’s type_name value.
Stitch data type: The Stitch data type the NetSuite type will be mapped to.
Description: Details about the data type or mapping.

NetSuite data type	Stitch data type	Description
VARCHAR2	STRING	The `VARCHAR2` data type includes `BOOLEAN` data due to how NetSuite stores these values. NetSuite stores `BOOLEAN` values as `VARCHAR2` with either a length of one (`"t"` or `"f"`) or three (`"yes"` or `"no"`). As typing can’t be correctly asserted based on a length of one or three, these values are dicovered as strings.
NUMBER	INTEGER	If the column’s `oa_scale` value is `0`, Stitch will type the data as an `INTEGER`.
NUMBER	NUMBER	If the column’s `oa_scale` value is greater than `0`, Stitch will type the data as a `NUMBER`.
TIMESTAMP	STRING (DATE-TIME)	Stitch will type `TIMESTAMP` data as a `DATE-TIME`-formatted string.

Data replication

After discovery is completed, Stitch will move onto extracting data. The Replication Method Stitch uses is dependent on whether the table contains valid Replication Key columns.

Stitch will default to using Key-based Incremental Replication if a table contains any of the following columns:

last_modified_date
date_last_modified
date_deleted
date_last_modified_gmt (transaction_lines table only)

If a table contains more than one of the above columns, you’ll be prompted to select a column to use as a Replication Key when you set the table to replicate. Otherwise, Stitch will use the single column as the Replication Key for the table.

If a table doesn’t contain any of the above columns, Stitch will default to using Full Table Replication.

As this integration supports configuring Replication Methods, you can toggle between Replication Methods for tables on the Table Settings page in Stitch.

Loading

How data replicated from an NetSuite Suite Analytics integration is loaded into your destination depends on two factors:

If the table has Primary Keys identified during discovery.
If your destination supports upserts, or updating existing rows. For destinations that support upserts, Stitch uses Primary Keys to de-dupe data during loading. Primary Keys are used to identify unique rows within a table and ensure that only the most recently updated version of that record appears in your destination.

Note: For Append-Only destinations, data will be loaded in an Append-Only manner regardless of whether a table has Primary Keys.

Loading with Primary Keys

If the destination supports upserts and the table has Primary Keys, Stitch will de-dupe records using _sdc_record_hash as the Primary Key.

This means that existing rows will be overwritten with the most recent version of the row. A record can only have a single unique Primary Key value, ensuring that only one version of the record exists in the destination at a time.

Loading without Primary Keys

If the destination is Append-Only, or if the table doesn’t have Primary Keys, data will be loaded in an Append-Only manner.

This means that existing rows will never be updated with new data. New and updated records will be appended to the end of the table as new rows.

Note: Querying Append-Only tables requires a different strategy than you might normally use. For instructions and a sample query, check out the Querying Append-Only tables guide.

NetSuite Suite Analytics table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 1 of this integration.

This is the latest version of the NetSuite Suite Analytics integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

account_activity

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

account_activity table foreign keys

Join account_activity with	on
account_period_activity	account_activity.account_id = account_period_activity.account_id account_activity.accounting_book_id = account_period_activity.accounting_book_id account_activity.department_id = account_period_activity.department_id account_activity.subsidiary_id = account_period_activity.subsidiary_id
account_period_activity_pe	account_activity.account_id = account_period_activity_pe.account_id account_activity.accounting_book_id = account_period_activity_pe.accounting_book_id account_activity.department_id = account_period_activity_pe.department_id account_activity.subsidiary_id = account_period_activity_pe.balance_from_subsidiary_id account_activity.subsidiary_id = account_period_activity_pe.subsidiary_id
account_subsidiary_map	account_activity.account_id = account_subsidiary_map.account_id account_activity.subsidiary_id = account_subsidiary_map.subsidiary_id
accounts	account_activity.account_id = accounts.deferral_account_id account_activity.account_id = accounts.parent_id account_activity.department_id = accounts.department_id
amortization_sched_lines	account_activity.account_id = amortization_sched_lines.account_id
budget	account_activity.account_id = budget.account_id account_activity.accounting_book_id = budget.accounting_book_id account_activity.department_id = budget.department_id account_activity.subsidiary_id = budget.subsidiary_id
customers	account_activity.account_id = customers.default_receivables_account_id account_activity.subsidiary_id = customers.subsidiary_id account_activity.subsidiary_id = customers.represents_subsidiary_id
employees	account_activity.account_id = employees.def_acct_corp_card_expenses_id account_activity.department_id = employees.department_id account_activity.subsidiary_id = employees.subsidiary_id
expense_accounts	account_activity.account_id = expense_accounts.expense_account_id
expense_amortization_rules	account_activity.account_id = expense_amortization_rules.contra_account_id
expense_plan_lines	account_activity.account_id = expense_plan_lines.deferred_expense_account_id account_activity.account_id = expense_plan_lines.expense_account_id
global_account_map	account_activity.account_id = global_account_map.destination_account_id account_activity.account_id = global_account_map.source_account_id account_activity.accounting_book_id = global_account_map.accounting_book_id account_activity.department_id = global_account_map.department_id account_activity.subsidiary_id = global_account_map.subsidiary_id
income_accounts	account_activity.account_id = income_accounts.income_account_id
income_account_map	account_activity.account_id = income_account_map.destination_account_id account_activity.account_id = income_account_map.source_account_id
opportunity_lines	account_activity.account_id = opportunity_lines.account_id account_activity.department_id = opportunity_lines.department_id account_activity.subsidiary_id = opportunity_lines.subsidiary_id
posting_account_activity	account_activity.account_id = posting_account_activity.account_id account_activity.accounting_book_id = posting_account_activity.accounting_book_id account_activity.department_id = posting_account_activity.department_id account_activity.subsidiary_id = posting_account_activity.subsidiary_id
posting_account_activity_pe	account_activity.account_id = posting_account_activity_pe.account_id account_activity.accounting_book_id = posting_account_activity_pe.accounting_book_id account_activity.department_id = posting_account_activity_pe.department_id account_activity.subsidiary_id = posting_account_activity_pe.subsidiary_id account_activity.subsidiary_id = posting_account_activity_pe.balance_from_subsidiary_id
revaluation	account_activity.account_id = revaluation.variance_account_id
revenue_plan_lines	account_activity.account_id = revenue_plan_lines.deferral_account_id account_activity.account_id = revenue_plan_lines.recognition_account_id
revrecschedulelines	account_activity.account_id = revrecschedulelines.account_id
sales_reps	account_activity.account_id = sales_reps.def_acct_corp_card_expenses_id
support_reps	account_activity.account_id = support_reps.def_acct_corp_card_expenses_id
transaction_history	account_activity.account_id = transaction_history.account_id
transaction_line_book_map	account_activity.account_id = transaction_line_book_map.account_id account_activity.accounting_book_id = transaction_line_book_map.accounting_book_id
transaction_lines	account_activity.account_id = transaction_lines.account_id account_activity.subsidiary_id = transaction_lines.subsidiary_id account_activity.subsidiary_id = transaction_lines.source_subsidiary_id
transaction_tax_detail	account_activity.account_id = transaction_tax_detail.account_id
transactions	account_activity.account_id = transactions.account_id
accounting_books	account_activity.accounting_book_id = accounting_books.accounting_book_id account_activity.accounting_book_id = accounting_books.base_book_id
expense_plans	account_activity.accounting_book_id = expense_plans.transaction_book_id
item_account_map	account_activity.accounting_book_id = item_account_map.accounting_book_id account_activity.department_id = item_account_map.department_id account_activity.subsidiary_id = item_account_map.subsidiary_id
transaction_book_map	account_activity.accounting_book_id = transaction_book_map.accounting_book_id
departments	account_activity.department_id = departments.department_id account_activity.department_id = departments.parent_id
employee_time	account_activity.department_id = employee_time.department_id account_activity.subsidiary_id = employee_time.billing_subsidiary_id account_activity.subsidiary_id = employee_time.subsidiary_id
subscription_plans	account_activity.department_id = subscription_plans.department_id account_activity.subsidiary_id = subscription_plans.subsidiary_id
subsidiary_department_map	account_activity.department_id = subsidiary_department_map.department_id account_activity.subsidiary_id = subsidiary_department_map.subsidiary_id
companies	account_activity.subsidiary_id = companies.subsidiary_id
consolidated_exchange_rates	account_activity.subsidiary_id = consolidated_exchange_rates.from_subsidiary_id account_activity.subsidiary_id = consolidated_exchange_rates.to_subsidiary_id
customer_subsidiary_map	account_activity.subsidiary_id = customer_subsidiary_map.subsidiary_id
expense_categories_subs_map	account_activity.subsidiary_id = expense_categories_subs_map.subsidiary_id
global_inventory_relationships	account_activity.subsidiary_id = global_inventory_relationships.inventory_subsidiary_id account_activity.subsidiary_id = global_inventory_relationships.originating_subsidiary_id
item_subsidiary_map	account_activity.subsidiary_id = item_subsidiary_map.subsidiary_id
item_vendor_map	account_activity.subsidiary_id = item_vendor_map.subsidiary_id
partners	account_activity.subsidiary_id = partners.subsidiary
role_subsidiary_map	account_activity.subsidiary_id = role_subsidiary_map.subsidiary_id
subsidiary_class_map	account_activity.subsidiary_id = subsidiary_class_map.subsidiary_id
support_incidents	account_activity.subsidiary_id = support_incidents.subsidiary_id
subsidiaries	account_activity.subsidiary_id = subsidiaries.billing_subsidiary_id
vendor_subsidiary_map	account_activity.subsidiary_id = vendor_subsidiary_map.subsidiary_id
vendors	account_activity.subsidiary_id = vendors.subsidiary account_activity.subsidiary_id = vendors.represents_subsidiary_id

account_activity table schema

account_id

INTEGER

accounting_book_id

INTEGER

activity_date

DATE-TIME

amount

INTEGER

department_id

INTEGER

is_hidden_custom_line

STRING

subsidiary_id

INTEGER

{{ system-column.record-hash }}

STRING

account_period_activity

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

account_period_activity table foreign keys

Join account_period_activity with	on
account_activity	account_period_activity.account_id = account_activity.account_id account_period_activity.accounting_book_id = account_activity.accounting_book_id account_period_activity.department_id = account_activity.department_id account_period_activity.subsidiary_id = account_activity.subsidiary_id
account_period_activity_pe	account_period_activity.account_id = account_period_activity_pe.account_id account_period_activity.accounting_book_id = account_period_activity_pe.accounting_book_id account_period_activity.accounting_period_id = account_period_activity_pe.accounting_period_id account_period_activity.department_id = account_period_activity_pe.department_id account_period_activity.subsidiary_id = account_period_activity_pe.balance_from_subsidiary_id account_period_activity.subsidiary_id = account_period_activity_pe.subsidiary_id
account_subsidiary_map	account_period_activity.account_id = account_subsidiary_map.account_id account_period_activity.subsidiary_id = account_subsidiary_map.subsidiary_id
accounts	account_period_activity.account_id = accounts.deferral_account_id account_period_activity.account_id = accounts.parent_id account_period_activity.department_id = accounts.department_id
amortization_sched_lines	account_period_activity.account_id = amortization_sched_lines.account_id account_period_activity.accounting_period_id = amortization_sched_lines.accounting_period_id
budget	account_period_activity.account_id = budget.account_id account_period_activity.accounting_book_id = budget.accounting_book_id account_period_activity.accounting_period_id = budget.accounting_period_id account_period_activity.department_id = budget.department_id account_period_activity.subsidiary_id = budget.subsidiary_id
customers	account_period_activity.account_id = customers.default_receivables_account_id account_period_activity.accounting_period_id = customers.first_sale_period_id account_period_activity.accounting_period_id = customers.last_sale_period_id account_period_activity.subsidiary_id = customers.subsidiary_id account_period_activity.subsidiary_id = customers.represents_subsidiary_id
employees	account_period_activity.account_id = employees.def_acct_corp_card_expenses_id account_period_activity.department_id = employees.department_id account_period_activity.subsidiary_id = employees.subsidiary_id
expense_accounts	account_period_activity.account_id = expense_accounts.expense_account_id
expense_amortization_rules	account_period_activity.account_id = expense_amortization_rules.contra_account_id
expense_plan_lines	account_period_activity.account_id = expense_plan_lines.deferred_expense_account_id account_period_activity.account_id = expense_plan_lines.expense_account_id account_period_activity.accounting_period_id = expense_plan_lines.accounting_period_id
global_account_map	account_period_activity.account_id = global_account_map.destination_account_id account_period_activity.account_id = global_account_map.source_account_id account_period_activity.accounting_book_id = global_account_map.accounting_book_id account_period_activity.department_id = global_account_map.department_id account_period_activity.subsidiary_id = global_account_map.subsidiary_id
income_accounts	account_period_activity.account_id = income_accounts.income_account_id
income_account_map	account_period_activity.account_id = income_account_map.destination_account_id account_period_activity.account_id = income_account_map.source_account_id
opportunity_lines	account_period_activity.account_id = opportunity_lines.account_id account_period_activity.department_id = opportunity_lines.department_id account_period_activity.subsidiary_id = opportunity_lines.subsidiary_id
posting_account_activity	account_period_activity.account_id = posting_account_activity.account_id account_period_activity.accounting_book_id = posting_account_activity.accounting_book_id account_period_activity.accounting_period_id = posting_account_activity.accounting_period_id account_period_activity.department_id = posting_account_activity.department_id account_period_activity.subsidiary_id = posting_account_activity.subsidiary_id
posting_account_activity_pe	account_period_activity.account_id = posting_account_activity_pe.account_id account_period_activity.accounting_book_id = posting_account_activity_pe.accounting_book_id account_period_activity.accounting_period_id = posting_account_activity_pe.accounting_period_id account_period_activity.department_id = posting_account_activity_pe.department_id account_period_activity.subsidiary_id = posting_account_activity_pe.subsidiary_id account_period_activity.subsidiary_id = posting_account_activity_pe.balance_from_subsidiary_id
revaluation	account_period_activity.account_id = revaluation.variance_account_id
revenue_plan_lines	account_period_activity.account_id = revenue_plan_lines.deferral_account_id account_period_activity.account_id = revenue_plan_lines.recognition_account_id account_period_activity.accounting_period_id = revenue_plan_lines.accounting_period_id
revrecschedulelines	account_period_activity.account_id = revrecschedulelines.account_id account_period_activity.accounting_period_id = revrecschedulelines.accounting_period_id
sales_reps	account_period_activity.account_id = sales_reps.def_acct_corp_card_expenses_id
support_reps	account_period_activity.account_id = support_reps.def_acct_corp_card_expenses_id
transaction_history	account_period_activity.account_id = transaction_history.account_id
transaction_line_book_map	account_period_activity.account_id = transaction_line_book_map.account_id account_period_activity.accounting_book_id = transaction_line_book_map.accounting_book_id
transaction_lines	account_period_activity.account_id = transaction_lines.account_id account_period_activity.subsidiary_id = transaction_lines.subsidiary_id account_period_activity.subsidiary_id = transaction_lines.source_subsidiary_id
transaction_tax_detail	account_period_activity.account_id = transaction_tax_detail.account_id
transactions	account_period_activity.account_id = transactions.account_id
accounting_books	account_period_activity.accounting_book_id = accounting_books.accounting_book_id account_period_activity.accounting_book_id = accounting_books.base_book_id
expense_plans	account_period_activity.accounting_book_id = expense_plans.transaction_book_id account_period_activity.accounting_period_id = expense_plans.accounting_period_id
item_account_map	account_period_activity.accounting_book_id = item_account_map.accounting_book_id account_period_activity.department_id = item_account_map.department_id account_period_activity.subsidiary_id = item_account_map.subsidiary_id
transaction_book_map	account_period_activity.accounting_book_id = transaction_book_map.accounting_book_id
accounting_periods	account_period_activity.accounting_period_id = accounting_periods.accounting_period_id account_period_activity.accounting_period_id = accounting_periods.parent_id account_period_activity.accounting_period_id = accounting_periods.year_id
consolidated_exchange_rates	account_period_activity.accounting_period_id = consolidated_exchange_rates.accounting_period_id account_period_activity.subsidiary_id = consolidated_exchange_rates.from_subsidiary_id account_period_activity.subsidiary_id = consolidated_exchange_rates.to_subsidiary_id
opportunities	account_period_activity.accounting_period_id = opportunities.accounting_period_id
revenue_plan_version_lines	account_period_activity.accounting_period_id = revenue_plan_version_lines.accounting_period_id
revenue_plans	account_period_activity.accounting_period_id = revenue_plans.accounting_period_id
departments	account_period_activity.department_id = departments.department_id account_period_activity.department_id = departments.parent_id
employee_time	account_period_activity.department_id = employee_time.department_id account_period_activity.subsidiary_id = employee_time.billing_subsidiary_id account_period_activity.subsidiary_id = employee_time.subsidiary_id
subscription_plans	account_period_activity.department_id = subscription_plans.department_id account_period_activity.subsidiary_id = subscription_plans.subsidiary_id
subsidiary_department_map	account_period_activity.department_id = subsidiary_department_map.department_id account_period_activity.subsidiary_id = subsidiary_department_map.subsidiary_id
companies	account_period_activity.subsidiary_id = companies.subsidiary_id
customer_subsidiary_map	account_period_activity.subsidiary_id = customer_subsidiary_map.subsidiary_id
expense_categories_subs_map	account_period_activity.subsidiary_id = expense_categories_subs_map.subsidiary_id
global_inventory_relationships	account_period_activity.subsidiary_id = global_inventory_relationships.inventory_subsidiary_id account_period_activity.subsidiary_id = global_inventory_relationships.originating_subsidiary_id
item_subsidiary_map	account_period_activity.subsidiary_id = item_subsidiary_map.subsidiary_id
item_vendor_map	account_period_activity.subsidiary_id = item_vendor_map.subsidiary_id
partners	account_period_activity.subsidiary_id = partners.subsidiary
role_subsidiary_map	account_period_activity.subsidiary_id = role_subsidiary_map.subsidiary_id
subsidiary_class_map	account_period_activity.subsidiary_id = subsidiary_class_map.subsidiary_id
support_incidents	account_period_activity.subsidiary_id = support_incidents.subsidiary_id
subsidiaries	account_period_activity.subsidiary_id = subsidiaries.billing_subsidiary_id
vendor_subsidiary_map	account_period_activity.subsidiary_id = vendor_subsidiary_map.subsidiary_id
vendors	account_period_activity.subsidiary_id = vendors.subsidiary account_period_activity.subsidiary_id = vendors.represents_subsidiary_id

account_period_activity table schema

account_id

INTEGER

accounting_book_id

INTEGER

accounting_period_id

INTEGER

amount

INTEGER

department_id

INTEGER

is_hidden_custom_line

STRING

subsidiary_id

INTEGER

{{ system-column.record-hash }}

STRING

account_period_activity_pe

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

account_period_activity_pe table foreign keys

Join account_period_activity_pe with	on
account_activity	account_period_activity_pe.account_id = account_activity.account_id account_period_activity_pe.accounting_book_id = account_activity.accounting_book_id account_period_activity_pe.department_id = account_activity.department_id account_period_activity_pe.balance_from_subsidiary_id = account_activity.subsidiary_id account_period_activity_pe.subsidiary_id = account_activity.subsidiary_id
account_period_activity	account_period_activity_pe.account_id = account_period_activity.account_id account_period_activity_pe.accounting_book_id = account_period_activity.accounting_book_id account_period_activity_pe.accounting_period_id = account_period_activity.accounting_period_id account_period_activity_pe.department_id = account_period_activity.department_id account_period_activity_pe.balance_from_subsidiary_id = account_period_activity.subsidiary_id account_period_activity_pe.subsidiary_id = account_period_activity.subsidiary_id
account_subsidiary_map	account_period_activity_pe.account_id = account_subsidiary_map.account_id account_period_activity_pe.balance_from_subsidiary_id = account_subsidiary_map.subsidiary_id account_period_activity_pe.subsidiary_id = account_subsidiary_map.subsidiary_id
accounts	account_period_activity_pe.account_id = accounts.deferral_account_id account_period_activity_pe.account_id = accounts.parent_id account_period_activity_pe.department_id = accounts.department_id
amortization_sched_lines	account_period_activity_pe.account_id = amortization_sched_lines.account_id account_period_activity_pe.accounting_period_id = amortization_sched_lines.accounting_period_id
budget	account_period_activity_pe.account_id = budget.account_id account_period_activity_pe.accounting_book_id = budget.accounting_book_id account_period_activity_pe.accounting_period_id = budget.accounting_period_id account_period_activity_pe.department_id = budget.department_id account_period_activity_pe.balance_from_subsidiary_id = budget.subsidiary_id account_period_activity_pe.subsidiary_id = budget.subsidiary_id
customers	account_period_activity_pe.account_id = customers.default_receivables_account_id account_period_activity_pe.accounting_period_id = customers.first_sale_period_id account_period_activity_pe.accounting_period_id = customers.last_sale_period_id account_period_activity_pe.balance_from_subsidiary_id = customers.subsidiary_id account_period_activity_pe.subsidiary_id = customers.subsidiary_id account_period_activity_pe.balance_from_subsidiary_id = customers.represents_subsidiary_id account_period_activity_pe.subsidiary_id = customers.represents_subsidiary_id
employees	account_period_activity_pe.account_id = employees.def_acct_corp_card_expenses_id account_period_activity_pe.department_id = employees.department_id account_period_activity_pe.balance_from_subsidiary_id = employees.subsidiary_id account_period_activity_pe.subsidiary_id = employees.subsidiary_id
expense_accounts	account_period_activity_pe.account_id = expense_accounts.expense_account_id
expense_amortization_rules	account_period_activity_pe.account_id = expense_amortization_rules.contra_account_id
expense_plan_lines	account_period_activity_pe.account_id = expense_plan_lines.deferred_expense_account_id account_period_activity_pe.account_id = expense_plan_lines.expense_account_id account_period_activity_pe.accounting_period_id = expense_plan_lines.accounting_period_id
global_account_map	account_period_activity_pe.account_id = global_account_map.destination_account_id account_period_activity_pe.account_id = global_account_map.source_account_id account_period_activity_pe.accounting_book_id = global_account_map.accounting_book_id account_period_activity_pe.department_id = global_account_map.department_id account_period_activity_pe.balance_from_subsidiary_id = global_account_map.subsidiary_id account_period_activity_pe.subsidiary_id = global_account_map.subsidiary_id
income_accounts	account_period_activity_pe.account_id = income_accounts.income_account_id
income_account_map	account_period_activity_pe.account_id = income_account_map.destination_account_id account_period_activity_pe.account_id = income_account_map.source_account_id
opportunity_lines	account_period_activity_pe.account_id = opportunity_lines.account_id account_period_activity_pe.department_id = opportunity_lines.department_id account_period_activity_pe.balance_from_subsidiary_id = opportunity_lines.subsidiary_id account_period_activity_pe.subsidiary_id = opportunity_lines.subsidiary_id
posting_account_activity	account_period_activity_pe.account_id = posting_account_activity.account_id account_period_activity_pe.accounting_book_id = posting_account_activity.accounting_book_id account_period_activity_pe.accounting_period_id = posting_account_activity.accounting_period_id account_period_activity_pe.department_id = posting_account_activity.department_id account_period_activity_pe.balance_from_subsidiary_id = posting_account_activity.subsidiary_id account_period_activity_pe.subsidiary_id = posting_account_activity.subsidiary_id
posting_account_activity_pe	account_period_activity_pe.account_id = posting_account_activity_pe.account_id account_period_activity_pe.accounting_book_id = posting_account_activity_pe.accounting_book_id account_period_activity_pe.accounting_period_id = posting_account_activity_pe.accounting_period_id account_period_activity_pe.department_id = posting_account_activity_pe.department_id account_period_activity_pe.balance_from_subsidiary_id = posting_account_activity_pe.subsidiary_id account_period_activity_pe.subsidiary_id = posting_account_activity_pe.subsidiary_id account_period_activity_pe.balance_from_subsidiary_id = posting_account_activity_pe.balance_from_subsidiary_id account_period_activity_pe.subsidiary_id = posting_account_activity_pe.balance_from_subsidiary_id
revaluation	account_period_activity_pe.account_id = revaluation.variance_account_id
revenue_plan_lines	account_period_activity_pe.account_id = revenue_plan_lines.deferral_account_id account_period_activity_pe.account_id = revenue_plan_lines.recognition_account_id account_period_activity_pe.accounting_period_id = revenue_plan_lines.accounting_period_id
revrecschedulelines	account_period_activity_pe.account_id = revrecschedulelines.account_id account_period_activity_pe.accounting_period_id = revrecschedulelines.accounting_period_id
sales_reps	account_period_activity_pe.account_id = sales_reps.def_acct_corp_card_expenses_id
support_reps	account_period_activity_pe.account_id = support_reps.def_acct_corp_card_expenses_id
transaction_history	account_period_activity_pe.account_id = transaction_history.account_id
transaction_line_book_map	account_period_activity_pe.account_id = transaction_line_book_map.account_id account_period_activity_pe.accounting_book_id = transaction_line_book_map.accounting_book_id
transaction_lines	account_period_activity_pe.account_id = transaction_lines.account_id account_period_activity_pe.balance_from_subsidiary_id = transaction_lines.subsidiary_id account_period_activity_pe.subsidiary_id = transaction_lines.subsidiary_id account_period_activity_pe.balance_from_subsidiary_id = transaction_lines.source_subsidiary_id account_period_activity_pe.subsidiary_id = transaction_lines.source_subsidiary_id
transaction_tax_detail	account_period_activity_pe.account_id = transaction_tax_detail.account_id
transactions	account_period_activity_pe.account_id = transactions.account_id
accounting_books	account_period_activity_pe.accounting_book_id = accounting_books.accounting_book_id account_period_activity_pe.accounting_book_id = accounting_books.base_book_id
expense_plans	account_period_activity_pe.accounting_book_id = expense_plans.transaction_book_id account_period_activity_pe.accounting_period_id = expense_plans.accounting_period_id
item_account_map	account_period_activity_pe.accounting_book_id = item_account_map.accounting_book_id account_period_activity_pe.department_id = item_account_map.department_id account_period_activity_pe.balance_from_subsidiary_id = item_account_map.subsidiary_id account_period_activity_pe.subsidiary_id = item_account_map.subsidiary_id
transaction_book_map	account_period_activity_pe.accounting_book_id = transaction_book_map.accounting_book_id
accounting_periods	account_period_activity_pe.accounting_period_id = accounting_periods.accounting_period_id account_period_activity_pe.accounting_period_id = accounting_periods.parent_id account_period_activity_pe.accounting_period_id = accounting_periods.year_id
consolidated_exchange_rates	account_period_activity_pe.accounting_period_id = consolidated_exchange_rates.accounting_period_id account_period_activity_pe.balance_from_subsidiary_id = consolidated_exchange_rates.from_subsidiary_id account_period_activity_pe.subsidiary_id = consolidated_exchange_rates.from_subsidiary_id account_period_activity_pe.balance_from_subsidiary_id = consolidated_exchange_rates.to_subsidiary_id account_period_activity_pe.subsidiary_id = consolidated_exchange_rates.to_subsidiary_id
opportunities	account_period_activity_pe.accounting_period_id = opportunities.accounting_period_id
revenue_plan_version_lines	account_period_activity_pe.accounting_period_id = revenue_plan_version_lines.accounting_period_id
revenue_plans	account_period_activity_pe.accounting_period_id = revenue_plans.accounting_period_id
departments	account_period_activity_pe.department_id = departments.department_id account_period_activity_pe.department_id = departments.parent_id
employee_time	account_period_activity_pe.department_id = employee_time.department_id account_period_activity_pe.balance_from_subsidiary_id = employee_time.billing_subsidiary_id account_period_activity_pe.subsidiary_id = employee_time.billing_subsidiary_id account_period_activity_pe.balance_from_subsidiary_id = employee_time.subsidiary_id account_period_activity_pe.subsidiary_id = employee_time.subsidiary_id
subscription_plans	account_period_activity_pe.department_id = subscription_plans.department_id account_period_activity_pe.balance_from_subsidiary_id = subscription_plans.subsidiary_id account_period_activity_pe.subsidiary_id = subscription_plans.subsidiary_id
subsidiary_department_map	account_period_activity_pe.department_id = subsidiary_department_map.department_id account_period_activity_pe.balance_from_subsidiary_id = subsidiary_department_map.subsidiary_id account_period_activity_pe.subsidiary_id = subsidiary_department_map.subsidiary_id
companies	account_period_activity_pe.balance_from_subsidiary_id = companies.subsidiary_id account_period_activity_pe.subsidiary_id = companies.subsidiary_id
customer_subsidiary_map	account_period_activity_pe.balance_from_subsidiary_id = customer_subsidiary_map.subsidiary_id account_period_activity_pe.subsidiary_id = customer_subsidiary_map.subsidiary_id
expense_categories_subs_map	account_period_activity_pe.balance_from_subsidiary_id = expense_categories_subs_map.subsidiary_id account_period_activity_pe.subsidiary_id = expense_categories_subs_map.subsidiary_id
global_inventory_relationships	account_period_activity_pe.balance_from_subsidiary_id = global_inventory_relationships.inventory_subsidiary_id account_period_activity_pe.subsidiary_id = global_inventory_relationships.inventory_subsidiary_id account_period_activity_pe.balance_from_subsidiary_id = global_inventory_relationships.originating_subsidiary_id account_period_activity_pe.subsidiary_id = global_inventory_relationships.originating_subsidiary_id
item_subsidiary_map	account_period_activity_pe.balance_from_subsidiary_id = item_subsidiary_map.subsidiary_id account_period_activity_pe.subsidiary_id = item_subsidiary_map.subsidiary_id
item_vendor_map	account_period_activity_pe.balance_from_subsidiary_id = item_vendor_map.subsidiary_id account_period_activity_pe.subsidiary_id = item_vendor_map.subsidiary_id
partners	account_period_activity_pe.balance_from_subsidiary_id = partners.subsidiary account_period_activity_pe.subsidiary_id = partners.subsidiary
role_subsidiary_map	account_period_activity_pe.balance_from_subsidiary_id = role_subsidiary_map.subsidiary_id account_period_activity_pe.subsidiary_id = role_subsidiary_map.subsidiary_id
subsidiary_class_map	account_period_activity_pe.balance_from_subsidiary_id = subsidiary_class_map.subsidiary_id account_period_activity_pe.subsidiary_id = subsidiary_class_map.subsidiary_id
support_incidents	account_period_activity_pe.balance_from_subsidiary_id = support_incidents.subsidiary_id account_period_activity_pe.subsidiary_id = support_incidents.subsidiary_id
subsidiaries	account_period_activity_pe.balance_from_subsidiary_id = subsidiaries.billing_subsidiary_id account_period_activity_pe.subsidiary_id = subsidiaries.billing_subsidiary_id
vendor_subsidiary_map	account_period_activity_pe.balance_from_subsidiary_id = vendor_subsidiary_map.subsidiary_id account_period_activity_pe.subsidiary_id = vendor_subsidiary_map.subsidiary_id
vendors	account_period_activity_pe.balance_from_subsidiary_id = vendors.subsidiary account_period_activity_pe.subsidiary_id = vendors.subsidiary account_period_activity_pe.balance_from_subsidiary_id = vendors.represents_subsidiary_id account_period_activity_pe.subsidiary_id = vendors.represents_subsidiary_id

account_period_activity_pe table schema

account_id

INTEGER

accounting_book_id

INTEGER

accounting_period_id

INTEGER

amount

INTEGER

balance_from_subsidiary_id

INTEGER

department_id

INTEGER

is_hidden_custom_line

STRING

subsidiary_id

INTEGER

{{ system-column.record-hash }}

STRING

account_subsidiary_map

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

account_subsidiary_map table foreign keys

Join account_subsidiary_map with	on
account_activity	account_subsidiary_map.account_id = account_activity.account_id account_subsidiary_map.subsidiary_id = account_activity.subsidiary_id
account_period_activity	account_subsidiary_map.account_id = account_period_activity.account_id account_subsidiary_map.subsidiary_id = account_period_activity.subsidiary_id
account_period_activity_pe	account_subsidiary_map.account_id = account_period_activity_pe.account_id account_subsidiary_map.subsidiary_id = account_period_activity_pe.balance_from_subsidiary_id account_subsidiary_map.subsidiary_id = account_period_activity_pe.subsidiary_id
accounts	account_subsidiary_map.account_id = accounts.deferral_account_id account_subsidiary_map.account_id = accounts.parent_id
amortization_sched_lines	account_subsidiary_map.account_id = amortization_sched_lines.account_id
budget	account_subsidiary_map.account_id = budget.account_id account_subsidiary_map.subsidiary_id = budget.subsidiary_id
customers	account_subsidiary_map.account_id = customers.default_receivables_account_id account_subsidiary_map.subsidiary_id = customers.subsidiary_id account_subsidiary_map.subsidiary_id = customers.represents_subsidiary_id
employees	account_subsidiary_map.account_id = employees.def_acct_corp_card_expenses_id account_subsidiary_map.subsidiary_id = employees.subsidiary_id
expense_accounts	account_subsidiary_map.account_id = expense_accounts.expense_account_id
expense_amortization_rules	account_subsidiary_map.account_id = expense_amortization_rules.contra_account_id
expense_plan_lines	account_subsidiary_map.account_id = expense_plan_lines.deferred_expense_account_id account_subsidiary_map.account_id = expense_plan_lines.expense_account_id
global_account_map	account_subsidiary_map.account_id = global_account_map.destination_account_id account_subsidiary_map.account_id = global_account_map.source_account_id account_subsidiary_map.subsidiary_id = global_account_map.subsidiary_id
income_accounts	account_subsidiary_map.account_id = income_accounts.income_account_id
income_account_map	account_subsidiary_map.account_id = income_account_map.destination_account_id account_subsidiary_map.account_id = income_account_map.source_account_id
opportunity_lines	account_subsidiary_map.account_id = opportunity_lines.account_id account_subsidiary_map.subsidiary_id = opportunity_lines.subsidiary_id
posting_account_activity	account_subsidiary_map.account_id = posting_account_activity.account_id account_subsidiary_map.subsidiary_id = posting_account_activity.subsidiary_id
posting_account_activity_pe	account_subsidiary_map.account_id = posting_account_activity_pe.account_id account_subsidiary_map.subsidiary_id = posting_account_activity_pe.subsidiary_id account_subsidiary_map.subsidiary_id = posting_account_activity_pe.balance_from_subsidiary_id
revaluation	account_subsidiary_map.account_id = revaluation.variance_account_id
revenue_plan_lines	account_subsidiary_map.account_id = revenue_plan_lines.deferral_account_id account_subsidiary_map.account_id = revenue_plan_lines.recognition_account_id
revrecschedulelines	account_subsidiary_map.account_id = revrecschedulelines.account_id
sales_reps	account_subsidiary_map.account_id = sales_reps.def_acct_corp_card_expenses_id
support_reps	account_subsidiary_map.account_id = support_reps.def_acct_corp_card_expenses_id
transaction_history	account_subsidiary_map.account_id = transaction_history.account_id
transaction_line_book_map	account_subsidiary_map.account_id = transaction_line_book_map.account_id
transaction_lines	account_subsidiary_map.account_id = transaction_lines.account_id account_subsidiary_map.subsidiary_id = transaction_lines.subsidiary_id account_subsidiary_map.subsidiary_id = transaction_lines.source_subsidiary_id
transaction_tax_detail	account_subsidiary_map.account_id = transaction_tax_detail.account_id
transactions	account_subsidiary_map.account_id = transactions.account_id
companies	account_subsidiary_map.subsidiary_id = companies.subsidiary_id
consolidated_exchange_rates	account_subsidiary_map.subsidiary_id = consolidated_exchange_rates.from_subsidiary_id account_subsidiary_map.subsidiary_id = consolidated_exchange_rates.to_subsidiary_id
customer_subsidiary_map	account_subsidiary_map.subsidiary_id = customer_subsidiary_map.subsidiary_id
employee_time	account_subsidiary_map.subsidiary_id = employee_time.billing_subsidiary_id account_subsidiary_map.subsidiary_id = employee_time.subsidiary_id
expense_categories_subs_map	account_subsidiary_map.subsidiary_id = expense_categories_subs_map.subsidiary_id
global_inventory_relationships	account_subsidiary_map.subsidiary_id = global_inventory_relationships.inventory_subsidiary_id account_subsidiary_map.subsidiary_id = global_inventory_relationships.originating_subsidiary_id
item_account_map	account_subsidiary_map.subsidiary_id = item_account_map.subsidiary_id
item_subsidiary_map	account_subsidiary_map.subsidiary_id = item_subsidiary_map.subsidiary_id
item_vendor_map	account_subsidiary_map.subsidiary_id = item_vendor_map.subsidiary_id
partners	account_subsidiary_map.subsidiary_id = partners.subsidiary
role_subsidiary_map	account_subsidiary_map.subsidiary_id = role_subsidiary_map.subsidiary_id
subscription_plans	account_subsidiary_map.subsidiary_id = subscription_plans.subsidiary_id
subsidiary_class_map	account_subsidiary_map.subsidiary_id = subsidiary_class_map.subsidiary_id
subsidiary_department_map	account_subsidiary_map.subsidiary_id = subsidiary_department_map.subsidiary_id
support_incidents	account_subsidiary_map.subsidiary_id = support_incidents.subsidiary_id
subsidiaries	account_subsidiary_map.subsidiary_id = subsidiaries.billing_subsidiary_id
vendor_subsidiary_map	account_subsidiary_map.subsidiary_id = vendor_subsidiary_map.subsidiary_id
vendors	account_subsidiary_map.subsidiary_id = vendors.subsidiary account_subsidiary_map.subsidiary_id = vendors.represents_subsidiary_id

account_subsidiary_map table schema

account_id

INTEGER

subsidiary_id

INTEGER

{{ system-column.record-hash }}

STRING

accounting_books

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

accounting_books table foreign keys

Join accounting_books with	on
account_activity	accounting_books.accounting_book_id = account_activity.accounting_book_id accounting_books.base_book_id = account_activity.accounting_book_id
account_period_activity	accounting_books.accounting_book_id = account_period_activity.accounting_book_id accounting_books.base_book_id = account_period_activity.accounting_book_id
account_period_activity_pe	accounting_books.accounting_book_id = account_period_activity_pe.accounting_book_id accounting_books.base_book_id = account_period_activity_pe.accounting_book_id
budget	accounting_books.accounting_book_id = budget.accounting_book_id accounting_books.base_book_id = budget.accounting_book_id
expense_plans	accounting_books.accounting_book_id = expense_plans.transaction_book_id accounting_books.base_book_id = expense_plans.transaction_book_id
global_account_map	accounting_books.accounting_book_id = global_account_map.accounting_book_id accounting_books.base_book_id = global_account_map.accounting_book_id
item_account_map	accounting_books.accounting_book_id = item_account_map.accounting_book_id accounting_books.base_book_id = item_account_map.accounting_book_id
posting_account_activity	accounting_books.accounting_book_id = posting_account_activity.accounting_book_id accounting_books.base_book_id = posting_account_activity.accounting_book_id
posting_account_activity_pe	accounting_books.accounting_book_id = posting_account_activity_pe.accounting_book_id accounting_books.base_book_id = posting_account_activity_pe.accounting_book_id
transaction_book_map	accounting_books.accounting_book_id = transaction_book_map.accounting_book_id accounting_books.base_book_id = transaction_book_map.accounting_book_id
transaction_line_book_map	accounting_books.accounting_book_id = transaction_line_book_map.accounting_book_id accounting_books.base_book_id = transaction_line_book_map.accounting_book_id

accounting_books table schema

accounting_book_extid

STRING

accounting_book_id

INTEGER

accounting_book_name

STRING

base_book_id

INTEGER

date_created

DATE-TIME

date_last_modified

DATE-TIME

effective_period_id

INTEGER

form_template_component_id

STRING

form_template_id

INTEGER

is_adjustment_only

STRING

is_arrangement_level_reclass

STRING

is_consolidated

STRING

is_contingent_revenue_handling

STRING

is_include_child_subsidiaries

STRING

is_primary

STRING

is_two_step_revenue_allocation

STRING

status

STRING

unbilled_receivable_grouping

STRING

{{ system-column.record-hash }}

STRING

accounting_periods

The accounting_periods table contains info about accounting periods.

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

accounting_periods table foreign keys

Join accounting_periods with	on
account_period_activity	accounting_periods.accounting_period_id = account_period_activity.accounting_period_id accounting_periods.parent_id = account_period_activity.accounting_period_id accounting_periods.year_id = account_period_activity.accounting_period_id
account_period_activity_pe	accounting_periods.accounting_period_id = account_period_activity_pe.accounting_period_id accounting_periods.parent_id = account_period_activity_pe.accounting_period_id accounting_periods.year_id = account_period_activity_pe.accounting_period_id
amortization_sched_lines	accounting_periods.accounting_period_id = amortization_sched_lines.accounting_period_id accounting_periods.parent_id = amortization_sched_lines.accounting_period_id accounting_periods.year_id = amortization_sched_lines.accounting_period_id
budget	accounting_periods.accounting_period_id = budget.accounting_period_id accounting_periods.parent_id = budget.accounting_period_id accounting_periods.year_id = budget.accounting_period_id
consolidated_exchange_rates	accounting_periods.accounting_period_id = consolidated_exchange_rates.accounting_period_id accounting_periods.parent_id = consolidated_exchange_rates.accounting_period_id accounting_periods.year_id = consolidated_exchange_rates.accounting_period_id
customers	accounting_periods.accounting_period_id = customers.first_sale_period_id accounting_periods.parent_id = customers.first_sale_period_id accounting_periods.year_id = customers.first_sale_period_id accounting_periods.accounting_period_id = customers.last_sale_period_id accounting_periods.parent_id = customers.last_sale_period_id accounting_periods.year_id = customers.last_sale_period_id
expense_plan_lines	accounting_periods.accounting_period_id = expense_plan_lines.accounting_period_id accounting_periods.parent_id = expense_plan_lines.accounting_period_id accounting_periods.year_id = expense_plan_lines.accounting_period_id
expense_plans	accounting_periods.accounting_period_id = expense_plans.accounting_period_id accounting_periods.parent_id = expense_plans.accounting_period_id accounting_periods.year_id = expense_plans.accounting_period_id
opportunities	accounting_periods.accounting_period_id = opportunities.accounting_period_id accounting_periods.parent_id = opportunities.accounting_period_id accounting_periods.year_id = opportunities.accounting_period_id
posting_account_activity	accounting_periods.accounting_period_id = posting_account_activity.accounting_period_id accounting_periods.parent_id = posting_account_activity.accounting_period_id accounting_periods.year_id = posting_account_activity.accounting_period_id
posting_account_activity_pe	accounting_periods.accounting_period_id = posting_account_activity_pe.accounting_period_id accounting_periods.parent_id = posting_account_activity_pe.accounting_period_id accounting_periods.year_id = posting_account_activity_pe.accounting_period_id
revenue_plan_lines	accounting_periods.accounting_period_id = revenue_plan_lines.accounting_period_id accounting_periods.parent_id = revenue_plan_lines.accounting_period_id accounting_periods.year_id = revenue_plan_lines.accounting_period_id
revenue_plan_version_lines	accounting_periods.accounting_period_id = revenue_plan_version_lines.accounting_period_id accounting_periods.parent_id = revenue_plan_version_lines.accounting_period_id accounting_periods.year_id = revenue_plan_version_lines.accounting_period_id
revenue_plans	accounting_periods.accounting_period_id = revenue_plans.accounting_period_id accounting_periods.parent_id = revenue_plans.accounting_period_id accounting_periods.year_id = revenue_plans.accounting_period_id
revrecschedulelines	accounting_periods.accounting_period_id = revrecschedulelines.accounting_period_id accounting_periods.parent_id = revrecschedulelines.accounting_period_id accounting_periods.year_id = revrecschedulelines.accounting_period_id

accounting_periods table schema

accounting_period_id

INTEGER

closed

STRING

closed_accounts_payable

STRING

closed_accounts_receivable

STRING

closed_all

STRING

closed_on

DATE-TIME

closed_payroll

STRING

date_last_modified

DATE-TIME

ending

DATE-TIME

fiscal_calendar_id

INTEGER

full_name

STRING

is_adjustment

STRING

isinactive

STRING

locked_accounts_payable

STRING

locked_accounts_receivable

STRING

locked_all

STRING

locked_payroll

STRING

name

STRING

parent_id

INTEGER

quarter

STRING

starting

DATE-TIME

year_0

STRING

year_id

INTEGER

{{ system-column.record-hash }}

STRING

accounts

The accounts table contains info about the accounts in the Chart of Accounts in your NetSuite Suite Analytics account.

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

accounts table foreign keys

Join accounts with	on
account_activity	accounts.deferral_account_id = account_activity.account_id accounts.parent_id = account_activity.account_id accounts.department_id = account_activity.department_id
account_period_activity	accounts.deferral_account_id = account_period_activity.account_id accounts.parent_id = account_period_activity.account_id accounts.department_id = account_period_activity.department_id
account_period_activity_pe	accounts.deferral_account_id = account_period_activity_pe.account_id accounts.parent_id = account_period_activity_pe.account_id accounts.department_id = account_period_activity_pe.department_id
account_subsidiary_map	accounts.deferral_account_id = account_subsidiary_map.account_id accounts.parent_id = account_subsidiary_map.account_id
amortization_sched_lines	accounts.deferral_account_id = amortization_sched_lines.account_id accounts.parent_id = amortization_sched_lines.account_id
budget	accounts.deferral_account_id = budget.account_id accounts.parent_id = budget.account_id accounts.class_id = budget.class_id accounts.department_id = budget.department_id accounts.location_id = budget.location_id
customers	accounts.deferral_account_id = customers.default_receivables_account_id accounts.parent_id = customers.default_receivables_account_id
employees	accounts.deferral_account_id = employees.def_acct_corp_card_expenses_id accounts.parent_id = employees.def_acct_corp_card_expenses_id accounts.class_id = employees.class_id accounts.currency_id = employees.def_expense_report_currency_id accounts.department_id = employees.department_id accounts.location_id = employees.location_id
expense_accounts	accounts.deferral_account_id = expense_accounts.expense_account_id accounts.parent_id = expense_accounts.expense_account_id
expense_amortization_rules	accounts.deferral_account_id = expense_amortization_rules.contra_account_id accounts.parent_id = expense_amortization_rules.contra_account_id
expense_plan_lines	accounts.deferral_account_id = expense_plan_lines.deferred_expense_account_id accounts.parent_id = expense_plan_lines.deferred_expense_account_id accounts.deferral_account_id = expense_plan_lines.expense_account_id accounts.parent_id = expense_plan_lines.expense_account_id
global_account_map	accounts.deferral_account_id = global_account_map.destination_account_id accounts.parent_id = global_account_map.destination_account_id accounts.deferral_account_id = global_account_map.source_account_id accounts.parent_id = global_account_map.source_account_id accounts.class_id = global_account_map.class_id accounts.department_id = global_account_map.department_id accounts.location_id = global_account_map.location_id
income_accounts	accounts.deferral_account_id = income_accounts.income_account_id accounts.parent_id = income_accounts.income_account_id
income_account_map	accounts.deferral_account_id = income_account_map.destination_account_id accounts.parent_id = income_account_map.destination_account_id accounts.deferral_account_id = income_account_map.source_account_id accounts.parent_id = income_account_map.source_account_id
opportunity_lines	accounts.deferral_account_id = opportunity_lines.account_id accounts.parent_id = opportunity_lines.account_id accounts.class_id = opportunity_lines.class_id accounts.department_id = opportunity_lines.department_id accounts.location_id = opportunity_lines.location_id
posting_account_activity	accounts.deferral_account_id = posting_account_activity.account_id accounts.parent_id = posting_account_activity.account_id accounts.class_id = posting_account_activity.class_id accounts.department_id = posting_account_activity.department_id accounts.location_id = posting_account_activity.location_id
posting_account_activity_pe	accounts.deferral_account_id = posting_account_activity_pe.account_id accounts.parent_id = posting_account_activity_pe.account_id accounts.class_id = posting_account_activity_pe.class_id accounts.department_id = posting_account_activity_pe.department_id accounts.location_id = posting_account_activity_pe.location_id
revaluation	accounts.deferral_account_id = revaluation.variance_account_id accounts.parent_id = revaluation.variance_account_id
revenue_plan_lines	accounts.deferral_account_id = revenue_plan_lines.deferral_account_id accounts.parent_id = revenue_plan_lines.deferral_account_id accounts.deferral_account_id = revenue_plan_lines.recognition_account_id accounts.parent_id = revenue_plan_lines.recognition_account_id
revrecschedulelines	accounts.deferral_account_id = revrecschedulelines.account_id accounts.parent_id = revrecschedulelines.account_id
sales_reps	accounts.deferral_account_id = sales_reps.def_acct_corp_card_expenses_id accounts.parent_id = sales_reps.def_acct_corp_card_expenses_id accounts.currency_id = sales_reps.currency_id
support_reps	accounts.deferral_account_id = support_reps.def_acct_corp_card_expenses_id accounts.parent_id = support_reps.def_acct_corp_card_expenses_id accounts.currency_id = support_reps.currency_id
transaction_history	accounts.deferral_account_id = transaction_history.account_id accounts.parent_id = transaction_history.account_id
transaction_line_book_map	accounts.deferral_account_id = transaction_line_book_map.account_id accounts.parent_id = transaction_line_book_map.account_id
transaction_lines	accounts.deferral_account_id = transaction_lines.account_id accounts.parent_id = transaction_lines.account_id
transaction_tax_detail	accounts.deferral_account_id = transaction_tax_detail.account_id accounts.parent_id = transaction_tax_detail.account_id
transactions	accounts.deferral_account_id = transactions.account_id accounts.parent_id = transactions.account_id
classes	accounts.class_id = classes.class_id accounts.class_id = classes.parent_id
employee_time	accounts.class_id = employee_time.class_id accounts.department_id = employee_time.department_id accounts.location_id = employee_time.location_id
item_account_map	accounts.class_id = item_account_map.class_id accounts.department_id = item_account_map.department_id accounts.location_id = item_account_map.location_id
subscription_plans	accounts.class_id = subscription_plans.class_id accounts.department_id = subscription_plans.department_id accounts.location_id = subscription_plans.location_id
subsidiary_class_map	accounts.class_id = subsidiary_class_map.class_id
billing_class_rates	accounts.currency_id = billing_class_rates.currency_id
companies	accounts.currency_id = companies.currency_id
currencies	accounts.currency_id = currencies.currency_id
customer_currencies	accounts.currency_id = customer_currencies.currency_id
employee_currency_map	accounts.currency_id = employee_currency_map.currency_id
inbound_shipments	accounts.currency_id = inbound_shipments.currency_id
item_billing_rates	accounts.currency_id = item_billing_rates.currency_id
item_price_history	accounts.currency_id = item_price_history.currency_id
item_vendor_pricing	accounts.currency_id = item_vendor_pricing.currency_id
location_costing_groups	accounts.currency_id = location_costing_groups.currency_id
opportunities	accounts.currency_id = opportunities.currency_id
departments	accounts.department_id = departments.department_id accounts.department_id = departments.parent_id
subsidiary_department_map	accounts.department_id = subsidiary_department_map.department_id
billing_accounts	accounts.location_id = billing_accounts.location_id
location_costing_grp_locations	accounts.location_id = location_costing_grp_locations.location_id
locations	accounts.location_id = locations.location_id accounts.location_id = locations.parent_id
planned_standard_costs	accounts.location_id = planned_standard_costs.location_id
subsidiary_location_map	accounts.location_id = subsidiary_location_map.location_id

accounts table schema

account_extid

STRING

account_id

INTEGER

accountnumber

STRING

cashflow_rate_type

STRING

category_1099_misc

STRING

category_1099_misc_mthreshold

NUMBER

class_id

INTEGER

currency_id

INTEGER

date_last_modified

DATE-TIME

deferral_account_id

INTEGER

department_id

INTEGER

description

STRING

full_description

STRING

full_name

STRING

general_rate_type

STRING

is_balancesheet

STRING

is_included_in_elimination

STRING

is_included_in_reval

STRING

is_including_child_subs

STRING

is_leftside

STRING

is_summary

STRING

isinactive

STRING

legal_name

STRING

location_id

INTEGER

name

STRING

openbalance

INTEGER

parent_id

INTEGER

type_name

STRING

type_sequence

INTEGER

{{ system-column.record-hash }}

STRING

activities

The activities table contains info about activities.

Note: As this table doesn’t have a Primary Key, data will be loaded using Append-Only loading even if your destination supports and is configured to use Upserts.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

activities table schema

access_level

STRING

activity_id

INTEGER

assigned_to_id

INTEGER

case_id

INTEGER

contact_id

INTEGER

date_0

DATE-TIME

date_completed

DATE-TIME

date_created

DATE-TIME

date_last_modified

DATE-TIME

entity_id

INTEGER

memo

STRING

opportunity_id

STRING

owner_id

INTEGER

status

STRING

title

STRING

type_0

STRING

address_book

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

address_book table foreign keys

Join address_book with	on
addresses	address_book.address_id = addresses.address_id

address_book table schema

address

STRING

address_book_id

INTEGER

address_id

INTEGER

address_line_1

STRING

address_line_2

STRING

address_line_3

STRING

attention

STRING

city

STRING

company

STRING

country

STRING

date_last_modified

DATE-TIME

entity_id

INTEGER

is_default_bill_address

STRING

is_default_ship_address

STRING

is_inactive

STRING

name

STRING

phone

STRING

state

STRING

zip

STRING

{{ system-column.record-hash }}

STRING

addresses

The addresses table contains info about all address instances.

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

addresses table foreign keys

Join addresses with	on
address_book	addresses.address_id = address_book.address_id

addresses table schema

address

STRING

address_id

INTEGER

address_line_1

STRING

address_line_2

STRING

address_line_3

STRING

attention

STRING

city

STRING

company

STRING

country

STRING

date_last_modified

DATE-TIME

is_overridden

STRING

phone

STRING

state

STRING

zip

STRING

{{ system-column.record-hash }}

STRING

amortization_sched_lines

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

amortization_sched_lines table foreign keys

Join amortization_sched_lines with	on
account_activity	amortization_sched_lines.account_id = account_activity.account_id
account_period_activity	amortization_sched_lines.account_id = account_period_activity.account_id amortization_sched_lines.accounting_period_id = account_period_activity.accounting_period_id
account_period_activity_pe	amortization_sched_lines.account_id = account_period_activity_pe.account_id amortization_sched_lines.accounting_period_id = account_period_activity_pe.accounting_period_id
account_subsidiary_map	amortization_sched_lines.account_id = account_subsidiary_map.account_id
accounts	amortization_sched_lines.account_id = accounts.deferral_account_id amortization_sched_lines.account_id = accounts.parent_id
budget	amortization_sched_lines.account_id = budget.account_id amortization_sched_lines.accounting_period_id = budget.accounting_period_id
customers	amortization_sched_lines.account_id = customers.default_receivables_account_id amortization_sched_lines.accounting_period_id = customers.first_sale_period_id amortization_sched_lines.accounting_period_id = customers.last_sale_period_id
employees	amortization_sched_lines.account_id = employees.def_acct_corp_card_expenses_id
expense_accounts	amortization_sched_lines.account_id = expense_accounts.expense_account_id
expense_amortization_rules	amortization_sched_lines.account_id = expense_amortization_rules.contra_account_id
expense_plan_lines	amortization_sched_lines.account_id = expense_plan_lines.deferred_expense_account_id amortization_sched_lines.account_id = expense_plan_lines.expense_account_id amortization_sched_lines.accounting_period_id = expense_plan_lines.accounting_period_id amortization_sched_lines.journal_id = expense_plan_lines.journal_id
global_account_map	amortization_sched_lines.account_id = global_account_map.destination_account_id amortization_sched_lines.account_id = global_account_map.source_account_id
income_accounts	amortization_sched_lines.account_id = income_accounts.income_account_id
income_account_map	amortization_sched_lines.account_id = income_account_map.destination_account_id amortization_sched_lines.account_id = income_account_map.source_account_id
opportunity_lines	amortization_sched_lines.account_id = opportunity_lines.account_id
posting_account_activity	amortization_sched_lines.account_id = posting_account_activity.account_id amortization_sched_lines.accounting_period_id = posting_account_activity.accounting_period_id
posting_account_activity_pe	amortization_sched_lines.account_id = posting_account_activity_pe.account_id amortization_sched_lines.accounting_period_id = posting_account_activity_pe.accounting_period_id
revaluation	amortization_sched_lines.account_id = revaluation.variance_account_id
revenue_plan_lines	amortization_sched_lines.account_id = revenue_plan_lines.deferral_account_id amortization_sched_lines.account_id = revenue_plan_lines.recognition_account_id amortization_sched_lines.accounting_period_id = revenue_plan_lines.accounting_period_id amortization_sched_lines.journal_id = revenue_plan_lines.journal_id
revrecschedulelines	amortization_sched_lines.account_id = revrecschedulelines.account_id amortization_sched_lines.accounting_period_id = revrecschedulelines.accounting_period_id amortization_sched_lines.journal_id = revrecschedulelines.journal_id
sales_reps	amortization_sched_lines.account_id = sales_reps.def_acct_corp_card_expenses_id
support_reps	amortization_sched_lines.account_id = support_reps.def_acct_corp_card_expenses_id
transaction_history	amortization_sched_lines.account_id = transaction_history.account_id amortization_sched_lines.journal_id = transaction_history.transaction_id
transaction_line_book_map	amortization_sched_lines.account_id = transaction_line_book_map.account_id
transaction_lines	amortization_sched_lines.account_id = transaction_lines.account_id amortization_sched_lines.journal_id = transaction_lines.transaction_id
transaction_tax_detail	amortization_sched_lines.account_id = transaction_tax_detail.account_id
transactions	amortization_sched_lines.account_id = transactions.account_id
accounting_periods	amortization_sched_lines.accounting_period_id = accounting_periods.accounting_period_id amortization_sched_lines.accounting_period_id = accounting_periods.parent_id amortization_sched_lines.accounting_period_id = accounting_periods.year_id
consolidated_exchange_rates	amortization_sched_lines.accounting_period_id = consolidated_exchange_rates.accounting_period_id
expense_plans	amortization_sched_lines.accounting_period_id = expense_plans.accounting_period_id amortization_sched_lines.journal_id = expense_plans.related_revenue_arrangement_id
opportunities	amortization_sched_lines.accounting_period_id = opportunities.accounting_period_id amortization_sched_lines.journal_id = opportunities.reversing-transaction-id
revenue_plan_version_lines	amortization_sched_lines.accounting_period_id = revenue_plan_version_lines.accounting_period_id amortization_sched_lines.journal_id = revenue_plan_version_lines.journal_id
revenue_plans	amortization_sched_lines.accounting_period_id = revenue_plans.accounting_period_id
amortization_schedules	amortization_sched_lines.schedule_id = amortization_schedules.schedule_id
billing_subscription_lines	amortization_sched_lines.journal_id = billing_subscription_lines.purchase_order_id amortization_sched_lines.journal_id = billing_subscription_lines.sales_order_id
billing_subscriptions	amortization_sched_lines.journal_id = billing_subscriptions.sales_order_id
campaignresponsehistory	amortization_sched_lines.journal_id = campaignresponsehistory.transaction_id
employee_time	amortization_sched_lines.journal_id = employee_time.transaction_id
notes_system_custom	amortization_sched_lines.journal_id = notes_system_custom.transaction_id
notes_system	amortization_sched_lines.journal_id = notes_system.transaction_id
notes_user	amortization_sched_lines.journal_id = notes_user.transaction_id
system_notes_custom	amortization_sched_lines.journal_id = system_notes_custom.transaction_id
system_notes	amortization_sched_lines.journal_id = system_notes.transaction_id
transaction_address	amortization_sched_lines.journal_id = transaction_address.transaction_id
transaction_book_map	amortization_sched_lines.journal_id = transaction_book_map.transaction_id
transaction_links	amortization_sched_lines.journal_id = transaction_links.applied_transaction_id amortization_sched_lines.journal_id = transaction_links.original_transaction_id
transaction_shipping_groups	amortization_sched_lines.journal_id = transaction_shipping_groups.transaction_id

amortization_sched_lines table schema

account_id

INTEGER

accounting_period_id

INTEGER

amount

STRING

is_recognized

STRING

journal_id

INTEGER

schedule_id

INTEGER

{{ system-column.record-hash }}

STRING

amortization_schedules

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

amortization_schedules table foreign keys

Join amortization_schedules with	on
amortization_sched_lines	amortization_schedules.schedule_id = amortization_sched_lines.schedule_id

amortization_schedules table schema

amount

NUMBER

initial_amount

STRING

is_template

STRING

name

STRING

period_offset

INTEGER

residual

STRING

schedule_id

INTEGER

schedule_method

STRING

schedule_number

STRING

schedule_type

STRING

start_offset

INTEGER

term_source

STRING

{{ system-column.record-hash }}

STRING

bill_of_distributions

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

bill_of_distributions table schema

bill_of_distribution_extid

STRING

bill_of_distribution_id

INTEGER

date_created

DATE-TIME

distribution_category_id

INTEGER

distribution_network_id

INTEGER

is_inactive

STRING

location_id

INTEGER

subsidiary_id

INTEGER

{{ system-column.record-hash }}

STRING

bill_of_materials

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

bill_of_materials table foreign keys

Join bill_of_materials with	on
bom_revisions	bill_of_materials.bill_of_materials_id = bom_revisions.bill_of_materials_id
billing_rate_cards_prices	bill_of_materials.original_assembly_id = billing_rate_cards_prices.service_item_id
billing_subscription_lines	bill_of_materials.original_assembly_id = billing_subscription_lines.item_id
bom_revision_components	bill_of_materials.original_assembly_id = bom_revision_components.item_id
budget	bill_of_materials.original_assembly_id = budget.item_id
campaignitem	bill_of_materials.original_assembly_id = campaignitem.item_id
customers	bill_of_materials.original_assembly_id = customers.tax_item_id
item_collection_item_map	bill_of_materials.original_assembly_id = item_collection_item_map.item_id
item_price_history	bill_of_materials.original_assembly_id = item_price_history.item_id
item_subsidiary_map	bill_of_materials.original_assembly_id = item_subsidiary_map.item_id
item_vendor_map	bill_of_materials.original_assembly_id = item_vendor_map.item_id
item_vendor_pricing	bill_of_materials.original_assembly_id = item_vendor_pricing.item_id
items	bill_of_materials.original_assembly_id = items.item_id
notes_system_custom	bill_of_materials.original_assembly_id = notes_system_custom.item_id
notes_system	bill_of_materials.original_assembly_id = notes_system.item_id
notes_user	bill_of_materials.original_assembly_id = notes_user.item_id
opportunity_lines	bill_of_materials.original_assembly_id = opportunity_lines.item_id bill_of_materials.original_assembly_id = opportunity_lines.tax_item_id
planned_standard_costs	bill_of_materials.original_assembly_id = planned_standard_costs.item_id
posting_account_activity	bill_of_materials.original_assembly_id = posting_account_activity.item_id
posting_account_activity_pe	bill_of_materials.original_assembly_id = posting_account_activity_pe.item_id
purchase_charge_rules	bill_of_materials.original_assembly_id = purchase_charge_rules.mark_up_item_id
standard_cost_components	bill_of_materials.original_assembly_id = standard_cost_components.component_id
subscription_co_lines	bill_of_materials.original_assembly_id = subscription_co_lines.plan_item_id
subscription_plan_lines	bill_of_materials.original_assembly_id = subscription_plan_lines.item_id
support_incidents	bill_of_materials.original_assembly_id = support_incidents.item_id
system_notes_custom	bill_of_materials.original_assembly_id = system_notes_custom.item_id
system_notes	bill_of_materials.original_assembly_id = system_notes.item_id
transaction_tax_detail	bill_of_materials.original_assembly_id = transaction_tax_detail.item_id

bill_of_materials table schema

available_for_all_assemblies

STRING

available_for_all_locations

STRING

bill_of_materials_extid

STRING

bill_of_materials_id

INTEGER

date_created

DATE-TIME

exclude_child_subsidiaries

STRING

form_template_component_id

STRING

form_template_id

INTEGER

is_inactive

STRING

memo

STRING

name

STRING

original_assembly_id

INTEGER

use_component_yield

STRING

{{ system-column.record-hash }}

STRING

billing_accounts

The billing_accounts table contains info about the billing accounts in your NetSuite account. A billing account is a record used to show all billing information for a customer or subcustomer. A billing account contains billing-specific information, including billing schedule, default payment terms, bill-to address, and currency.

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

billing_accounts table foreign keys

Join billing_accounts with	on
address_books	billing_accounts.address_book_id = address_books.address_book_id billing_accounts.bill_to_address_book_id = address_books.address_book_id billing_accounts.ship_to_address_book_id = address_books.address_book_id
billing_subscriptions	billing_accounts.billing_account_id = billing_subscriptions.billing_account_id
billing_schedule_descriptions	billing_accounts.billing_schedule_id = billing_schedule_descriptions.billing_schedule_id
charges	billing_accounts.billing_schedule_id = charges.billing_schedule_id
customers	billing_accounts.billing_schedule_id = customers.billing_schedule_id
transaction_lines	billing_accounts.billing_schedule_id = transaction_lines.billing_schedule_id
accounts	billing_accounts.location_id = accounts.location_id
budget	billing_accounts.location_id = budget.location_id
employee_time	billing_accounts.location_id = employee_time.location_id
employees	billing_accounts.location_id = employees.location_id
global_account_map	billing_accounts.location_id = global_account_map.location_id
item_account_map	billing_accounts.location_id = item_account_map.location_id
location_costing_grp_locations	billing_accounts.location_id = location_costing_grp_locations.location_id
locations	billing_accounts.location_id = locations.location_id billing_accounts.location_id = locations.parent_id
opportunity_lines	billing_accounts.location_id = opportunity_lines.location_id
planned_standard_costs	billing_accounts.location_id = planned_standard_costs.location_id
posting_account_activity	billing_accounts.location_id = posting_account_activity.location_id
posting_account_activity_pe	billing_accounts.location_id = posting_account_activity_pe.location_id
subscription_plans	billing_accounts.location_id = subscription_plans.location_id
subsidiary_location_map	billing_accounts.location_id = subsidiary_location_map.location_id

billing_accounts table schema

address_book_id

INTEGER

bill_to_address_book_id

INTEGER

billing_account_extid

INTEGER

billing_account_id

INTEGER

billing_account_memo

STRING

billing_account_name

STRING

billing_account_number

STRING

billing_schedule_id

INTEGER

class_id

INTEGER

currency_id

INTEGER

customer_id

INTEGER

date_created

DATE-TIME

date_last_actual_bill

DATE-TIME

date_last_bill_cycle

DATE-TIME

date_last_modified

DATE-TIME

date_next_bill_cycle

DATE-TIME

date_start

DATE-TIME

department_id

INTEGER

has_off_cycle_bill_request

STRING

is_customer_default

STRING

is_inactive

STRING

location_id

INTEGER

ship_to_address_book_id

INTEGER

{{ system-column.record-hash }}

STRING

billing_class_rates

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

billing_class_rates table foreign keys

Join billing_class_rates with	on
billing_rate_card_prices	billing_class_rates.billing_class_id = billing_rate_card_prices.billing_class_id
employee_time	billing_class_rates.billing_class_id = employee_time.billing_class_id
employees	billing_class_rates.billing_class_id = employees.billing_class_id billing_class_rates.currency_id = employees.def_expense_report_currency_id
item_billing_rates	billing_class_rates.billing_class_id = item_billing_rates.billing_class_id billing_class_rates.currency_id = item_billing_rates.currency_id
billing_rate_cards_prices	billing_class_rates.billing_rate_card_id = billing_rate_cards_prices.billing_rate_card_id
billing_rate_cards_versions	billing_class_rates.billing_rate_card_id = billing_rate_cards_versions.billing_rate_card_id
project_templates	billing_class_rates.billing_rate_card_id = project_templates.template_id
time_based_charge_rules	billing_class_rates.billing_rate_card_id = time_based_charge_rules.billing_rate_card_id
accounts	billing_class_rates.currency_id = accounts.currency_id
companies	billing_class_rates.currency_id = companies.currency_id
currencies	billing_class_rates.currency_id = currencies.currency_id
customer_currencies	billing_class_rates.currency_id = customer_currencies.currency_id
employee_currency_map	billing_class_rates.currency_id = employee_currency_map.currency_id
inbound_shipments	billing_class_rates.currency_id = inbound_shipments.currency_id
item_price_history	billing_class_rates.currency_id = item_price_history.currency_id
item_vendor_pricing	billing_class_rates.currency_id = item_vendor_pricing.currency_id
location_costing_groups	billing_class_rates.currency_id = location_costing_groups.currency_id
opportunities	billing_class_rates.currency_id = opportunities.currency_id
sales_reps	billing_class_rates.currency_id = sales_reps.currency_id
support_reps	billing_class_rates.currency_id = support_reps.currency_id

billing_class_rates table schema

billing_class_id

INTEGER

billing_rate_card_id

INTEGER

currency_id

INTEGER

unit_price

NUMBER

{{ system-column.record-hash }}

STRING

billing_classes

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

billing_classes table schema

billing_class_extid

STRING

billing_class_id

INTEGER

description

STRING

is_inactive

STRING

name

STRING

sale_unit_id

INTEGER

units_type_id

INTEGER

{{ system-column.record-hash }}

STRING

billing_rate_cards

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

billing_rate_cards table foreign keys

Join billing_rate_cards with	on
budget	billing_rate_cards.customer_id = budget.customer_id
customer_currencies	billing_rate_cards.customer_id = customer_currencies.customer_id
customer_subsidiary_map	billing_rate_cards.customer_id = customer_subsidiary_map.customer_id
customers	billing_rate_cards.customer_id = customers.customer_id billing_rate_cards.customer_id = customers.top_level_parent_id
employee_time	billing_rate_cards.customer_id = employee_time.customer_id

billing_rate_cards table schema

billing_rate_card_extid

STRING

billing_rate_card_id

INTEGER

customer_id

INTEGER

date_created

DATE-TIME

date_last_modified

DATE-TIME

is_inactive

STRING

name

STRING

{{ system-column.record-hash }}

STRING

billing_rate_cards_prices

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

billing_rate_cards_prices table foreign keys

Join billing_rate_cards_prices with	on
billing_class_rates	billing_rate_cards_prices.billing_rate_card_id = billing_class_rates.billing_rate_card_id
billing_rate_cards_versions	billing_rate_cards_prices.billing_rate_card_id = billing_rate_cards_versions.billing_rate_card_id billing_rate_cards_prices.version0 = billing_rate_cards_versions.version0
project_templates	billing_rate_cards_prices.billing_rate_card_id = project_templates.template_id
time_based_charge_rules	billing_rate_cards_prices.billing_rate_card_id = time_based_charge_rules.billing_rate_card_id
bill_of_materials	billing_rate_cards_prices.service_item_id = bill_of_materials.original_assembly_id
billing_subscription_lines	billing_rate_cards_prices.service_item_id = billing_subscription_lines.item_id
bom_revision_components	billing_rate_cards_prices.service_item_id = bom_revision_components.item_id billing_rate_cards_prices.sales_unit_id = bom_revision_components.unit_of_measure_id
budget	billing_rate_cards_prices.service_item_id = budget.item_id
campaignitem	billing_rate_cards_prices.service_item_id = campaignitem.item_id
customers	billing_rate_cards_prices.service_item_id = customers.tax_item_id
item_collection_item_map	billing_rate_cards_prices.service_item_id = item_collection_item_map.item_id
item_price_history	billing_rate_cards_prices.service_item_id = item_price_history.item_id
item_subsidiary_map	billing_rate_cards_prices.service_item_id = item_subsidiary_map.item_id
item_vendor_map	billing_rate_cards_prices.service_item_id = item_vendor_map.item_id
item_vendor_pricing	billing_rate_cards_prices.service_item_id = item_vendor_pricing.item_id
items	billing_rate_cards_prices.service_item_id = items.item_id
notes_system_custom	billing_rate_cards_prices.service_item_id = notes_system_custom.item_id
notes_system	billing_rate_cards_prices.service_item_id = notes_system.item_id
notes_user	billing_rate_cards_prices.service_item_id = notes_user.item_id
opportunity_lines	billing_rate_cards_prices.service_item_id = opportunity_lines.item_id billing_rate_cards_prices.service_item_id = opportunity_lines.tax_item_id
planned_standard_costs	billing_rate_cards_prices.service_item_id = planned_standard_costs.item_id
posting_account_activity	billing_rate_cards_prices.service_item_id = posting_account_activity.item_id
posting_account_activity_pe	billing_rate_cards_prices.service_item_id = posting_account_activity_pe.item_id
purchase_charge_rules	billing_rate_cards_prices.service_item_id = purchase_charge_rules.mark_up_item_id
standard_cost_components	billing_rate_cards_prices.service_item_id = standard_cost_components.component_id
subscription_co_lines	billing_rate_cards_prices.service_item_id = subscription_co_lines.plan_item_id
subscription_plan_lines	billing_rate_cards_prices.service_item_id = subscription_plan_lines.item_id
support_incidents	billing_rate_cards_prices.service_item_id = support_incidents.item_id
system_notes_custom	billing_rate_cards_prices.service_item_id = system_notes_custom.item_id
system_notes	billing_rate_cards_prices.service_item_id = system_notes.item_id
transaction_tax_detail	billing_rate_cards_prices.service_item_id = transaction_tax_detail.item_id
unit_types	billing_rate_cards_prices.unit_type_id = unit_types.unit_type_id
item_group	billing_rate_cards_prices.sales_unit_id = item_group.unit_of_measure_id
uom	billing_rate_cards_prices.sales_unit_id = uom.uom_id

billing_rate_cards_prices table schema

billing_class_id

INTEGER

billing_rate_card_id

INTEGER

currency_id

INTEGER

sales_unit_id

INTEGER

service_item_id

INTEGER

unit_price

INTEGER

units_type_id

INTEGER

version0

INTEGER

{{ system-column.record-hash }}

STRING

billing_rate_cards_versions

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

billing_rate_cards_versions table foreign keys

Join billing_rate_cards_versions with	on
billing_class_rates	billing_rate_cards_versions.billing_rate_card_id = billing_class_rates.billing_rate_card_id
billing_rate_cards_prices	billing_rate_cards_versions.billing_rate_card_id = billing_rate_cards_prices.billing_rate_card_id billing_rate_cards_versions.version0 = billing_rate_cards_prices.version0
project_templates	billing_rate_cards_versions.billing_rate_card_id = project_templates.template_id billing_rate_cards_versions.last_modified_by_id = project_templates.project_manager_id
time_based_charge_rules	billing_rate_cards_versions.billing_rate_card_id = time_based_charge_rules.billing_rate_card_id
customers	billing_rate_cards_versions.last_modified_by_id = customers.project_manager_id
employee_currency_map	billing_rate_cards_versions.last_modified_by_id = employee_currency_map.employee_id
employees	billing_rate_cards_versions.last_modified_by_id = employees.employee_id billing_rate_cards_versions.last_modified_by_id = employees.approver_id billing_rate_cards_versions.last_modified_by_id = employees.supervisor_id
project_revenue_rules	billing_rate_cards_versions.last_modified_by_id = project_revenue_rules.created_by billing_rate_cards_versions.last_modified_by_id = project_revenue_rules.last_modified_by
revenue_plan_versions	billing_rate_cards_versions.last_modified_by_id = revenue_plan_versions.created_by_id
subscription_change_orders	billing_rate_cards_versions.last_modified_by_id = subscription_change_orders.requester_id
unlocked_time_periods	billing_rate_cards_versions.last_modified_by_id = unlocked_time_periods.last_modified_by_id billing_rate_cards_versions.last_modified_by_id = unlocked_time_periods.employee_id
vendors	billing_rate_cards_versions.last_modified_by_id = vendors.time_approver_id

billing_rate_cards_versions table schema

billing_rate_card_id

INTEGER

date_created

DATE-TIME

date_effective

DATE-TIME

last_modified_by_id

INTEGER

version0

INTEGER

{{ system-column.record-hash }}

STRING

billing_schedule

The billing_schedule table contains info about the billing schedules in your NetSuite account.

Replication Method

Full Table

Loading Behavior

Append-Only

Useful links

NetSuite Suite Analytics documentation

billing_schedule table schema

bill_amount

NUMBER

bill_amount_foreign

NUMBER

bill_count

NUMBER

bill_date

DATE-TIME

bill_net_amount

INTEGER

bill_net_amount_foreign

INTEGER

milestone_id

INTEGER

payment_terms_id

INTEGER

rev_rec_end_date

DATE-TIME

rev_rec_start_date

DATE-TIME

transaction_id

INTEGER

transaction_line_id

INTEGER

billing_schedule

The billing_schedule table contains info about the billing schedules in your NetSuite account.

Replication Method

Full Table

Useful links

NetSuite Suite Analytics documentation

billing_schedule table schema

bill_amount

NUMBER

bill_amount_foreign

NUMBER

bill_count

NUMBER

bill_date

DATE-TIME

bill_net_amount

INTEGER

bill_net_amount_foreign

INTEGER

milestone_id

INTEGER

payment_terms_id

INTEGER

rev_rec_end_date

DATE-TIME

rev_rec_start_date

DATE-TIME

transaction_id

INTEGER

transaction_line_id

INTEGER

billing_schedule_descriptions

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

billing_schedule_descriptions table foreign keys

Join billing_schedule_descriptions with	on
billing_accounts	billing_schedule_descriptions.billing_schedule_id = billing_accounts.billing_schedule_id
charges	billing_schedule_descriptions.billing_schedule_id = charges.billing_schedule_id
customers	billing_schedule_descriptions.billing_schedule_id = customers.billing_schedule_id
transaction_lines	billing_schedule_descriptions.billing_schedule_id = transaction_lines.billing_schedule_id

billing_schedule_descriptions table schema

billing_schedule_id

INTEGER

billing_schedule_type

STRING

frequency

STRING

name

STRING

recurrence_count

INTEGER

{{ system-column.record-hash }}

STRING

billing_subscription_lines

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

billing_subscription_lines table foreign keys

Join billing_subscription_lines with	on
subscript_line_price_intervals	billing_subscription_lines.subline_id = subscript_line_price_intervals.subscription_line_id billing_subscription_lines.usage_multiplier_line_id = subscript_line_price_intervals.subscription_line_id billing_subscription_lines.subscription_plan_line_id = subscript_line_price_intervals.plan_line_id
subscription_co_lines	billing_subscription_lines.subline_id = subscription_co_lines.subscription_line_id billing_subscription_lines.usage_multiplier_line_id = subscription_co_lines.subscription_line_id billing_subscription_lines.subscription_id = subscription_co_lines.subscription_id billing_subscription_lines.item_id = subscription_co_lines.plan_item_id
subscription_line_revisions	billing_subscription_lines.subline_id = subscription_line_revisions.subscription_line_id billing_subscription_lines.usage_multiplier_line_id = subscription_line_revisions.subscription_line_id
billing_subscriptions	billing_subscription_lines.subscription_id = billing_subscriptions.subscription_id billing_subscription_lines.purchase_order_id = billing_subscriptions.sales_order_id billing_subscription_lines.sales_order_id = billing_subscriptions.sales_order_id
subscription_change_orders	billing_subscription_lines.subscription_id = subscription_change_orders.subscription_id
bill_of_materials	billing_subscription_lines.item_id = bill_of_materials.original_assembly_id
billing_rate_cards_prices	billing_subscription_lines.item_id = billing_rate_cards_prices.service_item_id
bom_revision_components	billing_subscription_lines.item_id = bom_revision_components.item_id
budget	billing_subscription_lines.item_id = budget.item_id
campaignitem	billing_subscription_lines.item_id = campaignitem.item_id
customers	billing_subscription_lines.item_id = customers.tax_item_id
item_collection_item_map	billing_subscription_lines.item_id = item_collection_item_map.item_id
item_price_history	billing_subscription_lines.item_id = item_price_history.item_id
item_subsidiary_map	billing_subscription_lines.item_id = item_subsidiary_map.item_id
item_vendor_map	billing_subscription_lines.item_id = item_vendor_map.item_id
item_vendor_pricing	billing_subscription_lines.item_id = item_vendor_pricing.item_id
items	billing_subscription_lines.item_id = items.item_id
notes_system_custom	billing_subscription_lines.item_id = notes_system_custom.item_id billing_subscription_lines.purchase_order_id = notes_system_custom.transaction_id billing_subscription_lines.sales_order_id = notes_system_custom.transaction_id
notes_system	billing_subscription_lines.item_id = notes_system.item_id billing_subscription_lines.purchase_order_id = notes_system.transaction_id billing_subscription_lines.sales_order_id = notes_system.transaction_id
notes_user	billing_subscription_lines.item_id = notes_user.item_id billing_subscription_lines.purchase_order_id = notes_user.transaction_id billing_subscription_lines.sales_order_id = notes_user.transaction_id
opportunity_lines	billing_subscription_lines.item_id = opportunity_lines.item_id billing_subscription_lines.item_id = opportunity_lines.tax_item_id
planned_standard_costs	billing_subscription_lines.item_id = planned_standard_costs.item_id
posting_account_activity	billing_subscription_lines.item_id = posting_account_activity.item_id
posting_account_activity_pe	billing_subscription_lines.item_id = posting_account_activity_pe.item_id
purchase_charge_rules	billing_subscription_lines.item_id = purchase_charge_rules.mark_up_item_id
standard_cost_components	billing_subscription_lines.item_id = standard_cost_components.component_id
subscription_plan_lines	billing_subscription_lines.item_id = subscription_plan_lines.item_id billing_subscription_lines.subscription_plan_line_id = subscription_plan_lines.plan_line_id billing_subscription_lines.subscription_plan_line_id = subscription_plan_lines.usage_multiplier_line_id
support_incidents	billing_subscription_lines.item_id = support_incidents.item_id
system_notes_custom	billing_subscription_lines.item_id = system_notes_custom.item_id billing_subscription_lines.purchase_order_id = system_notes_custom.transaction_id billing_subscription_lines.sales_order_id = system_notes_custom.transaction_id
system_notes	billing_subscription_lines.item_id = system_notes.item_id billing_subscription_lines.purchase_order_id = system_notes.transaction_id billing_subscription_lines.sales_order_id = system_notes.transaction_id
transaction_tax_detail	billing_subscription_lines.item_id = transaction_tax_detail.item_id
price_book_line_intervals	billing_subscription_lines.subscription_plan_line_id = price_book_line_intervals.plan_line_id billing_subscription_lines.subscription_plan_line_id = price_book_line_intervals.usage_multiplier_line_id
amortization_sched_lines	billing_subscription_lines.purchase_order_id = amortization_sched_lines.journal_id billing_subscription_lines.sales_order_id = amortization_sched_lines.journal_id
campaignresponsehistory	billing_subscription_lines.purchase_order_id = campaignresponsehistory.transaction_id billing_subscription_lines.sales_order_id = campaignresponsehistory.transaction_id
employee_time	billing_subscription_lines.purchase_order_id = employee_time.transaction_id billing_subscription_lines.sales_order_id = employee_time.transaction_id
expense_plan_lines	billing_subscription_lines.purchase_order_id = expense_plan_lines.journal_id billing_subscription_lines.sales_order_id = expense_plan_lines.journal_id
expense_plans	billing_subscription_lines.purchase_order_id = expense_plans.related_revenue_arrangement_id billing_subscription_lines.sales_order_id = expense_plans.related_revenue_arrangement_id
opportunities	billing_subscription_lines.purchase_order_id = opportunities.reversing-transaction-id billing_subscription_lines.sales_order_id = opportunities.reversing-transaction-id
revenue_plan_lines	billing_subscription_lines.purchase_order_id = revenue_plan_lines.journal_id billing_subscription_lines.sales_order_id = revenue_plan_lines.journal_id
revenue_plan_version_lines	billing_subscription_lines.purchase_order_id = revenue_plan_version_lines.journal_id billing_subscription_lines.sales_order_id = revenue_plan_version_lines.journal_id
revrecschedulelines	billing_subscription_lines.purchase_order_id = revrecschedulelines.journal_id billing_subscription_lines.sales_order_id = revrecschedulelines.journal_id
transaction_address	billing_subscription_lines.purchase_order_id = transaction_address.transaction_id billing_subscription_lines.sales_order_id = transaction_address.transaction_id
transaction_book_map	billing_subscription_lines.purchase_order_id = transaction_book_map.transaction_id billing_subscription_lines.sales_order_id = transaction_book_map.transaction_id
transaction_history	billing_subscription_lines.purchase_order_id = transaction_history.transaction_id billing_subscription_lines.sales_order_id = transaction_history.transaction_id
transaction_lines	billing_subscription_lines.purchase_order_id = transaction_lines.transaction_id billing_subscription_lines.sales_order_id = transaction_lines.transaction_id
transaction_links	billing_subscription_lines.purchase_order_id = transaction_links.applied_transaction_id billing_subscription_lines.sales_order_id = transaction_links.applied_transaction_id billing_subscription_lines.purchase_order_id = transaction_links.original_transaction_id billing_subscription_lines.sales_order_id = transaction_links.original_transaction_id
transaction_shipping_groups	billing_subscription_lines.purchase_order_id = transaction_shipping_groups.transaction_id billing_subscription_lines.sales_order_id = transaction_shipping_groups.transaction_id

billing_subscription_lines table schema

billing_mode_id

STRING

catalog_type

STRING

date_created

DATE-TIME

date_end

DATE-TIME

date_last_modified

DATE-TIME

date_recurrence_start

DATE-TIME

date_start

DATE-TIME

date_termination

DATE-TIME

discount

NUMBER

is_discount_percentage

STRING

is_include_in_renewal

STRING

is_prorate_end_date

STRING

is_prorate_start_date

STRING

item_id

INTEGER

line_type

STRING

period_amount

NUMBER

price_interval_group_id

INTEGER

purchase_order_id

STRING

quantity

NUMBER

recurring_amount

NUMBER

sales_order_id

INTEGER

sales_order_line_number

INTEGER

status_id

STRING

subline_extid

STRING

subline_id

INTEGER

subline_number

INTEGER

subscription_id

INTEGER

subscription_plan_line_id

INTEGER

usage_multiplier_line_id

INTEGER

{{ system-column.record-hash }}

STRING

billing_subscriptions

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

billing_subscriptions table foreign keys

Join billing_subscriptions with	on
billing_accounts	billing_subscriptions.billing_account_id = billing_accounts.billing_account_id
billing_subscription_lines	billing_subscriptions.subscription_id = billing_subscription_lines.subscription_id billing_subscriptions.sales_order_id = billing_subscription_lines.purchase_order_id billing_subscriptions.sales_order_id = billing_subscription_lines.sales_order_id
subscription_change_orders	billing_subscriptions.subscription_id = subscription_change_orders.subscription_id billing_subscriptions.default_renewal_plan_id = subscription_change_orders.renewal_subscription_plan_id billing_subscriptions.plan_id = subscription_change_orders.renewal_subscription_plan_id billing_subscriptions.default_renewal_term_id = subscription_change_orders.renewal_term_id billing_subscriptions.initial_term_id = subscription_change_orders.renewal_term_id
subscription_co_lines	billing_subscriptions.subscription_id = subscription_co_lines.subscription_id
price_books	billing_subscriptions.default_renewal_plan_id = price_books.plan_id billing_subscriptions.plan_id = price_books.plan_id
subscription_plan_lines	billing_subscriptions.default_renewal_plan_id = subscription_plan_lines.parent_id billing_subscriptions.plan_id = subscription_plan_lines.parent_id
subscription_plans	billing_subscriptions.default_renewal_plan_id = subscription_plans.plan_id billing_subscriptions.plan_id = subscription_plans.plan_id billing_subscriptions.default_renewal_plan_id = subscription_plans.default_renewal_plan_id billing_subscriptions.plan_id = subscription_plans.default_renewal_plan_id billing_subscriptions.default_renewal_term_id = subscription_plans.initial_term_id billing_subscriptions.initial_term_id = subscription_plans.initial_term_id billing_subscriptions.default_renewal_term_id = subscription_plans.default_renewal_term_id billing_subscriptions.initial_term_id = subscription_plans.default_renewal_term_id
subscription_terms	billing_subscriptions.default_renewal_term_id = subscription_terms.term_id billing_subscriptions.initial_term_id = subscription_terms.term_id
amortization_sched_lines	billing_subscriptions.sales_order_id = amortization_sched_lines.journal_id
campaignresponsehistory	billing_subscriptions.sales_order_id = campaignresponsehistory.transaction_id
employee_time	billing_subscriptions.sales_order_id = employee_time.transaction_id
expense_plan_lines	billing_subscriptions.sales_order_id = expense_plan_lines.journal_id
expense_plans	billing_subscriptions.sales_order_id = expense_plans.related_revenue_arrangement_id
notes_system_custom	billing_subscriptions.sales_order_id = notes_system_custom.transaction_id
notes_system	billing_subscriptions.sales_order_id = notes_system.transaction_id
notes_user	billing_subscriptions.sales_order_id = notes_user.transaction_id
opportunities	billing_subscriptions.sales_order_id = opportunities.reversing-transaction-id
revenue_plan_lines	billing_subscriptions.sales_order_id = revenue_plan_lines.journal_id
revenue_plan_version_lines	billing_subscriptions.sales_order_id = revenue_plan_version_lines.journal_id
revrecschedulelines	billing_subscriptions.sales_order_id = revrecschedulelines.journal_id
system_notes_custom	billing_subscriptions.sales_order_id = system_notes_custom.transaction_id
system_notes	billing_subscriptions.sales_order_id = system_notes.transaction_id
transaction_address	billing_subscriptions.sales_order_id = transaction_address.transaction_id
transaction_book_map	billing_subscriptions.sales_order_id = transaction_book_map.transaction_id
transaction_history	billing_subscriptions.sales_order_id = transaction_history.transaction_id
transaction_lines	billing_subscriptions.sales_order_id = transaction_lines.transaction_id
transaction_links	billing_subscriptions.sales_order_id = transaction_links.applied_transaction_id billing_subscriptions.sales_order_id = transaction_links.original_transaction_id
transaction_shipping_groups	billing_subscriptions.sales_order_id = transaction_shipping_groups.transaction_id

billing_subscriptions table schema

advance_renewal_period_number

INTEGER

advance_renewal_period_unit_id

STRING

amount

NUMBER

billing_account_id

INTEGER

currency

STRING

date_created

DATE-TIME

date_end

DATE-TIME

date_estimated_revrec_end

DATE-TIME

date_last_modified

DATE-TIME

date_start

DATE-TIME

default_renewal_method_id

STRING

default_renewal_plan_id

INTEGER

default_renewal_price_book_id

INTEGER

default_renewal_term_id

INTEGER

default_renewal_trantype_id

STRING

description

STRING

generate_modification_elements

STRING

initial_term_id

INTEGER

is_auto_renewal

STRING

is_sub_start_date_as_rsd

STRING

name

STRING

plan_id

INTEGER

price_book_id

INTEGER

sales_order_id

INTEGER

subscription_extid

STRING

subscription_id

INTEGER

subscription_number

STRING

subscription_revision

INTEGER

{{ system-column.record-hash }}

STRING

bin_number

Replication Method

Full Table

Loading Behavior

Append-Only

Useful links

NetSuite Suite Analytics documentation

bin_number table schema

bin_id

INTEGER

bin_number

STRING

bin_number_extid

STRING

isinactive

STRING

ispreferred

STRING

item_id

INTEGER

location_id

INTEGER

memo

STRING

on_hand_count

INTEGER

bin_number_counts

Replication Method

Full Table

Loading Behavior

Append-Only

Useful links

NetSuite Suite Analytics documentation

bin_number_counts table schema

available_count

INTEGER

bin_id

INTEGER

bin_number

STRING

item_id

INTEGER

location_id

INTEGER

on_hand_count

INTEGER

bins

The bins table contains info about bins, or places in your warehouse where you store inventory items.

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

bins table schema

bin_id

INTEGER

bin_number

INTEGER

external_id

INTEGER

is_inactive

STRING

location_id

INTEGER

memo

STRING

{{ system-column.record-hash }}

STRING

bom_revision_components

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

bom_revision_components table foreign keys

Join bom_revision_components with	on
bom_revisions	bom_revision_components.bom_revision_id = bom_revisions.bom_revision_id
bill_of_materials	bom_revision_components.item_id = bill_of_materials.original_assembly_id
billing_rate_cards_prices	bom_revision_components.item_id = billing_rate_cards_prices.service_item_id bom_revision_components.unit_of_measure_id = billing_rate_cards_prices.sales_unit_id
billing_subscription_lines	bom_revision_components.item_id = billing_subscription_lines.item_id
budget	bom_revision_components.item_id = budget.item_id
campaignitem	bom_revision_components.item_id = campaignitem.item_id
customers	bom_revision_components.item_id = customers.tax_item_id
item_collection_item_map	bom_revision_components.item_id = item_collection_item_map.item_id
item_price_history	bom_revision_components.item_id = item_price_history.item_id
item_subsidiary_map	bom_revision_components.item_id = item_subsidiary_map.item_id
item_vendor_map	bom_revision_components.item_id = item_vendor_map.item_id
item_vendor_pricing	bom_revision_components.item_id = item_vendor_pricing.item_id
items	bom_revision_components.item_id = items.item_id
notes_system_custom	bom_revision_components.item_id = notes_system_custom.item_id
notes_system	bom_revision_components.item_id = notes_system.item_id
notes_user	bom_revision_components.item_id = notes_user.item_id
opportunity_lines	bom_revision_components.item_id = opportunity_lines.item_id bom_revision_components.item_id = opportunity_lines.tax_item_id
planned_standard_costs	bom_revision_components.item_id = planned_standard_costs.item_id
posting_account_activity	bom_revision_components.item_id = posting_account_activity.item_id
posting_account_activity_pe	bom_revision_components.item_id = posting_account_activity_pe.item_id
purchase_charge_rules	bom_revision_components.item_id = purchase_charge_rules.mark_up_item_id
standard_cost_components	bom_revision_components.item_id = standard_cost_components.component_id
subscription_co_lines	bom_revision_components.item_id = subscription_co_lines.plan_item_id
subscription_plan_lines	bom_revision_components.item_id = subscription_plan_lines.item_id
support_incidents	bom_revision_components.item_id = support_incidents.item_id
system_notes_custom	bom_revision_components.item_id = system_notes_custom.item_id
system_notes	bom_revision_components.item_id = system_notes.item_id
transaction_tax_detail	bom_revision_components.item_id = transaction_tax_detail.item_id
item_group	bom_revision_components.unit_of_measure_id = item_group.unit_of_measure_id
uom	bom_revision_components.unit_of_measure_id = uom.uom_id

bom_revision_components table schema

bom_revision_component_id

INTEGER

bom_revision_id

INTEGER

component_yield

INTEGER

item_id

INTEGER

item_source

STRING

quantity

NUMBER

seq_num

INTEGER

unit_of_measure_id

INTEGER

{{ system-column.record-hash }}

STRING

bom_revisions

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

bom_revisions table foreign keys

Join bom_revisions with	on
bill_of_materials	bom_revisions.bill_of_materials_id = bill_of_materials.bill_of_materials_id
bom_revision_components	bom_revisions.bom_revision_id = bom_revision_components.bom_revision_id

bom_revisions table schema

bill_of_materials_id

INTEGER

bom_revision_extid

STRING

bom_revision_id

INTEGER

date_created

DATE-TIME

date_effective

DATE-TIME

date_obsolete

DATE-TIME

form_template_component_id

STRING

form_template_id

INTEGER

is_inactive

STRING

memo

STRING

name

STRING

{{ system-column.record-hash }}

STRING

budget

The budget table contains info about the budgets in your NetSuite Suite Analytics account. A budget records the expected values of income and expenses for your business. Budgets can be created for specific customers, items, departments, classes, locations, or any combination of these criteria.

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

budget table foreign keys

Join budget with	on
account_activity	budget.account_id = account_activity.account_id budget.accounting_book_id = account_activity.accounting_book_id budget.department_id = account_activity.department_id budget.subsidiary_id = account_activity.subsidiary_id
account_period_activity	budget.account_id = account_period_activity.account_id budget.accounting_book_id = account_period_activity.accounting_book_id budget.accounting_period_id = account_period_activity.accounting_period_id budget.department_id = account_period_activity.department_id budget.subsidiary_id = account_period_activity.subsidiary_id
account_period_activity_pe	budget.account_id = account_period_activity_pe.account_id budget.accounting_book_id = account_period_activity_pe.accounting_book_id budget.accounting_period_id = account_period_activity_pe.accounting_period_id budget.department_id = account_period_activity_pe.department_id budget.subsidiary_id = account_period_activity_pe.balance_from_subsidiary_id budget.subsidiary_id = account_period_activity_pe.subsidiary_id
account_subsidiary_map	budget.account_id = account_subsidiary_map.account_id budget.subsidiary_id = account_subsidiary_map.subsidiary_id
accounts	budget.account_id = accounts.deferral_account_id budget.account_id = accounts.parent_id budget.class_id = accounts.class_id budget.department_id = accounts.department_id budget.location_id = accounts.location_id
amortization_sched_lines	budget.account_id = amortization_sched_lines.account_id budget.accounting_period_id = amortization_sched_lines.accounting_period_id
customers	budget.account_id = customers.default_receivables_account_id budget.accounting_period_id = customers.first_sale_period_id budget.accounting_period_id = customers.last_sale_period_id budget.customer_id = customers.customer_id budget.customer_id = customers.top_level_parent_id budget.item_id = customers.tax_item_id budget.subsidiary_id = customers.subsidiary_id budget.subsidiary_id = customers.represents_subsidiary_id
employees	budget.account_id = employees.def_acct_corp_card_expenses_id budget.class_id = employees.class_id budget.department_id = employees.department_id budget.location_id = employees.location_id budget.subsidiary_id = employees.subsidiary_id
expense_accounts	budget.account_id = expense_accounts.expense_account_id
expense_amortization_rules	budget.account_id = expense_amortization_rules.contra_account_id
expense_plan_lines	budget.account_id = expense_plan_lines.deferred_expense_account_id budget.account_id = expense_plan_lines.expense_account_id budget.accounting_period_id = expense_plan_lines.accounting_period_id
global_account_map	budget.account_id = global_account_map.destination_account_id budget.account_id = global_account_map.source_account_id budget.accounting_book_id = global_account_map.accounting_book_id budget.class_id = global_account_map.class_id budget.department_id = global_account_map.department_id budget.location_id = global_account_map.location_id budget.subsidiary_id = global_account_map.subsidiary_id
income_accounts	budget.account_id = income_accounts.income_account_id
income_account_map	budget.account_id = income_account_map.destination_account_id budget.account_id = income_account_map.source_account_id
opportunity_lines	budget.account_id = opportunity_lines.account_id budget.class_id = opportunity_lines.class_id budget.department_id = opportunity_lines.department_id budget.item_id = opportunity_lines.item_id budget.item_id = opportunity_lines.tax_item_id budget.location_id = opportunity_lines.location_id budget.subsidiary_id = opportunity_lines.subsidiary_id
posting_account_activity	budget.account_id = posting_account_activity.account_id budget.accounting_book_id = posting_account_activity.accounting_book_id budget.accounting_period_id = posting_account_activity.accounting_period_id budget.class_id = posting_account_activity.class_id budget.department_id = posting_account_activity.department_id budget.item_id = posting_account_activity.item_id budget.location_id = posting_account_activity.location_id budget.subsidiary_id = posting_account_activity.subsidiary_id
posting_account_activity_pe	budget.account_id = posting_account_activity_pe.account_id budget.accounting_book_id = posting_account_activity_pe.accounting_book_id budget.accounting_period_id = posting_account_activity_pe.accounting_period_id budget.class_id = posting_account_activity_pe.class_id budget.department_id = posting_account_activity_pe.department_id budget.item_id = posting_account_activity_pe.item_id budget.location_id = posting_account_activity_pe.location_id budget.subsidiary_id = posting_account_activity_pe.subsidiary_id budget.subsidiary_id = posting_account_activity_pe.balance_from_subsidiary_id
revaluation	budget.account_id = revaluation.variance_account_id
revenue_plan_lines	budget.account_id = revenue_plan_lines.deferral_account_id budget.account_id = revenue_plan_lines.recognition_account_id budget.accounting_period_id = revenue_plan_lines.accounting_period_id
revrecschedulelines	budget.account_id = revrecschedulelines.account_id budget.accounting_period_id = revrecschedulelines.accounting_period_id
sales_reps	budget.account_id = sales_reps.def_acct_corp_card_expenses_id
support_reps	budget.account_id = support_reps.def_acct_corp_card_expenses_id
transaction_history	budget.account_id = transaction_history.account_id
transaction_line_book_map	budget.account_id = transaction_line_book_map.account_id budget.accounting_book_id = transaction_line_book_map.accounting_book_id
transaction_lines	budget.account_id = transaction_lines.account_id budget.subsidiary_id = transaction_lines.subsidiary_id budget.subsidiary_id = transaction_lines.source_subsidiary_id
transaction_tax_detail	budget.account_id = transaction_tax_detail.account_id budget.item_id = transaction_tax_detail.item_id
transactions	budget.account_id = transactions.account_id
accounting_books	budget.accounting_book_id = accounting_books.accounting_book_id budget.accounting_book_id = accounting_books.base_book_id
expense_plans	budget.accounting_book_id = expense_plans.transaction_book_id budget.accounting_period_id = expense_plans.accounting_period_id
item_account_map	budget.accounting_book_id = item_account_map.accounting_book_id budget.class_id = item_account_map.class_id budget.department_id = item_account_map.department_id budget.location_id = item_account_map.location_id budget.subsidiary_id = item_account_map.subsidiary_id
transaction_book_map	budget.accounting_book_id = transaction_book_map.accounting_book_id
accounting_periods	budget.accounting_period_id = accounting_periods.accounting_period_id budget.accounting_period_id = accounting_periods.parent_id budget.accounting_period_id = accounting_periods.year_id
consolidated_exchange_rates	budget.accounting_period_id = consolidated_exchange_rates.accounting_period_id budget.subsidiary_id = consolidated_exchange_rates.from_subsidiary_id budget.subsidiary_id = consolidated_exchange_rates.to_subsidiary_id
opportunities	budget.accounting_period_id = opportunities.accounting_period_id
revenue_plan_version_lines	budget.accounting_period_id = revenue_plan_version_lines.accounting_period_id
revenue_plans	budget.accounting_period_id = revenue_plans.accounting_period_id
budget_category	budget.category_id = budget_category.category_id
classes	budget.class_id = classes.class_id budget.class_id = classes.parent_id
employee_time	budget.class_id = employee_time.class_id budget.customer_id = employee_time.customer_id budget.department_id = employee_time.department_id budget.location_id = employee_time.location_id budget.subsidiary_id = employee_time.billing_subsidiary_id budget.subsidiary_id = employee_time.subsidiary_id
subscription_plans	budget.class_id = subscription_plans.class_id budget.department_id = subscription_plans.department_id budget.location_id = subscription_plans.location_id budget.subsidiary_id = subscription_plans.subsidiary_id
subsidiary_class_map	budget.class_id = subsidiary_class_map.class_id budget.subsidiary_id = subsidiary_class_map.subsidiary_id
billing_rate_cards	budget.customer_id = billing_rate_cards.customer_id
customer_currencies	budget.customer_id = customer_currencies.customer_id
customer_subsidiary_map	budget.customer_id = customer_subsidiary_map.customer_id budget.subsidiary_id = customer_subsidiary_map.subsidiary_id
departments	budget.department_id = departments.department_id budget.department_id = departments.parent_id
subsidiary_department_map	budget.department_id = subsidiary_department_map.department_id budget.subsidiary_id = subsidiary_department_map.subsidiary_id
bill_of_materials	budget.item_id = bill_of_materials.original_assembly_id
billing_rate_cards_prices	budget.item_id = billing_rate_cards_prices.service_item_id
billing_subscription_lines	budget.item_id = billing_subscription_lines.item_id
bom_revision_components	budget.item_id = bom_revision_components.item_id
campaignitem	budget.item_id = campaignitem.item_id
item_collection_item_map	budget.item_id = item_collection_item_map.item_id
item_price_history	budget.item_id = item_price_history.item_id
item_subsidiary_map	budget.item_id = item_subsidiary_map.item_id budget.subsidiary_id = item_subsidiary_map.subsidiary_id
item_vendor_map	budget.item_id = item_vendor_map.item_id budget.subsidiary_id = item_vendor_map.subsidiary_id
item_vendor_pricing	budget.item_id = item_vendor_pricing.item_id
items	budget.item_id = items.item_id
notes_system_custom	budget.item_id = notes_system_custom.item_id
notes_system	budget.item_id = notes_system.item_id
notes_user	budget.item_id = notes_user.item_id
planned_standard_costs	budget.item_id = planned_standard_costs.item_id budget.location_id = planned_standard_costs.location_id
purchase_charge_rules	budget.item_id = purchase_charge_rules.mark_up_item_id
standard_cost_components	budget.item_id = standard_cost_components.component_id
subscription_co_lines	budget.item_id = subscription_co_lines.plan_item_id
subscription_plan_lines	budget.item_id = subscription_plan_lines.item_id
support_incidents	budget.item_id = support_incidents.item_id budget.subsidiary_id = support_incidents.subsidiary_id
system_notes_custom	budget.item_id = system_notes_custom.item_id
system_notes	budget.item_id = system_notes.item_id
billing_accounts	budget.location_id = billing_accounts.location_id
location_costing_grp_locations	budget.location_id = location_costing_grp_locations.location_id
locations	budget.location_id = locations.location_id budget.location_id = locations.parent_id
subsidiary_location_map	budget.location_id = subsidiary_location_map.location_id
companies	budget.subsidiary_id = companies.subsidiary_id
expense_categories_subs_map	budget.subsidiary_id = expense_categories_subs_map.subsidiary_id
global_inventory_relationships	budget.subsidiary_id = global_inventory_relationships.inventory_subsidiary_id budget.subsidiary_id = global_inventory_relationships.originating_subsidiary_id
partners	budget.subsidiary_id = partners.subsidiary
role_subsidiary_map	budget.subsidiary_id = role_subsidiary_map.subsidiary_id
subsidiaries	budget.subsidiary_id = subsidiaries.billing_subsidiary_id
vendor_subsidiary_map	budget.subsidiary_id = vendor_subsidiary_map.subsidiary_id
vendors	budget.subsidiary_id = vendors.subsidiary budget.subsidiary_id = vendors.represents_subsidiary_id

budget table schema

account_id

NUMBER

accounting_book_id

NUMBER

accounting_period_id

NUMBER

amount

NUMBER

budget_date

DATE-TIME

budget_id

NUMBER

category_id

NUMBER

class_id

NUMBER

customer_id

NUMBER

department_id

NUMBER

item_id

NUMBER

location_id

NUMBER

subsidiary_id

NUMBER

{{ system-column.record-hash }}

STRING

budget_category

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

budget_category table foreign keys

Join budget_category with	on
budget	budget_category.category_id = budget.category_id

budget_category table schema

budget_category_id

INTEGER

is_global

STRING

isinactive

STRING

name

STRING

{{ system-column.record-hash }}

STRING

calls

Note: As this table doesn’t have a Primary Key, data will be loaded using Append-Only loading even if your destination supports and is configured to use Upserts.

Replication Method	Key-based Incremental
Loading Behavior	Append-Only
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

calls table schema

call_date

DATE-TIME

call_extid

STRING

call_id

INTEGER

case_id

INTEGER

company_id

INTEGER

date_completed

DATE-TIME

date_created

DATE-TIME

date_last_modified

DATE-TIME

note

STRING

opportunity_id

INTEGER

organizer_id

INTEGER

owner_id

INTEGER

phone

STRING

status

STRING

subject

STRING

campaign_audiences

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

campaign_audiences table foreign keys

Join campaign_audiences with	on
campaigns	campaign_audiences.campaignaudience_id = campaigns.audience_id

campaign_audiences table schema

campaignaudience_extid

STRING

campaignaudience_id

INTEGER

date_last_modified

DATE-TIME

description

STRING

isinactive

STRING

name

STRING

{{ system-column.record-hash }}

STRING

campaign_categories

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

campaign_categories table foreign keys

Join campaign_categories with	on
campaignevent	campaign_categories.default_campaign_id = campaignevent.campaign_id
campaignitem	campaign_categories.default_campaign_id = campaignitem.campaign_id
campaigns	campaign_categories.default_campaign_id = campaigns.campaign_id campaign_categories.campaigncategory_id = campaigns.category_id campaign_categories.parent_id = campaigns.category_id
customers	campaign_categories.default_campaign_id = customers.lead_source_id
opportunities	campaign_categories.default_campaign_id = opportunities.lead_source_id

campaign_categories table schema

campaigncategory_extid

STRING

campaigncategory_id

INTEGER

date_last_modified

DATE-TIME

default_campaign_id

INTEGER

description

STRING

is_available_externally

STRING

isinactive

STRING

name

STRING

parent_id

INTEGER

{{ system-column.record-hash }}

STRING

campaign_families

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

campaign_families table foreign keys

Join campaign_families with	on
campaigns	campaign_families.campaignfamily_id = campaigns.family_id

campaign_families table schema

campaignfamily_extid

STRING

campaignfamily_id

INTEGER

date_last_modified

DATE-TIME

description

STRING

isinactive

STRING

name

STRING

{{ system-column.record-hash }}

STRING

campaign_search_engine

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

campaign_search_engine table foreign keys

Join campaign_search_engine with	on
campaigns	campaign_search_engine.search_engine_id = campaigns.search_engine_id

campaign_search_engine table schema

date_last_modified

DATE-TIME

description

STRING

isinactive

STRING

name

STRING

search_engine_extid

STRING

search_engine_id

INTEGER

{{ system-column.record-hash }}

STRING

campaign_subscription_statuses

If you set this table to replicate and select Key-based Incremental Replication, you’ll need to also select a Replication Key.

There are multiple possible Replication Keys for this table:

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Keys	date_last_modified last_modified_date
Useful links	NetSuite Suite Analytics documentation

campaign_subscription_statuses table foreign keys

Join campaign_subscription_statuses with	on
campaign_subscriptions	campaign_subscription_statuses.subscription_id = campaign_subscriptions.campaignsubscription_id
campaignevent	campaign_subscription_statuses.subscription_id = campaignevent.subscription_id
campaignresponse	campaign_subscription_statuses.entity_id = campaignresponse.entity_id
campaignresponsehistory	campaign_subscription_statuses.entity_id = campaignresponsehistory.author
campaigns	campaign_subscription_statuses.entity_id = campaigns.organizer_id
caseescalationhistory	campaign_subscription_statuses.entity_id = caseescalationhistory.escalator_id campaign_subscription_statuses.entity_id = caseescalationhistory.entity_id
contact_types	campaign_subscription_statuses.entity_id = contact_types.contact_id campaign_subscription_statuses.entity_id = contact_types.owner_id
currency_exchange_rates	campaign_subscription_statuses.entity_id = currency_exchange_rates.entity_id
currencyrates	campaign_subscription_statuses.entity_id = currencyrates.entity_id
customers	campaign_subscription_statuses.entity_id = customers.converted_to_id campaign_subscription_statuses.entity_id = customers.converted_to_contact_id campaign_subscription_statuses.entity_id = customers.sales_rep_id campaign_subscription_statuses.entity_id = customers.parent_id
entity_role_map	campaign_subscription_statuses.entity_id = entity_role_map.entity_id
entityterritorymap	campaign_subscription_statuses.entity_id = entityterritorymap.entity_id
messagerecipient	campaign_subscription_statuses.entity_id = messagerecipient.entity_id
notes_system_custom	campaign_subscription_statuses.entity_id = notes_system_custom.company_id campaign_subscription_statuses.entity_id = notes_system_custom.author_id
notes_system	campaign_subscription_statuses.entity_id = notes_system.company_id campaign_subscription_statuses.entity_id = notes_system.author_id
notes_user	campaign_subscription_statuses.entity_id = notes_user.company_id
opportunities	campaign_subscription_statuses.entity_id = opportunities.sales_rep_id
opportunity_lines	campaign_subscription_statuses.entity_id = opportunity_lines.company_id campaign_subscription_statuses.entity_id = opportunity_lines.related_company_id
resource_group_entity_map	campaign_subscription_statuses.entity_id = resource_group_entity_map.entity_id
resource_groups	campaign_subscription_statuses.entity_id = resource_groups.resource_group_id
support_incidents	campaign_subscription_statuses.entity_id = support_incidents.owner_id campaign_subscription_statuses.entity_id = support_incidents.assigned_id campaign_subscription_statuses.entity_id = support_incidents.company_id
supportcasehistory	campaign_subscription_statuses.entity_id = supportcasehistory.employee_id
system_notes_custom	campaign_subscription_statuses.entity_id = system_notes_custom.company_id campaign_subscription_statuses.entity_id = system_notes_custom.author_id campaign_subscription_statuses.entity_id = system_notes_custom.customfield_created_by_id campaign_subscription_statuses.entity_id = system_notes_custom.customfield_modified_by_id
system_notes	campaign_subscription_statuses.entity_id = system_notes.company_id campaign_subscription_statuses.entity_id = system_notes.author_id
transaction_address	campaign_subscription_statuses.entity_id = transaction_address.created_by_id campaign_subscription_statuses.entity_id = transaction_address.last_modified_by_id
transaction_history	campaign_subscription_statuses.entity_id = transaction_history.user_id campaign_subscription_statuses.entity_id = transaction_history.entity_id

campaign_subscription_statuses table schema

date_last_modified

DATE-TIME

entity_id

INTEGER

last_modified_date

DATE-TIME

subscription_id

INTEGER

unsubscribed

STRING

{{ system-column.record-hash }}

STRING

campaign_subscriptions

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

campaign_subscriptions table foreign keys

Join campaign_subscriptions with	on
campaign_subscription_statuses	campaign_subscriptions.campaignsubscription_id = campaign_subscription_statuses.subscription_id
campaignevent	campaign_subscriptions.campaignsubscription_id = campaignevent.subscription_id

campaign_subscriptions table schema

campaignsubscription_extid

STRING

campaignsubscription_id

INTEGER

date_last_modified

DATE-TIME

description

STRING

isinactive

STRING

name

STRING

{{ system-column.record-hash }}

STRING

campaign_verticals

Replication Method	Key-based Incremental
Primary Key	_sdc_record_hash
Replication Key	date_last_modified
Useful links	NetSuite Suite Analytics documentation

campaign_verticals table foreign keys

Join campaign_verticals with	on
campaigns	campaign_verticals.vertical_id = campaigns.vertical_id

campaign_verticals table schema

campaignvertical_extid

STRING

campaignvertical_id

INTEGER

date_last_modified

DATE-TIME

description

STRING

isinactive

STRING

name

STRING

{{ system-column.record-hash }}

STRING

campaignchannel

Note: As this table doesn’t have a Primary Key, data will be