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:

  • For tables using Key-based Incremental Replication, data equal to or newer than this date will be replicated to your destination.
  • For tables using Full Table Replication, all data - including records that are older, equal to, or newer than this date - will be replicated to your destination.

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

accounting_books

Replication Method :

Key-based Incremental

 Replication Key :

date_last_modified
Primary Key :

_sdc_record_hash

 Official docs :

Official Docs

accounting_books table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • accounting_book_id

date_last_modified
DATE-TIME

The time the accounting book was last modified.

accounting_book_extid
STRING

accounting_book_id
INTEGER

Reference:

accounting_book_name
STRING

base_book_id
INTEGER

Reference:

date_created
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

accounting_periods

Replication Method :

Key-based Incremental

 Replication Key :

date_last_modified
Primary Key :

_sdc_record_hash

 Official docs :

Official Docs

The accounting_periods table contains info about accounting periods.

accounting_periods table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • accounting_period_id

date_last_modified
DATE-TIME

The time the accounting period was last modified.

accounting_period_id
INTEGER

The accounting period ID. Note: This column is used to create the _sdc_record_hash value.

Reference:

closed
STRING

Indicates whether the period is closed.

closed_accounts_payable
STRING

Whether the period is closed for accounts payable.

closed_accounts_receivable
STRING

Whether the period is closed for accounts receivable.

closed_all
STRING

Whether the period is closed for all.

closed_on
DATE-TIME

The date the period was closed.

closed_payroll
STRING

Whether the period is closed for payroll.

ending
DATE-TIME

The end date for the period.

fiscal_calendar_id
INTEGER

The fiscal calendar for the period.

full_name
STRING

The full name of the period.

is_adjustment
STRING

Whether the period is an adjustment period.

isinactive
STRING

Whether the period is inactive.

locked_accounts_payable
STRING

Whether accounts payable is locked for the period.

locked_accounts_receivable
STRING

Whether accounts receivable is locked for the period.

locked_all
STRING

Whether all are locked for the period.

locked_payroll
STRING

Whether payroll is locked for the period.

name
STRING

The name of the period.

parent_id
INTEGER

The parent accounting period.

Reference:

quarter
STRING

Whether the period is a quarter.

starting
DATE-TIME

The start date of the period.

year_0
STRING

year_id
INTEGER

The year of the accounting period.

Reference:

accounts

Replication Method :

Key-based Incremental

 Replication Key :

date_last_modified
Primary Key :

_sdc_record_hash

 Official docs :

Official Docs

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

accounts table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • account_id

date_last_modified
DATE-TIME

The time the account was last modified.

account_id
INTEGER

The account ID. Note: This column is used to create the _sdc_record_hash value.

Reference:

account_extid
STRING

The account’s external ID.

accountnumber
STRING

The account number.

cashflow_rate_type
STRING

The cash flow rate type for the account.

category_1099_misc
STRING

The 1099-MISC category for the account.

category_1099_misc_mthreshold
NUMBER

The 1099-MISC category for the account.

class_id
INTEGER

The class for the account.

Reference:

currency_id
INTEGER

The ID of the currency for funds in the account.

Reference:

deferral_account_id
INTEGER

The deferral account for the account.

Reference:

department_id
INTEGER

The department with access to the account.

Reference:

description
STRING

The account description.

full_description
STRING

The full account description.

full_name
STRING

The full name for the account.

general_rate_type
STRING

The general rate type for the account.

is_balancesheet
STRING

is_included_in_elimination
STRING

is_included_in_reval
STRING

is_including_child_subs
STRING

Indicates whether the account is shared with all sub-subsidiaries associated with each subsidiary associated with the account.

is_leftside
STRING

is_summary
STRING

isinactive
STRING

Indicates if the account is inactive.

legal_name
STRING

The legal name of the account. Note: This requires that the Use Legal Name in Accounting preference is enabled in NetSuite.

location_id
INTEGER

The location with access to the account.

Reference:

name
STRING

The account name as it displays on reports.

openbalance
INTEGER

The open balance for the account.

parent_id
INTEGER

The parent account.

Reference:

type_name
STRING

The account type.

type_sequence
INTEGER

account_activity

Replication Method :

Full Table

 Primary Key :

_sdc_record_hash
Official docs :

Official Docs

