NetSuite (v2) | Stitch Documentation

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

For support, contact Stitch support.

NetSuite integration summary

Stitch’s NetSuite integration replicates data using the NetSuite SuiteTalk API (v2023_1). Refer to the Schema section for a list of objects available for replication.

NetSuite feature snapshot

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

STITCH
Release status	Deprecated on May 8, 2019	Supported by	Stitch
Stitch plan	Standard	API availability	Not available
Singer GitHub repository
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting NetSuite

NetSuite setup requirements

To set up NetSuite in Stitch, you need:

Administrator permissions in NetSuite. This is required to complete the setup steps in NetSuite.

Step 1: Whitelist Stitch's IP addresses

Note: This step is required only if IP address rules (Setup > Company > Enable Features > Company > Access) are enabled for your NetSuite account. Otherwise, skip to Step 2.

Step 1.1: Verify your Stitch account’s data pipeline region
Step 1.2: Add Stitch’s IP addresses to your NetSuite company information

Step 1.1: Verify your Stitch account's data pipeline region

The IP addresses you’ll whitelist depend on the Data pipeline region your account is in.

Sign into your Stitch account, if you haven’t already.
Click User menu (your icon) > Manage Account Settings and locate the Data pipeline region section to verify your account’s region.
Locate the list of IP addresses for your region:
- North America region IP addresses
- Europe region IP addresses

Keep this list handy - you’ll need it in the next step.

Step 1.2: Add Stitch's IP addresses to your NetSuite company information

Sign into your NetSuite account as an administrator.
In your NetSuite account, click Setup > Company > Company Information.
In the Allowed IP addresses field, add a comma-delimited list of the Stitch IP addresses you retrieved in the previous step.

Note: Make sure you don’t overwrite or change any existing IP addresses in this field - doing so could cause access issues for you and other NetSuite users in your account.

This is an example of what the screen should look like, using Stitch’s North America IP addresses:
Click Save.

Step 2: Configure Web Services and authentication settings

To use Stitch’s NetSuite integration, you’ll need to enable Web Services and token-based authentication in your NetSuite account.

Step 2.1: Enable Web Services
Step 2.2: Enable token-based authentication

Step 2.1: Enable Web Services

In this step, you’ll enable Web Services for your NetSuite account. This is required to use NetSuite’s SuiteTalk API, which is what Stitch will use to extract data.

Sign into your NetSuite account as an administrator, if you aren’t already signed in.
Using the global search, type page: enable and click the Page: Enable Features result. For example:
On the Enable Features page, click the SuiteCloud subtab.
Locate the SuiteTalk (Web Services) section.
Check the Web Services box.

Step 2.2: Enable token-based authentication

Next, you’ll enable token-based authentication for your NetSuite account. This is required to generate tokens and authenticate to the SuiteTalk API.

On the Enable Features page, locate the Manage Authentication section. This should be after the SuiteTalk section.
Check the Token-based Authentication box. Your settings should look like this when finished:
Scroll to the bottom of the page and click Save.

Step 3: Create an integration record for Stitch

Next, you’ll create an integration record for Stitch. This will uniquely identify Stitch in your NetSuite account.

Using the global search, type page: integrations and click the Page: Manage Integrations result.
On the Integrations page, click the New button.
On the New Integration page, fill in the following fields:
- Name: Enter a name for the integration. For example: Stitch
- State: Select Enabled.
In the Authentication tab, select the Token-based Authentication option.
Click the Save button. The confirmation page will display a Consumer key/secret section.
Copy the Consumer Key and Secret somewhere handy. You’ll need these credentials to complete the setup in Stitch.

Step 4: Create a Stitch NetSuite role and configure permissions

To connect NetSuite to Stitch, we recommend that you create a Stitch-specific role and user for us. We suggest this to ensure that 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.

Step 4.1: Create a Stitch NetSuite role
Step 4.2: Configure role permissions
Step 4.3: Save the role

Step 4.1: Create a Stitch NetSuite role

Using the global search, type page: new role and click the Page: New Role result.
On the Role page, enter a name for the role in the Name field. For example: Stitch
In the Authentication section, check the Web Services Only Role box.

Step 4.2: Configure role permissions

Next, you’ll grant permissions to the role. In the tabs below, you’ll find the following:

Adding permissions - Step-by-step instructions for adding permissions to the role on the Create Role page.
Required permissions - The minimum permissions required to successfully connect Stitch to NetSuite.
Object permissions - The permissions required to access and replicate data for specific objects in NetSuite. Stitch recommends granting only the permissions required for the objects you want to replicate.

About NetSuite permissions

Depending on which products are enabled in your NetSuite account, you might not see some of these permissions. If you don’t see a permission in your NetSuite account, skip it.

For more info about these permissions and how they work within NetSuite, refer to NetSuite’s Permissions Documentation spreadsheet, which can be downloaded here from their help center. You may need to log into NetSuite to access their documentation.

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:

In the Permissions tab, click a subtab. For example: Transactions
Using the Permission dropdown, search for the permission you want to add. Refer to the other tabs in this section for the permissions you need to add.
Using the Level dropdown, set the permission level to the corresponding level outlined in this guide:
Click Add.
Repeat these steps until all permissions in the Required permissions tab and the desired permissions in the Object permissions tab have been added.

Note: If you don’t see a permission in NetSuite that is listed here, skip it. Some permissions are dependent on specific features being enabled in your NetSuite account.

These permissions are the minimum required to successfully connect Stitch to your NetSuite integration. While Stitch may be able to replicate some data using only these permissions, it is unlikely that Stitch will be able to replicate all possible NetSuite objects. Refer to the Object permissions tab to grant permissions for specific objects (tables).

Permission	Tab	Level
Custom Body Fields	Setup	View
Custom Fields	Setup	View
Custom Record Types	Setup	View
Deleted Records	Setup	Full
SOAP Web Services	Setup	Full
User Access Token	Setup	Full

In the table below are object-specific permissions and the tables they correspond to. The permissions for a given table must be granted to the Stitch role in order to access and replicate data for the table.

The columns in the table are as follows:

