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.

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

    The SuiteAnalytics Connect permission in the Create Role screen in NetSuite

  5. Click Add to add the permission to the role.
  6. When finished, click Save to create the role.

Step 2: Get the role's internal ID

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

    The role's internal ID in the Manage Roles screen in NetSuite

    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.

  1. Using the global search, type page: new employee and click the Page: New Employees result.
  2. In the Employee page, fill in the Name, Email, and any other required fields.
  3. Click the Access tab, located in the bottom half of the page.
  4. 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.
  5. 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.

  1. On the home page of your NetSuite account, click Settings > Set Up SuiteAnalytics Connect:

    The NetSuite homepage with the Set Up SuiteAnalytics Connect option highlighted

  2. The next page will display the connection details in the Your Configuration section:

    The Your Configuration section of the Set Up SuiteAnalytics Connect page in NetSuite

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

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

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the NetSuite Suite Analytics icon.

  4. 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.

  5. In the Host field, paste the host value from Step 4.
  6. In the Port field, paste the port value from Step 4.
  7. In the Account ID field, paste the account ID field from Step 4.
  8. In the Role ID field, enter the role’s internal ID from Step 2.
  9. 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

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:

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

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:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. 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.
  5. Repeat this process for all the tables and columns you want to replicate.
  6. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. 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.

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.


NetSuite Suite Analytics replication

In this section:

Extraction

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

Discovery

During Discovery, Stitch will:

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:

  1. Combine all Primary Key column values on a per record basis
  2. Hash the result and place the hash in a system column named _sdc_record_hash
  3. Designate _sdc_record_hash as the table’s Primary Key. Primary Key columns will have a icon next to their name in Stitch.
  4. 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:

  1. If the table has Primary Keys identified during discovery.

  2. 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

account_activity

Replication Method

Full Table

Primary Key

_sdc_record_hash

Useful links

NetSuite Suite Analytics documentation

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_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

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_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

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_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

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_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

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_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

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_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

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

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

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

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

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

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

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

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

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

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

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_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

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

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

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

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

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_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_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

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_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

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_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

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_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

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

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

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_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

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_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

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

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_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

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

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

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_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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 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