Release Status Released Supported By Stitch
Availability Paid Status Page NetSuite Status Page
Default Historical Sync 1 year Default Replication Frequency 30 minutes
Whitelisting Unsupported Destination Incompatibilities None

Connecting NetSuite

NetSuite Setup requirements

To set up NetSuite in Stitch, you need:

  • A paid Stitch plan. While those currently in the Free Trial will also be able to set up NetSuite, replication will be paused until a paid plan is selected after the trial ends.
  • Administrator permissions in NetSuite. This is required to complete the setup steps in NetSuite.

  • To enable Web Services for your NetSuite account. This is necessary to access NetSuite’s API.

Step 1: Enable Web Services in your NetSuite account

  1. In your NetSuite account, click Setup > Company > Enable Features.
  2. Click the SuiteCloud subtab.
  3. Locate the SuiteTalk (Web Services) section.
  4. Check the Web Services box: The SuiteTalk (Web Services) section in NetSuite's SuiteCloud subtab.
  5. Scroll to the bottom of the page and click Save.

Step 2: Whitelist Stitch's IP addresses

  1. In your NetSuite account, click Setup > Company > Company Information.
  2. In the Allowed IP addresses field, enter a comma-separated list of the following IP addresses:

    • 52.23.137.21/32

    • 52.204.223.208/32

    • 52.204.228.32/32

    • 52.204.230.227/32

  3. Click Save.

Step 3: Create a Stitch NetSuite role

To connect NetSuite to Stitch, we recommend that you create a Stitch-specific role and user for us. We suggest this to ensure that:

  1. Stitch is easily distinguishable in any logs or audits.

  2. Stitch doesn’t encounter issues with replication due to NetSuite’s API limitations. Currently, a single NetSuite user is allowed to only have a single open API session at a time. If the user connected to Stitch has another connection elsewhere, replication problems will arise.

  3. Stitch can successfully authenticate to NetSuite. This will require creating a role that mirrors the standard NetSuite Full Access Role.

    Note: Using the Full Access role requires two-factor authentication, which Stitch’s integration doesn’t currently support. For this reason, do not assign the actual Full Access role to the Stitch user.

Step 3.1: Create the new role

To ensure Stitch can access and replicate all NetSuite objects supported for replication, you’ll need to create a role to assign to the Stitch user.

  1. In your NetSuite account, click Setup > Users/Roles > Manage Roles > New.
  2. On the Role page, enter a name for the role in the Name field. For example: Stitch

Step 3.2: Grant permissions to the role

Next, you’ll grant permissions to the role. Below are instructions for adding permissions to the role, the permissions required, and where to find them in NetSuite.

In NetSuite, the Create Role Permissions section contains several subsections. In this guide is a tab that corresponds to the permissions you need to add in each NetSuite subsection. For example: In the Permissions > Transactions subsection, you’ll add the permissions outlined in the Transactions tab of this guide.

Refer to the other tabs in this section of the guide for the permissions you need to add.

To add a permission to the role:

  1. In the Permissions section, click a subsection. For example: Transactions
  2. Using the Permission dropdown, search for the permission you want to add.

    For example: If adding permissions in the Transactions subtab of NetSuite, you’ll use the checklist in the Transactions tab of this guide.

  3. Using the Level dropdown, set the permission level to the corresponding level outlined in this guide:

    The Transactions subsection in the Permissions section of the NetSuite Create Role page

  4. Click Add.
  5. Repeat these steps until all permissions in the tabs of this guide have been added.

These permissions are the minimum required to successfully connect Stitch to your NetSuite integration.

Note: While Stitch may be able to replicate some data using only these permisisons, it is unlikely that Stitch will be able to replicate all possible NetSuite objects. You should grant the permissions outlined in the other tabs to ensure successful replication.

Added Permission name Location Level
Custom Body Fields Setup tab

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields Setup tab

View

Custom Record Types Setup tab

View

Custom Column Fields Setup tab

View

Custom Entity Fields Setup tab

View

Custom Item Fields Setup tab

View

Custom Event Fields Setup tab

View

Custom Transaction Fields Setup tab

View

Other Custom Fields Setup tab

View

Perform Search Lists tab

View

Allows for various object-specific search functions.

Deleted Records Setup tab

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services Setup tab

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.

These permissions are found in the Transactions tab of the Create Role page in NetSuite.

Added Permission name Level
Access Payment Audit Log

View

Adjust Inventory

Full

Adjust Inventory Worksheet

Full

Approve Direct Deposit

Full

Approve EFT

Full

Approve Online Bill Payments

Full

Audit Trail

Full

Bill Purchase Orders

Full

Bill Sales Orders

Full

Billing Setup

Full

Bills

Full

Cash Sale

Full

Cash Sale Refund

Full

Check

Full

Credit Card

Full

Credit Card Refund

Full

Credit Memo

Full

Currency Revaluation

Full

Customer Payment

Full

Customer Refund

Full

Deposit

Full

Direct Deposit Status

Full

Distribute Inventory

Full

Edit Forecast

Full

EFT Status

Full

Enter Opening Balances

Full

Enter Vendor Credits

Full

Enter Year-to-date Payroll Adjustments

Full

Establish Quotas

Full

Estimate

Full

Expense Report

Full

Finance Charge

Full

Fulfill Orders

Full

Generate Statements

Full

Individual Paycheck

Full

Invoice

Full

Journal Approval

Full

Make Journal Entry

Full

Opportunity

Full

Pay Bills

Full

Pay Sales Tax

Full

Payroll Liability Payments

Full

Post Time

Full

Process Payroll

Full

Purchase Order

Full

Receive Orders

Full

Reconcile

Full

Refund Returns

Full

Return Auth. Approval

Full

Return Authorization

Full

Revenue Commitment

Full

Revenue Commitment Reversal

Full

Generate Revenue Commitment

Full

Generate Revenue Commitment Reversals

Full

Sales Order

Full

Sales Order Approval

Full

Set Up Budgets

Full

Statement Charge

Full

Track Time

Full

Transfer Funds

Full

Transfer Inventory

Full

View Online Bill Pay Status

Full

These permissions are found in the Reports tab of the Create Role page in NetSuite.

Added Permission name Level
Accounts Receivable Un-Billed

View

Balance Sheet

View

Budget

View

Cash Flow Statement

View

Form 1099 - Federal Miscellaneous Income

View

Form W-2 - Wage and Tax Statement

View

General Ledger

View

Income Statement

View

Inventory

View

Payroll Summary & Detail Reports

View

Payroll Check Register

View

Payroll Journal Report

View

Payroll Liability Report

View

Payroll Summary & Detail Reports

View

Purchases

View

Reconcile Reporting

View

Employee Reminders

View

Sales

View

Sales By Partner

View

Sales By Promotion Code

View

Sales Force Automation

View

Support

View

Tax

View

Time Tracking

View

Transaction Detail

View

Trial Balance

View

Web Site Report

View

Web Store Report

View

Report Customization

Full

These permissions are found in the Lists tab of the Create Role page in NetSuite.

Added Permission name Level
Employees

View

Resource Allocations

View

Perform Search

View

Allows for various object-specific search functions.

Accounts

Full

Accounts Payable Register

Full

Accounts Receivable Register

Full

Advanced Government Issued IDs

Full

Bank Account Registers

Full

Calendar

Full

Marketing Campaign

Full

Campaign History

Full

Cases

Full

Classes

Full

Color Themes

Full

Companies

Full

Competitors

Full

Contacts

Full

Cost of Goods Sold Registers

Full

Credit Card Registers

Full

CRM Group

Full

Currency

Full