- If present, the table corresponds to a feature or features that must be enabled in NetSuite. If the feature or features aren't enabled in your account, the permission listed will not be available to grant and attempts to extract data for the corresponding table will result in permissions errors.
Table name - The name of the Stitch table.
Tab - The tab in the Create Role page that contains the permission.
Permission - The permission required to access and replicate data for the table.
Level - The level of permission required to access and replicate data for the table. This will usually be View.

Table name	Permission	Tab	Level
Account	Accounts		View
AccountingPeriod	Manage Accounting Periods	Setup	View
Address	[Parent Record Permission]	Lists	View
BillingAccount	Customers	Lists	View
BillingSchedule	Billing Schedules		View
Bin	Bins	Lists	View
Bom	Bill of Materials	Lists	View
BomRevision	Bill of Materials	Lists	View
Budget	Set Up Budgets	Lists	View
CalendarEvent	Calendar	Lists	View
Campaign	Marketing Campaigns	Lists	View
Charge	Charge	Transactions	View
Classification	[Parent Record Permission]	Lists	View
ConsolidatedExchangeRate	Currency	Lists	View
Contact	Contacts	Lists	View
ContactCategory	CRM Lists	Setup	View
ContactRole	CRM Lists	Setup	View
CostCategory	Accounting Lists	Setup	View
CouponCode	Promotion	Lists	View
CurrencyRate	Currency	Lists	View
CustomList	Custom Lists	Setup	View
Customer	Customers	Lists	View
CustomerCategory	Accounting Lists	Setup	View
CustomerMessage	Accounting Lists	Setup	View
CustomerStatus	Customer Status	Setup	View
CustomerSubsidiaryRelationship	Subsidiaries	Lists	View
Deleted	Deleted Records	Setup	Full
Department	Departments	Lists	View
Employee	Employees	Lists	View
EntityGroup	CRM Groups	Lists	View
ExpenseCategory	Expense Categories	Lists	View
FairValuePrice	Fair Value Price	Lists	View
File	Documents and Files	Lists	View
Folder	Documents and Files	Lists	View
GiftCertificate	Items	Lists	View
GlobalAccountMapping	Global Account Mapping	Setup	View
HcmJob	HCMJob Management	Lists	View
InboundShipment	Inbound Shipment	Lists	View
InventoryNumber	Items	Lists	View
Issue	Issues	Lists	View
Item	[Item Type]	Lists	View
ItemAccountMapping	Item Account Mapping	Setup	View
ItemDemandPlan	Item Demand Plan	Lists	View
ItemRevision	Item Revisions	Lists	View
ItemSupplyPlan	Item Supply Plan	Lists	View
Job	Projects	Lists	View
JobStatus	Projects	Lists	View
JobType	Projects	Lists	View
Location	Locations	Lists	View
ManufacturingCostTemplate	Manufacturing Cost Template	Lists	View
ManufacturingOperationTask	Work Orders	Transactions	View
ManufacturingRouting	Manufacturing Routing	Lists	View
MerchandiseHierarchyNode	Merchandise Hierarchy Node	Setup	View
Message	Track Messages	Lists	View
Nexus	Tax Items	Lists	View
Note	Notes Tab	Lists	View
NoteType	CRM Lists	Setup	View
Opportunity	Opportunity	Transactions	View
OtherNameCategory	Accounting Lists	Setup	View
Partner	Partners	Lists	View
PartnerCategory	CRM Lists	Setup	View
Paycheck	Individual Paycheck	Transactions	View
PaymentMethod	Payment Methods	Lists	View
PayrollItem	Payroll Items	Lists	View
PhoneCall	Phone Call	Lists	View
PriceLevel	Accounting Lists	Setup	View
PricingGroup	Accounting Lists	Setup	View
ProjectTask	Project Tasks	Lists	View
PromotionCode	Promotions	Lists	View
ResourceAllocation	Resource Allocations	Lists	View
RevRecSchedule	Revenue Recognition Schedules	Lists	View
RevRecTemplate	Revenue Recognition Schedules	Lists	View
SalesRole	Sales Roles	Lists	View
SalesTaxItem	Tax Items	Lists	View
SiteCategory	Presentation Categories	Lists	View
Solution	Knowledge Base	Lists	View
Subsidiary	Subsidiaries	Lists	View
SupportCase	Cases	Lists	View
Task	Project Tasks	Lists	View
TaxGroup	Tax Groups	Lists	View
TaxType	Tax Groups	Lists	View
Term	Customer Payment	Transactions	View
TimeBill	Track Time	Transactions	View
TimeEntry	Track Time	Transactions	View
TimeSheet	Track Time	Transactions	View
Topic	Knowledge Base	Lists	View
Transaction	[Transaction Type]	Transactions	View
UnitsType	Units	Lists	View
Usage	Subscriptions	Lists	View
Vendor	Vendors	Lists	View
VendorCategory	Accounting Lists	Setup	View
VendorSubsidiaryRelationship	Subsidiaries	Lists	View
WinLossReason	Opportunity	Transactions	View

Step 4.3: Save the role

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

Step 5: Create a Stitch NetSuite user

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

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

Step 6: Create access tokens for Stitch

Note: This requires the Setup > Access Token Management permission in NetSuite.

In this step, you’ll generate access tokens for the Stitch integration record (application) and user role.

Using the global search, type page: tokens and click the Page: Access Tokens result.
Click the New Access Token button.
On the Access Token page, fill in the following fields:
- Application Name: Select the integration record you created in Step 3.
- User: Select the Stitch user you created in Step 5.
- Role: Select the Stitch role you created in Step 4.
- Token Name: Enter a name for the token. For example: Stitch
Click the Save button. The confirmation page will display a Token ID and Secret.
Copy the Token ID and Secret somewhere handy. You’ll need these credentials to complete the setup in Stitch.

Step 7: Locate your NetSuite Account ID

Using the global search, type page: web services and click the Page: Web Services Preferences result.
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 8: Add NetSuite as a Stitch data source

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

For example, the name “Stitch NetSuite” would create a schema called stitch_netsuite in the destination. Note: Schema names cannot be changed after you save the integration.
In the Account field, enter the NetSuite account ID you retrieved in Step 7.
In the Consumer Key field, paste the Consumer Key you generated when you created Stitch’s integration record.
In the Token ID field, paste the Token ID you generated when you created Stitch’s access tokens.
In the Consumer Secret field, paste the Consumer Secret you generated when you created Stitch’s integration record.
In the Token Secret field, paste the Token Secret you generated when you created Stitch’s access tokens.