account_activity table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • account_id

  • accounting_book_id

  • activity_date

  • department_id

  • is_hidden_custom_line

  • subsidiary_id

account_id
INTEGER

Reference:

accounting_book_id
INTEGER

Reference:

activity_date
DATE-TIME

amount
INTEGER

department_id
INTEGER

Reference:

is_hidden_custom_line
STRING

subsidiary_id
INTEGER

Reference:

account_period_activity

Replication Method :

Full Table

 Primary Key :

_sdc_record_hash
Official docs :

Official Docs

account_period_activity table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • account_id

  • accounting_book_id

  • accounting_period_id

  • department_id

  • subsidiary_id

account_id
INTEGER

Reference:

accounting_book_id
INTEGER

Reference:

accounting_period_id
INTEGER

Reference:

amount
INTEGER

department_id
INTEGER

Reference:

is_hidden_custom_line
STRING

subsidiary_id
INTEGER

Reference:

account_period_activity_pe

Replication Method :

Full Table

 Primary Key :

_sdc_record_hash
Official docs :

Official Docs

account_period_activity_pe table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • account_id

  • accounting_book_id

  • accounting_period_id

  • balance_from_subsidiary_id

  • department_id

  • subsidiary_id

account_id
INTEGER

Reference:

accounting_book_id
INTEGER

Reference:

accounting_period_id
INTEGER

Reference:

amount
INTEGER

balance_from_subsidiary_id
INTEGER

Reference:

department_id
INTEGER

Reference:

is_hidden_custom_line
STRING

subsidiary_id
INTEGER

Reference:

account_subsidiary_map

Replication Method :

Full Table

 Primary Key :

_sdc_record_hash
Official docs :

Official Docs

account_subsidiary_map table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • account_id

  • subsidiary_id

account_id
INTEGER

Reference:

subsidiary_id
INTEGER

Reference:

activities

Replication Method :

Key-based Incremental

 Replication Key :

date_last_modified
Primary Key :

None

 Official docs :

Official Docs
Loading Behavior:

Append-Only

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.

activities table schema

date_last_modified
DATE-TIME

The time the activity was last modified.

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

The date the activity was created. Note: According to NetSuite’s documentation, this field isn’t applicable to the note activity type.

entity_id
INTEGER

memo
STRING

The memo for the activity. From NetSuite’s documentation:

Memo. Long messages may be truncated. If you need a longer message, try joining the message column from the message table.

opportunity_id
STRING

owner_id
INTEGER

status
STRING

title
STRING

type_0
STRING

addresses

Replication Method :

Key-based Incremental

 Replication Key :

date_last_modified
Primary Key :

_sdc_record_hash

 Official docs :

Official Docs

The addresses table contains info about all address instances.

addresses table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • address_id

date_last_modified
DATE-TIME

The time the address was last modified.

address_id
INTEGER

The address ID. Note: This column is used to create the _sdc_record_hash value.

Reference:

address
STRING

Full address text. To create this field, NetSuite will combine all address fields.

address_line_1
STRING

The first line of the address.

address_line_2
STRING

The second line of the address.

address_line_3
STRING

The third line of the address.

attention
STRING

city
STRING

The city of the address.

company
STRING

The company of the address.

country
STRING

The country of the address.

is_overridden
STRING

Whether manually-defined address text is used instead of the address text generated by NetSuite.

phone
STRING

The phone number associated with the address.

state
STRING

The state of the address.

zip
STRING

The zip code of the address.

address_book

Replication Method :

Key-based Incremental

 Replication Key :

date_last_modified
Primary Key :

_sdc_record_hash

 Official docs :

Official Docs

address_book table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • address_book_id

date_last_modified
DATE-TIME

The time the address book was last modified.

address
STRING

address_book_id
INTEGER

Reference:

address_id
INTEGER

Reference:

address_line_1
STRING

address_line_2
STRING

address_line_3
STRING

attention
STRING

city
STRING

company
STRING

country
STRING

entity_id
INTEGER

is_default_bill_address
STRING

is_default_ship_address
STRING

is_inactive
STRING

name
STRING

phone
STRING

state
STRING

zip
STRING

amortization_schedules

Replication Method :

Full Table

 Primary Key :

_sdc_record_hash
Official docs :

Official Docs

