NetSuite integration summary

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

NetSuite feature snapshot

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

STITCH
Release status

Released on May 8, 2019

Supported by

Stitch

Stitch plan

Standard

API availability

Available

Singer GitHub repository

Not applicable

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

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.

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

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

  1. Sign into your NetSuite account as an administrator.
  2. In your NetSuite account, click Setup > Company > Company Information.
  3. 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:

    The Company Information screen in NetSuite with the Allowed IP Addresses field populated with Stitch's North America IP addresses

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

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.

  1. Sign into your NetSuite account as an administrator, if you aren’t already signed in.
  2. Using the global search, type page: enable and click the Page: Enable Features result. For example:

    NetSuite global search field

  3. On the Enable Features page, click the SuiteCloud subtab.
  4. Locate the SuiteTalk (Web Services) section.
  5. 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.

  1. On the Enable Features page, locate the Manage Authentication section. This should be after the SuiteTalk section.
  2. Check the Token-based Authentication box. Your settings should look like this when finished:

    Highlighted Web Services and Token-based Authentication fields on the NetSuite Enable features page

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

  1. Using the global search, type page: integrations and click the Page: Manage Integrations result.
  2. On the Integrations page, click the New button.
  3. On the New Integration page, fill in the following fields:
    • Name: Enter a name for the integration. For example: Stitch
    • State: Select Enabled.
  4. In the Authentication tab, select the Token-based Authentication option.
  5. Click the Save button. The confirmation page will display a Consumer key/secret section.
  6. 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

  1. Using the global search, type page: new role and click the Page: New Role result.
  2. On the Role page, enter a name for the role in the Name field. For example: Stitch
  3. 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.

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 tab, click a subtab. For example: Transactions
  2. 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.
  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 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
Log in using Access Tokens Setup Full
Perform Search Lists View
User Access Tokens Setup Full
Web Services 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 Lists View
AccountingPeriod Manage Accounting Periods Setup View
Address [Parent Record Permission] Lists View
BillingAccount Customers Lists View
BillingSchedule Billing Schedules Lists View
Bin Bins 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
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
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
WinLossReason Opportunity Transactions View
customrecord_[custom_record_name] Custom Record Types Setup 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

The Name, Email, Access tab, Password, and Role tabs highlighted in the NetSuite

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

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

Step 6: Create access tokens for Stitch

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

  1. Using the global search, type page: tokens and click the Page: Access Tokens result.
  2. Click the New Access Token button.
  3. 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
  4. Click the Save button. The confirmation page will display a Token ID and Secret.
  5. 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

  1. Using the global search, type page: web services and click the Page: Web Services Preferences result.
  2. 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

  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. In the Account field, enter the NetSuite account ID you retrieved in Step 7.
  6. In the Consumer Key field, paste the Consumer Key you generated when you created Stitch’s integration record.
  7. In the Token ID field, paste the Token ID you generated when you created Stitch’s access tokens.
  8. In the Consumer Secret field, paste the Consumer Secret you generated when you created Stitch’s integration record.
  9. 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

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:

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

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:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

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

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

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

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

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

  5. Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

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

In this section:

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:

  1. Type page: record types into global search and click the Page: Record Types result.
  2. Locate and click the custom record type in the list. This will open the Custom Record Type page.
  3. 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

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

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.


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 Lists > Accounts (View) permission in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

internalId
STRING

The account ID.

_class
VARIES

acctName
STRING

The account name as it displays on reports.

acctNumber
STRING

The account number.

acctType
VARIES

The account type. According to NetSuite’s 2018.1 Schema Browser, account type codes are:

  • 0 - Bank
  • 1 - Accts Receivable
  • 2 - Inventory
  • 4 - Other Curr Assets
  • 5 - Fixed Assets
  • 6 - Accum Deprec.
  • 8 - Other Assets
  • 10 - Accts Payable
  • 12 - Oth Curr Liab.
  • 14 - Long Term Liab.
  • 16 - Equity-No Close
  • 18 - Retained Earn
  • 19 - Equity-Closes
  • 21 - Income
  • 23 - COGS
  • 24 - Expense
  • 25 - Other Income
  • 26 - Other Expense