Step 9: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your NetSuite integration. This means that:

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

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

Step 10: Create a replication schedule

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

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

NetSuite integrations support the following replication scheduling methods:

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

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

Step 11: Set objects to replicate

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

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

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

For NetSuite integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

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

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

Initial and historical replication jobs

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

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

Initial replication jobs with Anchor Scheduling

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

Free historical data loads

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

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

NetSuite replication

In this section:

Custom records
Deleted records
Supported NetSuite transaction types
Supported NetSuite item types
Unsupported NetSuite record types

Custom records

For each custom record type in NetSuite, a table for that custom record type will be available for selection in Stitch.

Table names for custom record types

Custom record tables are named custrecord_[custom_record_name], where [custom_record_name] is the value of the ID field in the Custom Record Setup page in NetSuite.

For example: If a custom record were named promo discount in NetSuite, the corresponding table for those records would be named custrecord_promo_discount.

If the ID field in the Custom Record Setup page is left blank, NetSuite will auto-assign a numerical ID to the record. In Stitch, the table for the custom record would then be something like custrecord_123, where 123 is the ID auto-assigned by NetSuite.

Replication methods for custom record types

Highlighted Show Last Modified field in NetSuite's Custom Record Type page

The Replication Method Stitch uses to replicate data for a custom record type depends on whether the Show Last Modified setting is checked in NetSuite for the custom record. This determines whether the NetSuite SuiteTalk API will return a timestamp column to use as a Replication Key.

If the record definition has the Show Last Modified setting enabled, Stitch will use Key-based Incremental Replication. This means that only new and updated records for the record type will be replicated during each job.
If the record definition doesn’t have this setting enabled, Stitch will use Full Table Replication. This means that all records for the record type will be replicated in full during each job.

To check the configuration of this setting for a custom record type in NetSuite:

Type page: record types into global search and click the Page: Record Types result.
Locate and click the custom record type in the list. This will open the Custom Record Type page.
Locate the Show Last Modified setting.

In the example to the right, both of these settings are enabled for the Stitch Example custom record type.

Deleted records

Accounting for deleted records is especially important if you’re performing any sort of aggregate function - for example, totaling invoices or balancing your books.

To account for deletes in NetSuite, Stitch’s NetSuite integration offers a table named Deleted. Once set to replicate, this table acts as a log for records deleted in NetSuite for supported record types.

In this section:

Identify deleted records in other tables
Record types with delete support

Identify deleted records in other tables

Note: The SQL queries in this section are only examples. As SQL syntax varies by database type, you may have to modify or rewrite these queries to allow them to run in your destination.

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 Transaction and Deleted tables:

SELECT * 
     FROM netsuite.Transaction tran 
LEFT JOIN netsuite.Deleted del
       ON tran.internalId = del.internalId 
      AND tran.type = 'invoice'
      AND del.type = 'invoice'

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

SELECT *
     FROM netsuite.Transaction 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.Transaction tran 
LEFT JOIN netsuite.Deleted del
       ON tran.internalId = del.internalId 
AND LOWER(tran.type) = LOWER(del.type) 
    WHERE del.deletedDate is null;

Refer to the Deleted table schema for more info about the available fields in the Deleted table.

Record types with delete support

According to NetSuite’s documentation, only certain record types support the getDeleted API operation Stitch uses to retrieve deleted record data from the SuiteTalk API.

In the table below are the record types that have delete support and the name of the Stitch table that contains the data for that record type. If a record type is listed, records of this type will be logged in the Deleted table when they are deleted in NetSuite.

Note: If a record type isn’t in this list, it doesn’t have delete support. Records not listed here will not be included in the Deleted table even if they are deleted in NetSuite.

NetSuite record type	Stitch table name
AdvInterCompanyJournalEntry	Transaction
AssemblyBuild	Transaction
AssemblyItem	Item
AssemblyUnbuild	Transaction
BillingSchedule	BillingSchedule
Bin	Bin
BinTransfer	Transaction
BinWorksheet	Transaction
Bom	Bom
BomRevision	BomRevision
CalendarEvent	CalendarEvent
Campaign	Campaign
CashRefund	Transaction
CashSale	Transaction
Charge	Charge
Check	Transaction
Contact	Contact
ContactCategory	ContactCategory
CostCategory	CostCategory
CouponCode	CouponCode
CreditMemo	Transaction
CurrencyRate	CurrencyRate
customRecord	customrecord_[custom_record_name]
CustomTransaction	Transaction
Customer	Customer
CustomerCategory	CustomerCategory
CustomerMessage	CustomerMessage
CustomerDeposit	Transaction
CustomerPayment	Transaction
CustomerRefund	Transaction
CustomerStatus	CustomerStatus
CustomerSubsidiaryRelationship	CustomerSubsidiaryRelationship
Deposit	Transaction
DepositApplication	Transaction
DescriptionItem	Item
DiscountItem	Item
DownloadItem	Item
Employee	Employee
Estimate	Transaction
ExpenseReport	Transaction
File	File
Folder	Folder
GiftCertificateItem	Item
GlobalAccountMapping	GlobalAccountMapping
InterCompanyJournalEntry	Transaction
InterCompanyTransferOrder	Transaction
InventoryAdjustment	Transaction
InventoryCostRevaluation	Transaction
InventoryItem	Item
InventoryNumber	InventoryNumber
InventoryTransfer	Transaction
Invoice	Transaction
Issue	Issue
ItemAccountMapping	ItemAccountMapping
ItemDemandPlan	ItemDemandPlan
ItemFulfillment	Transaction
ItemSupplyPlan	ItemSupplyPlan
ItemGroup	Item
ItemRevision	ItemRevision
Job	Job
JobStatus	JobStatus
JournalEntry	Transaction
KitItem	Item
LotNumberedAssemblyItem	Item
LotNumberedInventoryItem	Item
MarkupItem	Item
Message	Message
ManufacturingCostTemplate	ManufacturingCostTemplate
ManufacturingOperationTask	ManufacturingOperationTask
ManufacturingRouting	ManufacturingRouting
MerchandiseHierarchyNode	MerchandiseHierarchyNode
Nexus	Nexus
NonInventoryPurchaseItem	Item
NonInventoryResaleItem	Item
NonInventorySaleItem	Item
Note	Note
NoteType	NoteType
Opportunity	Opportunity
OtherChargePurchaseItem	Item
OtherChargeResaleItem	Item
OtherChargeSaleItem	Item
OtherNameCategory	OtherNameCategory
Partner	Partner
Paycheck	Transaction
PaymentItem	Item
PaymentMethod	PaymentMethod
PayrollItem	PayrollItem
PhoneCall	PhoneCall
PriceLevel	PriceLevel
PricingGroup	PricingGroup
ProjectTask	ProjectTask
PromotionCode	PromotionCode
PurchaseOrder	Transaction
ResourceAllocation	ResourceAllocation
ReturnAuthorization	Transaction
SalesOrder	Transaction
SalesTaxItem	Item
SerializedAssemblyItem	Item
SerializedInventoryItem	Item
ServicePurchaseItem	Item
ServiceResaleItem	Item
ServiceSaleItem	Item
StatisticalJournalEntry	Transaction
SubtotalItem	Item
SupportCase	SupportCase
Task	Task
Term	Term
TimeSheet	TimeSheet
TransferOrder	Transaction
Usage	Usage
Vendor	Vendor
VendorBill	Transaction
VendorCredit	Transaction
VendorPayment	Transaction
VendorReturnAuthorization	Transaction
VendorSubsidiaryRelationship	VendorSubsidiaryRelationship
WinLossReason	WinLossReason
WorkOrder	Transaction
WorkOrderIssue	Transaction
WorkOrderCompletion	Transaction
WorkOrderClose	Transaction