Custom Record Entries

Full

Customer Profile

Full

Customers

Full

Departments

Full

Documents and Files

Full

Email Template

Full

Employee Change Reason

Full

Employee Effective Dating

Full

Other Lists

Full

Employees

Full

Equity Registers

Full

Events

Full

Expense Categories

Full

Expense Registers

Full

Find Transaction

Full

Fixed Asset Registers

Full

Government Issued ID Types

Full

Income Registers

Full

Items

Full

Jobs

Full

HCMJob Management

Full

Knowledge Base

Full

Kudos

Full

Locations

Full

Long Term Liability Registers

Full

Marketing Template

Full

Mass Updates

Full

Media Folders

Full

Memorized Transactions

Full

Non Posting Registers

Full

Notes Tab

Full

Organization Value

Full

Other Asset Registers

Full

Other Current Asset Registers

Full

Other Current Liability Registers

Full

Other Expense Registers

Full

Other Income Registers

Full

Other Names

Full

Partners

Full

Paychecks

Full

Payment Methods

Full

Payroll Items

Full

Presentation Categories

Full

Promotion

Full

Related Items

Full

Resource

Full

Resource Allocation Approval

Full

Shipping Items

Full

Store Content Items

Full

Store Tabs

Full

Tasks

Full

Tax Items

Full

Termination Reasons

Full

Time-Off Administration

Full

Track Messages

Full

Vendors

Full

These permissions are found in the Setup tab of the Create Role page in NetSuite.

Added Permission name Level
Custom Body Fields

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields

View

Custom Record Types

View

Custom Column Fields

View

Custom Entity Fields

View

Custom Item Fields

View

Custom Event Fields

View

Custom Transaction Fields

View

Other Custom Fields

View

Accounting Lists

Full

CRM Lists

Full

Deleted Records

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.

Step 3.3: Save the role and retrieve its internal ID

After you’ve finished granting permissions to the role, click Save to create the it.

Next, you’ll retrieve the role’s internal ID. Stitch requires this ID to successfully create your NetSuite integration.

If you’ve just saved the role, you should automatically be redirected to the Manage Roles page. If not, you can access this page by clicking Setup > Users/Roles > Manage Roles.

Locate the role you just created. The ID is located in a column called Internal ID:

The Internal ID column contains the user's Role ID.

If you don’t see the Internal ID column in the list, you may need to add it:

  1. Click the Edit View button.
  2. Click the drop-down menu and select Internal ID.
  3. Click Add.
  4. Click Save.

After you add the column to the Roles list, locate the ID for the role. Keep this handy - you’ll need it to complete the setup in Stitch.

Step 4: Create the Stitch NetSuite user

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

  1. In your NetSuite account, click Lists > Employees > Employees > New.
  2. In the Employee page, fill in the Name and Email fields.
  3. Next, click the Access tab.
  4. In the Access tab:

    1. Create a password for the Stitch user. Enter it in the Password field, then again in the Confirm Password field.
    2. In the Roles section, search the dropdown menu to locate the Stitch role you created in Step 3.
    3. Click Add once you’ve located the role.
  5. When finished, click Save.

Step 5: Locate your NetSuite Account ID

Click Setup > Integration Web Services Preferences.

In the Primary Information section, locate the Account ID field as shown in the image on the right.

Note: If your Account ID contains a suffix - 1234567_SB2, for example - it should be included when entering the ID into Stitch.

Step 6: Add NetSuite 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 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” would create a schema called stitch_netsuite in the destination. Note: Schema names cannot be changed after you save the integration.

  5. Enter the email address and password associated with the Stitch NetSuite user.
  6. Enter the Role ID you retrieved in Step 3.3. Note: This must be the numerical ID, not the name of the role. See Step 3.3 if you need help locating the user’s Role ID.
  7. In the Account ID field, enter the Account ID you retrieved in Step 5.
  8. Select the Account Type - Production or Sandbox.

Step 7: Define the Historical Sync

The Sync Historical Data setting will define the starting date for your NetSuite 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’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 8: 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.

Stitch offers two methods of creating a replication schedule:

  • Replication Frequency: This method requires selecting the interval you want replication to run for the integration. Start times of replication jobs are based on the start time and duration of the previous job. Refer to the Replication Frequency documentation for more information and examples.
  • Anchor scheduling: Based on the Replication Frequency, or interval, you select, this method “anchors” the start times of this integration’s replication jobs to a time you select to create a predictable schedule. Anchor scheduling is a combination of the Anchor Time and Replication Frequency settings, which must both be defined to use this method. Additionally, note that:

    • A Replication Frequency of at least one hour is required to use anchor scheduling.
    • An initial replication job may not begin immediately after saving the integration, depending on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

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

Step 9: Set tables to replicate

To complete the setup, you’ll need to select tables you want to replicate to your data warehouse.

Check out the Schema section to learn more about the available tables in NetSuite and how they replicate.

  1. In the Integration Details page, click the Tables to Replicate tab.
  2. Locate a table you want to replicate.
  3. To track a table, click the checkbox next to the table’s name. A green checkmark means the table is set to replicate.

  4. Repeat this process for all the tables you want to replicate.

Initial and historical replication jobs

After you finish setting up NetSuite, 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 table schemas

Deleted records

Stitch’s NetSuite integration includes a table called netsuite_deleted; this table contains a row for every deleted record that supports deletes. Accounting for deleted records is especially important if you’re performing any sort of aggregate function - for example, totaling invoices or balancing your books.

For this reason, we recommend setting this table to replicate.

netsuite_deleted Table Schema

The attributes of the netsuite_deleted table include:

  • type: This indicates the type of record. For example: invoice.
  • name: This is the name of the record. For example: Invoice #INV197
  • deletedDate: The date the record was deleted.
  • customRecord: This indicates if the record was a custom record.
  • internalId: This is the numerical ID of the record.

Custom records will look a little different than other records. In this case, you’ll see the following:

  • type: This column will contain a numerical ID.
  • name and internalId: The internalId of the record will display in both columns.
  • customRecord: This column will contain a true value.

For example: The first two records in this table are “normal” records, while the third is a custom record:

type internalId name customRecord deletedDate
invoice 124831 Invoice #INV197 false 2016-08-02T09:33:07.000-07:00
journalEntry 111366 Journal #JV13526 false 2016-08-04T12:01:22.000-07:00
19 128 128 true 2016-07-21T12:05:26.000-07:00

Accounting for deleted records

To account for deleted records, you can use a LEFT JOIN to tie deleted records back to the appropriate table.

For example: The following query would return all invoice records that exist in the netsuite_transaction and netsuite_deleted tables:

   SELECT * 
     FROM netsuite_transactions tran 
LEFT JOIN netsuite_deleted del
       ON tran.internalId = del.internalId 
      AND tran.type = 'invoice'
      AND del.type = 'invoice'

If you’re using a data warehouse that is case-insensitive (like Redshift), some queries may result in errors. If this occurs, try using LOWER to resolve the issue:

   SELECT *
     FROM netsuite_transactions tran 
LEFT JOIN netsuite_deleted del 
       ON tran.internalId = del.internalId 
AND LOWER(tran.type) = LOWER(del.type)

To filter out deleted records from other data, you can run a query like this one:

   SELECT *
     FROM netsuite_transactions tran 
LEFT JOIN netsuite_deleted del
       ON tran.internalId = del.internalId 
AND LOWER(tran.type) = LOWER(del.type) 
    WHERE del.deletedDate is null;

Supported transaction types

The following table contains the transaction types Stitch’s NetSuite integration currently supports.


netsuite_account