billableExpensesAcct
VARIES

cashFlowRate
VARIES

The type of exchange rate used to translate foreign currency amounts for this account in the cash flow statement.

category1099Misc
VARIES

curDocNum
INTEGER, STRING

The next check number in the sequence for the account.

currency
VARIES

The currency for funds in the account.

customFieldList
VARIES

The custom fields associated with the account.

deferralAcct
VARIES

department
VARIES

The department with access to the account.

description
STRING

The account description.

eliminate
BOOLEAN, STRING

Indicates whether the account is an intercompany account.

exchangeRate
STRING

The exchange rate for the account’s currency.

externalId
STRING

generalRate
VARIES

Possible values are:

  • `_average’
  • _current
  • _historical

includeChildren
BOOLEAN, STRING

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

inventory
BOOLEAN, STRING

Indicates if the account balance is included in the Inventory KPI.

isInactive
BOOLEAN, STRING

Indicates if the account is inactive.

legalName
STRING

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

localizationsList
VARIES

location
VARIES

The location with access to the account.

nullFieldList
VARIES

openingBalance
NUMBER, STRING

The opening balance for the account.

parent
VARIES

The parent account.

restrictToAccountingBookList
VARIES

revalue
BOOLEAN, STRING

Indicates if the account is selected for open balance currency revaluation.

subsidiaryList
VARIES

tranDate
DATE-TIME

unit
VARIES

The base unit assigned to unitsType. Applicable only when accType is _statistical.

unitsType
VARIES

The type of unit associated with the statistical account. Applicable only when accType is _statistical.


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.

internalId
STRING

allLocked
BOOLEAN, STRING

allowNonGLChanges
BOOLEAN, STRING

apLocked
BOOLEAN, STRING

arLocked
BOOLEAN, STRING

closed
BOOLEAN, STRING

closedOnDate
DATE-TIME

endDate
DATE-TIME

fiscalCalendar
VARIES

fiscalCalendarsList
VARIES

isAdjust
BOOLEAN, STRING

isQuarter
BOOLEAN, STRING

isYear
BOOLEAN, STRING

nullFieldList
VARIES

parent
VARIES

payrollLocked
BOOLEAN, STRING

periodName
STRING

startDate
DATE-TIME


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.

internalId
STRING

addr1
STRING

addr2
STRING

addr3
STRING

addrPhone
STRING

addrText
STRING

addressee
STRING

attention
STRING

city
STRING

country
VARIES

customFieldList
VARIES

nullFieldList
VARIES

override
BOOLEAN, STRING

state
STRING

zip
STRING


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.

internalId
STRING

_class
VARIES

billingSchedule
VARIES

cashSaleForm
VARIES

createdBy
STRING

createdDate
DATE-TIME

currency
VARIES

customFieldList
VARIES

customForm
VARIES

customer
VARIES

customerDefault
BOOLEAN, STRING

department
VARIES

externalId
STRING

frequency
VARIES

idNumber
STRING

inactive
BOOLEAN, STRING

invoiceForm
VARIES

lastBillCycleDate
DATE-TIME

lastBillDate
DATE-TIME

location
VARIES

memo
STRING

name
STRING

nextBillCycleDate
DATE-TIME

nullFieldList
VARIES

startDate
DATE-TIME

subsidiary
VARIES


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

internalId
STRING

applyToSubtotal
BOOLEAN, STRING

billForActuals
BOOLEAN, STRING

dayPeriod
INTEGER, STRING

externalId
STRING

frequency
VARIES

inArrears
BOOLEAN, STRING

initialAmount
STRING

initialTerms
VARIES

isInactive
BOOLEAN, STRING

isPublic
BOOLEAN, STRING

milestoneList
VARIES

monthDom
INTEGER, STRING

monthDow
VARIES

monthDowim
VARIES

monthMode
VARIES

name
STRING

nullFieldList
VARIES

numberRemaining
INTEGER, STRING

project
VARIES

recurrenceDowMaskList
VARIES

recurrenceList
VARIES

recurrencePattern
VARIES

recurrenceTerms
VARIES

repeatEvery
VARIES

scheduleType
VARIES

seriesStartDate
DATE-TIME

transaction
VARIES

yearDom
INTEGER, STRING

yearDow
VARIES

yearDowim
VARIES

yearDowimMonth
VARIES

yearMode
VARIES

yearMonth
VARIES


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.

internalId
STRING

binNumber
STRING

customFieldList
VARIES

externalId
STRING

isInactive
BOOLEAN, STRING

location
VARIES

memo
STRING

nullFieldList
VARIES


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.

internalId
STRING

_class
VARIES

account
VARIES

amount
NUMBER, STRING

budgetType
VARIES

category
VARIES

currency
VARIES

customFieldList
VARIES

customer
VARIES

department
VARIES

item
VARIES

location
VARIES

nullFieldList
VARIES

periodAmount1
NUMBER, STRING

periodAmount10
NUMBER, STRING

periodAmount11
NUMBER, STRING

periodAmount12
NUMBER, STRING

periodAmount13
NUMBER, STRING

periodAmount14
NUMBER, STRING

periodAmount15
NUMBER, STRING

periodAmount16
NUMBER, STRING

periodAmount17
NUMBER, STRING

periodAmount18
NUMBER, STRING

periodAmount19
NUMBER, STRING

periodAmount2
NUMBER, STRING

periodAmount20
NUMBER, STRING

periodAmount21
NUMBER, STRING

periodAmount22
NUMBER, STRING

periodAmount23
NUMBER, STRING

periodAmount24
NUMBER, STRING

periodAmount3
NUMBER, STRING

periodAmount4
NUMBER, STRING

periodAmount5
NUMBER, STRING

periodAmount6
NUMBER, STRING

periodAmount7
NUMBER, STRING

periodAmount8
NUMBER, STRING

periodAmount9
NUMBER, STRING

subsidiary
VARIES

year
VARIES


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.

internalId
STRING

lastModifiedDate
DATE-TIME

accessLevel
VARIES

allDayEvent
BOOLEAN, STRING

attendeeList
VARIES

company
VARIES

contact
VARIES

createdDate
DATE-TIME

customFieldList
VARIES

customForm
VARIES

endByDate
DATE-TIME

endDate
DATE-TIME

exclusionDateList
VARIES

externalId
STRING

frequency
VARIES

location
STRING

message
STRING

noEndDate
BOOLEAN, STRING

nullFieldList
VARIES

organizer
VARIES

owner
VARIES

period
INTEGER, STRING

recurrence
STRING

recurrenceDow
VARIES

recurrenceDowMaskList
VARIES

recurrenceDowim
VARIES

reminderMinutes
VARIES

reminderType
VARIES

resourceList
VARIES

sendEmail
BOOLEAN, STRING

seriesStartDate
DATE-TIME

startDate
DATE-TIME

status
VARIES

supportCase
VARIES

timeItemList
VARIES

timedEvent
BOOLEAN, STRING

title
STRING

transaction
VARIES


Campaign

Replication Method :

Full Table

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.

internalId
STRING

audience
VARIES

baseCost
NUMBER, STRING

campaignDirectMailList
VARIES

campaignEmailList
VARIES

campaignEventList
VARIES

campaignId
STRING

category
VARIES

convCostPerCustomer
NUMBER, STRING

conversions
INTEGER, STRING

cost
NUMBER, STRING

costPerCustomer
NUMBER, STRING

customFieldList
VARIES

customForm
VARIES

endDate
DATE-TIME

eventResponseList
VARIES

expectedRevenue
NUMBER, STRING

externalId
STRING

family
VARIES

isInactive
BOOLEAN, STRING

itemList
VARIES

keyword
STRING

leadsGenerated
INTEGER, STRING

local
BOOLEAN, STRING

message
STRING

nullFieldList
VARIES

offer
VARIES

owner
VARIES

profit
NUMBER, STRING

promotionCode
VARIES

roi
NUMBER, STRING

searchEngine
VARIES

startDate
DATE-TIME

title
STRING

totalRevenue
NUMBER, STRING

uniqueVisitors
INTEGER, STRING

url
STRING

vertical
VARIES


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.

internalId
STRING

_class
VARIES

amount
NUMBER, STRING

billTo
VARIES

billingAccount
VARIES

billingItem
VARIES

chargeDate
DATE-TIME

chargeType
VARIES

createdDate
DATE-TIME

currency
VARIES

customForm
VARIES

department
VARIES

description
STRING

externalId
STRING

invoice
VARIES

invoiceLine
VARIES

location
VARIES

nullFieldList
VARIES

projectTask
VARIES

quantity
NUMBER, STRING

rate
STRING

rule
VARIES

runId
STRING

salesOrder
VARIES

salesOrderLine
VARIES

stage
VARIES

subscriptionLine
VARIES

timeRecord
VARIES

transaction
VARIES

transactionLine
VARIES

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

internalId
STRING

classTranslationList
VARIES

customFieldList
VARIES

externalId
STRING

includeChildren
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

parent
VARIES

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.

internalId
STRING

accountingBook
STRING

averageRate
NUMBER, STRING

currentRate
NUMBER, STRING

externalId
STRING

fromCurrency
STRING

fromSubsidiary
STRING

historicalRate
NUMBER, STRING

isDerived
BOOLEAN, STRING

isEliminationSubsidiary
BOOLEAN, STRING

isPeriodClosed
BOOLEAN, STRING

nullFieldList
VARIES

postingPeriod
STRING

toCurrency
STRING

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

internalId
STRING

The contact ID.

lastModifiedDate
DATE-TIME

The time the contact was last modified.

addressbookList
VARIES

altEmail
STRING

The alternate email address for the contact.

assistant
VARIES

A reference to an existing contact.

assistantPhone
STRING

billPay
BOOLEAN, STRING

Indicates whether payments can be sent online to the contact.

categoryList
VARIES

comments
STRING

Additional comments about the contact.

company
VARIES

The company the contact works for.

contactSource
VARIES

Indicates how the contact came to do business with your company.

customFieldList
VARIES

The custom fields associated with the contact.

customForm
VARIES

dateCreated
DATE-TIME

The date the contact was created.

defaultAddress
STRING

The default billing address for the contact.

email
STRING

The contact’s email address.

entityId
STRING

The name for the contact in lists.

externalId
STRING

fax
STRING

The contact’s fax number.

firstName
STRING

The contact’s first name.

globalSubscriptionStatus
VARIES

The contact’s subscription status. Possible values are:

  • Confirmed Opt-In
  • Soft Opt-In
  • Soft Opt-Out
  • Confirmed Opt-Out

homePhone
STRING

The customer’s home phone number.

image
VARIES

A reference to a file in the file cabinet for the contact.

isInactive
BOOLEAN, STRING

Indicates if the contact is inactive.

isPrivate
BOOLEAN, STRING

Indicates if the contact is private. When a contact is private, it can only be viewed by th e user that entered the contact record.

lastName
STRING

The contact’s last name.

middleName
STRING

The contact’s middle name.

mobilePhone
STRING

The contact’s mobile phone number.

nullFieldList
VARIES

officePhone
STRING

The contact’s office phone number.

phone
STRING

The contact’s phone number.

phoneticName
STRING

The furigana character used to sort the contact record in NetSuite.

salutation
STRING

The contact’s salutation.

subscriptionsList
VARIES

subsidiary
VARIES

supervisor
VARIES

The contact’s supervisor.

supervisorPhone
STRING

The contact supervisor’s phone number.

title
STRING

The contact’s title at their company.


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.

internalId
STRING

_private
BOOLEAN, STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

sync
BOOLEAN, STRING


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.

internalId
STRING

description
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

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

internalId
STRING

account
VARIES

externalId
STRING

isInactive
BOOLEAN, STRING

itemCostType
VARIES

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

internalId
STRING

code
STRING

dateSent
DATE-TIME

externalId
STRING

nullFieldList
VARIES

promotion
VARIES

recipient
VARIES

useCount
INTEGER, STRING

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.

internalId
STRING

baseCurrency
VARIES

effectiveDate
DATE-TIME

exchangeRate
NUMBER, STRING

nullFieldList
VARIES

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

internalId
STRING

lastModifiedDate
DATE-TIME

The time the customer was last updated.

accessRole
VARIES

The role assigned to the customer.

accountNumber
STRING

The number of the account assigned for the customer.

addressbookList
VARIES

aging
NUMBER, STRING

The overdue Accounts Receivable balance for the customer.

aging1
NUMBER, STRING

The overdue Accounts Receivable balance for the customer.

aging2
NUMBER, STRING

The overdue Accounts Receivable balance for the customer.

aging3
NUMBER, STRING

The overdue Accounts Receivable balance for the customer.

aging4
NUMBER, STRING

The overdue Accounts Receivable balance for the customer.

alcoholRecipientType
VARIES

The customer’s default intended recipient type. This info is included for FedEx shipments containing alcohol.

altEmail
STRING

The alternate email for the customer.

altName
STRING

The name of the person or company.

altPhone
STRING

The customer’s alternate phone number.

balance
NUMBER, STRING

The customer’s currency Accounts Receivable balance.

billPay
BOOLEAN, STRING

Indicates if the customer has online bill pay enabled.

buyingReason
VARIES

The customer’s reason for buying from your company.

buyingTimeFrame
VARIES

The timeframe for the customer to purchase from your company.

campaignCategory
VARIES

The campaign category associated with the customer.

category
VARIES

The category associated with the customer.

clickStream
STRING

The click stream for the customer on first visit.

comments
STRING

Additional comments about the customer.

companyName
STRING

The name of the customer’s company.

consolAging
NUMBER, STRING

The overdue consolidated Accounts Receivable balance for the customer. These totals include the balance from all the customers and subcustomers in this hierarchy.

consolAging1
NUMBER, STRING

The overdue consolidated Accounts Receivable balance for the customer. These totals include the balance from all the customers and subcustomers in this hierarchy.

consolAging2
NUMBER, STRING

The overdue consolidated Accounts Receivable balance for the customer. These totals include the balance from all the customers and subcustomers in this hierarchy.

consolAging3
NUMBER, STRING

The overdue consolidated Accounts Receivable balance for the customer. These totals include the balance from all the customers and subcustomers in this hierarchy.

consolAging4
NUMBER, STRING

The overdue consolidated Accounts Receivable balance for the customer. These totals include the balance from all the customers and subcustomers in this hierarchy.

consolBalance
NUMBER, STRING

The current Accounts Receivable balance due for the customer-subcustomer hierarchy this customer is a member of.

consolDaysOverdue
INTEGER, STRING

The number of days the consolOverdueBalance is overdue.

consolDepositBalance
NUMBER, STRING

The total amount of unapplied deposits for the customer-subcustomer hierarchy the customer is a member of.

consolOverdueBalance
NUMBER, STRING

The consolidated total owed for open transactions for the customer-subcustomer hierarchy that are past their due date. Note: According to NetSuite’s documentation, for open transactions that don’t have a due date, the transaction date is used as the due date to calculate this value.

consolUnbilledOrders
NUMBER, STRING

The total amount of orders that have been entered but not yet billed for the customer-subcustomer hierarchy this customer is a member of.

contactRolesList
VARIES

contribPct
STRING

creditCardsList
VARIES

creditHoldOverride
VARIES

Possible values include:

  • _auto
  • _on
  • _off

creditLimit
NUMBER, STRING

The credit limit for the customer.

currency
VARIES

The currency used by the customer.

currencyList
VARIES

customFieldList
VARIES

The custom fields associated with the customer.

customForm
VARIES

dateCreated
DATE-TIME

The date the customer was created.

daysOverdue
INTEGER, STRING

defaultAddress
STRING

The customer’s default billing address.

defaultOrderPriority
NUMBER, STRING

The default order priority for the customer.

depositBalance
NUMBER, STRING

The deposit balance for the customer.

displaySymbol
STRING

The currency symbol and text to use for the customer’s currency.

downloadList
VARIES

drAccount
VARIES

The deferred revenue account to use by default to post revenue reclassification amounts generated by revenue reclassification journal entries for the customer.

email
STRING

The customer’s email address.

emailPreference
VARIES

The customer’s email preference. For example: _PDF, _HTML

emailTransactions
BOOLEAN, STRING

The preferred transaction delivery method for the customer. Possible values are:

  • Email
  • Print
  • Fax

endDate
DATE-TIME

The projected end date for the customer.

entityId
STRING

The name of the customer record.

entityStatus
VARIES

estimatedBudget
NUMBER, STRING

The estimated budget for the customer.

externalId
STRING

fax
STRING

The customer’s fax number.

faxTransactions
BOOLEAN, STRING

firstName
STRING

The customer’s first name.

firstVisit
DATE-TIME

The date of the customer’s first visit.

fxAccount
VARIES

The revenue account to use by default to post foreign currency adjustments that result when exchange rates are different for billilng and revenue postings for the customer. This will be an Income account.

giveAccess
BOOLEAN, STRING

Indicates if the customer has login access to your NetSuite account.

globalSubscriptionStatus
VARIES

The customer’s subscription status. Possible values include:

  • Confirmed Opt-In
  • Soft Opt-In
  • Soft Opt-Out
  • Confirmed Opt-Out

groupPricingList
VARIES

homePhone
STRING

The customer’s home phone number.

image
VARIES

A reference to a file in the file cabinet for the customer.

isBudgetApproved
BOOLEAN, STRING

Indicates if the customer’s budget has been approved.

isInactive
BOOLEAN, STRING

Indicates if the customer is inactive.

isPerson
BOOLEAN, STRING

Indicates if the customer is a person, versus a company.

itemPricingList
VARIES

keywords
STRING

The keywords the customer used in the search engine for their first visit.

language
VARIES

The language used by the customer.

lastName
STRING

The customer’s last name.

lastPageVisited
STRING

The last page the customer visited on their most recent visit to your web site.

lastVisit
DATE-TIME

The date the customer last visited your web site.

leadSource
VARIES

Indicates how the customer was referred to your company.

middleName
STRING

The customer’s middle name.

mobilePhone
STRING

The customer’s mobile phone number.

monthlyClosing
VARIES

negativeNumberFormat
VARIES

The customer’s negative number format preference, if any. This indicates whether negative numbers should be preceeded by a minus sign (-) or enclosed in parenthesis ( ).

nullFieldList
VARIES

numberFormat
VARIES

The customer’s positive number format preference. In NetSuite, this setting controls how the thousands separator and decimals display for the customer.

openingBalance
NUMBER, STRING

The opening balance for the customer’s account.

openingBalanceAccount
VARIES

The account the opening balance was applied to.

openingBalanceDate
DATE-TIME

The date of the balance entered in the Opening Balance field.

overdueBalance
NUMBER, STRING

The overdue balance for the customer.

overrideCurrencyFormat
BOOLEAN, STRING

Indicates if the currency format has been customized for the customer.

parent
VARIES

If the customer is a subcustomer or a smaller entity of another customer, this will be the parent customer.

partner
VARIES

The partner associated with the customer.

partnersList
VARIES

password
STRING

The password assigned to allow the customer to access NetSuite.

password2
STRING

The password confirmation field value for the customer.

phone
STRING

The customer’s phone number.

phoneticName
STRING

The furigana character used to sort the customer record in NetSuite.

prefCCProcessor
VARIES

The customer’s preferred credit card processor.

priceLevel
VARIES

The price level used for selling to the customer.

printOnCheckAs
STRING

The value that prints on the Pay to the Order Of line of checks sent to the customer.

printTransactions
BOOLEAN, STRING

receivablesAccount
VARIES

The Default Account Receivables Account to use for the customer.

referrer
STRING

The site that referred the customer to your NetSuite website on their first visit.

reminderDays
INTEGER, STRING

The number of days before the end date that a reminder should be sent for renewing the customer’s contract or project.

representingSubsidiary
VARIES

Indicates if the customer is an intercompany customer.

requirePwdChange
BOOLEAN, STRING

Indicates if a password change will be required on the next NetSuite login for the customer.

resaleNumber
STRING

The customer’s tax license number. This is used in cases where sales tax is not collected from the customer.

salesGroup
VARIES

The sales team group associated with the customer when team sellilng is enabled in NetSuite.

salesReadiness
VARIES

Indicates how close the customer is to purchasing.

salesRep
VARIES

The sales rep associated with the customer.

salesTeamList
VARIES

salutation
STRING

The salutation for the customer.

sendEmail
BOOLEAN, STRING

Indicates if the customer is automatically sent an email notification when access to NetSuite is provided.

shipComplete
BOOLEAN, STRING

Indicates if orders should only be shipped to the customer when they’re totally fulfilled.

shippingItem
VARIES

The default shipping method for the customer.

stage
VARIES

startDate
DATE-TIME

The date the person/company became a customer, lead, or prospect. If the customer has a contract, this may be the start date of the contract. If an estimate or opportunity is entered for the customer, NetSuite may update this value with the date of that transaction.

subscriptionsList
VARIES

subsidiary
VARIES

The subsidiary associated with the customer.

symbolPlacement
VARIES

Indicates whether symbols are placed before or after numbers for the customer.

syncPartnerTeams
BOOLEAN, STRING

Indicates whether changes made to the partner team will update the customer’s transactions.

taxExempt
BOOLEAN, STRING

Indicates if the customer is tax exempt.

taxItem
VARIES

The standard tax rate for the customer.

taxable
BOOLEAN, STRING

Indicates if the customer pays sales tax according to the taxItem rate.

terms
VARIES

The terms for the customer.

territory
VARIES

The sales territory the customer is in.

thirdPartyAcct
STRING

The customer’s FedEx or UPS account number.

thirdPartyCountry
VARIES

The country associated with the customer’s FedEx or UPS account.

thirdPartyZipcode
STRING

The zip code associated with the customer’s FedEx or UPS account.

title
STRING

The job title for the customer at companyName.

unbilledOrders
NUMBER, STRING

The total amount of orders that have been entered into NetSuite but not yet billed.

url
STRING

The URL associated with the customer.

vatRegNumber
STRING

For the UK edition of NetSuite. The customer’s VAT registration number.

visits
INTEGER, STRING

The total number of visits the customer has made to your website. A new visit is counted after the customer leaves the site and returns.

webLead
STRING

Indicates whether the customer registered via a NetSuite website. Possible values are Yes or No.


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.

internalId
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

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

internalId
STRING

description
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

preferred
BOOLEAN, STRING


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.

internalId
STRING

description
STRING

externalId
STRING

includeInLeadReports
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

probability
NUMBER, STRING

stage
VARIES


CustomList

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The CustomList table contains info about

internalId
STRING

convertToCustomRecord
BOOLEAN, STRING

customValueList
VARIES

description
STRING

isInactive
BOOLEAN, STRING

isMatrixOption
BOOLEAN, STRING

isOrdered
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

owner
VARIES

scriptId
STRING

translationsList
VARIES


customrecord_[custom_record_name]

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

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

Custom record tables are named customrecord_[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 customrecord_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 customrecord_123, where 123 is the ID auto-assigned by NetSuite.

Note: The Replication Method Stitch uses to replicate custom record types depends on how custom records are configured in NetSuite. Refer to the Custom records section for more info.

internalId
INTEGER

The unique ID for the record.

lastModifiedDate
DATE-TIME

The time the record was last updated.

Note: This field will only contain values if the custom record type has Show Last Modified enabled in NetSuite. Refer to the Custom records section for more info.

Fields selected by you

Custom record tables will contain the same attributes of the custom record type in NetSuite. The table schema for custom record types will vary depending on the attributes you set to replicate in Stitch.


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.

internalId
STRING

The record’s ID.

type
STRING

The value of this column will vary depending on the record type:

  • Custom records - This field will contain a numerical ID pertaining to the record.
  • Standard records - This field will contain the type of record that was deleted. For example: Invoice. Refer to the Record types with delete support section for a list of possible record types.

deletedDate
DATE-TIME

The time the record was deleted.

customRecord
BOOLEAN

If true, the record that was deleted was a custom record. If false, the record that was deleted was a standard record.

externalId
STRING

The record’s external ID, if available.

name
STRING

The value of this column will vary depending on the record type:

  • Custom records - This field will contain the record’s internalId.
  • Standard records - This field will contain the name of the record that was deleted. For example: Invoice #INV197.

scriptId
STRING

The script ID identifying the specific custom record or custom transaction type.


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.

internalId
STRING

classTranslationList
VARIES

customFieldList
VARIES

externalId
STRING

includeChildren
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

parent
VARIES

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.

internalId
STRING

lastModifiedDate
DATE-TIME

IPAddressRule
STRING

_class
VARIES

accountNumber
STRING

accruedTimeList
VARIES

addressbookList
VARIES

adpId
STRING

altName
STRING

approvalLimit
NUMBER, STRING

approver
VARIES

baseWage
NUMBER, STRING

baseWageType
VARIES

billPay
BOOLEAN, STRING

billingClass
VARIES

birthDate
DATE-TIME

comments
STRING

commissionPaymentPreference
VARIES

companyContributionList
VARIES

compensationCurrency
VARIES

concurrentWebServicesUser
BOOLEAN, STRING

currency
VARIES

customFieldList
VARIES

customForm
VARIES

dateCreated
DATE-TIME

deductionList
VARIES

defaultAddress
STRING

department
VARIES

directDeposit
BOOLEAN, STRING

directDepositList
VARIES

earningList
VARIES

eligibleForCommission
BOOLEAN, STRING

email
STRING

emergencyContactList
VARIES

employeeStatus
VARIES

employeeType
VARIES

entityId
STRING

ethnicity
VARIES

expenseLimit
NUMBER, STRING

externalId
STRING

fax
STRING

firstName
STRING

gender
VARIES

giveAccess
BOOLEAN, STRING

globalSubscriptionStatus
VARIES

hasOfflineAccess
BOOLEAN, STRING

hcmPositionList
VARIES

hireDate
DATE-TIME

homePhone
STRING

hrEducationList
VARIES

image
VARIES

inheritIPRules
BOOLEAN, STRING

initials
STRING

isInactive
BOOLEAN, STRING

isJobResource
BOOLEAN, STRING

isSalesRep
BOOLEAN, STRING

isSupportRep
BOOLEAN, STRING

job
VARIES

jobDescription
STRING

laborCost
NUMBER, STRING

lastName
STRING

lastPaidDate
DATE-TIME

lastReviewDate
DATE-TIME

location
VARIES

maritalStatus
VARIES

middleName
STRING

mobilePhone
STRING

nextReviewDate
DATE-TIME

nullFieldList
VARIES

officePhone
STRING

password
STRING

password2
STRING

payFrequency
VARIES

phone
STRING

phoneticName
STRING

purchaseOrderApprovalLimit
NUMBER, STRING

purchaseOrderApprover
VARIES

purchaseOrderLimit
NUMBER, STRING

ratesList
VARIES

releaseDate
DATE-TIME

requirePwdChange
BOOLEAN, STRING

rolesList
VARIES

salesRole
VARIES

salutation
STRING

sendEmail
BOOLEAN, STRING

socialSecurityNumber
STRING

startDateTimeOffCalc
DATE-TIME

subscriptionsList
VARIES

subsidiary
VARIES

supervisor
VARIES

template
VARIES

terminationCategory
VARIES

terminationDetails
STRING

terminationReason
VARIES

terminationRegretted
VARIES

timeApprover
VARIES

timeOffPlan
VARIES

title
STRING

usePerquest
BOOLEAN, STRING

useTimeData
VARIES

workAssignment
VARIES

workCalendar
VARIES

workplace
VARIES


EntityGroup

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The EntityGroup table contains info about the groups in your NetSuite account.

EntityGroup table replication requirements

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

internalId
STRING

comments
STRING

customFieldList
VARIES

email
STRING

externalId
STRING

groupName
STRING

groupOwner
VARIES

groupType
VARIES

isFunctionalTeam
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

isManufacturingWorkCenter
BOOLEAN, STRING

isPrivate
BOOLEAN, STRING

isProductTeam
BOOLEAN, STRING

isSalesRep
BOOLEAN, STRING

isSalesTeam
BOOLEAN, STRING

isSavedSearch
BOOLEAN, STRING

isSupportRep
BOOLEAN, STRING

issueRole
VARIES

laborResources
INTEGER, STRING

machineResources
INTEGER, STRING

nullFieldList
VARIES

parentGroupType
VARIES

restrictionGroup
VARIES