Supported NetSuite transaction types

Stitch supports replicating the transaction types listed below. Data for these records can be found in the Transaction table:

AssemblyBuild
AssemblyUnbuild
BinTransfer
BinWorksheet
CashRefund
CashSale
Check
CreditMemo
CustomerDeposit
CustomerPayment
CustomerRefund
Deposit
DepositApplication
Estimate
ExpenseReport
InventoryTransfer
InterCompanyJournalEntry
InventoryAdjustment
InventoryCostRevaluation
Invoice
ItemFulfillment
ItemReceipt
JournalEntry
PaycheckJournal
PurchaseOrder
ReturnAuthorization
SalesOrder
StatisticalJournalEntry
TransferOrder
VendorBill
VendorCredit
VendorPayment
VendorReturnAuthorization
WorkOrder
WorkOrderClose
WorkOrderCompletion
WorkOrderIssue

Supported NetSuite item types

Stitch supports replicating the item types listed below. Data for these records can be found in the Item table:

AssemblyItem
DescriptionItem
DiscountItem
DownloadItem
GiftCertificateItem
InventoryItem
ItemGroup
KitItem
LotNumberedAssemblyItem
LotNumberedInventoryItem
MarkupItem
NonInventoryPurchaseItem
NonInventoryResaleItem
NonInventorySaleItem
OtherChargePurchaseItem
OtherChargeResaleItem
OtherChargeSaleItem
PaymentItem
SerializedAssemblyItem
SerializedInventoryItem
ServicePurchaseItem
ServiceResaleItem
ServiceSaleItem
SubtotalItem

Unsupported NetSuite record types

Stitch supports replicating all record types from NetSuite’s 2017.2 WSDL, with the exception of the following:

AccountingTransaction
AssemblyItemBom
Entity
InventoryDetail
InventoryNumberbin
ItemBinNumber
MseSubsidary
OriginatingLead
Pricing
ProjectTaskAssignment
TaxDetail

NetSuite table reference

Schemas and versioning

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

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

To ensure we can provide you with up-to-date documentation, this section will only cover a few of the most popular tables Stitch’s NetSuite integration offers.

Refer to the NetSuite SuiteTalk Schema Browser for info on objects not listed here, including the fields available in each object.

Note: Stitch currently supports the replication of the majority of NetSuite objects, with the exception of those listed in the Unsupported Objects section.

Table and column names in your destination

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

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

Account

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

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

Account table replication requirements