Replication Method: Full Table Documentation: Official Docs
Primary Key :

The netsuite_account table contains info about the accounts in your NetSuite instance.

Refer to the other tabs in this section of the guide for the permissions you need to add.

To add a permission to the role:

  1. In the Permissions section, click a subsection. For example: Transactions
  2. Using the Permission dropdown, search for the permission you want to add.

    For example: If adding permissions in the Transactions subtab of NetSuite, you’ll use the checklist in the Transactions tab of this guide.

  3. Using the Level dropdown, set the permission level to the corresponding level outlined in this guide:

    The Transactions subsection in the Permissions section of the NetSuite Create Role page

  4. Click Add.
  5. Repeat these steps until all permissions in the tabs of this guide have been added.

These permissions are the minimum required to successfully connect Stitch to your NetSuite integration.

Note: While Stitch may be able to replicate some data using only these permisisons, it is unlikely that Stitch will be able to replicate all possible NetSuite objects. You should grant the permissions outlined in the other tabs to ensure successful replication.

Added Permission name Location Level
Custom Body Fields Setup tab

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields Setup tab

View

Custom Record Types Setup tab

View

Custom Column Fields Setup tab

View

Custom Entity Fields Setup tab

View

Custom Item Fields Setup tab

View

Custom Event Fields Setup tab

View

Custom Transaction Fields Setup tab

View

Other Custom Fields Setup tab

View

Perform Search Lists tab

View

Allows for various object-specific search functions.

Deleted Records Setup tab

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services Setup tab

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.

These permissions are found in the Transactions tab of the Create Role page in NetSuite.

Added Permission name Level
Access Payment Audit Log

View

Adjust Inventory

Full

Adjust Inventory Worksheet

Full

Approve Direct Deposit

Full

Approve EFT

Full

Approve Online Bill Payments

Full

Audit Trail

Full

Bill Purchase Orders

Full

Bill Sales Orders

Full

Billing Setup

Full

Bills

Full

Cash Sale

Full

Cash Sale Refund

Full

Check

Full

Credit Card

Full

Credit Card Refund

Full

Credit Memo

Full

Currency Revaluation

Full

Customer Payment

Full

Customer Refund

Full

Deposit

Full

Direct Deposit Status

Full

Distribute Inventory

Full

Edit Forecast

Full

EFT Status

Full

Enter Opening Balances

Full

Enter Vendor Credits

Full

Enter Year-to-date Payroll Adjustments

Full

Establish Quotas

Full

Estimate

Full

Expense Report

Full

Finance Charge

Full

Fulfill Orders

Full

Generate Statements

Full

Individual Paycheck

Full

Invoice

Full

Journal Approval

Full

Make Journal Entry

Full

Opportunity

Full

Pay Bills

Full

Pay Sales Tax

Full

Payroll Liability Payments

Full

Post Time

Full

Process Payroll

Full

Purchase Order

Full

Receive Orders

Full

Reconcile

Full

Refund Returns

Full

Return Auth. Approval

Full

Return Authorization

Full

Revenue Commitment

Full

Revenue Commitment Reversal

Full

Generate Revenue Commitment

Full

Generate Revenue Commitment Reversals

Full

Sales Order

Full

Sales Order Approval

Full

Set Up Budgets

Full

Statement Charge

Full

Track Time

Full

Transfer Funds

Full

Transfer Inventory

Full

View Online Bill Pay Status

Full

These permissions are found in the Reports tab of the Create Role page in NetSuite.

Added Permission name Level
Accounts Receivable Un-Billed

View

Balance Sheet

View

Budget

View

Cash Flow Statement

View

Form 1099 - Federal Miscellaneous Income

View

Form W-2 - Wage and Tax Statement

View

General Ledger

View

Income Statement

View

Inventory

View

Payroll Summary & Detail Reports

View

Payroll Check Register

View

Payroll Journal Report

View

Payroll Liability Report

View

Payroll Summary & Detail Reports

View

Purchases

View

Reconcile Reporting

View

Employee Reminders

View

Sales

View

Sales By Partner

View

Sales By Promotion Code

View

Sales Force Automation

View

Support

View

Tax

View

Time Tracking

View

Transaction Detail

View

Trial Balance

View

Web Site Report

View

Web Store Report

View

Report Customization

Full

These permissions are found in the Lists tab of the Create Role page in NetSuite.

Added Permission name Level
Employees

View

Resource Allocations

View

Perform Search

View

Allows for various object-specific search functions.

Accounts

Full

Accounts Payable Register

Full

Accounts Receivable Register

Full

Advanced Government Issued IDs

Full

Bank Account Registers

Full

Calendar

Full

Marketing Campaign

Full

Campaign History

Full

Cases

Full

Classes

Full

Color Themes

Full

Companies

Full

Competitors

Full

Contacts

Full

Cost of Goods Sold Registers

Full

Credit Card Registers

Full

CRM Group

Full

Currency

Full

Custom Record Entries

Full

Customer Profile

Full

Customers

Full

Departments

Full

Documents and Files

Full

Email Template

Full

Employee Change Reason

Full

Employee Effective Dating

Full

Other Lists

Full

Employees

Full

Equity Registers

Full

Events

Full

Expense Categories

Full

Expense Registers

Full

Find Transaction

Full

Fixed Asset Registers

Full

Government Issued ID Types

Full

Income Registers

Full

Items

Full

Jobs

Full

HCMJob Management

Full

Knowledge Base

Full

Kudos

Full

Locations

Full

Long Term Liability Registers

Full

Marketing Template

Full

Mass Updates

Full

Media Folders

Full

Memorized Transactions

Full

Non Posting Registers

Full

Notes Tab

Full

Organization Value

Full

Other Asset Registers

Full

Other Current Asset Registers

Full

Other Current Liability Registers

Full

Other Expense Registers

Full

Other Income Registers

Full

Other Names

Full

Partners

Full

Paychecks

Full

Payment Methods

Full

Payroll Items

Full

Presentation Categories

Full

Promotion

Full

Related Items

Full

Resource

Full

Resource Allocation Approval

Full

Shipping Items

Full

Store Content Items

Full

Store Tabs

Full

Tasks

Full

Tax Items

Full

Termination Reasons

Full

Time-Off Administration

Full

Track Messages

Full

Vendors

Full

These permissions are found in the Setup tab of the Create Role page in NetSuite.

Added Permission name Level
Custom Body Fields

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields

View

Custom Record Types

View

Custom Column Fields

View

Custom Entity Fields

View

Custom Item Fields

View

Custom Event Fields

View

Custom Transaction Fields

View

Other Custom Fields

View

Accounting Lists

Full

CRM Lists

Full

Deleted Records

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.


netsuite_accounting_period

Replication Method: Full Table Documentation: Official Docs
Primary Key :

The netsuite_accounting_period table contains info about accounting periods in your NetSuite instance.

Refer to the other tabs in this section of the guide for the permissions you need to add.

To add a permission to the role:

  1. In the Permissions section, click a subsection. For example: Transactions
  2. Using the Permission dropdown, search for the permission you want to add.

    For example: If adding permissions in the Transactions subtab of NetSuite, you’ll use the checklist in the Transactions tab of this guide.

  3. Using the Level dropdown, set the permission level to the corresponding level outlined in this guide:

    The Transactions subsection in the Permissions section of the NetSuite Create Role page

  4. Click Add.
  5. Repeat these steps until all permissions in the tabs of this guide have been added.

These permissions are the minimum required to successfully connect Stitch to your NetSuite integration.

Note: While Stitch may be able to replicate some data using only these permisisons, it is unlikely that Stitch will be able to replicate all possible NetSuite objects. You should grant the permissions outlined in the other tabs to ensure successful replication.

