NetSuite snapshot

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

STITCH
Release Status

Released

Supported By

Stitch

Stitch Plan

Paid

DATA SELECTION
Table Selection

Supported

Column Selection

Unsupported

REPLICATION SETTINGS
Anchor Scheduling

Supported

Table-level Reset

Unsupported

Configurable Replication Methods

Unsupported

TRANSPARENCY
Extraction Logs

Unsupported

Loading Reports

Unsupported

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

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.

AssemblyBuild AssemblyUnBuild BinTransfer BinWorksheet
CashRefund CashSale Check CreditMemo
Custom CustomerDeposit CustomerPayment CustomerRefund
Deposit DepositApplication Estimate ExpenseReport
InventoryAdjustment InventoryCostRevaluation InventoryTransfer Invoice
ItemFulfillment ItemReceipt Journal Opportunity
PaycheckJournal PurchaseOrder Requisition ReturnAuthorization
SalesOrder TransferOrder VendorBill VendorCredit
VendorPayment VendorReturnAuthorization WorkOrder WorkOrderClose
WorkOrderCompletion WorkOrderIssue

netsuite_account

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

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

internalId
INTEGER

The account ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_accounting_period

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

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

internalId
INTEGER

The accounting period ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_app_definition

Replication Method: Full Table
Primary Key : internalId

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

internalId
INTEGER

The app definition ID.

Your Selected Fields

Other fields selected by you.


netsuite_app_package

Replication Method: Full Table
Primary Key : internalId

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

internalId
INTEGER

The app packages ID.

Your Selected Fields

Other fields selected by you.


netsuite_billing_schedule

Replication Method: Full Table
Primary Key : internalId

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

internalId
INTEGER

The account ID.

Your Selected Fields

Other fields selected by you.


netsuite_bin

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

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

internalId
INTEGER

The bins ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_budget

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

The netsuite_budget table contains info about budgets.

internalId
INTEGER

The account ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_calendar_event

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_calendar_event table contains info about calendar events.

internalId
INTEGER

The calendar event ID.

lastModifiedDate
DATE-TIME

The time the calendar event was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_campaign

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_campaign table contains info about campaigns.

internalId
INTEGER

The campaign ID.

lastModifiedDate
DATE-TIME

The time the campaign was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_charge

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

The netsuite_charge table contains info about charges.

internalId
INTEGER

The charge ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_classification

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

The netsuite_classification table contains info about classifications.

internalId
INTEGER

The classification ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_contact

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_contact table contains info about contacts.

internalId
INTEGER

The contact ID.

lastModifiedDate
DATE-TIME

The time the contact was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_contact_category

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

The netsuite_contact_category table contains info about contact categories.

internalId
INTEGER

The contact category ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_contact_role

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

The netsuite_contact_role table contains info about contact roles.

internalId
INTEGER

The contact role ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_coupon_code

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

The netsuite_coupon_code table contains info about coupon codes.

internalId
INTEGER

The coupon code ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_currency_rate

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

The netsuite_currency_rate table contains info about currency rates.

internalId
INTEGER

The currency rate ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_custom_list

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

The netsuite_custom_list table contains info about custom lists.

internalId
INTEGER

The custom list ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_custom_records

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

The netsuite_custom_records table contains info about custom records.

internalId
INTEGER

The custom records ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_customer

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_customer table contains info about customers.

internalId
INTEGER

The customer ID.

lastModifiedDate
DATE-TIME

The time the customer was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_customer_category

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_customer_category table contains info about customer categories.

internalId
INTEGER

The customer category ID.

lastModifiedDate
DATE-TIME

The time the customer category was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_customer_message

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

The netsuite_customer_message table contains info about customer messages.

internalId
INTEGER

The customer message ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_customer_status

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

The netsuite_customer_status table contains info about customer statuses.

internalId
INTEGER

The customer status ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_deleted

Replication Method: Key-based Incremental Replication Key : deletedDate
Primary Key : internalId : type Documentation: Official Docs

The netsuite_deleted table contains info about deleted records.

internalId
INTEGER

The deleted record ID.

type
STRING

The type of record that was deleted. For example: invoice

deletedDate
DATE-TIME

The time the deleted record was deleted.

customRecord
BOOLEAN

Indicates if the deleted record was a custom record.

name
STRING

The name of the record that was deleted. For example: Invoice #INV197


netsuite_department

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