Replicating this table requires the Accounts (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

Account table schema

description
STRING

acctNumber
STRING

department
VARIES

nullFieldList
VARIES

acctName
STRING

cashFlowRate
VARIES

parent
VARIES

includeChildren
BOOLEAN, STRING

eliminate
BOOLEAN, STRING

localizationsList
VARIES

unit
VARIES

exchangeRate
STRING

customFieldList
VARIES

isInactive
BOOLEAN, STRING

deferralAcct
VARIES

restrictToAccountingBookList
VARIES

acctType
VARIES

legalName
STRING

inventory
BOOLEAN, STRING

currency
VARIES

openingBalance
STRING, NUMBER

revalue
BOOLEAN, STRING

externalId
STRING

generalRate
VARIES

_class
VARIES

unitsType
VARIES

internalId
STRING

curDocNum
STRING, INTEGER

billableExpensesAcct
VARIES

subsidiaryList
VARIES

tranDate
STRING

location
VARIES

category1099Misc
VARIES

AccountingPeriod

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

The AccountingPeriod table contains info about the accounting periods in your NetSuite account.

AccountingPeriod table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

Accounting > Accounting Periods

You will also need the Setup > Manage Accounting Periods (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

AccountingPeriod table schema

allLocked
BOOLEAN, STRING

isQuarter
BOOLEAN, STRING

closed
BOOLEAN, STRING

nullFieldList
VARIES

parent
VARIES

allowNonGLChanges
BOOLEAN, STRING

startDate
STRING

payrollLocked
BOOLEAN, STRING

apLocked
BOOLEAN, STRING

endDate
STRING

fiscalCalendarsList
VARIES

isYear
BOOLEAN, STRING

isAdjust
BOOLEAN, STRING

internalId
STRING

arLocked
BOOLEAN, STRING

closedOnDate
STRING

fiscalCalendar
VARIES

periodName
STRING

Address

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

The Address table contains info about the custom address forms in your NetSuite account.

Custom address forms can apply to entity, transaction, subsidiary, company information, location, and workplace records in NetSuite. As custom address forms inherit the permissions set on the parent record, the permissions required for the parent record are required to access custom address data.

For example: To get custom address data for a location, the user must have the permission for accessing location data.

Address table schema

nullFieldList
VARIES

addr3
STRING

addr1
STRING

addrPhone
STRING

addressee
STRING

customFieldList
VARIES

city
STRING

state
STRING

addrText
STRING

zip
STRING

addr2
STRING

attention
STRING

internalId
STRING

override
BOOLEAN, STRING

country
VARIES

BillingAccount

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

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

BillingAccount table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

Accounting > Billing Accounts

You will also need the Lists > Customers (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

BillingAccount table schema

inactive
BOOLEAN, STRING

department
VARIES

billingSchedule
VARIES

nullFieldList
VARIES

cashSaleForm
VARIES

createdBy
STRING

name
STRING

customFieldList
VARIES

frequency
VARIES

startDate
STRING

idNumber
STRING

subsidiary
VARIES

customer
VARIES

currency
VARIES

invoiceForm
VARIES

customerDefault
BOOLEAN, STRING

nextBillCycleDate
STRING

externalId
STRING

customForm
VARIES

_class
VARIES

internalId
STRING

lastBillCycleDate
STRING

createdDate
STRING

location
VARIES

memo
STRING

lastBillDate
STRING

BillingSchedule

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

The BillingSchedule table contains info about the billing schedules in your NetSuite account. Billing schedules are used to define how bills for transactions are relayed to customers. In general, a billing schedule determines the frequency with which the customer is billed and the amount of each bill. However, the exact effect of a billing schedule varies depending on its type.

BillingSchedule table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

Accounting > Advanced Billing (Required for any billing schedule type)
Accounting > Project Management (Required for Charge-based, Fix-bid interval, Fixed-bid milestone, and Time and materials billing schedules)
Accounting > Charge-based Billing (Required for Charge-based billing schedules)

You will also need the Billing Schedules (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

BillingSchedule table schema

milestoneList
VARIES

nullFieldList
VARIES

monthDom
STRING, INTEGER

recurrencePattern
VARIES

recurrenceDowMaskList
VARIES

scheduleType
VARIES

yearDowimMonth
VARIES

name
STRING

yearDow
VARIES

yearDom
STRING, INTEGER

repeatEvery
VARIES

frequency
VARIES

monthMode
VARIES

billForActuals
BOOLEAN, STRING

yearMode
VARIES

isInactive
BOOLEAN, STRING

transaction
VARIES

recurrenceTerms
VARIES

isPublic
BOOLEAN, STRING

monthDowim
VARIES

yearMonth
VARIES

numberRemaining
STRING, INTEGER

project
VARIES

externalId
STRING

internalId
STRING

applyToSubtotal
BOOLEAN, STRING

recurrenceList
VARIES

dayPeriod
STRING, INTEGER

monthDow
VARIES

yearDowim
VARIES

initialTerms
VARIES

initialAmount
STRING

inArrears
BOOLEAN, STRING

seriesStartDate
STRING

Bin

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

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

Bin table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

Items & Inventory > Bin Management

You will also need the Lists > Bins (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

Bin table schema

internalId
STRING

externalId
STRING

binNumber
STRING

location
VARIES

memo
STRING

isInactive
BOOLEAN, STRING

customFieldList
VARIES

nullFieldList
VARIES

Bom

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

The Bom table contains info about bills of materials (BOM): the quantities of raw materials, assemblies, sub-components, and parts needed to manufacture a product.

Bom table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

Inventory & Items > Advanced Bill of Materials

You will also need the Lists > Bill of Materials (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

Bom table schema

legacyBomForAssembly
VARIES

restrictToLocationsList
VARIES

nullFieldList
VARIES

includeChildren
BOOLEAN, STRING

name
STRING

customFieldList
VARIES

isInactive
BOOLEAN, STRING

availableForAllLocations
BOOLEAN, STRING

externalId
STRING

customForm
VARIES

internalId
STRING

usedOnAssembly
BOOLEAN, STRING

restrictToAssembliesList
VARIES

createdDate
STRING

subsidiaryList
VARIES

useComponentYield
BOOLEAN, STRING

memo
STRING

availableForAllAssemblies
BOOLEAN, STRING

BomRevision

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

The BomRevision table contains info about updates on bills of materials.

BomRevision table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

Inventory & Items > Advanced Bill of Materials

BomRevision table schema

nullFieldList
VARIES

effectiveStartDate
STRING

name
STRING

customFieldList
VARIES

isInactive
BOOLEAN, STRING

componentList
VARIES

effectiveEndDate
STRING

externalId
STRING

customForm
VARIES

internalId
STRING

billOfMaterials
VARIES

createdDate
STRING

memo
STRING

Budget

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

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

Budget table replication requirements

Replicating this table requires the Lists > Set Up Budgets (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

Budget table schema

category
VARIES

amount
STRING, NUMBER

department
VARIES

periodAmount5
STRING, NUMBER

nullFieldList
VARIES

accountingBook
STRING, NUMBER

periodAmount14
STRING, NUMBER

periodAmount2
STRING, NUMBER

periodAmount6
STRING, NUMBER

periodAmount3
STRING, NUMBER

customFieldList
VARIES

periodAmount23
STRING, NUMBER

item
VARIES

periodAmount22
STRING, NUMBER

periodAmount16
STRING, NUMBER

periodAmount4
STRING, NUMBER

periodAmount9
STRING, NUMBER

subsidiary
VARIES

periodAmount10
STRING, NUMBER

periodAmount17
STRING, NUMBER

customer
VARIES

periodAmount18
STRING, NUMBER

account
VARIES

currency
VARIES

year
VARIES

periodAmount8
STRING, NUMBER

periodAmount12
STRING, NUMBER

periodAmount24
STRING, NUMBER

periodAmount13
STRING, NUMBER

_class
VARIES

internalId
STRING

periodAmount1
STRING, NUMBER

budgetType
VARIES

periodAmount19
STRING, NUMBER

periodAmount20
STRING, NUMBER

periodAmount7
STRING, NUMBER

location
VARIES

periodAmount15
STRING, NUMBER

periodAmount11
STRING, NUMBER

periodAmount21
STRING, NUMBER

CalendarEvent

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

The CalendarEvent table contains info about the scheduled activities, or events, that are on the calendar in your NetSuite account.

CalendarEvent table replication requirements

Replicating this table requires the Lists > Calendar (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

CalendarEvent table schema

accessLevel
VARIES

nullFieldList
VARIES

attendeeList
VARIES

reminderType
VARIES

recurrenceDowMaskList
VARIES

noEndDate
BOOLEAN, STRING

timeItemList
VARIES

endByDate
STRING

reminderMinutes
VARIES

sendEmail
BOOLEAN, STRING

customFieldList
VARIES

frequency
VARIES

startDate
STRING

resourceList
VARIES

transaction
VARIES

lastModifiedDate
STRING

exclusionDateList
VARIES

title
STRING

allDayEvent
BOOLEAN, STRING

endDate
STRING

externalId
STRING

status
VARIES

customForm
VARIES

recurrenceDowim
VARIES

internalId
STRING

recurrence
STRING

createdDate
STRING

period
STRING, INTEGER

supportCase
VARIES

location
STRING

contact
VARIES

company
VARIES

owner
VARIES

recurrenceDow
VARIES

organizer
VARIES

timedEvent
BOOLEAN, STRING

message
STRING

seriesStartDate
STRING

Campaign

Replication Method :	Key-based Incremental	Replication Key :
Primary Key :	internalId	Official docs :	Official Docs

The Campaign table contains info about the campaigns in your NetSuite account. Campaigns are used to manage marketing initiatives.

Campaign table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

CRM > Marketing Automation

You will also need the Lists > Marketing Campaigns (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

Campaign table schema

totalRevenue
STRING, NUMBER

leadsGenerated
STRING, INTEGER

category
VARIES

nullFieldList
VARIES

family
VARIES

costPerCustomer
STRING, NUMBER

offer
VARIES

expectedRevenue
STRING, NUMBER

campaignId
STRING

customFieldList
VARIES

profit
STRING, NUMBER

startDate
STRING

itemList
VARIES

vertical
VARIES

isInactive
BOOLEAN, STRING

title
STRING

promotionCode
VARIES

endDate
STRING

searchEngine
VARIES

externalId
STRING

keyword
STRING

customForm
VARIES

conversions
STRING, INTEGER

campaignEventList
VARIES

audience
VARIES

internalId
STRING

url
STRING

baseCost
STRING, NUMBER

campaignDirectMailList
VARIES

uniqueVisitors
STRING, INTEGER

cost
STRING, NUMBER

convCostPerCustomer
STRING, NUMBER

local
BOOLEAN, STRING

roi
STRING, NUMBER

owner
VARIES

eventResponseList
VARIES

campaignEmailList
VARIES

message
STRING

Charge

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

The Charge table contains info about the charges in your NetSuite account, which represent billable amounts that your clients must pay.

Charge table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

Transactions > Charge-Based Billing

You will also need the Transactions > Charge (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

Charge table schema

description
STRING

timeRecord
VARIES

amount
STRING, NUMBER

department
VARIES

nullFieldList
VARIES

stage
VARIES

billTo
VARIES

billingAccount
VARIES

chargeDate
STRING

use
VARIES

transactionLine
VARIES

rule
VARIES

billingItem
VARIES

transaction
VARIES

rate
STRING

chargeType
VARIES

subscriptionLine
VARIES

invoice
VARIES

currency
VARIES

invoiceLine
VARIES

runId
STRING

projectTask
VARIES

externalId
STRING

customForm
VARIES

_class
VARIES

internalId
STRING

salesOrderLine
VARIES

salesOrder
VARIES

createdDate
STRING

quantity
STRING, NUMBER

location
VARIES

Classification

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

The Classification table contains info about the classifications in your NetSuite account.

As classifications inherit the permissions set on the parent record, the permissions required for the parent record are required to access classification data.

For example: To get classification data for a location, the user must have the permission for accessing location data.

Classification table schema

nullFieldList
VARIES

parent
VARIES

includeChildren
BOOLEAN, STRING

name
STRING

customFieldList
VARIES

isInactive
BOOLEAN, STRING

classTranslationList
VARIES

externalId
STRING

internalId
STRING

subsidiaryList
VARIES

ConsolidatedExchangeRate

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

The ConsolidatedExchangeRate table contains info about consolidated exchange rates. This is used in NetSuite OneWorld for consolidation purposes, ensuring currency amounts correctly roll up from child to parent subsidiaries.

ConsolidatedExchangeRate table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

NetSuite OneWorld

You will also need the Lists > Currency (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

ConsolidatedExchangeRate table schema

nullFieldList
VARIES

accountingBook
STRING

postingPeriod
STRING

fromSubsidiary
STRING

isDerived
BOOLEAN, STRING

toCurrency
STRING

toSubsidiary
STRING

averageRate
STRING, NUMBER

isPeriodClosed
BOOLEAN, STRING

externalId
STRING

currentRate
STRING, NUMBER

internalId
STRING

fromCurrency
STRING

historicalRate
STRING, NUMBER

isEliminationSubsidiary
BOOLEAN, STRING

Contact

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

The Contact table contains info about contacts.

Contact table replication requirements

Replicating this table requires the Lists > Contacts (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

Contact table schema

middleName
STRING

fax
STRING

email
STRING

nullFieldList
VARIES

assistantPhone
STRING

addressbookList
VARIES

assistant
VARIES

defaultAddress
STRING

subscriptionsList
VARIES

phone
STRING

customFieldList
VARIES

comments
STRING

categoryList
VARIES

mobilePhone
STRING

firstName
STRING

salutation
STRING

isInactive
BOOLEAN, STRING

lastModifiedDate
STRING

subsidiary
VARIES

phoneticName
STRING

title
STRING

homePhone
STRING

supervisor
VARIES

externalId
STRING

customForm
VARIES

billPay
BOOLEAN, STRING

lastName
STRING

internalId
STRING

contactSource
VARIES

supervisorPhone
STRING

altEmail
STRING

image
VARIES

isPrivate
BOOLEAN, STRING

globalSubscriptionStatus
VARIES

officePhone
STRING

dateCreated
STRING

entityId
STRING

company
VARIES

ContactCategory

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

The ContactCategory table contains info about the types of contacts in your NetSuite account.

ContactCategory table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

CRM > Customer Relationship Management

You will also need the Setup > CRM Lists (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

ContactCategory table schema

internalId
STRING

externalId
STRING

name
STRING

_private
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

nullFieldList
VARIES

ContactRole

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

The ContactRole table contains info about contact roles in your NetSuite account.

ContactRole table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

CRM > Customer Relationship Management

You will also need the Setup > CRM Lists (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

ContactRole table schema

internalId
STRING

externalId
STRING

name
STRING

description
STRING

isInactive
BOOLEAN, STRING

nullFieldList
VARIES

CostCategory

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

The CostCategory table contains info about cost categories, which are used to classify different types of costs associated with items.

CostCategory table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

Items & Inventory > Standard Costing , or
Items & Inventory > Landed Cost

You will also need the Setup > Accounting Lists (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

CostCategory table schema

internalId
STRING

externalId
STRING

name
STRING

account
VARIES

itemCostType
VARIES

isInactive
BOOLEAN, STRING

nullFieldList
VARIES

CouponCode

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

The CouponCode table contains info about the coupon codes in your NetSuite account.

CouponCode table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

Transactions > Promotion Codes

You will also need the Lists > Promotion (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

CouponCode table schema

nullFieldList
VARIES

useCount
STRING, INTEGER

recipient
VARIES

externalId
STRING

dateSent
STRING

internalId
STRING

code
STRING

promotion
VARIES

used
BOOLEAN, STRING

CurrencyRate

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

The CurrencyRate table contains info about currency rate records in you NetSuite account. These are also known as Exchange Rate records in NetSuite.

CurrencyRate table replication requirements

Replicating this table requires the Lists > Currency (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

CurrencyRate table schema

internalId
STRING

baseCurrency
VARIES

transactionCurrency
VARIES

exchangeRate
STRING, NUMBER

effectiveDate
STRING

currencyRateType
STRING

nullFieldList
VARIES

Customer

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

The Customer table contains info about customers.

Customer table replication requirements

Replicating this table requires the Lists > Customers (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

Customer table schema

assignedWebSite
STRING

leadSource
VARIES

category
VARIES

contactRolesList
VARIES

shipComplete
BOOLEAN, STRING

middleName
STRING

faxTransactions
BOOLEAN, STRING

consolDepositBalance
STRING, NUMBER

emailPreference
VARIES

password2
STRING

consolBalance
STRING, NUMBER

negativeNumberFormat
VARIES

fax
STRING

consolAging3
STRING, NUMBER

email
STRING

reminderDays
STRING, INTEGER

consolUnbilledOrders
STRING, NUMBER

nullFieldList
VARIES

syncPartnerTeams
BOOLEAN, STRING

isPerson
BOOLEAN, STRING

drAccount
VARIES

depositBalance
STRING, NUMBER

visits
STRING, INTEGER

representingSubsidiary
VARIES

vatRegNumber
STRING

stage
VARIES

buyingReason
VARIES

overrideCurrencyFormat
BOOLEAN, STRING

aging
STRING, NUMBER

addressbookList
VARIES

accountNumber
STRING

defaultAddress
STRING

receivablesAccount
VARIES

salesRep
VARIES

parent
VARIES

currencyList
VARIES

subscriptionsList
VARIES

terms
VARIES

creditCardsList
VARIES

partner
VARIES

displaySymbol
STRING

password
STRING

phone
STRING

consolOverdueBalance
STRING, NUMBER

isBudgetApproved
BOOLEAN, STRING

altPhone
STRING

creditHoldOverride
VARIES

sendEmail
BOOLEAN, STRING

prefCCProcessor
VARIES

customFieldList
VARIES

comments
STRING

accessRole
VARIES

mobilePhone
STRING

groupPricingList
VARIES

startDate
STRING

resaleNumber
STRING

firstName
STRING

creditLimit
STRING, NUMBER

lastVisit
STRING

salutation
STRING

thirdPartyCarrier
STRING

isInactive
BOOLEAN, STRING

webLead
STRING

lastModifiedDate
STRING

partnersList
VARIES

consolAging
STRING, NUMBER

subsidiary
VARIES

taxRegistrationList
STRING

consolDaysOverdue
STRING, INTEGER

phoneticName
STRING

keywords
STRING

defaultTaxReg
STRING

title
STRING

requirePwdChange
BOOLEAN, STRING

monthlyClosing
VARIES

homePhone
STRING

numberFormat
VARIES

downloadList
VARIES

currency
VARIES

symbolPlacement
VARIES

aging1
STRING, NUMBER

consolAging4
STRING, NUMBER

itemPricingList
VARIES

referrer
STRING

endDate
STRING

balance
STRING, NUMBER

firstVisit
STRING

sourceWebSite
STRING

openingBalance
STRING, NUMBER

unbilledOrders
STRING, NUMBER

fxAccount
VARIES

daysOverdue
STRING, INTEGER

territory
VARIES

giveAccess
BOOLEAN, STRING

externalId
STRING

defaultOrderPriority
STRING, NUMBER

language
VARIES

salesGroup
VARIES

customForm
VARIES

billPay
BOOLEAN, STRING

lastName
STRING

alcoholRecipientType
VARIES

consolAging2
STRING, NUMBER

printOnCheckAs
STRING

thirdPartyAcct
STRING

internalId
STRING

url
STRING

salesTeamList
VARIES

salesReadiness
VARIES

emailTransactions
BOOLEAN, STRING

altName
STRING

aging4
STRING, NUMBER

overdueBalance
STRING, NUMBER

aging2
STRING, NUMBER

altEmail
STRING

image
VARIES

openingBalanceDate
STRING

priceLevel
VARIES

taxable
BOOLEAN, STRING

clickStream
STRING

lastPageVisited
STRING

campaignCategory
VARIES

globalSubscriptionStatus
VARIES

companyName
STRING

consolAging1
STRING, NUMBER

buyingTimeFrame
VARIES

printTransactions
BOOLEAN, STRING

dateCreated
STRING

contribPct
STRING

defaultAllocationStrategy
STRING

aging3
STRING, NUMBER

estimatedBudget
STRING, NUMBER

entityId
STRING

thirdPartyZipcode
STRING

taxExempt
BOOLEAN, STRING

entityStatus
VARIES

shippingItem
VARIES

openingBalanceAccount
VARIES

taxItem
VARIES

thirdPartyCountry
VARIES

CustomerCategory

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

The CustomerCategory table contains info about the types of customers in your NetSuite account.

CustomerCategory table replication requirements

Replicating this table requires the Setup > Accounting Lists (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

CustomerCategory table schema

internalId
STRING

externalId
STRING

name
STRING

isInactive
BOOLEAN, STRING

nullFieldList
VARIES

CustomerMessage

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

The CustomerMessage table contains info about standardized customer messages in your NetSuite account.

CustomerMessage table replication requirements

Replicating this table requires the Setup > Accounting Lists (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

CustomerMessage table schema

internalId
STRING

externalId
STRING

name
STRING

description
STRING

preferred
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

nullFieldList
VARIES

CustomerStatus

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

The CustomerStatus table contains info about the stages for leads, prospects, and customers in your NetSuite sales cycle.

CustomerStatus table replication requirements

Replicating this table requires the Setup > Customer Status (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

CustomerStatus table schema

description
STRING

nullFieldList
VARIES

stage
VARIES

name
STRING

isInactive
BOOLEAN, STRING

probability
STRING, NUMBER

externalId
STRING

internalId
STRING

includeInLeadReports
BOOLEAN, STRING

CustomerSubsidiaryRelationship

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

The CustomerSubsidiaryRelationship table contains info about customers shared with multiple subsidiaries.

CustomerSubsidiaryRelationship table replication requirements

Replicating this table requires that the following feature(s) be enabled in your NetSuite account:

Multi-Subsidiary Customer > Company

You will also need the Lists > Subsidiaries (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

CustomerSubsidiaryRelationship table schema

internalId
STRING

externalId
STRING

entity
VARIES

subsidiary
VARIES

isPrimarySub
BOOLEAN, STRING

primaryCurrency
VARIES

customFieldList
VARIES

nullFieldList
VARIES

CustomList

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

The CustomList table contains info about

CustomList table schema

description
STRING

nullFieldList
VARIES

name
STRING

customValueList
VARIES

isMatrixOption
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

scriptId
STRING

isOrdered
BOOLEAN, STRING

internalId
STRING

translationsList
VARIES

convertToCustomRecord
BOOLEAN, STRING

owner
VARIES

Deleted

Replication Method :	Key-based Incremental	Replication Key :	deletedDate
Primary Key :	internalId : type	API endpoint :	getDeleted

The Deleted table contains info about deleted records.

Deleted table replication requirements

Replicating this table requires the Setup > Deleted Records (Full) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

Objects with delete support

According to NetSuite’s documentation, only certain objects support the getDeleted operation Stitch uses to retrieve deleted record data from the SuiteTalk API.

Refer to the Deleted records section for more info and a list of record types with delete support.

Deleted table schema

deletedDate
STRING

name
STRING

internalId
STRING

externalId
STRING

type
STRING

scriptId
STRING

customRecord
BOOLEAN

Department

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

The Department table contains info about the departments in your NetSuite account.

Department table replication requirements

Replicating this table requires the Lists > Departments (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

Department table schema

nullFieldList
VARIES

parent
VARIES

includeChildren
BOOLEAN, STRING

name
STRING

customFieldList
VARIES

isInactive
BOOLEAN, STRING

classTranslationList
VARIES

externalId
STRING

internalId
STRING

subsidiaryList
VARIES

Employee

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

The Employee table contains info about the employees in your NetSuite account.

Employee table replication requirements

Replicating this table requires the Lists > Employees (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

Employee table schema

timeApprover
VARIES

rolesList
VARIES

companyContributionList
VARIES

middleName
STRING

password2
STRING

initials
STRING

department
VARIES

eligibleForCommission
BOOLEAN, STRING

fax
STRING

email
STRING

nullFieldList
VARIES

ratesList
VARIES

bonusTargetType
STRING

isJobResource
BOOLEAN, STRING

usePerquest
BOOLEAN, STRING

employeeStatus
VARIES

hrEducationList
VARIES

addressbookList
VARIES

accountNumber
STRING

defaultAddress
STRING

compensationCurrency
VARIES

subscriptionsList
VARIES

deductionList
VARIES

terminationDetails
STRING

nextReviewDate
STRING

password
STRING

phone
STRING

purchaseOrderLimit
STRING, NUMBER

purchaseOrderApprovalLimit
STRING, NUMBER

hcmPositionList
VARIES

approvalLimit
STRING, NUMBER

bonusTargetPayFrequency
STRING

isSalesRep
BOOLEAN, STRING

earningList
VARIES

commissionPaymentPreference
VARIES

terminationReason
VARIES

sendEmail
BOOLEAN, STRING

customFieldList
VARIES

comments
STRING

adpId
STRING

mobilePhone
STRING

birthDate
STRING

terminationRegretted
VARIES

concurrentWebServicesUser
BOOLEAN, STRING

firstName
STRING

salutation
STRING

releaseDate
STRING

isInactive
BOOLEAN, STRING

isSupportRep
BOOLEAN, STRING

ethnicity
VARIES

template
VARIES

lastModifiedDate
STRING

socialSecurityNumber
STRING

isJobManager
BOOLEAN, STRING

subsidiary
VARIES

bonusTargetComment
STRING

workAssignment
VARIES

bonusTarget
STRING, NUMBER

baseWageType
VARIES

phoneticName
STRING

title
STRING

requirePwdChange
BOOLEAN, STRING

directDeposit
BOOLEAN, STRING

useTimeData
VARIES

homePhone
STRING

supervisor
VARIES

approver
VARIES

currency
VARIES

targetUtilization
STRING, NUMBER

accruedTimeList
VARIES

billingClass
VARIES

purchaseOrderApprover
VARIES

giveAccess
BOOLEAN, STRING

baseWage
STRING, NUMBER

externalId
STRING

jobDescription
STRING

customForm
VARIES

billPay
BOOLEAN, STRING

lastName
STRING

_class
VARIES

internalId
STRING

lastReviewDate
STRING

altName
STRING

hireDate