Added Permission name Location Level
Custom Body Fields Setup tab

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields Setup tab

View

Custom Record Types Setup tab

View

Custom Column Fields Setup tab

View

Custom Entity Fields Setup tab

View

Custom Item Fields Setup tab

View

Custom Event Fields Setup tab

View

Custom Transaction Fields Setup tab

View

Other Custom Fields Setup tab

View

Perform Search Lists tab

View

Allows for various object-specific search functions.

Deleted Records Setup tab

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services Setup tab

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.

These permissions are found in the Transactions tab of the Create Role page in NetSuite.

Added Permission name Level
Access Payment Audit Log

View

Adjust Inventory

Full

Adjust Inventory Worksheet

Full

Approve Direct Deposit

Full

Approve EFT

Full

Approve Online Bill Payments

Full

Audit Trail

Full

Bill Purchase Orders

Full

Bill Sales Orders

Full

Billing Setup

Full

Bills

Full

Cash Sale

Full

Cash Sale Refund

Full

Check

Full

Credit Card

Full

Credit Card Refund

Full

Credit Memo

Full

Currency Revaluation

Full

Customer Payment

Full

Customer Refund

Full

Deposit

Full

Direct Deposit Status

Full

Distribute Inventory

Full

Edit Forecast

Full

EFT Status

Full

Enter Opening Balances

Full

Enter Vendor Credits

Full

Enter Year-to-date Payroll Adjustments

Full

Establish Quotas

Full

Estimate

Full

Expense Report

Full

Finance Charge

Full

Fulfill Orders

Full

Generate Statements

Full

Individual Paycheck

Full

Invoice

Full

Journal Approval

Full

Make Journal Entry

Full

Opportunity

Full

Pay Bills

Full

Pay Sales Tax

Full

Payroll Liability Payments

Full

Post Time

Full

Process Payroll

Full

Purchase Order

Full

Receive Orders

Full

Reconcile

Full

Refund Returns

Full

Return Auth. Approval

Full

Return Authorization

Full

Revenue Commitment

Full

Revenue Commitment Reversal

Full

Generate Revenue Commitment

Full

Generate Revenue Commitment Reversals

Full

Sales Order

Full

Sales Order Approval

Full

Set Up Budgets

Full

Statement Charge

Full

Track Time

Full

Transfer Funds

Full

Transfer Inventory

Full

View Online Bill Pay Status

Full

These permissions are found in the Reports tab of the Create Role page in NetSuite.

Added Permission name Level
Accounts Receivable Un-Billed

View

Balance Sheet

View

Budget

View

Cash Flow Statement

View

Form 1099 - Federal Miscellaneous Income

View

Form W-2 - Wage and Tax Statement

View

General Ledger

View

Income Statement

View

Inventory

View

Payroll Summary & Detail Reports

View

Payroll Check Register

View

Payroll Journal Report

View

Payroll Liability Report

View

Payroll Summary & Detail Reports

View

Purchases

View

Reconcile Reporting

View

Employee Reminders

View

Sales

View

Sales By Partner

View

Sales By Promotion Code

View

Sales Force Automation

View

Support

View

Tax

View

Time Tracking

View

Transaction Detail

View

Trial Balance

View

Web Site Report

View

Web Store Report

View

Report Customization

Full

These permissions are found in the Lists tab of the Create Role page in NetSuite.

Added Permission name Level
Employees

View

Resource Allocations

View

Perform Search

View

Allows for various object-specific search functions.

Accounts

Full

Accounts Payable Register

Full

Accounts Receivable Register

Full

Advanced Government Issued IDs

Full

Bank Account Registers

Full

Calendar

Full

Marketing Campaign

Full

Campaign History

Full

Cases

Full

Classes

Full

Color Themes

Full

Companies

Full

Competitors

Full

Contacts

Full

Cost of Goods Sold Registers

Full

Credit Card Registers

Full

CRM Group

Full

Currency

Full

Custom Record Entries

Full

Customer Profile

Full

Customers

Full

Departments

Full

Documents and Files

Full

Email Template

Full

Employee Change Reason

Full

Employee Effective Dating

Full

Other Lists

Full

Employees

Full

Equity Registers

Full

Events

Full

Expense Categories

Full

Expense Registers

Full

Find Transaction

Full

Fixed Asset Registers

Full

Government Issued ID Types

Full

Income Registers

Full

Items

Full

Jobs

Full

HCMJob Management

Full

Knowledge Base

Full

Kudos

Full

Locations

Full

Long Term Liability Registers

Full

Marketing Template

Full

Mass Updates

Full

Media Folders

Full

Memorized Transactions

Full

Non Posting Registers

Full

Notes Tab

Full

Organization Value

Full

Other Asset Registers

Full

Other Current Asset Registers

Full

Other Current Liability Registers

Full

Other Expense Registers

Full

Other Income Registers

Full

Other Names

Full

Partners

Full

Paychecks

Full

Payment Methods

Full

Payroll Items

Full

Presentation Categories

Full

Promotion

Full

Related Items

Full

Resource

Full

Resource Allocation Approval

Full

Shipping Items

Full

Store Content Items

Full

Store Tabs

Full

Tasks

Full

Tax Items

Full

Termination Reasons

Full

Time-Off Administration

Full

Track Messages

Full

Vendors

Full

These permissions are found in the Setup tab of the Create Role page in NetSuite.

Added Permission name Level
Custom Body Fields

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields

View

Custom Record Types

View

Custom Column Fields

View

Custom Entity Fields

View

Custom Item Fields

View

Custom Event Fields

View

Custom Transaction Fields

View

Other Custom Fields

View

Accounting Lists

Full

CRM Lists

Full

Deleted Records

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.


netsuite_app_definition

Replication Method: Full Table
Primary Key :

The netsuite_app_definition table contains info about the accounts in your NetSuite instance.

Refer to the other tabs in this section of the guide for the permissions you need to add.

To add a permission to the role:

  1. In the Permissions section, click a subsection. For example: Transactions
  2. Using the Permission dropdown, search for the permission you want to add.

    For example: If adding permissions in the Transactions subtab of NetSuite, you’ll use the checklist in the Transactions tab of this guide.

  3. Using the Level dropdown, set the permission level to the corresponding level outlined in this guide:

    The Transactions subsection in the Permissions section of the NetSuite Create Role page

  4. Click Add.
  5. Repeat these steps until all permissions in the tabs of this guide have been added.

These permissions are the minimum required to successfully connect Stitch to your NetSuite integration.

Note: While Stitch may be able to replicate some data using only these permisisons, it is unlikely that Stitch will be able to replicate all possible NetSuite objects. You should grant the permissions outlined in the other tabs to ensure successful replication.

Added Permission name Location Level
Custom Body Fields Setup tab

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields Setup tab

View

Custom Record Types Setup tab

View

Custom Column Fields Setup tab

View

Custom Entity Fields Setup tab

View

Custom Item Fields Setup tab

View

Custom Event Fields Setup tab

View

Custom Transaction Fields Setup tab

View

Other Custom Fields Setup tab

View

Perform Search Lists tab

View

Allows for various object-specific search functions.

Deleted Records Setup tab

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services Setup tab

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.

These permissions are found in the Transactions tab of the Create Role page in NetSuite.

Added Permission name Level
Access Payment Audit Log

View

Adjust Inventory

Full

Adjust Inventory Worksheet

Full

Approve Direct Deposit

Full

Approve EFT

Full

Approve Online Bill Payments

Full

Audit Trail

Full

Bill Purchase Orders

Full

Bill Sales Orders

Full

Billing Setup

Full

Bills

Full

Cash Sale

Full

Cash Sale Refund

Full

Check

Full

Credit Card

Full

Credit Card Refund

Full

Credit Memo

Full

Currency Revaluation

Full

Customer Payment

Full

Customer Refund

Full

Deposit

Full

Direct Deposit Status

Full

Distribute Inventory

Full

Edit Forecast

Full

EFT Status

Full

Enter Opening Balances

Full

Enter Vendor Credits

Full

Enter Year-to-date Payroll Adjustments

Full

Establish Quotas

Full

Estimate

Full

Expense Report

Full

Finance Charge

Full

Fulfill Orders

Full

Generate Statements

Full

Individual Paycheck

Full

Invoice

Full

Journal Approval

Full

Make Journal Entry

Full

Opportunity

Full

Pay Bills

Full

Pay Sales Tax

Full

Payroll Liability Payments

Full

Post Time

Full

Process Payroll

Full

Purchase Order

Full

Receive Orders

Full

Reconcile

Full

Refund Returns

Full

Return Auth. Approval

Full

Return Authorization

Full

Revenue Commitment

Full

Revenue Commitment Reversal

Full

Generate Revenue Commitment

Full

Generate Revenue Commitment Reversals

Full

Sales Order

Full

Sales Order Approval

Full

Set Up Budgets

Full

Statement Charge

Full

Track Time

Full

Transfer Funds

Full

Transfer Inventory

Full

View Online Bill Pay Status

Full

These permissions are found in the Reports tab of the Create Role page in NetSuite.

Added Permission name Level
Accounts Receivable Un-Billed

View

Balance Sheet

View

Budget

View

Cash Flow Statement

View

Form 1099 - Federal Miscellaneous Income

View

Form W-2 - Wage and Tax Statement

View

General Ledger

View

Income Statement

View

Inventory

View

Payroll Summary & Detail Reports

View

Payroll Check Register

View

Payroll Journal Report

View

Payroll Liability Report

View

Payroll Summary & Detail Reports

View

Purchases

View

Reconcile Reporting

View

Employee Reminders

View

Sales

View

Sales By Partner

View

Sales By Promotion Code

View

Sales Force Automation

View

Support

View

Tax

View

Time Tracking

View

Transaction Detail

View

Trial Balance

View

Web Site Report

View

Web Store Report

View

Report Customization

Full

These permissions are found in the Lists tab of the Create Role page in NetSuite.

Added Permission name Level
Employees

View

Resource Allocations

View

Perform Search

View

Allows for various object-specific search functions.

Accounts

Full

Accounts Payable Register

Full

Accounts Receivable Register

Full

Advanced Government Issued IDs

Full

Bank Account Registers

Full

Calendar

Full

Marketing Campaign

Full

Campaign History

Full

Cases

Full

Classes

Full

Color Themes

Full

Companies

Full

Competitors

Full

Contacts

Full

Cost of Goods Sold Registers

Full

Credit Card Registers

Full

CRM Group

Full

Currency

Full

Custom Record Entries

Full

Customer Profile

Full

Customers

Full

Departments

Full

Documents and Files

Full

Email Template

Full

Employee Change Reason

Full

Employee Effective Dating

Full

Other Lists

Full

Employees

Full

Equity Registers

Full

Events

Full

Expense Categories

Full

Expense Registers

Full

Find Transaction

Full

Fixed Asset Registers

Full

Government Issued ID Types

Full

Income Registers

Full

Items

Full

Jobs

Full

HCMJob Management

Full

Knowledge Base

Full

Kudos

Full

Locations

Full

Long Term Liability Registers

Full

Marketing Template

Full

Mass Updates

Full

Media Folders

Full

Memorized Transactions

Full

Non Posting Registers

Full

Notes Tab

Full

Organization Value

Full

Other Asset Registers

Full

Other Current Asset Registers

Full

Other Current Liability Registers

Full

Other Expense Registers

Full

Other Income Registers

Full

Other Names

Full

Partners

Full

Paychecks

Full

Payment Methods

Full

Payroll Items

Full

Presentation Categories

Full

Promotion

Full

Related Items

Full

Resource

Full

Resource Allocation Approval

Full

Shipping Items

Full

Store Content Items

Full

Store Tabs

Full

Tasks

Full

Tax Items

Full

Termination Reasons

Full

Time-Off Administration

Full

Track Messages

Full

Vendors

Full

These permissions are found in the Setup tab of the Create Role page in NetSuite.

Added Permission name Level
Custom Body Fields

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields

View

Custom Record Types

View

Custom Column Fields

View

Custom Entity Fields

View

Custom Item Fields

View

Custom Event Fields

View

Custom Transaction Fields

View

Other Custom Fields

View

Accounting Lists

Full

CRM Lists

Full

Deleted Records

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.


netsuite_app_package

Replication Method: Full Table
Primary Key :

The netsuite_app_package table contains info about the accounts in your NetSuite instance.

Refer to the other tabs in this section of the guide for the permissions you need to add.

To add a permission to the role:

  1. In the Permissions section, click a subsection. For example: Transactions
  2. Using the Permission dropdown, search for the permission you want to add.

    For example: If adding permissions in the Transactions subtab of NetSuite, you’ll use the checklist in the Transactions tab of this guide.

  3. Using the Level dropdown, set the permission level to the corresponding level outlined in this guide:

    The Transactions subsection in the Permissions section of the NetSuite Create Role page

  4. Click Add.
  5. Repeat these steps until all permissions in the tabs of this guide have been added.

These permissions are the minimum required to successfully connect Stitch to your NetSuite integration.

Note: While Stitch may be able to replicate some data using only these permisisons, it is unlikely that Stitch will be able to replicate all possible NetSuite objects. You should grant the permissions outlined in the other tabs to ensure successful replication.

Added Permission name Location Level
Custom Body Fields Setup tab

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields Setup tab

View

Custom Record Types Setup tab

View

Custom Column Fields Setup tab

View

Custom Entity Fields Setup tab

View

Custom Item Fields Setup tab

View

Custom Event Fields Setup tab

View

Custom Transaction Fields Setup tab

View

Other Custom Fields Setup tab

View

Perform Search Lists tab

View

Allows for various object-specific search functions.

Deleted Records Setup tab

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services Setup tab

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.

These permissions are found in the Transactions tab of the Create Role page in NetSuite.

Added Permission name Level
Access Payment Audit Log

View

Adjust Inventory

Full

Adjust Inventory Worksheet

Full

Approve Direct Deposit

Full

Approve EFT

Full

Approve Online Bill Payments

Full

Audit Trail

Full

Bill Purchase Orders

Full

Bill Sales Orders

Full

Billing Setup

Full

Bills

Full

Cash Sale

Full

Cash Sale Refund

Full

Check

Full

Credit Card

Full

Credit Card Refund

Full

Credit Memo

Full

Currency Revaluation

Full

Customer Payment

Full

Customer Refund

Full

Deposit

Full

Direct Deposit Status

Full

Distribute Inventory

Full

Edit Forecast

Full

EFT Status

Full

Enter Opening Balances

Full

Enter Vendor Credits

Full

Enter Year-to-date Payroll Adjustments

Full

Establish Quotas

Full

Estimate

Full

Expense Report

Full

Finance Charge

Full

Fulfill Orders

Full

Generate Statements

Full

Individual Paycheck

Full

Invoice

Full

Journal Approval

Full

Make Journal Entry

Full

Opportunity

Full

Pay Bills

Full

Pay Sales Tax

Full

Payroll Liability Payments

Full

Post Time

Full

Process Payroll

Full

Purchase Order

Full

Receive Orders

Full

Reconcile

Full

Refund Returns

Full

Return Auth. Approval

Full

Return Authorization

Full

Revenue Commitment

Full

Revenue Commitment Reversal

Full

Generate Revenue Commitment

Full

Generate Revenue Commitment Reversals

Full

Sales Order

Full

Sales Order Approval

Full

Set Up Budgets

Full

Statement Charge

Full

Track Time

Full

Transfer Funds

Full

Transfer Inventory

Full

View Online Bill Pay Status

Full

These permissions are found in the Reports tab of the Create Role page in NetSuite.

Added Permission name Level
Accounts Receivable Un-Billed

View

Balance Sheet

View

Budget

View

Cash Flow Statement

View

Form 1099 - Federal Miscellaneous Income

View

Form W-2 - Wage and Tax Statement

View

General Ledger

View

Income Statement

View

Inventory

View

Payroll Summary & Detail Reports

View

Payroll Check Register

View

Payroll Journal Report

View

Payroll Liability Report

View

Payroll Summary & Detail Reports

View

Purchases

View

Reconcile Reporting

View

Employee Reminders

View

Sales

View

Sales By Partner

View

Sales By Promotion Code

View

Sales Force Automation

View

Support

View

Tax

View

Time Tracking

View

Transaction Detail

View

Trial Balance

View

Web Site Report

View

Web Store Report

View

Report Customization

Full

These permissions are found in the Lists tab of the Create Role page in NetSuite.

Added Permission name Level
Employees

View

Resource Allocations

View

Perform Search

View

Allows for various object-specific search functions.

Accounts

Full

Accounts Payable Register

Full

Accounts Receivable Register

Full

Advanced Government Issued IDs

Full

Bank Account Registers

Full

Calendar

Full

Marketing Campaign

Full

Campaign History

Full

Cases

Full

Classes

Full

Color Themes

Full

Companies

Full

Competitors

Full

Contacts

Full

Cost of Goods Sold Registers

Full

Credit Card Registers

Full

CRM Group

Full

Currency

Full

Custom Record Entries

Full

Customer Profile

Full

Customers

Full

Departments

Full

Documents and Files

Full

Email Template

Full

Employee Change Reason

Full

Employee Effective Dating

Full

Other Lists

Full

Employees

Full

Equity Registers

Full

Events

Full

Expense Categories

Full

Expense Registers

Full

Find Transaction

Full

Fixed Asset Registers

Full

Government Issued ID Types

Full

Income Registers

Full

Items

Full

Jobs

Full

HCMJob Management

Full

Knowledge Base

Full

Kudos

Full

Locations

Full

Long Term Liability Registers

Full

Marketing Template

Full

Mass Updates

Full

Media Folders

Full

Memorized Transactions

Full

Non Posting Registers

Full

Notes Tab

Full

Organization Value

Full

Other Asset Registers

Full

Other Current Asset Registers

Full

Other Current Liability Registers

Full

Other Expense Registers

Full

Other Income Registers

Full

Other Names

Full

Partners

Full

Paychecks

Full

Payment Methods

Full

Payroll Items

Full

Presentation Categories

Full

Promotion

Full

Related Items

Full

Resource

Full

Resource Allocation Approval

Full

Shipping Items

Full

Store Content Items

Full

Store Tabs

Full

Tasks

Full

Tax Items

Full

Termination Reasons

Full

Time-Off Administration

Full

Track Messages

Full

Vendors

Full

These permissions are found in the Setup tab of the Create Role page in NetSuite.

Added Permission name Level
Custom Body Fields

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields

View

Custom Record Types

View

Custom Column Fields

View

Custom Entity Fields

View

Custom Item Fields

View

Custom Event Fields

View

Custom Transaction Fields

View

Other Custom Fields

View

Accounting Lists

Full

CRM Lists

Full

Deleted Records

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.


netsuite_billing_schedule

Replication Method: Full Table
Primary Key :

The netsuite_billing_schedule table contains info about the accounts in your NetSuite instance.

Refer to the other tabs in this section of the guide for the permissions you need to add.

To add a permission to the role:

  1. In the Permissions section, click a subsection. For example: Transactions
  2. Using the Permission dropdown, search for the permission you want to add.

    For example: If adding permissions in the Transactions subtab of NetSuite, you’ll use the checklist in the Transactions tab of this guide.

  3. Using the Level dropdown, set the permission level to the corresponding level outlined in this guide:

    The Transactions subsection in the Permissions section of the NetSuite Create Role page

  4. Click Add.
  5. Repeat these steps until all permissions in the tabs of this guide have been added.

These permissions are the minimum required to successfully connect Stitch to your NetSuite integration.

Note: While Stitch may be able to replicate some data using only these permisisons, it is unlikely that Stitch will be able to replicate all possible NetSuite objects. You should grant the permissions outlined in the other tabs to ensure successful replication.

Added Permission name Location Level
Custom Body Fields Setup tab

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields Setup tab

View

Custom Record Types Setup tab

View

Custom Column Fields Setup tab

View

Custom Entity Fields Setup tab

View

Custom Item Fields Setup tab

View

Custom Event Fields Setup tab

View

Custom Transaction Fields Setup tab

View

Other Custom Fields Setup tab

View

Perform Search Lists tab

View

Allows for various object-specific search functions.

Deleted Records Setup tab

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services Setup tab

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.

These permissions are found in the Transactions tab of the Create Role page in NetSuite.

Added Permission name Level
Access Payment Audit Log

View

Adjust Inventory

Full

Adjust Inventory Worksheet

Full

Approve Direct Deposit

Full

Approve EFT

Full

Approve Online Bill Payments

Full

Audit Trail

Full

Bill Purchase Orders

Full

Bill Sales Orders

Full

Billing Setup

Full

Bills

Full

Cash Sale

Full

Cash Sale Refund

Full

Check

Full

Credit Card

Full

Credit Card Refund

Full

Credit Memo

Full

Currency Revaluation

Full

Customer Payment

Full

Customer Refund

Full

Deposit

Full

Direct Deposit Status

Full

Distribute Inventory

Full

Edit Forecast

Full

EFT Status

Full

Enter Opening Balances

Full

Enter Vendor Credits

Full

Enter Year-to-date Payroll Adjustments

Full

Establish Quotas

Full

Estimate

Full

Expense Report

Full

Finance Charge

Full

Fulfill Orders

Full

Generate Statements

Full

Individual Paycheck

Full

Invoice

Full

Journal Approval

Full

Make Journal Entry

Full

Opportunity

Full

Pay Bills

Full

Pay Sales Tax

Full

Payroll Liability Payments

Full

Post Time

Full

Process Payroll

Full

Purchase Order

Full

Receive Orders

Full

Reconcile

Full

Refund Returns

Full

Return Auth. Approval

Full

Return Authorization

Full

Revenue Commitment

Full

Revenue Commitment Reversal

Full

Generate Revenue Commitment

Full

Generate Revenue Commitment Reversals

Full

Sales Order

Full

Sales Order Approval

Full

Set Up Budgets

Full

Statement Charge

Full

Track Time

Full

Transfer Funds

Full

Transfer Inventory

Full

View Online Bill Pay Status

Full

These permissions are found in the Reports tab of the Create Role page in NetSuite.

Added Permission name Level
Accounts Receivable Un-Billed

View

Balance Sheet

View

Budget

View

Cash Flow Statement

View

Form 1099 - Federal Miscellaneous Income

View

Form W-2 - Wage and Tax Statement

View

General Ledger

View

Income Statement