The netsuite_department table contains info about departments.

internalId
INTEGER

The department ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_employee

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_employee table contains info about employees.

internalId
INTEGER

The employee ID.

lastModifiedDate
DATE-TIME

The time the employee was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_entity_group

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_entity_group table contains info about entity groups.

internalId
INTEGER

The entity group ID.

lastModifiedDate
DATE-TIME

The time the entity group was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_expense_category

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

The netsuite_expense_category table contains info about expense categories.

internalId
INTEGER

The expense category ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_file

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

The netsuite_file table contains info about files.

internalId
INTEGER

The file ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_folder

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_folder table contains info about folders.

internalId
INTEGER

The folder ID.

lastModifiedDate
DATE-TIME

The time the folder was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_gift_certificate

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

The netsuite_gift_certificate table contains info about gift certificates.

internalId
INTEGER

The gift certificate ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_global_account_mapping

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

The netsuite_global_account_mapping table contains info about global account mappings.

internalId
INTEGER

The global account mapping ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_inventory_number

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

The netsuite_inventory_number table contains info about inventory numbers.

internalId
INTEGER

The inventory number ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_issue

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

The netsuite_issue table contains info about issues.

internalId
INTEGER

The issue ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_item

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_item table contains info about items.

internalId
INTEGER

The item ID.

lastModifiedDate
DATE-TIME

The time the item was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_item_account_mapping

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

The netsuite_item_account_mapping table contains info about item account mappings.

internalId
INTEGER

The item account mapping ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_item_demand_plan

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_item_demand_plan table contains info about item demand plans.

internalId
INTEGER

The item demand plan ID.

lastModifiedDate
DATE-TIME

The time the item demand plan was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_item_revision

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

The netsuite_item_revision table contains info about item revisions.

internalId
INTEGER

The item revision ID.

_type
STRING

The type of item that was revised.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_item_supply_plan

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_item_supply_plan table contains info about item supply plans.

internalId
INTEGER

The item supply plan ID.

lastModifiedDate
DATE-TIME

The time the item supply plan was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_job

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_job table contains info about jobs.

internalId
INTEGER

The job ID.

lastModifiedDate
DATE-TIME

The time the job was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_job_status

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

The netsuite_job_status table contains info about job statuses.

internalId
INTEGER

The job status ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_job_type

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

The netsuite_job_type table contains info about job types.

internalId
INTEGER

The job type ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_location

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

The netsuite_location table contains info about locations.

internalId
INTEGER

The location ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_manufacturing_cost_template

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

The netsuite_manufacturing_cost_template table contains info about manufacturing cost templates.

internalId
INTEGER

The manufacturing cost template ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_manufacturing_operation_task

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

The netsuite_manufacturing_operation_task table contains info about manufacturing operation tasks.

internalId
INTEGER

The manufacturing operation task ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_manufacturing_routing

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

The netsuite_manufacturing_routing table contains info about manufacturing routings.

internalId
INTEGER

The manufacturing routing ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_message

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

The netsuite_message table contains info about messages.

internalId
INTEGER

The message ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_nexus

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

The netsuite_nexus table contains info about nexus tax items.

internalId
INTEGER

The record ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_note

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

The netsuite_note table contains info about notes.

internalId
INTEGER

The note ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_note_type

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

The netsuite_note_type table contains info about note types.

internalId
INTEGER

The note type ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_opportunity

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_opportunity table contains info about opportunities.

internalId
INTEGER

The opportunity ID.

lastModifiedDate
DATE-TIME

The time the opportunity was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_originating_lead

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_originating_lead table contains info about originating leads.

internalId
INTEGER

The originating lead ID.

type
STRING

The originating lead type.

lastModifiedDate
DATE-TIME

The time the originating lead was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_other_name_category

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

The netsuite_other_name_category table contains info about other name categories.

internalId
INTEGER

The other name category ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_partner

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_partner table contains info about partners.

internalId
INTEGER

The partner ID.

lastModifiedDate
DATE-TIME

The time the partner was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_partner_category

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

The netsuite_partner_category table contains info about partner categories.

internalId
INTEGER

The partner category ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_payment_method

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

The netsuite_payment_method table contains info about payment methods.

internalId
INTEGER

The payment method ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_payroll_item

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

The netsuite_payroll_item table contains info about payroll items.

internalId
INTEGER

The payroll item ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_phone_call

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_phone_call table contains info about phone calls.