amortization_schedules table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • schedule_id

amount
NUMBER

initial_amount
STRING

is_template
STRING

name
STRING

period_offset
INTEGER

residual
STRING

schedule_id
INTEGER

Reference:

schedule_method
STRING

schedule_number
STRING

schedule_type
STRING

start_offset
INTEGER

term_source
STRING

amortization_sched_lines

Replication Method :

Full Table

 Primary Key :

_sdc_record_hash
Official docs :

Official Docs

amortization_sched_lines table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • account_id

  • accounting_period_id

  • journal_id

  • schedule_id

account_id
INTEGER

Reference:

accounting_period_id
INTEGER

Reference:

amount
STRING

is_recognized
STRING

journal_id
INTEGER

Reference:

Reference:

schedule_id
INTEGER

Reference:

billing_accounts

Replication Method :

Key-based Incremental

 Replication Key :

date_last_modified
Primary Key :

_sdc_record_hash

 Official docs :

Official Docs

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.

billing_accounts table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • billing_account_id

date_last_modified
DATE-TIME

The time the billing account was last modified.

billing_account_id
INTEGER

The billing account ID. Note: This column is used to create the _sdc_record_hash value.

Reference:

address_book_id
INTEGER

The address book associated with the billing account.

bill_to_address_book_id
INTEGER

The bill to address book for the billing account.

Reference:

billing_account_extid
INTEGER

The billing account’s external ID.

billing_account_memo
STRING

Memo for the billing account.

billing_account_name
STRING

The name of the billing account.

billing_account_number
STRING

The billing account number.

billing_schedule_id
INTEGER

The billing schedule for the billing account.

Reference:

class_id
INTEGER

The class for the billing account.

currency_id
INTEGER

The currency for the billing account.

customer_id
INTEGER

The customer for the billing account.

date_created
DATE-TIME

The date the billing account was created.

date_last_actual_bill
DATE-TIME

The date of the last actual bill for the billing account.

date_last_bill_cycle
DATE-TIME

The date of the last bill cycle for the billing account.

date_next_bill_cycle
DATE-TIME

The date of the next bill cycle for the billing account.

date_start
DATE-TIME

The start date of the billing account.

department_id
INTEGER

The department of the billing account.

has_off_cycle_bill_request
STRING

Whether off-cycle billing is used for the billing account.

is_customer_default
STRING

Whether the customer is the default for the billing account.

is_inactive
STRING

Whether the billing account is inactive.

location_id
INTEGER

The location of the billing account.

ship_to_address_book_id
INTEGER

The ship to address book for the billing account.

Reference:

billing_classes

Replication Method :

Full Table

 Primary Key :

_sdc_record_hash
Official docs :

Official Docs

billing_classes table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • billing_class_id

billing_class_extid
STRING

billing_class_id
INTEGER

Reference:

description
STRING

is_inactive
STRING

name
STRING

sale_unit_id
INTEGER

units_type_id
INTEGER

billing_class_rates

Replication Method :

Full Table

 Primary Key :

_sdc_record_hash
Official docs :

Official Docs

billing_class_rates table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • billing_class_id

  • billing_rate_card_id

  • currency_id

billing_class_id
INTEGER

billing_rate_card_id
INTEGER

currency_id
INTEGER

unit_price
NUMBER

billing_rate_cards

Replication Method :

Key-based Incremental

 Replication Key :

date_last_modified
Primary Key :

_sdc_record_hash

 Official docs :

Official Docs

billing_rate_cards table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • billing_rate_card_id

date_last_modified
DATE-TIME

The time the billing rate card was last modified.

billing_rate_card_extid
STRING

billing_rate_card_id
INTEGER

Reference:

customer_id
INTEGER

Reference:

date_created
DATE-TIME

is_inactive
STRING

name
STRING

billing_rate_cards_prices

Replication Method :

Full Table

 Primary Key :

_sdc_record_hash
Official docs :

Official Docs

billing_rate_cards_prices table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • billing_class_id

  • billing_rate_card_id

  • currency_id

  • version0

billing_class_id
INTEGER

Reference:

billing_rate_card_id
INTEGER

Reference:

currency_id
INTEGER

Reference:

sales_unit_id
INTEGER

Reference:

service_item_id
INTEGER

unit_price
INTEGER