View

Inventory

View

Payroll Summary & Detail Reports

View

Payroll Check Register

View

Payroll Journal Report

View

Payroll Liability Report

View

Payroll Summary & Detail Reports

View

Purchases

View

Reconcile Reporting

View

Employee Reminders

View

Sales

View

Sales By Partner

View

Sales By Promotion Code

View

Sales Force Automation

View

Support

View

Tax

View

Time Tracking

View

Transaction Detail

View

Trial Balance

View

Web Site Report

View

Web Store Report

View

Report Customization

Full

These permissions are found in the Lists tab of the Create Role page in NetSuite.

Added Permission name Level
Employees

View

Resource Allocations

View

Perform Search

View

Allows for various object-specific search functions.

Accounts

Full

Accounts Payable Register

Full

Accounts Receivable Register

Full

Advanced Government Issued IDs

Full

Bank Account Registers

Full

Calendar

Full

Marketing Campaign

Full

Campaign History

Full

Cases

Full

Classes

Full

Color Themes

Full

Companies

Full

Competitors

Full

Contacts

Full

Cost of Goods Sold Registers

Full

Credit Card Registers

Full

CRM Group

Full

Currency

Full

Custom Record Entries

Full

Customer Profile

Full

Customers

Full

Departments

Full

Documents and Files

Full

Email Template

Full

Employee Change Reason

Full

Employee Effective Dating

Full

Other Lists

Full

Employees

Full

Equity Registers

Full

Events

Full

Expense Categories

Full

Expense Registers

Full

Find Transaction

Full

Fixed Asset Registers

Full

Government Issued ID Types

Full

Income Registers

Full

Items

Full

Jobs

Full

HCMJob Management

Full

Knowledge Base

Full

Kudos

Full

Locations

Full

Long Term Liability Registers

Full

Marketing Template

Full

Mass Updates

Full

Media Folders

Full

Memorized Transactions

Full

Non Posting Registers

Full

Notes Tab

Full

Organization Value

Full

Other Asset Registers

Full

Other Current Asset Registers

Full

Other Current Liability Registers

Full

Other Expense Registers

Full

Other Income Registers

Full

Other Names

Full

Partners

Full

Paychecks

Full

Payment Methods

Full

Payroll Items

Full

Presentation Categories

Full

Promotion

Full

Related Items

Full

Resource

Full

Resource Allocation Approval

Full

Shipping Items

Full

Store Content Items

Full

Store Tabs

Full

Tasks

Full

Tax Items

Full

Termination Reasons

Full

Time-Off Administration

Full

Track Messages

Full

Vendors

Full

These permissions are found in the Setup tab of the Create Role page in NetSuite.

Added Permission name Level
Custom Body Fields

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields

View

Custom Record Types

View

Custom Column Fields

View

Custom Entity Fields

View

Custom Item Fields

View

Custom Event Fields

View

Custom Transaction Fields

View

Other Custom Fields

View

Accounting Lists

Full

CRM Lists

Full

Deleted Records

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.


netsuite_bin

Replication Method: Full Table Documentation: Official Docs
Primary Key :

The netsuite_bin table contains info about the accounts in your NetSuite instance.

Refer to the other tabs in this section of the guide for the permissions you need to add.

To add a permission to the role:

  1. In the Permissions section, click a subsection. For example: Transactions
  2. Using the Permission dropdown, search for the permission you want to add.

    For example: If adding permissions in the Transactions subtab of NetSuite, you’ll use the checklist in the Transactions tab of this guide.

  3. Using the Level dropdown, set the permission level to the corresponding level outlined in this guide:

    The Transactions subsection in the Permissions section of the NetSuite Create Role page

  4. Click Add.
  5. Repeat these steps until all permissions in the tabs of this guide have been added.

These permissions are the minimum required to successfully connect Stitch to your NetSuite integration.

Note: While Stitch may be able to replicate some data using only these permisisons, it is unlikely that Stitch will be able to replicate all possible NetSuite objects. You should grant the permissions outlined in the other tabs to ensure successful replication.

Added Permission name Location Level
Custom Body Fields Setup tab

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields Setup tab

View

Custom Record Types Setup tab

View

Custom Column Fields Setup tab

View

Custom Entity Fields Setup tab

View

Custom Item Fields Setup tab

View

Custom Event Fields Setup tab

View

Custom Transaction Fields Setup tab

View

Other Custom Fields Setup tab

View

Perform Search Lists tab

View

Allows for various object-specific search functions.

Deleted Records Setup tab

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services Setup tab

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.

These permissions are found in the Transactions tab of the Create Role page in NetSuite.

Added Permission name Level
Access Payment Audit Log

View

Adjust Inventory

Full

Adjust Inventory Worksheet

Full

Approve Direct Deposit

Full

Approve EFT

Full

Approve Online Bill Payments

Full

Audit Trail

Full

Bill Purchase Orders

Full

Bill Sales Orders

Full

Billing Setup

Full

Bills

Full

Cash Sale

Full

Cash Sale Refund

Full

Check

Full

Credit Card

Full

Credit Card Refund

Full

Credit Memo

Full

Currency Revaluation

Full

Customer Payment

Full

Customer Refund

Full

Deposit

Full

Direct Deposit Status

Full

Distribute Inventory

Full

Edit Forecast

Full

EFT Status

Full

Enter Opening Balances

Full

Enter Vendor Credits

Full

Enter Year-to-date Payroll Adjustments

Full

Establish Quotas

Full

Estimate

Full

Expense Report

Full

Finance Charge

Full

Fulfill Orders

Full

Generate Statements

Full

Individual Paycheck

Full

Invoice

Full

Journal Approval

Full

Make Journal Entry

Full

Opportunity

Full

Pay Bills

Full

Pay Sales Tax

Full

Payroll Liability Payments

Full

Post Time

Full

Process Payroll

Full

Purchase Order

Full

Receive Orders

Full

Reconcile

Full

Refund Returns

Full

Return Auth. Approval

Full

Return Authorization

Full

Revenue Commitment

Full

Revenue Commitment Reversal

Full

Generate Revenue Commitment

Full

Generate Revenue Commitment Reversals

Full

Sales Order

Full

Sales Order Approval

Full

Set Up Budgets

Full

Statement Charge

Full

Track Time

Full

Transfer Funds

Full

Transfer Inventory

Full

View Online Bill Pay Status

Full

These permissions are found in the Reports tab of the Create Role page in NetSuite.

Added Permission name Level
Accounts Receivable Un-Billed

View

Balance Sheet

View

Budget

View

Cash Flow Statement

View

Form 1099 - Federal Miscellaneous Income

View

Form W-2 - Wage and Tax Statement

View

General Ledger

View

Income Statement

View

Inventory

View

Payroll Summary & Detail Reports

View

Payroll Check Register

View

Payroll Journal Report

View

Payroll Liability Report

View

Payroll Summary & Detail Reports

View

Purchases

View

Reconcile Reporting

View

Employee Reminders

View

Sales

View

Sales By Partner

View

Sales By Promotion Code

View

Sales Force Automation

View

Support

View

Tax

View

Time Tracking

View

Transaction Detail

View

Trial Balance

View

Web Site Report

View

Web Store Report

View

Report Customization

Full

These permissions are found in the Lists tab of the Create Role page in NetSuite.

Added Permission name Level
Employees

View

Resource Allocations

View

Perform Search

View

Allows for various object-specific search functions.

Accounts

Full

Accounts Payable Register

Full

Accounts Receivable Register

Full

Advanced Government Issued IDs

Full

Bank Account Registers

Full

Calendar

Full

Marketing Campaign

Full

Campaign History

Full

Cases

Full

Classes

Full

Color Themes

Full

Companies

Full

Competitors

Full

Contacts

Full

Cost of Goods Sold Registers

Full

Credit Card Registers

Full

CRM Group

Full

Currency

Full

Custom Record Entries

Full

Customer Profile

Full

Customers

Full

Departments

Full

Documents and Files

Full

Email Template

Full

Employee Change Reason

Full

Employee Effective Dating

Full

Other Lists

Full

Employees

Full

Equity Registers

Full

Events

Full

Expense Categories

Full

Expense Registers

Full

Find Transaction

Full

Fixed Asset Registers

Full

Government Issued ID Types

Full

Income Registers

Full

Items

Full

Jobs

Full

HCMJob Management

Full

Knowledge Base

Full

Kudos

Full

Locations

Full

Long Term Liability Registers

Full

Marketing Template

Full

Mass Updates

Full

Media Folders

Full

Memorized Transactions

Full

Non Posting Registers

Full

Notes Tab

Full

Organization Value

Full

Other Asset Registers

Full

Other Current Asset Registers

Full

Other Current Liability Registers

Full

Other Expense Registers

Full

Other Income Registers

Full

Other Names

Full

Partners

Full

Paychecks

Full

Payment Methods

Full

Payroll Items

Full

Presentation Categories

Full

Promotion

Full

Related Items

Full

Resource

Full

Resource Allocation Approval

Full

Shipping Items

Full

Store Content Items

Full

Store Tabs

Full

Tasks

Full

Tax Items

Full

Termination Reasons

Full

Time-Off Administration

Full

Track Messages

Full

Vendors

Full

These permissions are found in the Setup tab of the Create Role page in NetSuite.

Added Permission name Level
Custom Body Fields

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields

View

Custom Record Types

View

Custom Column Fields

View

Custom Entity Fields

View

Custom Item Fields

View

Custom Event Fields

View

Custom Transaction Fields

View

Other Custom Fields

View

Accounting Lists

Full

CRM Lists

Full

Deleted Records

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.


netsuite_budget

Replication Method: Full Table Documentation: Official Docs
Primary Key :

The netsuite_budget table contains info about [PLACEHOLDER].

Refer to the other tabs in this section of the guide for the permissions you need to add.

To add a permission to the role:

  1. In the Permissions section, click a subsection. For example: Transactions
  2. Using the Permission dropdown, search for the permission you want to add.

    For example: If adding permissions in the Transactions subtab of NetSuite, you’ll use the checklist in the Transactions tab of this guide.

  3. Using the Level dropdown, set the permission level to the corresponding level outlined in this guide:

    The Transactions subsection in the Permissions section of the NetSuite Create Role page

  4. Click Add.
  5. Repeat these steps until all permissions in the tabs of this guide have been added.

These permissions are the minimum required to successfully connect Stitch to your NetSuite integration.

Note: While Stitch may be able to replicate some data using only these permisisons, it is unlikely that Stitch will be able to replicate all possible NetSuite objects. You should grant the permissions outlined in the other tabs to ensure successful replication.

Added Permission name Location Level
Custom Body Fields Setup tab

View

Required to allow Stitch to access and replicate custom record types and the data within those records.

These permissions are required to replicate the netsuite_custom_list and netsuite_custom_records tables.

Custom Fields Setup tab

View

Custom Record Types Setup tab

View

Custom Column Fields Setup tab

View

Custom Entity Fields Setup tab

View

Custom Item Fields Setup tab

View

Custom Event Fields Setup tab

View

Custom Transaction Fields Setup tab

View

Other Custom Fields Setup tab

View

Perform Search Lists tab

View

Allows for various object-specific search functions.

Deleted Records Setup tab

Full

Allows Stitch to query for deleted records in objects that the Stitch user has access to. For example: If access to transactions is granted, Stitch can replicate deleted transaction records.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to deleted records of any type. For example: If the Departments permission is set to View, Stitch will be able to see and replicate department data (existing and deleted), but not create, delete, or edit records.

Web Services Setup tab

View

Required to allow Stitch to access your NetSuite account.

Note: NetSuite only allows Full as the level for this permission, but this only grants read-only access to the account. For Stitch to access any entity data, such as Departments, permission must also be granted to that entity.

These permissions are found in the Transactions tab of the Create Role page in NetSuite.

Added Permission name Level
Access Payment Audit Log

View

Adjust Inventory

Full

Adjust Inventory Worksheet

Full

Approve Direct Deposit

Full

Approve EFT

Full

Approve Online Bill Payments

Full

Audit Trail

Full

Bill Purchase Orders

Full

Bill Sales Orders

Full

Billing Setup

Full

Bills

Full

Cash Sale

Full

Cash Sale Refund

Full

Check

Full

Credit Card

Full

Credit Card Refund

Full

Credit Memo

Full

Currency Revaluation

Full

Customer Payment

Full

Customer Refund

Full

Deposit

Full

Direct Deposit Status

Full

Distribute Inventory

Full

Edit Forecast

Full

EFT Status

Full

Enter Opening Balances

Full

Enter Vendor Credits

Full

Enter Year-to-date Payroll Adjustments

Full

Establish Quotas

Full

Estimate

Full

Expense Report

Full

Finance Charge

Full

Fulfill Orders

Full

Generate Statements

Full

Individual Paycheck

Full

Invoice

Full

Journal Approval

Full

Make Journal Entry

Full

Opportunity

Full

Pay Bills

Full

Pay Sales Tax

Full

Payroll Liability Payments

Full

Post Time

Full

Process Payroll

Full

Purchase Order

Full

Receive Orders

Full

Reconcile

Full

Refund Returns

Full

Return Auth. Approval

Full

Return Authorization

Full

Revenue Commitment

Full

Revenue Commitment Reversal

Full

Generate Revenue Commitment

Full

Generate Revenue Commitment Reversals

Full

Sales Order

Full

Sales Order Approval

Full

Set Up Budgets

Full

Statement Charge

Full

Track Time

Full

Transfer Funds

Full

Transfer Inventory

Full

View Online Bill Pay Status

Full

These permissions are found in the Reports tab of the Create Role page in NetSuite.

Added Permission name Level
Accounts Receivable Un-Billed

View

Balance Sheet

View

Budget

View

Cash Flow Statement

View

Form 1099 - Federal Miscellaneous Income

View

Form W-2 - Wage and Tax Statement

View

General Ledger

View

Income Statement

View

Inventory

View

Payroll Summary & Detail Reports

View

Payroll Check Register

View

Payroll Journal Report

View

Payroll Liability Report

View

Payroll Summary & Detail Reports

View

Purchases

View

Reconcile Reporting

View

Employee Reminders

View

Sales

View

Sales By Partner

View

Sales By Promotion Code

View

Sales Force Automation

View

Support

View

Tax

View

Time Tracking

View

Transaction Detail

View

Trial Balance

View

Web Site Report

View

Web Store Report

View

Report Customization

Full

These permissions are found in the Lists tab of the Create Role page in NetSuite.

Added Permission name Level
Employees

View

Resource Allocations

View

Perform Search

View

Allows for various object-specific search functions.

Accounts

Full

Accounts Payable Register

Full

Accounts Receivable Register

Full

Advanced Government Issued IDs

Full

Bank Account Registers

Full

Calendar

Full

Marketing Campaign

Full

Campaign History

Full

Cases

Full

Classes

Full

Color Themes

Full

Companies

Full

Competitors

Full

Contacts

Full

Cost of Goods Sold Registers

Full

Credit Card Registers

Full

CRM Group

Full