internalId
INTEGER

The phone call ID.

lastModifiedDate
DATE-TIME

The time the phone call was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_price_level

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

The netsuite_price_level table contains info about [price levels.

internalId
INTEGER

The price level ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_pricing_group

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

The netsuite_pricing_group table contains info about pricing groups.

internalId
INTEGER

The pricing group ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_project_task

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_project_task table contains info about project tasks.

internalId
INTEGER

The project task ID.

lastModifiedDate
DATE-TIME

The time the project task was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_promotion_code

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

The netsuite_promotion_code table contains info about promotion codes.

internalId
INTEGER

The promotion code ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_resource_allocation

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

The netsuite_resource_allocation table contains info about resource allocations.

internalId
INTEGER

The resource allocation ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_rev_rec_schedule

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

The netsuite_rev_rec_schedule table contains info about revenue recognition schedules.

internalId
INTEGER

The revenue recognition schedule ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_rev_rec_template

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

The netsuite_rev_rec_template table contains info about revenue recognition templates.

internalId
INTEGER

The revenue recognition template ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_sales_role

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

The netsuite_sales_role table contains info about sales roles.

internalId
INTEGER

The sales role ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_site_category

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

The netsuite_site_category table contains info about site categories.

internalId
INTEGER

The site category ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_solution

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_solution table contains info about solutions.

internalId
INTEGER

The solution ID.

lastModifiedDate
DATE-TIME

The time the solution was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_subsidiary

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

The netsuite_subsidiary table contains info about subsidiaries.

internalId
INTEGER

The subsidiary ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_support_case

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_support_case table contains info about support cases.

internalId
INTEGER

The support case ID.

lastModifiedDate
DATE-TIME

The time the support case was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_task

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_task table contains info about tasks.

internalId
INTEGER

The task ID.

lastModifiedDate
DATE-TIME

The time the task was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_term

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

The netsuite_term table contains info about terms.

internalId
INTEGER

The term ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_time_bill

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_time_bill table contains info about time bills.

internalId
INTEGER

The time bill ID.

lastModifiedDate
DATE-TIME

The time the time bill was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_time_entry

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_time_entry table contains info about time entries.

internalId
INTEGER

The time entry ID.

lastModifiedDate
DATE-TIME

The time the time entry was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_time_sheet

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

The netsuite_time_sheet table contains info about time sheets.

internalId
INTEGER

The time sheet ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_topic

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

The netsuite_topic table contains info about knowledge base topics.

internalId
INTEGER

The topic ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_transaction

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_transaction table contains info about transactions.

internalId
INTEGER

The transaction ID.

_type
STRING

The transaction type. Possible values are:

  • AssemblyBuild

  • AssemblyUnBuild

  • BinTransfer

  • BinWorksheet

  • CashRefund

  • CashSale

  • Check

  • CreditMemo

  • Custom

  • CustomerDeposit

  • CustomerPayment

  • CustomerRefund

  • Deposit

  • DepositApplication

  • Estimate

  • ExpenseReport

  • InventoryAdjustment

  • InventoryCostRevaluation

  • InventoryTransfer

  • Invoice

  • ItemFulfillment

  • ItemReceipt

  • Journal

  • Opportunity

  • PaycheckJournal

  • PurchaseOrder

  • Requisition

  • ReturnAuthorization

  • SalesOrder

  • TransferOrder

  • VendorBill

  • VendorCredit

  • VendorPayment

  • VendorReturnAuthorization

  • WorkOrder

  • WorkOrderClose

  • WorkOrderCompletion

  • WorkOrderIssue

lastModifiedDate
DATE-TIME

The time the transaction was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_units_type

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

The netsuite_units_type table contains info about unit types.

internalId
INTEGER

The units type ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_vendor

Replication Method: Key-based Incremental Replication Key : lastModifiedDate
Primary Key : internalId Documentation: Official Docs

The netsuite_vendor table contains info about vendors.

internalId
INTEGER

The vendor ID.

lastModifiedDate
DATE-TIME

The time the vendor was last updated.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_vendor_category

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

The netsuite_vendor_category table contains info about vendor categories.

internalId
INTEGER

The vendor category ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_win_loss_reason

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

The netsuite_win_loss_reason table contains info about win loss reasons.

internalId
INTEGER

The win loss reason ID.

Your Selected Fields

Other fields selected by you. For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.



Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.