units_type_id
INTEGER

Reference:

version0
INTEGER

Reference:

billing_rate_cards_versions

Replication Method :

Full Table

 Primary Key :

_sdc_record_hash
Official docs :

Official Docs

billing_schedule

Replication Method :

Full Table

 Primary Key :

None
Official docs :

Official Docs

 Loading Behavior:

Append-Only

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

billing_schedule table schema

bill_amount
NUMBER

The bill amount.

bill_amount_foreign
NUMBER

The foreign currency bill amount.

bill_count
NUMBER

The bill count.

bill_date
DATE-TIME

The date of the bill.

bill_net_amount
INTEGER

The bill net amount.

bill_net_amount_foreign
INTEGER

The bill net amount in foreign currency.

milestone_id
INTEGER

The milestone ID.

payment_terms_id
INTEGER

The payment term ID.

rev_rec_end_date
DATE-TIME

The rev rec end date.

rev_rec_start_date
DATE-TIME

The rev rec start date.

transaction_id
INTEGER

The transaction ID.

transaction_line_id
INTEGER

The transaction line ID.

billing_schedule

Replication Method :

Full Table

 Primary Key :

None
Official docs :

Official Docs

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

billing_schedule table schema

bill_amount
NUMBER

The bill amount.

bill_amount_foreign
NUMBER

The foreign currency bill amount.

bill_count
NUMBER

The bill count.

bill_date
DATE-TIME

The date of the bill.

bill_net_amount
INTEGER

The bill net amount.

bill_net_amount_foreign
INTEGER

The bill net amount in foreign currency.

milestone_id
INTEGER

The milestone ID.

payment_terms_id
INTEGER

The payment term ID.

rev_rec_end_date
DATE-TIME

The rev rec end date.

rev_rec_start_date
DATE-TIME

The rev rec start date.

transaction_id
INTEGER

The transaction ID.

transaction_line_id
INTEGER

The transaction line ID.

billing_schedule_descriptions

Replication Method :

Full Table

 Primary Key :

_sdc_record_hash
Official docs :

Official Docs

billing_schedule_descriptions table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • billing_schedule_id

billing_schedule_id
INTEGER

Reference:

billing_schedule_type
STRING

frequency
STRING

name
STRING

recurrence_count
INTEGER

billing_subscriptions

Replication Method :

Key-based Incremental

 Replication Key :

date_last_modified
Primary Key :

_sdc_record_hash

 Official docs :

Official Docs

billing_subscriptions table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • subscription_id

date_last_modified
DATE-TIME

The time the billing subscription was last modified.

subscription_id
INTEGER

Reference:

advance_renewal_period_number
INTEGER

advance_renewal_period_unit_id
STRING

amount
NUMBER

billing_account_id
INTEGER

Reference:

currency
STRING

date_created
DATE-TIME

date_end
DATE-TIME

date_estimated_revrec_end
DATE-TIME

date_start
DATE-TIME

default_renewal_method_id
STRING

default_renewal_plan_id
INTEGER

Reference:

default_renewal_price_book_id
INTEGER

default_renewal_term_id
INTEGER

Reference:

default_renewal_trantype_id
STRING

description
STRING

generate_modification_elements
STRING

initial_term_id
INTEGER

Reference:

is_auto_renewal
STRING

is_sub_start_date_as_rsd
STRING

name
STRING

plan_id
INTEGER

Reference:

price_book_id
INTEGER

sales_order_id
INTEGER

Reference:

Reference:

subscription_extid
STRING

subscription_number
STRING

subscription_revision
INTEGER

billing_subscription_lines

Replication Method :

Key-based Incremental

 Replication Key :

date_last_modified
Primary Key :

_sdc_record_hash

 Official docs :

Official Docs

billing_subscription_lines table schema

_sdc_record_hash
STRING

A Stitch-generated SHA 256 hash that should be used as a Primary Key. The hash consists of a UTF-8 encoded JSON list containing the values of the columns designated as the table’s Primary Keys by NetSuite.

NetSuite designates the following columns as Primary Keys for this table:

  • subline_id

date_last_modified
DATE-TIME

The time the billing subscription line was last modified.

billing_mode_id
STRING

catalog_type
STRING

date_created
DATE-TIME

date_end
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

Reference:

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

Reference: