NetSuite (v1.0) | 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 (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.0) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release Status	Released	Supported By	Stitch
Stitch Plan	Paid
DATA SELECTION
Table Selection	Supported	Column Selection	Supported
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Unsupported
Table-level Reset	Unsupported	Configurable Replication Methods	Unsupported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting NetSuite

NetSuite setup requirements

To set up NetSuite in Stitch, you need:

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

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.

Sign into your NetSuite account as an administrator.
In your NetSuite account, click Setup > Company > Company Information.
In the Allowed IP addresses field, add the following comma-separated list of Stitch’s IP addresses:
```
52.23.137.21/32,52.204.223.208/32,52.204.228.32/32,52.204.230.227/32
```
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.
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.

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 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 is easily distinguishable in any logs or audits.
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.
Stitch can successfully authenticate to NetSuite.

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 permissions and save the Stitch role

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

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 Manually assign or change password box to create a password for the Stitch user.
2. Enter a password in the Password field, then again in the Confirm Password field.
3. In the Roles section, search the dropdown menu to locate the Stitch role you created in Step 4.
4. 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 sync

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

For tables using Incremental Replication, data equal to or newer than this date will be replicated to your data warehouse.
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 data warehouse.

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

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

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 tables and columns to replicate

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

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

In the list of tables that displays - or in the Tables to Replicate tab, if you skipped this step during setup - locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A green checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A green 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.

Note: If you change these settings while a replication job is still in progress, they will not be used until the next job starts.

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

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

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 1.0 of this integration.

This is the latest version of the NetSuite integraiton.

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

View table schema on GitHub

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.

Account table schema

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

View table schema on GitHub

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

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

View table schema on GitHub

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

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

View table schema on GitHub

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

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

View table schema on GitHub

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.

BillingSchedule table schema

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

View table schema on GitHub

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

binNumber
STRING

customFieldList
VARIES

externalId
STRING

isInactive
BOOLEAN, STRING

location
VARIES

memo
STRING

nullFieldList
VARIES

Budget

View table schema on GitHub

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

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

View table schema on GitHub

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

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

Classification

View table schema on GitHub

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

internalId
STRING

classTranslationList
VARIES

customFieldList
VARIES

externalId
STRING

includeChildren
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

parent
VARIES

subsidiaryList
VARIES

ConsolidatedExchangeRate

View table schema on GitHub

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

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

ContactCategory

View table schema on GitHub

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

_private
BOOLEAN, STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

sync
BOOLEAN, STRING

ContactRole

View table schema on GitHub

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

description
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

CostCategory

View table schema on GitHub

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

account
VARIES

externalId
STRING

isInactive
BOOLEAN, STRING

itemCostType
VARIES

name
STRING

nullFieldList
VARIES

CouponCode

View table schema on GitHub

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

internalId
STRING

code
STRING

dateSent
DATE-TIME

externalId
STRING

nullFieldList
VARIES

promotion
VARIES

recipient
VARIES

useCount
INTEGER, STRING

used
BOOLEAN, STRING

CurrencyRate

View table schema on GitHub

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

effectiveDate
DATE-TIME

exchangeRate
NUMBER, STRING

nullFieldList
VARIES

transactionCurrency
VARIES

CustomList

View table schema on GitHub

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

The CustomList table contains info about

CustomList table schema

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

Customer

View table schema on GitHub

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

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

View table schema on GitHub

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

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

CustomerMessage

View table schema on GitHub

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

description
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

preferred
BOOLEAN, STRING

CustomerStatus

View table schema on GitHub

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

internalId
STRING

description
STRING

externalId
STRING

includeInLeadReports
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

probability
NUMBER, STRING

stage
VARIES

Deleted

View table schema on GitHub

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

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

View table schema on GitHub

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

internalId
STRING

classTranslationList
VARIES

customFieldList
VARIES

externalId
STRING

includeChildren
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

parent
VARIES

subsidiaryList
VARIES

EntityGroup

View table schema on GitHub

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.

EntityGroup table schema

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

savedSearch
VARIES

subsidiary
VARIES

workCalendar
VARIES

ExpenseCategory

View table schema on GitHub

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

The ExpenseCategory table contains info about the expense categories in your NetSuite account.

ExpenseCategory table replication requirements

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

ExpenseCategory table schema

internalId
STRING

customFieldList
VARIES

customForm
VARIES

defaultRate
NUMBER, STRING

description
STRING

expenseAcct
VARIES

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

rateRequired
BOOLEAN, STRING

ratesList
VARIES

subsidiaryList
VARIES

translationsList
VARIES

FairValuePrice

View table schema on GitHub

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

The FairValuePrice table contains info about the fair value price list in your NetSuite account.

FairValuePrice table replication requirements

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

Accounting > Advanced Revenue Management

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

FairValuePrice table schema

internalId
STRING

currency
VARIES

customFieldList
VARIES

customForm
VARIES

dimensionList
VARIES

endDate
DATE-TIME

externalId
STRING

fairValue
NUMBER, STRING

fairValueFormula
VARIES

fairValueRangePolicy
VARIES

highValue
NUMBER, STRING

highValuePercent
NUMBER, STRING

isVsoePrice
BOOLEAN, STRING

item
VARIES

itemRevenueCategory
VARIES

lowValue
NUMBER, STRING

lowValuePercent
NUMBER, STRING

nullFieldList
VARIES

startDate
DATE-TIME

units
VARIES

unitsType
VARIES

Folder

View table schema on GitHub

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

The Folder table contains info about the folders in your NetSuite File Cabinet.

Folder table replication requirements

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

Folder table schema

internalId
STRING

_class
VARIES

bundleable
BOOLEAN, STRING

department
VARIES

description
STRING

externalId
STRING

folderType
VARIES

group
VARIES

hideInBundle
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

isOnline
BOOLEAN, STRING

isPrivate
BOOLEAN, STRING

location
VARIES

name
STRING

nullFieldList
VARIES

parent
VARIES

subsidiary
VARIES

GiftCertificate

View table schema on GitHub

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

The GiftCertificate table contains info about the gift certificates in your NetSuite account.

GiftCertificate table replication requirements

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

Items & Inventory > Gift Certificates

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

GiftCertificate table schema

internalId
STRING

lastModifiedDate
DATE-TIME

amountRemaining
NUMBER, STRING

createdDate
DATE-TIME

email
STRING

expirationDate
DATE-TIME

giftCertCode
STRING

message
STRING

name
STRING

nullFieldList
VARIES

originalAmount
NUMBER, STRING

sender
STRING

GlobalAccountMapping

View table schema on GitHub

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

The GlobalAccountMapping table contains the global account mapping record details in your NetSuite account.

For NetSuite accounts using Multi-Book Accounting, the global account mapping record enables you to configure secondary accounting books to post to accounts different from the primary book. These mappings are used by transactions where the user can manually select the account to which the transaction posts.

GlobalAccountMapping table replication requirements

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

NetSuite OneWorld
Accounting > Multi-Book Accounting
Accounting > Chart of Accounts Mapping

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

GlobalAccountMapping table schema

internalId
STRING

_class
VARIES

accountingBook
VARIES

customDimension
VARIES

customFieldList
VARIES

customForm
VARIES

department
VARIES

destinationAccount
VARIES

effectiveDate
DATE-TIME

endDate
DATE-TIME

externalId
STRING

location
VARIES

nullFieldList
VARIES

sourceAccount
VARIES

subsidiary
VARIES

HcmJob

View table schema on GitHub

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

HcmJob table replication requirements

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

Employees > Job Management

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

HcmJob table schema

internalId
STRING

customFieldList
VARIES

description
STRING

employmentCategory
VARIES

externalId
STRING

isInactive
BOOLEAN, STRING

jobId
STRING

nullFieldList
VARIES

title
STRING

InboundShipment

View table schema on GitHub

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

The InboundShipment table contains info about inbound shipments in your NetSuite account.

InboundShipment table replication requirements

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

Transactions > Inbound Shipment Management

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

InboundShipment table schema

internalId
STRING

actualDeliveryDate
DATE-TIME

actualShippingDate
DATE-TIME

billOfLading
STRING

customFieldList
VARIES

customForm
VARIES

expectedDeliveryDate
DATE-TIME

expectedShippingDate
DATE-TIME

externalDocumentNumber
STRING

externalId
STRING

itemsList
VARIES

nullFieldList
VARIES

shipmentMemo
STRING

shipmentNumber
STRING

shipmentStatus
VARIES

vesselNumber
STRING

InventoryNumber

View table schema on GitHub

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

The InventoryNumber table contains info about the serial or lot numbers in your NetSuite account.

InventoryNumber table replication requirements

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

Items & Inventory > Serialized Inventory or Lot Tracking

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

InventoryNumber table schema

internalId
STRING

customFieldList
VARIES

expirationDate
DATE-TIME

externalId
STRING

inventoryNumber
STRING

item
VARIES

locationsList
VARIES

memo
STRING

nullFieldList
VARIES

status
STRING

units
STRING

Issue

View table schema on GitHub

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

The Issue table contains info about the support cases in your NetSuite account.

Issue table replication requirements

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

CRM > Issue Management

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

Issue table schema

internalId
STRING

lastModifiedDate
DATE-TIME

assigned
VARIES

brokenInVersionList
VARIES

buildBroken
VARIES

buildFixed
VARIES

buildTarget
VARIES

createdDate
DATE-TIME

customFieldList
VARIES

customForm
VARIES

emailAssignee
BOOLEAN, STRING

emailCellsList
VARIES

emailEmployeesList
VARIES

externalAbstract
STRING

externalDetails
STRING

externalId
STRING

fixedInVersionList
VARIES

isOwner
BOOLEAN, STRING

isReviewed
BOOLEAN, STRING

isShowStopper
BOOLEAN, STRING

issueAbstract
STRING

issueNumber
STRING

issueStatus
VARIES

issueTagsList
VARIES

issueType
VARIES

item
VARIES

module
VARIES

newDetails
STRING

nullFieldList
VARIES

priority
VARIES

product
VARIES

productTeam
VARIES

relatedIssuesList
VARIES

reportedBy
VARIES

reproduce
VARIES

reviewer
VARIES

severity
VARIES

source
VARIES

targetVersionList
VARIES

trackCode
VARIES

versionBroken
VARIES

versionFixed
VARIES

versionTarget
VARIES

ItemAccountMapping

View table schema on GitHub

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

The ItemAccountMapping table contains details about the item account mapping record in your NetSuite account.

For accounts using NetSuite Multi-Book Accounting, the item account mapping record enables you to configure secondary accounting books to post to accounts different from the primary book, based on the item that is the subject of the transaction. These mappings are used by transactions where the item determines the account to which the transaction posts.

ItemAccountMapping table replication requirements

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

NetSuite OneWorld
Accounting > Multi-Book Accounting
Accounting > Chart of Accounts Mapping

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

ItemAccountMapping table schema

internalId
STRING

_class
VARIES

accountingBook
VARIES

customDimension
VARIES

customFieldList
VARIES

customForm
VARIES

department
VARIES

destinationAccount
VARIES

effectiveDate
DATE-TIME

endDate
DATE-TIME

externalId
STRING

itemAccount
VARIES

location
VARIES

nullFieldList
VARIES

sourceAccount
VARIES

subsidiary
VARIES

ItemDemandPlan

View table schema on GitHub

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

The ItemDemandPlan table contains info about item demand plans in your NetSuite account. An item demand plan transaction stores the quantity expected to be needed, during specified time periods, for an item.

ItemDemandPlan table replication requirements

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

Items & Inventory > Demand Planning

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

ItemDemandPlan table schema

internalId
STRING

customFieldList
VARIES

customForm
VARIES

demandPlanCalendarType
VARIES

demandPlanMatrix
VARIES

endDate
DATE-TIME

externalId
STRING

item
VARIES

location
VARIES

memo
STRING

month
VARIES

nullFieldList
VARIES

startDate
DATE-TIME

subsidiary
VARIES

units
VARIES

year
INTEGER, STRING

ItemRevision

View table schema on GitHub

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

The ItemRevision table contains info about item revisions in your NetSuite account.

ItemRevision table replication requirements

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

Items & Inventory > Assembly Items

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

ItemRevision table schema

internalId
STRING

effectiveDate
DATE-TIME

externalId
STRING

inactive
BOOLEAN, STRING

item
VARIES

memo
STRING

name
STRING

nullFieldList
VARIES

obsoleteDate
DATE-TIME

ItemSupplyPlan

View table schema on GitHub

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

The ItemSupplyPlan table contains info about the item supply plans in your NetSuite account. An item supply plan lists the purchase orders or work orders required to ensure that item quantity meets expected demand.

ItemSupplyPlan table replication requirements

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

Items & Inventory > Demand Planning

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

ItemSupplyPlan table schema

internalId
STRING

customFieldList
VARIES

customForm
VARIES

externalId
STRING

item
VARIES

location
VARIES

memo
STRING

nullFieldList
VARIES

orderList
VARIES

subsidiary
VARIES

units
VARIES

Job

View table schema on GitHub

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

The Job table contains info about the projects in your NetSuite account.

Job table replication requirements

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

Company > Projects

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

Job table schema

internalId
STRING

accountNumber
STRING

actualTime
VARIES

addressbookList
VARIES

allocatePayrollExpenses
BOOLEAN, STRING

allowAllResourcesForTasks
BOOLEAN, STRING

allowExpenses
BOOLEAN, STRING

allowTime
BOOLEAN, STRING

altName
STRING

altPhone
STRING

applyProjectExpenseTypeToAll
BOOLEAN, STRING

billPay
BOOLEAN, STRING

billingSchedule
VARIES

calculatedEndDate
DATE-TIME

calculatedEndDateBaseline
DATE-TIME

category
VARIES

comments
STRING

companyName
STRING

creditCardsList
VARIES

currency
VARIES

customFieldList
VARIES

customForm
VARIES

dateCreated
DATE-TIME

defaultAddress
STRING

email
STRING

emailPreference
VARIES

endDate
DATE-TIME

entityId
STRING

entityStatus
VARIES

estimateRevRecTemplate
VARIES

estimatedCost
NUMBER, STRING

estimatedGrossProfit
NUMBER, STRING

estimatedGrossProfitPercent
NUMBER, STRING

estimatedLaborCost
NUMBER, STRING

estimatedLaborCostBaseline
NUMBER, STRING

estimatedLaborRevenue
NUMBER, STRING

estimatedRevenue
NUMBER, STRING

estimatedTime
VARIES

estimatedTimeOverride
VARIES

externalId
STRING

fax
STRING

fxRate
NUMBER, STRING

globalSubscriptionStatus
VARIES

includeCrmTasksInTotals
BOOLEAN, STRING

isExemptTime
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

isProductiveTime
BOOLEAN, STRING

isUtilizedTime
BOOLEAN, STRING

jobBillingType
VARIES

jobItem
VARIES

jobPrice
NUMBER, STRING

jobResourcesList
VARIES

jobType
VARIES

language
VARIES

lastBaselineDate
DATE-TIME

lastModifiedDate
DATE-TIME

limitTimeToAssignees
BOOLEAN, STRING

materializeTime
BOOLEAN, STRING

milestonesList
VARIES

nullFieldList
VARIES

openingBalance
NUMBER, STRING

openingBalanceAccount
VARIES

openingBalanceDate
DATE-TIME

parent
VARIES

percentComplete
NUMBER, STRING

percentCompleteOverrideList
VARIES

percentTimeComplete
NUMBER, STRING

phone
STRING

phoneticName
STRING

plStatementList
VARIES

projectExpenseType
VARIES

projectedEndDate
DATE-TIME

projectedEndDateBaseline
DATE-TIME

revRecForecastRule
VARIES

startDate
DATE-TIME

startDateBaseline
DATE-TIME

subsidiary
VARIES

timeRemaining
VARIES

usePercentCompleteOverride
BOOLEAN, STRING

workplace
VARIES

JobStatus

View table schema on GitHub

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

The JobStatus table contains info about the statuses that can be applied to projects in your NetSuite account.

JobStatus table replication requirements

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

Company > Projects

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

JobStatus table schema

internalId
STRING

description
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

JobType

View table schema on GitHub

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

The JobType table contains info about the types that can be applied to projects in your NetSuite account.

JobType table replication requirements

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

Company > Projects

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

JobType table schema

internalId
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

parent
VARIES

ManufacturingCostTemplate

View table schema on GitHub

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

The ManufacturingCostTemplate table contains info about the manufacturing cost templates in your NetSuite account.

A manufacturing cost template is a list of rates that can be associated with completing a specific operation. The template defines the activities that occur and related costs to be recorded each time this step is completed.

ManufacturingCostTemplate table replication requirements

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

Items & Inventory > Manufacturing Routing and Work Center

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

ManufacturingCostTemplate table schema

internalId
STRING

costDetailList
VARIES

customFieldList
VARIES

customForm
VARIES

externalId
STRING

isInactive
BOOLEAN, STRING

memo
STRING

name
STRING

nullFieldList
VARIES

subsidiary
VARIES

ManufacturingOperationTask

View table schema on GitHub

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

The ManufacturingOperationTask table contains info about manufacturing operation tasks in your NetSuite account.

After a WIP work order that has a designated routing is saved in NetSuite, manufacturing operation tasks are created based on the routing. Each of these tasks is a step that must be done in order for the assembly process to be finished.

ManufacturingOperationTask table replication requirements

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

Items & Inventory > Manufacturing Routing and Work Center

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

ManufacturingOperationTask table schema

internalId
STRING

actualWork
NUMBER, STRING

autoCalculateLag
BOOLEAN, STRING

completedQuantity
NUMBER, STRING

costDetailList
VARIES

customFieldList
VARIES

customForm
VARIES

endDate
DATE-TIME

estimatedWork
NUMBER, STRING

externalId
STRING

inputQuantity
NUMBER, STRING

laborResources
INTEGER, STRING

machineResources
INTEGER, STRING

manufacturingCostTemplate
VARIES

manufacturingWorkCenter
VARIES

message
STRING

nullFieldList
VARIES

operationSequence
INTEGER, STRING

order
VARIES

predecessorList
VARIES

remainingWork
NUMBER, STRING

runRate
NUMBER, STRING

setupTime
NUMBER, STRING

startDate
DATE-TIME

status
VARIES

title
STRING

workOrder
VARIES

ManufacturingRouting

View table schema on GitHub

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

The ManufacturingRouting table contains info about the manufacturing routing templates in your NetSuite account.

A manufacturing routing is a template that contains a list of steps required to build an assembly item. Each step is in a sequential order necessary to complete the operational sequence for completing the assembly. After you have created a routing record, that routing can be selected on a work order to direct the completion of the assembly. The routing determines the work center, cost template, labor resources, and machine resources that will be used during the assembly.

ManufacturingRouting table replication requirements

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

Items & Inventory > Manufacturing Routing and Work Center

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

ManufacturingRouting table schema

internalId
STRING

autoCalculateLag
BOOLEAN, STRING

billOfMaterials
VARIES

customFieldList
VARIES

customForm
VARIES

externalId
STRING

isDefault
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

item
VARIES

locationList
VARIES

memo
STRING

name
STRING

nullFieldList
VARIES

routingComponentList
VARIES

routingStepList
VARIES

subsidiary
VARIES

Message

View table schema on GitHub

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

The Message table contains info about the messages in your NetSuite account.

Message table replication requirements

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

Message table schema

internalId
STRING

lastModifiedDate
DATE-TIME

activity
VARIES

author
VARIES

authorEmail
STRING

bcc
STRING

cc
STRING

compressAttachments
BOOLEAN, STRING

dateTime
STRING

emailed
BOOLEAN, STRING

externalId
STRING

incoming
BOOLEAN, STRING

mediaItemList
VARIES

message
STRING

messageDate
DATE-TIME

nullFieldList
VARIES

recipient
VARIES

recipientEmail
STRING

recordName
STRING

recordTypeName
STRING

subject
STRING

transaction
VARIES

Note

View table schema on GitHub

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

The Note table contains info about the notes in your NetSuite account.

Note table replication requirements

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

Note table schema

internalId
STRING

lastModifiedDate
DATE-TIME

activity
VARIES

author
VARIES

customFieldList
VARIES

customForm
VARIES

direction
VARIES

entity
VARIES

externalId
STRING

folder
VARIES

item
VARIES

media
VARIES

note
STRING

noteDate
DATE-TIME

noteType
VARIES

nullFieldList
VARIES

record
VARIES

recordType
VARIES

title
STRING

topic
VARIES

transaction
VARIES

NoteType

View table schema on GitHub

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

The NoteType table contains info about the types that can be applied to notes in your NetSuite account.

NoteType table replication requirements

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

NoteType table schema

internalId
STRING

description
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

Opportunity

View table schema on GitHub

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

The Opportunity table contains info about the opportunities in your NetSuite account.

Opportunity table replication requirements

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

CRM > Opportunities

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

Opportunity table schema

internalId
STRING

lastModifiedDate
DATE-TIME

_class
VARIES

accountingBookDetailList
VARIES

actionItem
STRING

altSalesRangeHigh
NUMBER, STRING

altSalesRangeLow
NUMBER, STRING

billAddressList
VARIES

billingAddress
VARIES

buyingReason
VARIES

buyingTimeFrame
VARIES

closeDate
DATE-TIME

competitorsList
VARIES

contribPct
STRING

createdDate
DATE-TIME

currency
VARIES

currencyName
STRING

customFieldList
VARIES

customForm
VARIES

daysOpen
INTEGER, STRING

department
VARIES

entity
VARIES

entityStatus
VARIES

entityTaxRegNum
VARIES

estGrossProfit
NUMBER, STRING

estGrossProfitPercent
NUMBER, STRING

estimatedBudget
NUMBER, STRING

exchangeRate
NUMBER, STRING

expectedCloseDate
DATE-TIME

externalId
STRING

forecastType
VARIES

isBudgetApproved
BOOLEAN, STRING

itemList
VARIES

job
VARIES

leadSource
VARIES

location
VARIES

memo
STRING

nexus
VARIES

nullFieldList
VARIES

oneTime
NUMBER, STRING

partner
VARIES

partnersList
VARIES

probability
NUMBER, STRING

projAltSalesAmt
NUMBER, STRING

projectedTotal
NUMBER, STRING

rangeHigh
NUMBER, STRING

rangeLow
NUMBER, STRING

recurAnnually
NUMBER, STRING

recurMonthly
NUMBER, STRING

recurQuarterly
NUMBER, STRING

recurWeekly
NUMBER, STRING

salesGroup
VARIES

salesReadiness
VARIES

salesRep
VARIES

salesTeamList
VARIES

shipAddressList
VARIES

shipIsResidential
BOOLEAN, STRING

shippingAddress
VARIES

source
STRING

status
STRING

subsidiary
VARIES

subsidiaryTaxRegNum
VARIES

syncPartnerTeams
BOOLEAN, STRING

syncSalesTeams
BOOLEAN, STRING

tax2Total
NUMBER, STRING

taxDetailsList
VARIES

taxDetailsOverride
BOOLEAN, STRING

taxRegOverride
BOOLEAN, STRING

taxTotal
NUMBER, STRING

title
STRING

totalCostEstimate
NUMBER, STRING

tranDate
DATE-TIME

tranId
STRING

vatRegNum
STRING

weightedTotal
NUMBER, STRING

winLossReason
VARIES

OtherNameCategory

View table schema on GitHub

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

The OtherNameCategory table contains info about the other name categories in your NetSuite account. Other name category values are used on other name records to categorize them. The list of other name records is a collection of records for people or companies who are not vendors, customers, or employees.

OtherNameCategory table replication requirements

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

CRM > Sales Force Automation

OtherNameCategory table schema

internalId
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

PartnerCategory

View table schema on GitHub

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

The PartnerCategory table contains info about the categories that can be applied to partners in your NetSuite account.

PartnerCategory table replication requirements

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

CRM > Partner 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.

PartnerCategory table schema

internalId
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

parent
VARIES

Paycheck

View table schema on GitHub

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

The Paycheck table contains info about the paycheck records in your NetSuite account.

Paycheck table replication requirements

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

Employees > Payroll

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

Paycheck table schema

internalId
STRING

lastModifiedDate
DATE-TIME

_class
VARIES

account
VARIES

address
STRING

balance
NUMBER, STRING

batchNumber
STRING

createdDate
DATE-TIME

department
VARIES

entity
VARIES

externalId
STRING

location
VARIES

memo
STRING

nullFieldList
VARIES

payContribList
VARIES

payDeductList
VARIES

payDisburseList
VARIES

payEarnList
VARIES

payExpList
VARIES

payFrequency
STRING

payPtoList
VARIES

paySummaryList
VARIES

payTaxList
VARIES

payTimeList
VARIES

periodEnding
DATE-TIME

postingPeriod
VARIES

status
STRING

tranDate
DATE-TIME

tranId
STRING

userAmount
NUMBER, STRING

workplace
VARIES

PaymentMethod

View table schema on GitHub

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

The PaymentMethod table contains info about the customer payment methods in your NetSuite account.

PaymentMethod table replication requirements

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

PaymentMethod table schema

internalId
STRING

account
VARIES

creditCard
BOOLEAN, STRING

expressCheckoutArrangement
STRING

externalId
STRING

isDebitCard
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

isOnline
BOOLEAN, STRING

merchantAccountsList
VARIES

name
STRING

nullFieldList
VARIES

payPalEmailAddress
STRING

undepFunds
BOOLEAN, STRING

useExpressCheckout
BOOLEAN, STRING

visualsList
VARIES

PayrollItem

View table schema on GitHub

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

The PayrollItem table contains info about the payroll items, or payroll transaction line items, in your NetSuite account.

PayrollItem table replication requirements

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

Employees > Payroll

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

PayrollItem table schema

internalId
STRING

customFieldList
VARIES

employeePaid
BOOLEAN, STRING

expenseAccount
VARIES

externalId
STRING

inactive
BOOLEAN, STRING

itemType
VARIES

liabilityAccount
VARIES

name
STRING

nullFieldList
VARIES

subsidiary
VARIES

vendor
VARIES

PhoneCall

View table schema on GitHub

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

The PhoneCall table contains info about the phone call records in your NetSuite account.

PhoneCall table replication requirements

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

PhoneCall table schema

internalId
STRING

lastModifiedDate
DATE-TIME

accessLevel
BOOLEAN, STRING

assigned
VARIES

company
VARIES

completedDate
DATE-TIME

contact
VARIES

contactList
VARIES

createdDate
DATE-TIME

customFieldList
VARIES

customForm
VARIES

endDate
DATE-TIME

externalId
STRING

message
STRING

milestone
VARIES

nullFieldList
VARIES

owner
VARIES

phone
STRING

priority
VARIES

reminderMinutes
VARIES

reminderType
VARIES

sendEmail
BOOLEAN, STRING

startDate
DATE-TIME

status
VARIES

supportCase
VARIES

timeItemList
VARIES

timedEvent
BOOLEAN, STRING

title
STRING

transaction
VARIES

PriceLevel

View table schema on GitHub

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

The PriceLevel table contains info about the price level list in your NetSuite account. Price level defines a list of values that are used by opportunity and item records to set the price level for a specific item.

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

PriceLevel table schema

internalId
STRING

discountpct
NUMBER, STRING

externalId
STRING

isInactive
BOOLEAN, STRING

isOnline
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

updateExistingPrices
BOOLEAN, STRING

PricingGroup

View table schema on GitHub

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

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

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

PricingGroup table schema

internalId
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

ProjectTask

View table schema on GitHub

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

The ProjectTask table contains info about the project tasks in your NetSuite account.

ProjectTask table replication requirements

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

Company > Project Management

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

ProjectTask table schema

internalId
STRING

actualWork
NUMBER, STRING

assigneeList
VARIES

company
VARIES

constraintType
VARIES

contact
VARIES

customFieldList
VARIES

customForm
VARIES

endDate
DATE-TIME

endDateBaseline
DATE-TIME

estimatedWork
NUMBER, STRING

estimatedWorkBaseline
NUMBER, STRING

eventId
VARIES

externalId
STRING

finishByDate
DATE-TIME

isMilestone
BOOLEAN, STRING

isOnCriticalPath
STRING

lateEnd
DATE-TIME

lateStart
DATE-TIME

message
STRING

nonBillableTask
BOOLEAN, STRING

nullFieldList
VARIES

order
VARIES

owner
VARIES

parent
VARIES

percentTimeComplete
NUMBER, STRING

predecessorList
VARIES

priority
VARIES

remainingWork
NUMBER, STRING

slackMinutes
NUMBER, STRING

startDate
DATE-TIME

startDateBaseline
DATE-TIME

status
VARIES

timeItemList
VARIES

title
STRING

PromotionCode

View table schema on GitHub

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

The PromotionCode table contains info about the promotion codes in your NetSuite account.

PromotionCode 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 > Promotions (View) permission. If you have the above feature(s) enabled, refer to the Configure the Stitch role section for instructions on adding this permission.

PromotionCode table schema

internalId
STRING

applyDiscountTo
VARIES

code
STRING

codePattern
STRING

currencyList
VARIES

customFieldList
VARIES

customForm
VARIES

description
STRING

discount
VARIES

discountType
BOOLEAN, STRING

displayLineDiscounts
BOOLEAN, STRING

endDate
DATE-TIME

excludeItems
BOOLEAN, STRING

externalId
STRING

freeShipMethod
VARIES

implementation
VARIES

isInactive
BOOLEAN, STRING

isPublic
BOOLEAN, STRING

itemsList
VARIES

locationList
VARIES

minimumOrderAmount
NUMBER, STRING

name
STRING

nullFieldList
VARIES

numberToGenerate
INTEGER, STRING

partnersList
VARIES

rate
STRING

startDate
DATE-TIME

useType
VARIES

ResourceAllocation

View table schema on GitHub

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

The ResourceAllocation table contains info about resource allocations, or employee time reservations, in your NetSuite account.

ResourceAllocation table replication requirements

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

Accounting > Advanced Accounting > Revenue Recognition

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

ResourceAllocation table schema

internalId
STRING

allocationAmount
NUMBER, STRING

allocationResource
VARIES

allocationType
VARIES

allocationUnit
VARIES

approvalStatus
VARIES

customFieldList
VARIES

customForm
VARIES

endDate
DATE-TIME

externalId
STRING

nextApprover
VARIES

notes
STRING

nullFieldList
VARIES

numberHours
NUMBER, STRING

percentOfTime
NUMBER, STRING

project
VARIES

requestedby
VARIES

startDate
DATE-TIME

RevRecSchedule

View table schema on GitHub

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

The RevRecSchedule table contains info about the revenue recognition schedules in your NetSuite account. A revenue recognition schedule indicates the posting periods in which revenue should be recognized, and the amount to be recognized in each period, for an item sale.

RevRecSchedule table replication requirements

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

Accounting > Advanced Accounting > Revenue Recognition

You will also need the Lists > Revenue Recognition 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.

RevRecSchedule table schema

internalId
STRING

amortizationPeriod
INTEGER, STRING

amortizationType
VARIES

externalId
STRING

initialAmount
NUMBER, STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

periodOffset
INTEGER, STRING

recogIntervalSrc
VARIES

recurrenceList
VARIES

recurrenceType
VARIES

revRecOffset
INTEGER, STRING

RevRecTemplate

View table schema on GitHub

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

The RevRecTemplate table contains info about the revenue recognition templates in your NetSuite account. A revenue recognition template indicates how revenue from associated items should be posted.

RevRecTemplate table replication requirements

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

Accounting > Advanced Accounting > Revenue Recognition

RevRecTemplate table schema

internalId
STRING

amortizationPeriod
INTEGER, STRING

amortizationType
VARIES

externalId
STRING

initialAmount
NUMBER, STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

periodOffset
INTEGER, STRING

recogIntervalSrc
VARIES

recurrenceList
VARIES

recurrenceType
VARIES

revRecOffset
INTEGER, STRING

SalesRole

View table schema on GitHub

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

The SalesRole table contains info about the sales roles in your NetSuite account.

SalesRole table replication requirements

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

CRM > Team Selling

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

SalesRole table schema

internalId
STRING

description
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

isSalesRep
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

SalesTaxItem

View table schema on GitHub

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

The SalesTaxItem table contains info about the sales tax items in your NetSuite account.

SalesTaxItem table replication requirements

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

SalesTaxItem table schema

internalId
STRING

available
VARIES

city
STRING

county
STRING

customFieldList
VARIES

description
STRING

displayName
STRING

eccode
BOOLEAN, STRING

effectiveFrom
DATE-TIME

excludeFromTaxReports
BOOLEAN, STRING

exempt
BOOLEAN, STRING

export
BOOLEAN, STRING

externalId
STRING

includeChildren
BOOLEAN, STRING

isDefault
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

itemId
STRING

nexusCountry
VARIES

nullFieldList
VARIES

parent
VARIES

purchaseAccount
VARIES

rate
STRING

reverseCharge
BOOLEAN, STRING

saleAccount
VARIES

service
BOOLEAN, STRING

state
STRING

subsidiaryList
VARIES

taxAccount
VARIES

taxAgency
VARIES

taxType
VARIES

validUntil
DATE-TIME

zip
STRING

SiteCategory

View table schema on GitHub

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

The SiteCategory table contains info about the categories used to organize your website.

SiteCategory table replication requirements

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

SiteCategory table schema

internalId
STRING

categoryListLayout
VARIES

correlatedItemsListLayout
VARIES

description
STRING

excludeFromSitemap
BOOLEAN, STRING

externalId
STRING

isInactive
BOOLEAN, STRING

isOnline
BOOLEAN, STRING

itemId
STRING

itemListLayout
VARIES

metaTagHtml
STRING

nullFieldList
VARIES

pageTitle
STRING

parentCategory
VARIES

presentationItemList
VARIES

relatedItemsListLayout
VARIES

searchKeywords
STRING

sitemapPriority
VARIES

storeDetailedDescription
STRING

storeDisplayImage
VARIES

storeDisplayThumbnail
VARIES

translationsList
VARIES

urlComponent
STRING

website
VARIES

Solution

View table schema on GitHub

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

The Solution table contains info about the solutions, or answers to customer issues, in your NetSuite account.

Solution table replication requirements

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

CRM > Knowledge Base

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

Solution table schema

internalId
STRING

lastModifiedDate
DATE-TIME

assigned
VARIES

createdDate
DATE-TIME

customFieldList
VARIES

customForm
VARIES

displayOnline
BOOLEAN, STRING

externalId
STRING

isInactive
BOOLEAN, STRING

longDescription
STRING

message
STRING

nullFieldList
VARIES

solutionCode
STRING

solutionsList
VARIES

status
VARIES

title
STRING

topicsList
VARIES

Subsidiary

View table schema on GitHub

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

The Subsidiary table contains info about the subsidiary records in your NetSuite account. A subsidiary represents a separate company within your global organization.

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

Subsidiary table schema

internalId
STRING

accountingBookDetailList
VARIES

addrLanguage
STRING

allowPayroll
BOOLEAN, STRING

checkLayout
VARIES

classTranslationList
VARIES

consol
STRING

country
VARIES

currency
VARIES

customFieldList
VARIES

edition
STRING

email
STRING

externalId
STRING

fax
STRING

federalIdNumber
STRING

fiscalCalendar
VARIES

inboundEmail
STRING

interCoAccount
VARIES

isElimination
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

legalName
STRING

logo
VARIES

mainAddress
VARIES

name
STRING

nexusList
VARIES

nonConsol
STRING

nullFieldList
VARIES

pageLogo
VARIES

parent
VARIES

purchaseOrderAmount
NUMBER, STRING

purchaseOrderQuantity
NUMBER, STRING

purchaseOrderQuantityDiff
NUMBER, STRING

receiptAmount
NUMBER, STRING

receiptQuantity
NUMBER, STRING

receiptQuantityDiff
NUMBER, STRING

returnAddress
VARIES

shippingAddress
VARIES

showSubsidiaryName
BOOLEAN, STRING

ssnOrTin
STRING

state
STRING

state1TaxNumber
STRING

taxFiscalCalendar
VARIES

taxRegistrationList
VARIES

tranPrefix
STRING

url
STRING

SupportCase

View table schema on GitHub

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

The SupportCase table contains info about the support cases in your NetSuite account.

SupportCase table replication requirements

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

CRM > Case Management

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

SupportCase table schema

internalId
STRING

lastModifiedDate
DATE-TIME

assigned
VARIES

caseNumber
STRING

category
VARIES

company
VARIES

contact
VARIES

createdDate
DATE-TIME

customFieldList
VARIES

customForm
VARIES

email
STRING

emailEmployeesList
VARIES

emailForm
BOOLEAN, STRING

endDate
DATE-TIME

escalateToList
VARIES

escalationMessage
STRING

externalId
STRING

helpDesk
BOOLEAN, STRING

inboundEmail
STRING

incomingMessage
STRING

insertSolution
VARIES

internalOnly
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

issue
VARIES

item
VARIES

lastMessageDate
DATE-TIME

lastModifiedDate
DATE-TIME

lastReopenedDate
DATE-TIME

module
VARIES

newSolutionFromMsg
STRING

nullFieldList
VARIES

origin
VARIES

outgoingMessage
STRING

phone
STRING

priority
VARIES

product
VARIES

profile
VARIES

searchSolution
STRING

serialNumber
VARIES

solutionsList
VARIES

startDate
DATE-TIME

status
VARIES

subsidiary
VARIES

timeItemList
VARIES

title
STRING

Task

View table schema on GitHub

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

The Task table contains info about the tasks in your NetSuite account.

Task table replication requirements

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

Company > Project Management

Task table schema

internalId
STRING

lastModifiedDate
DATE-TIME

accessLevel
BOOLEAN, STRING

actualTime
VARIES

assigned
VARIES

company
VARIES

completedDate
DATE-TIME

contact
VARIES

contactList
VARIES

createdDate
DATE-TIME

customFieldList
VARIES

customForm
VARIES

dueDate
DATE-TIME

endDate
DATE-TIME

estimatedTime
VARIES

estimatedTimeOverride
VARIES

externalId
STRING

message
STRING

milestone
VARIES

nullFieldList
VARIES

owner
VARIES

parent
VARIES

percentComplete
NUMBER, STRING

percentTimeComplete
NUMBER, STRING

priority
VARIES

reminderMinutes
VARIES

reminderType
VARIES

sendEmail
BOOLEAN, STRING

startDate
DATE-TIME

status
VARIES

supportCase
VARIES

timeItemList
VARIES

timeRemaining
VARIES

timedEvent
BOOLEAN, STRING

title
STRING

transaction
VARIES

TaxGroup

View table schema on GitHub

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

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

TaxGroup table replication requirements

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

TaxGroup table schema

internalId
STRING

city
STRING

county
STRING

description
STRING

externalId
STRING

includeChildren
BOOLEAN, STRING

isDefault
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

itemId
STRING

nexusCountry
VARIES

nullFieldList
VARIES

piggyback
BOOLEAN, STRING

rate
NUMBER, STRING

state
STRING

subsidiaryList
VARIES

taxItemList
VARIES

taxType
VARIES

taxitem1
VARIES

taxitem2
VARIES

unitprice1
STRING

unitprice2
STRING

zip
STRING

TaxType

View table schema on GitHub

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

The TaxType table contains info about the tax types in your NetSuite account. A tax type determines where the tax paid or collected is tracked on the balance sheet. The balance sheet account to which NetSuite posts the collection or payment of tax is called the tax control account.

TaxType table replication requirements

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

TaxType table schema

internalId
STRING

country
VARIES

description
STRING

doesNotAddToTotal
BOOLEAN, STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nexusAccountsList
VARIES

nexusesTaxList
VARIES

nullFieldList
VARIES

postToItemCost
BOOLEAN, STRING

reverseCharge
BOOLEAN, STRING

taxInNetAmount
BOOLEAN, STRING

Term

View table schema on GitHub

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

The Term table contains info about the terms in your NetSuite account. Terms are used to specify when payment is due on customer invoices.

Term table replication requirements

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

Term table schema

internalId
STRING

dateDriven
BOOLEAN, STRING

dayDiscountExpires
INTEGER, STRING

dayOfMonthNetDue
INTEGER, STRING

daysUntilExpiry
INTEGER, STRING

daysUntilNetDue
INTEGER, STRING

discountPercent
NUMBER, STRING

discountPercentDateDriven
NUMBER, STRING

dueNextMonthIfWithinDays
INTEGER, STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

preferred
BOOLEAN, STRING

TimeBill

View table schema on GitHub

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

The TimeBill table contains info about the time transactions in your NetSuite account. Also known as time bills, these transactions records the hours worked by an employee. This transaction can be used to record billable hours and invoice customers.

TimeBill table replication requirements

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

Employees > Time Tracking

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

TimeBill table schema

internalId
STRING

lastModifiedDate
DATE-TIME

_class
VARIES

approvalStatus
VARIES

caseTaskEvent
VARIES

createdDate
DATE-TIME

customFieldList
VARIES

customForm
VARIES

customer
VARIES

department
VARIES

employee
VARIES

externalId
STRING

hours
VARIES

isBillable
BOOLEAN, STRING

item
VARIES

location
VARIES

memo
STRING

nullFieldList
VARIES

overrideRate
BOOLEAN, STRING

paidExternally
BOOLEAN, STRING

payrollItem
VARIES

price
VARIES

rate
NUMBER, STRING

rejectionNote
STRING

status
STRING

subsidiary
VARIES

supervisorApproval
BOOLEAN, STRING

temporaryLocalJurisdiction
VARIES

temporaryStateJurisdiction
VARIES

timeSheet
VARIES

timeType
VARIES

tranDate
DATE-TIME

workplace
VARIES

TimeEntry

View table schema on GitHub

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

The TimeEntry table contains info about the time entries in your NetSuite account.

TimeEntry table replication requirements

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

Employees > Time Sheets

TimeEntry table schema

internalId
STRING

lastModifiedDate
DATE-TIME

_class
VARIES

approvalStatus
VARIES

billingClass
STRING

caseTaskEvent
VARIES

createdDate
DATE-TIME

customFieldList
VARIES

customer
VARIES

department
VARIES

externalId
STRING

hours
VARIES

isBillable
BOOLEAN, STRING

item
VARIES

location
VARIES

memo
STRING

nullFieldList
VARIES

overrideRate
BOOLEAN, STRING

paidExternally
BOOLEAN, STRING

payrollItem
VARIES

price
VARIES

rate
NUMBER, STRING

subsidiary
VARIES

timeType
VARIES

TimeSheet

View table schema on GitHub

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

The TimeSheet table contains info about the time sheets in your NetSuite account.

TimeSheet table replication requirements

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

Employees > Timesheets

TimeSheet table schema

internalId
STRING

approvalStatus
VARIES

customFieldList
VARIES

customForm
VARIES

employee
VARIES

endDate
DATE-TIME

externalId
STRING

nullFieldList
VARIES

startDate
DATE-TIME

subsidiary
VARIES

timeGridList
VARIES

totalHours
VARIES

Transaction

View table schema on GitHub

Replication Method :	Key-based Incremental	Replication Key :	lastModifiedDate
Primary Key :	internalId : _type

The Transaction table contains info about transactions.

Supported transaction types

Stitch’s NetSuite integration supports replicating data for the the transaction types in the Supported NetSuite transaction types section.

Transaction table replication requirements

Replicating this table requires the Transactions > [Transaction Type] (View) permission, where [Transaction Type] is a supported transaction type, in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

Transaction table schema

internalId
STRING

The transaction ID.

_type
STRING

The type of the transaction. This will be one of the transaction types supported by Stitch for replication.

For example: If the transaction is an invoice, the value of this field will be _Invoice.

lastModifiedDate
DATE-TIME

The time the transaction was last modified.

_class
VARIES

accessibilityTypeFedEx
VARIES

ItemFulfillment -

account
VARIES

CashRefund - The cash or bank account to refund from.
CashSale - The account to be credited when payment is received via credit card.
CreditMemo, CustomerRefund - The Accounts Receivable account affected by the transaction.
CustomerDeposit, Deposit - The bank account that will receive the funds from the transaction.
CustomerPayment - The account for deposited payments.
Invoice - The AR account affected by the transaction.
InventoryAdjustment - The account to be used for inventory adjustments.
InventoryCostRevaluation - The adjustment account associated with the transaction.

accountingApproval
BOOLEAN, STRING

ExpenseReport - Indicates if the expense report is ready to be paid.

accountingBook
VARIES

JournalEntry - The accounting book associated with the journal entry.

accountingBookDetailList
VARIES

actualShipDate
DATE-TIME

address
STRING

CustomerRefund - The billing address for the customer.

adjLocation
VARIES

InventoryAdjustment - The location to associate with the adjustment transaction.

advance
NUMBER, STRING

ExpenseReport - The amount advanced to the employee for the associated expenses.

altHandlingCost
NUMBER, STRING

CashRefund, CashSale, CreditMemo - The amount the customer was charged for handling.
Estimate - The amount the customer will be charged for handling.

altSalesTotal
NUMBER, STRING

Estimate - The Alternate Sales Amount for line items on the estimate. This is applicable to NetSuite’s Alternate Sales Amount feature.

altShippingCost
NUMBER, STRING

CashRefund, CashSale - The amount the customer was charged for shipping.
Estimate - The amount the customer will be charged for shipping.

amount
NUMBER, STRING

ExpenseReport - The total of all expense line items minus the advance amount.

amountPaid
NUMBER, STRING

CreditMemo - The amount paid in the credit memo.
Invoice - The total amount paid for the invoice.

amountRemaining
NUMBER, STRING

CreditMemo - The amount remaining in the credit memo.
Invoice - The amount due for the invoice.

ancillaryEndorsementFedEx
VARIES

ItemFulfillment - The Address Correction or Return Service for SmartPost returns.

apAcct
VARIES

applied
NUMBER, STRING

CreditMemo - The amount of credit applied.
CustomerPayment - The amount of total payments applied.
DepositApplication - The amount of deposit applied.

applyList
VARIES

CreditMemo, CustomerDeposit, CustomerPayment, CustomerRefund, DepositApplication

approvalStatus
VARIES

ExpenseReport - The status of the transaction in the approval process. Possible values include Pending Approval, Approved, Rejected

approved
BOOLEAN, STRING

JournalEntry - Indicates whether the journal entry was approved. Journal entries are posted upon approval.

arAcct
VARIES

CustomerPayment, DepositApplication - The Accounts Receivable account that will be affected by the transaction.

assemblyItem
VARIES

authCode
STRING

The authorization code for the transaction.

autoApply
BOOLEAN, STRING

CreditMemo - Indicates if credit will be automatically applied to the oldest open receivable.
CustomerPayment - Indicates if payments will be automatically applied to the oldest open receivable.

autoCalculateLag
BOOLEAN, STRING

availableVendorCredit
NUMBER, STRING

b13AFilingOptionFedEx
VARIES

ItemFulfillment -

b13AStatementDataFedEx
STRING

ItemFulfillment -

backupEmailAddressFedEx
STRING

ItemFulfillment -

backupEmailAddressUps
STRING

ItemFulfillment -

balance
NUMBER, STRING

CreditMemo - The balance of the credit memo.
CustomerPayment, CustomerRefund - The balance in the customer’s account.

billAddressList
VARIES

CashRefund, CashSale, CreditMemo, Estimate - The billing address for the transaction, which is the billing address for the customer associated with the transaction.

billOfMaterials
VARIES

AssemblyBuild - The bill of materials to associate with the assembly.
AssemblyUnbuild - The bill of materials associated with the unassembly.

billOfMaterialsRevision
VARIES

AssemblyBuild - The bill of materials revision associated with the assembly.
AssemblyUnbuild - The bill of materials revision associated with the unassembly.

billPay
BOOLEAN, STRING

Indicates if the check for the transaction can be sent online.

billingAccount
VARIES

CashSale -

billingAddress
VARIES

CashSale, CreditMemo, Estimate - The billing address for the transaction.

billingSchedule
VARIES

CashSale -
Estimate - The billing schedule associated with the transaction.

binNumbers
STRING

AssemblyBuild - The bin numbers associated with the transaction.
AssemblyUnbuild - The bin numbers associated with the transaction.

blanketEndDateUps
DATE-TIME

ItemFulfillment - The expiration date for the NAFTA certificate of origin.

blanketStartDateUps
DATE-TIME

ItemFulfillment - The start date for the blanket period that the NAFTA certificate of origin is in effect.

bookingConfirmationNumFedEx
STRING

buildable
NUMBER, STRING

AssemblyBuild - Indicates the number of assembly items possible, determined by the amount of member items in stock.

built
NUMBER, STRING

AssemblyUnbuild - Indicates the number of built assembly items.

canHaveStackable
BOOLEAN, STRING

CashSale -
Estimate -

carrierIdUps
STRING

ItemFulfillment - The four-digit Standard Carrier Alpha Code (SCAC) of the carrier for vessel, rail, and truck shipments, or the two to three character International Air Transport Association (IATA) code of carrier for air shipments. Refer to the United States Census Bureau for info on codes.

cashBackList
VARIES

ccApproved
BOOLEAN, STRING

CashRefund, CashSale, CustomerDeposit, CustomerPayment, CustomerRefund - Indicates if the credit card associated with the transaction is approved.

ccAvsStreetMatch
VARIES

CashSale, CustomerDeposit, CustomerPayment - The Address Verification Services (AVS) result code returned to Verisign if paid via credit card. Possible values include _Y (Address matches), _N, (Address doesn’t match) _X (AVS is unsupported or no info was returned to Versign).

ccAvsZipMatch
VARIES

CashSale, CustomerDeposit, CustomerPayment - The Address Verification Services (AVS) result code returned to Verisign if paid via credit card. Possible values include _Y (Zip code matches), _N, (Zip code doesn’t match) _X (AVS is unsupported or no info was returned to Versign).

ccExpireDate
DATE-TIME

CashRefund, CashSale, CustomerDeposit, CustomerPayment, CustomerRefund - The expiration date of the credit card associated with the transaction.

ccIsPurchaseCardBin
BOOLEAN, STRING

CashRefund, CashSale, CustomerDeposit, CustomerPayment, CustomerRefund - Indicates whether the credit card is a purchase card. This is associated with NetSuite’s Send Purchase Card Data feature.

ccName
STRING

CashRefund, CashSale, CustomerDeposit, CustomerPayment - The cardholder name from the default credit card on the customer’s record.

ccNumber
STRING

CashRefund, CashSale, CustomerDeposit, CustomerPayment - The credit card number. Note: This value will be masked when replicated from NetSuite.

ccProcessAsPurchaseCard
BOOLEAN, STRING

CashRefund, CashSale, CustomerDeposit, CustomerPayment - Indicates if NetSuite has determined the credit card to be a purchase card and it should be processed as such.

ccSecurityCode
STRING

CashSale, CustomerDeposit, CustomerPayment - The three-digit security code from the back of the customer’s credit card.

ccSecurityCodeMatch
VARIES

CashSale, CustomerDeposit, CustomerPayment - The Card Security Code (CSC) result code returned from Verisign when paid via credit ccard. Possible values include Y (Code matches), N (Code doesn’t match), X` (CSC is unuspported or no info was returned to Verisign).

ccStreet
STRING

CashRefund, CashSale, CustomerDeposit, CustomerPayment, CustomerRefund - The street address from the customer’s billing address.

ccZipCode
STRING

CashRefund, CashSale, CustomerDeposit, CustomerPayment, CustomerRefund - The zip code from the customer’s billing address.

chargeIt
BOOLEAN, STRING

CashRefund, CashSale, CustomerDeposit, CustomerPayment - If the refund is by credit card, this indicates whether the credit can be processed over the internet.

checkNum
STRING

CustomerDeposit, CustomerPayment - If the customer paid by check, this will be the check number.

companyContributionList
VARIES

companyTaxList
VARIES

complete
BOOLEAN, STRING

ExpenseReport - Indicates if the expense report is complete.

completedQuantity
NUMBER, STRING

componentList
VARIES

AssemblyUnbuild -

contribPct
STRING

CashRefund, CashSale, CreditMemo, Estimate -

costComponentList
VARIES

InventoryCostRevaluation -

createdDate
DATE-TIME

AssemblyUnbuild -
Deposit - The date the deposit was created.

createdFrom
VARIES

CashRefund - The return authorization the refund is created from.
CashSale - The sales order the sale is associated with.
CreditMemo -
ItemFulfillment - The sales order the fulfillment is created from.
JournalEntry - The original transaction being voided.

createdFromShipGroup
INTEGER, STRING

creditCard
VARIES

CashRefund, CashSale, CustomerDeposit, CustomerPayment, CustomerRefund - A reference to the credit card records associated with the customer.

creditCardProcessor
VARIES

CashRefund, CashSale, CustomerDeposit, CustomerPayment, CustomerRefund - References the credit card processor used to process the payment.

creditLimit
NUMBER, STRING

creditList
VARIES

CustomerPayment -

currency
VARIES

CashRefund, CashSale, CreditMemo, CustomerDeposit - The currency of the customer associated with the transaction.

currencyName
STRING

CashRefund, CashSale, CreditMemo, CustomerDeposit - The name of the currency associated with the customer.
Deposit - The currency of the bank account associated with the transaction.

customFieldList
VARIES

customForm
VARIES

The custom form associated with the transaction.

customer
VARIES

CustomerPayment, DepositApplication - A reference to a customer or job.
CustomerRefund - A reference to the customer associated with the transaction.

debitCardIssueNo
STRING

CashRefund, CashSale, CustomerPayment - For UK accounts only. The debit card authorization number.
CustomerDeposit, CustomerRefund - If the customer paid by debit card, this will be the card’s issue number.

deductionList
VARIES

deferredRevenue
NUMBER, STRING

CashRefund, CashSale, CreditMemo - The amount of revenue deferred on the transaction.

depDate
DATE-TIME

DepositApplication - The date the pre-payment was originally deposited.

department
VARIES

The department associated with the transaction.

deposit
VARIES

DepositApplication - A reference to the customer deposit being applied.

depositList
VARIES

CustomerPayment -
CustomerRefund -

discountAmount
NUMBER, STRING

Invoice - The discount the customer will recieve if the invoice is paid according to the set terms.

discountDate
DATE-TIME

Invoice - The date the customer must pay the invoice by to receive the discount.

discountItem
VARIES

CashRefund, CashSale, CreditMemo, Estimate - The discount item associated with the transaction.

discountRate
STRING

CashRefund, CashSale, CreditMemo, Estimate - The discount rate for discountItem. If the value includes a percent sign (%), this is calculated as percent. Otherwise, this is calculated as an absolute discount value.

discountTotal
NUMBER, STRING

CashRefund, CashSale, CreditMemo, Estimate - The total of the amount discounted.

drAccount
VARIES

dueDate
DATE-TIME

Estimate - The due date for the estimate.
ExpenseReport - The due date for the expense report.

earningList
VARIES

eccNumberUps
STRING

ItemFulfillment - The Export Control Classification Number for the fulfillment.

email
STRING

CashRefund, CashSale, CreditMemo - The email address(es) that should receive notification about the transaction.

employee
VARIES

employeeTaxList
VARIES

endDate
DATE-TIME

CashSale - The date for the last cash sale.
Estimate - The end date for the estimate.

endOperation
VARIES

entity
VARIES

CashRefund, CashSale, CreditMemo, Estimate, Invoice - The customer associated with the transaction.
ExpenseReport - The employee associated with the expense report.

entityStatus
VARIES

Estimate - The entity status.

entityTaxRegNum
VARIES

CashRefund, CashSale, CreditMemo, Estimate -

entryNumberUps
STRING

ItemFulfillment - The Import Entry Number for the fulfillment, used when the export transaction is used as proof of export for import transactions.

estGrossProfit
NUMBER, STRING

CashRefund, CashSale, CreditMemo, Estimate - The estimated gross profit associated with the refund. This is calculated as the revenue amount minus the estimated cost.

estGrossProfitPercent
NUMBER, STRING

CashRefund, CashSale, CreditMemo, Estimate - The estimated gross profit margin, as a percentage. This is calculated as the estimated gross profit divided by revenue, expressed as a percentage.

estimatedTotalValue
NUMBER, STRING

InventoryAdjustment - The total value of the change in inventory.

exchangeRate
NUMBER, STRING

The exchange rate associated with the currency.

excludeCommission
BOOLEAN, STRING

CashRefund, CashSale, CreditMemo - Indicates if the transaction and its subordinate transactions should be excluded from all commission calculations.

expCostDiscAmount
NUMBER, STRING

CashSale - The discount amount associated with expenses for the transaction.

expCostDiscPrint
BOOLEAN, STRING

CashSale - Indicates if discounts or markups made to expenses should be printed on the invoice for the transaction.

expCostDiscRate
STRING

CashSale - The rate of the discount or markup item. This rate is applied to selected billable expenses and calculated in the total for the cash sale.
Invoice - The rate for the discount or markup item.

expCostDiscTax1Amt
NUMBER, STRING

CashSale -

expCostDiscTaxable
BOOLEAN, STRING

CashSale - Indicates if expenses associated with the transaction are taxable.

expCostDiscount
VARIES

Invoice - The markup or discount to be applied to expenses billed in the invoice.

expCostDiscprint
BOOLEAN, STRING

Invoice - Indicates if the discount or markup added should be printed on the invoice.

expCostList
VARIES

Invoice -

expCostTaxCode
VARIES

CashSale - The default tax code for expenses associated with the transaction.

expCostTaxRate1
NUMBER, STRING

CashSale - The tax rate for expCostTaxCode.

expCostTaxRate2
NUMBER, STRING

CashSale - The tax rate for expCostTaxCode.

expandAssembly
BOOLEAN, STRING

expectedCloseDate
DATE-TIME

Estimate - The expected close date of the estimate.

expenseList
VARIES

expirationDate
DATE-TIME

AssemblyBuild - The lot expiration date for lot numbered assembly items.

exportTypeUps
VARIES

ItemFulfillment - Possible values include: Domestic Exports, Foreign Exports, Foreign Military Sales

externalId
STRING

fax
STRING

CashRefund, CashSale, CreditMemo -

firmed
BOOLEAN, STRING

fob
STRING

CashSale, Estimate - The location where customers tecnhnically acquire ownership.

forecastType
VARIES

Estimate - The forecast type associated with the estimate.

fxAccount
VARIES

generateIntegratedShipperLabel
BOOLEAN, STRING

ItemFulfillment - Indicates if the fulfillment uses a UPS or FedEx-integrated shipping item.

getAuth
BOOLEAN, STRING

giftCert
VARIES

CashRefund, CashSale, CreditMemo -

giftCertApplied
NUMBER, STRING

CashRefund, CashSale, CreditMemo -

giftCertAvailable
NUMBER, STRING

CashRefund, CashSale, CreditMemo -

giftCertRedemptionList
VARIES

giftCertTotal
NUMBER, STRING

CashRefund, CashSale, CreditMemo -

halAddr1FedEx
STRING

halAddr2FedEx
STRING

halAddr3FedEx
STRING

halCityFedEx
STRING

halCountryFedEx
STRING

halPhoneFedEx
STRING

halStateFedEx
STRING

halZipFedEx
STRING

handlingCost
NUMBER, STRING

CashRefund, CashSale, CreditMemo - The amount the customer was charged for handling.
Estimate - The amount the customer will be charged for handling.

handlingTax1Rate
NUMBER, STRING

CashRefund, CashSale, CreditMemo, Estimate - The tax rate for the associated handlingTaxCode.

handlingTax2Rate
NUMBER, STRING

CashRefund, CashSale, CreditMemo, Estimate - The tax rate for the associated handlingTaxCode.

handlingTaxCode
VARIES

CashRefund, CreditMemo, Estimate - The tax code associated with handling charges.

hazmatTypeFedEx
VARIES

holdAtLocationFedEx
BOOLEAN, STRING

homeDeliveryDateFedEx
DATE-TIME

homeDeliveryTypeFedEx
VARIES

ignoreAvs
BOOLEAN, STRING

CashSale, CustomerDeposit, CustomerPayment - Indicates if the results of the Address Verification System (AVS) pre-authoriziation check should be ignored.

inbondCodeUps
STRING

ItemFulfillment - The two-character Foreign Trade Statistics Regulation (FTSR) code used to indicate whether the shipment is being transported under bond. Refer to the United States Census Bureau for more info.

inboundShipment
VARIES

includeInForecast
BOOLEAN, STRING

Estimate - Indicates if the estimate is to be included in sales forecast reports, key performance indicators, and snapshots.

incoterm
VARIES

insideDeliveryFedEx
BOOLEAN, STRING

ItemFulfillment - Indicates if the shipment can be delivered to a location other than the loading error.

insidePickupFedEx
BOOLEAN, STRING

ItemFulfillment - Indicates if the shipment can be picked up from a location other than the loading error.

intercoStatus
VARIES

intercoTransaction
VARIES

intlExemptionNumFedEx
STRING

ItemFulfillment -

inventoryDetail
VARIES

AssemblyBuild - Indicates the bin and quantity detail associated with the assembly.
AssemblyUnbuild - Indicates the bin and quantity detail associated with the unassembly.

inventoryList
VARIES

InventoryTransfer -

inventoryValue
NUMBER, STRING

InventoryCostRevaluation - The new inventory value.

isBackflush
BOOLEAN, STRING

isBookSpecific
BOOLEAN, STRING

JournalEntry -

isCargoAircraftOnlyFedEx
BOOLEAN, STRING

isMultiShipTo
BOOLEAN, STRING

CreditMemo - Indicates that shipping is allowed for more than one address for this transaction.

isRecurringPayment
BOOLEAN, STRING

CashSale, CustomerDeposit, CustomerPayment - Indicates if the sale was generated from a sales order for a recurring payment.

isRoutedExportTransactionUps
BOOLEAN, STRING

ItemFulfillment - Indicates if the foreign principal party in interest authorizes a US forwarding agent or other agent to export the merchandise out of the US.

isTaxable
BOOLEAN, STRING

CashRefund, CashSale, CreditMemo, Estimate - Indicates if the order is taxable.

isWip
BOOLEAN, STRING

item
VARIES

AssemblyBuild - The assembly item to build.
AssemblyUnbuild - The assembly item to unbuild.

itemCostDiscAmount
NUMBER, STRING

CashSale - The discount or markup amount to be applied to the total.

itemCostDiscPrint
BOOLEAN, STRING

CashSale - Indicates if a discount or markup was added and should be printed on the invoice.

itemCostDiscRate
STRING

CashSale - The rate of the discount or markup item.

itemCostDiscTax1Amt
NUMBER, STRING

CashSale -

itemCostDiscTaxable
BOOLEAN, STRING

CashSale - Indicates if markups should be applied to prices before taxes.

itemCostDiscount
VARIES

CashSale - The discount or markup item to apply to billable items applied to the sale.

itemCostList
VARIES

CashSale -

itemCostTaxCode
VARIES

CashSale - The default tax code for all items in the sale.

itemCostTaxRate1
NUMBER, STRING

CashSale - The tax rate for itemCostTaxCode.

itemCostTaxRate2
NUMBER, STRING

CashSale - The tax rate for itemCostTaxCode.

itemFulfillment
VARIES

itemList
VARIES

CreditMemo -
Estimate -

job
VARIES

CashRefund - The job associated with the transaction being refunded.
CashSale - The job associated with the transaction.
CreditMemo, Estimate, Invoice - The project associated with the transaction.

landedCostMethod
VARIES

Possible values are: _quantity, _value, _weight

landedCostPerLine
BOOLEAN, STRING

Indicates if the landed cost per line is to be specified for the transaction.

landedCostsList
VARIES

leadSource
VARIES

CashRefund, CashSale, CreditMemo, Estimate - The lead source the transaction is associated with.

licenseDateUps
DATE-TIME

ItemFulfillment - The date of the license number.

licenseExceptionUps
VARIES

ItemFulfillment - The license exception symbol for the shipment type.

licenseNumberUps
STRING

ItemFulfillment - The license number required when operating under the authority of the Department of the Treasury, Office of Foreign Assets Control license, Department of Justice DEA permit, or any other export license issued by a federal goverment agency.

lineList
VARIES

JournalEntry -

linkedTrackingNumbers
STRING

CashSale -
Estimate -

location
VARIES

The location for the transaction.

manufacturingRouting
VARIES

memo
STRING

An optional memo for the transaction.

message
STRING

CashRefund, CashSale, CreditMemo, Estimate - Defaults to the messageSel value.

messageSel
VARIES

CashRefund, CashSale, CreditMemo, Estimate - The message associated with the refund.

methodOfTransportUps
VARIES

ItemFulfillment - The method by which the merchandise is exported.

nextApprover
VARIES

ExpenseReport - The next approver for the expense report.

nextBill
DATE-TIME

nexus
VARIES

CashRefund, CashSale, CreditMemo, Estimate - The nexus of the transaction.
JournalEntry - The nexus associated with the journal entry, if any.

nullFieldList
VARIES

onCreditHold
STRING

CreditMemo -

oneTime
NUMBER, STRING

Estimate -

operationList
VARIES

opportunity
VARIES

CashSale - A reference to opportunities associated with the customer (entity).
Estimate - A reference to the opportunity associated with the estimate.

options
VARIES

orderQuantity
NUMBER, STRING

orderStatus
VARIES

otherList
VARIES

otherRefNum
STRING

CashRefund, CashSale, CreditMemo, Estimate - The customer PO number associated with the refund.

packageFedExList
VARIES

ItemFulfillment -

packageList
VARIES

ItemFulfillment -

packageUpsList
VARIES

ItemFulfillment -

packageUspsList
VARIES

ItemFulfillment -

packedDate
DATE-TIME

ItemFulfillment -

parentExpenseAlloc
VARIES

JournalEntry - The parent expense allocation associated with the journal entry.

partiesToTransactionUps
BOOLEAN, STRING

ItemFulfillment - Indicates if this is a related party transaction.

partner
VARIES

CashRefund, CashSale, CreditMemo, Estimate - A reference to a partner record. By default, this is the partner set on the entity record.

partnersList
VARIES

CashSale, CreditMemo, Estimate -

payment
NUMBER, STRING

CustomerDeposit - The currency amount of the deposit.
CustomerPayment - The total amount of the payment for the customer.

paymentEventDate
DATE-TIME

paymentEventHoldReason
VARIES

paymentEventResult
VARIES

paymentEventType
VARIES

paymentEventUpdatedBy
STRING

paymentHold
BOOLEAN, STRING

paymentList
VARIES

paymentMethod
VARIES

CashRefund, CashSale, CustomerPayment, CustomerRefund - The type of card used in the transaction.
CustomerDeposit - The payment method for the deposit.

payPalStatus
STRING

CashRefund, CashSale -

payPalTranId
STRING

CashRefund, CashSale -

paypalAuthId
STRING

CashRefund, CashSale -

paypalProcess
BOOLEAN, STRING

CashRefund, CashSale -

pending
NUMBER, STRING

CustomerPayment - The sum of unapproved credit card payments for the customer.

pickedDate
DATE-TIME

ItemFulfillment - The date the fulfillment was picked.

pnRefNum
STRING

CashRefund, CashSale, CustomerDeposit, CustomerPayment, CustomerRefund - If you accept credit card payments, this will be the Verisign authentication code when the payment is approved.

postingPeriod
VARIES

The posting period for the transaction.

printVoucher
BOOLEAN, STRING

probability
NUMBER, STRING

Estimate - The probability of the estimate.

promoCode
VARIES

CashRefund, CashSale, CreditMemo, Estimate - The promotion code applied to the transaction.

promotionsList
VARIES

CashRefund, CashSale, Estimate -

purchaseContract
VARIES

purchaseOrderList
VARIES

quantity
NUMBER, STRING

AssemblyBuild - The number of assembly items to build.
AssemblyUnbuild - The number of assembly items to unbuild.

recipientTaxIdUps
STRING

ItemFulfillment - The tax ID number of the business receiving the shipment.

recognizedRevenue
NUMBER, STRING

CashRefund, CashSale, CreditMemo - The cumulative amount of revenue recognized for the transaction.

recurAnnually
NUMBER, STRING

Estimate -

recurMonthly
NUMBER, STRING

Estimate -

recurQuarterly
NUMBER, STRING

Estimate -

recurWeekly
NUMBER, STRING

Estimate -

recurringBill
BOOLEAN, STRING

CashSale - Indicates if the sale is a recurring bill.

refundCheck
BOOLEAN, STRING

CashRefund - Indicates if the refund will be made by check (TRUE) or cash or credit card (FALSE).

requestedBy
VARIES

ItemFulfillment - The fulfillment request that the item fulfillment originated from.

revCommitStatus
VARIES

revRecEndDate
DATE-TIME

Invoice - The revenue recognition end date for the line.

revRecOnRevCommitment
BOOLEAN, STRING

CashRefund, CashSale, CreditMemo - Indicates if a Revenue Commitment or Revenue Commitment reversal should be creaed for the transaction.

revRecSchedule
VARIES

CashSale - The revenue recognition schedule for the transaction.

revRecStartDate
DATE-TIME

CashSale- The start date for the revenue rec schedule for the transaction.

revenueStatus
VARIES

CashRefund, CreditMemo - The status of revenue for the transaction. Possible values are Pending, In Progress, Completed

reversalDate
DATE-TIME

JournalEntry - The date for the reversing entry to be posted.

reversalDefer
BOOLEAN, STRING

JournalEntry - Indicates that the reversal should be made into a memorized transaction that automatically occurrs on the reversalDate.

reversalEntry
STRING

JournalEntry - If the journal entry is a reversal entry, this will reference the reversing entry.

revision
VARIES

AssemblyBuild - The revision of the assembly build to use.

salesEffectiveDate
DATE-TIME

CashRefund, CashSale, CreditMemo - The sales effective date for the transaction.

salesGroup
VARIES

CashRefund, CashSale, CreditMemo, Estimate - The sales team associated with the transaction. Associated with NetSuite’s Team Selling Feature.

salesOrder
VARIES

CustomerDeposit - The sales order that the deposit is reserved for. The deposit may only be applied to the order listed here.

salesRep
VARIES

CashRefund, CashSale, CreditMemo, Estimate - The sales representative associated with the customer in the entity field.

salesTeamList
VARIES

CashRefund, CashSale, CreditMemo, Estimate -

saturdayDeliveryFedEx
BOOLEAN, STRING

ItemFulfillment - Indicates whether FedEx is required to deliver the shipment on a Saturday.

saturdayDeliveryUps
BOOLEAN, STRING

ItemFulfillment - Indicates whether UPS is required to deliver the shipment on a Saturday.

saturdayPickupFedex
BOOLEAN, STRING

ItemFulfillment - Indicates whether FedEx is required to pick up the shipment on a Saturday.

saveOnAuthDecline
BOOLEAN, STRING

schedulingMethod
VARIES

scrapQuantity
NUMBER, STRING

sendBackupEmailFedEx
BOOLEAN, STRING

ItemFulfillment - Indicates if proof of delivery should be automatically sent when the package is delivered.

sendBackupEmailUps
BOOLEAN, STRING

ItemFulfillment - Indicates if shipment notifications should be sent to the backupEmailUps email.

sendShipNotifyEmailFedEx
BOOLEAN, STRING

ItemFulfillment - Indicates if the recipient of the shipment should be alerted of the expected delivery date.

sendShipNotifyEmailUps
BOOLEAN, STRING

ItemFulfillment - Indicates if the recipient of the shipment should be alerted of the package being shipped.

serialNumbers
STRING

AssemblyBuild - The serial numbers for the assemblies to build.
AssemblyUnbuild - The serial numbers for the assemblies to unbuild.

shipAddress
STRING

shipAddressList
VARIES

CashSale, Estimate - The shipping address for the transaction.

shipComplete
BOOLEAN, STRING

shipDate
DATE-TIME

CashSale, Estimate - The ship date for the transaction.

shipDateFedEx
DATE-TIME

ItemFulfillment -

shipGroupList
VARIES

CashSale, Estimate -

shipIsResidential
BOOLEAN, STRING

CashSale, Estimate - Indicates whether the shipAddressList is a residential address.

shipMethod
VARIES

CashRefund, CashSale, CreditMemo, Estimate - The shipping method for the transaction.

shipNotifyEmailAddress2Ups
STRING

shipNotifyEmailAddressFedEx
STRING

shipNotifyEmailAddressUps
STRING

shipNotifyEmailMessageUps
STRING

shipStatus
VARIES

shipTo
VARIES

shipmentWeightFedEx
NUMBER, STRING

ItemFulfillment - The total weight of all packages in the order.

shipmentWeightUps
NUMBER, STRING

ItemFulfillment - The total weight of all packages in the order.

shippedDate
DATE-TIME

shippingAddress
VARIES

CashSale, Estimate -

shippingCost
NUMBER, STRING

CashRefund, CashSale, CreditMemo, Estimate - The shipping cost for the transaction.

shippingTax1Rate
NUMBER, STRING

CashRefund, CashSale, CreditMemo, Estimate - The tax rate associated with the shippingTaxCode.

shippingTax2Rate
NUMBER, STRING

CashRefund, CashSale, CreditMemo, Estimate - The tax rate associated with the shippingTaxCode.

shippingTaxCode
VARIES

CashRefund, CashSale, CreditMemo, Estimate - The tax code used for shipping costs.

shopperIpAddress
STRING

signatureHomeDeliveryFedEx
BOOLEAN, STRING

softDescriptor
STRING

CustomerDeposit -

source
STRING

CashRefund, CashSale, CreditMemo, Estimate - The source of the transaction.

sourceTransactionId
STRING

sourceTransactionLine
INTEGER, STRING

specialOrder
BOOLEAN, STRING

startDate
DATE-TIME

CashSale - The date for creating the first bill.
Estimate - The expected closing date for the estimate.

startOperation
VARIES

status
STRING

The status of the transaction.

subTotal
NUMBER, STRING

CashRefund, CashSale, CreditMemo, Estimate - The transaction subtotal before any discounts, shipping, handling, or tax costs are added to the order.

subsidiary
VARIES

Check - The primary subsidiary associated with the payee.
CashSale, CreditMemo, CustomerPayment, CustomerRefund, DepositApplication, Estimate, JournalEntry - The subsidiary associated with the transaction.
Deposit - The subsidiary associated with the bank account for the transaction.

subsidiaryTaxRegNum
VARIES

CashRefund, CashSale, Estimate - The tax registration number of the transaction nexus.
JournalEntry - The tax registration number associated with the journal entry, if any.

supervisorApproval
BOOLEAN, STRING

ExpenseReport - Indicates if supervisor approval is required for the expense report.

syncPartnerTeams
BOOLEAN, STRING

CashRefund, CashSale, CreditMemo, Estimate - Indicates if the sales team on the customer’s record should be updated based on modifications to the transaction.

syncSalesTeams
BOOLEAN, STRING

CashRefund, CashSale, CreditMemo, Estimate - Indicates if the sales team on the customer’s record should be updated based on modifications to the transaction.

tax1Amt
NUMBER, STRING

todo

tax2Amt
NUMBER, STRING

todo

tax2Total
NUMBER, STRING

Check - The total amount of PST based on the associated line items.
CashRefund, CashSale, CreditMemo - The PST tax total for Canadian accounts.
Estimate - The tax rate multiplied by the taxable total number of line items.

taxDetailsList
VARIES

CashSale, CreditMemo, Estimate -

taxDetailsOverride
BOOLEAN, STRING

CashRefund, CashSale, CreditMemo, Estimate - Indicates if tax info from the Tax Details subtab of the transaction should be overridden.

taxItem
VARIES

CashRefund, CashSale, CreditMemo, Estimate - The tax item for the customer associated with the transaction.

taxRate
NUMBER, STRING

CashRefund, CashSale, CreditMemo, Estimate - The percentage rate of the taxItem.

taxRegOverride
BOOLEAN, STRING

CashRefund, CashSale, CreditMemo, Estimate - Indicates if the values in nexus and subsidiaryTaxRegNum should be overridden.

taxTotal
NUMBER, STRING

Check - The total amount of GST based on the associated line items.
CashRefund, CashSale, CreditMemo, Estimate - The total tax applied to the transaction.

terms
VARIES

Estimate - The discount term to apply to the estimate.

termsFreightChargeFedEx
NUMBER, STRING

termsInsuranceChargeFedEx
NUMBER, STRING

termsOfSaleFedEx
VARIES

thirdPartyAcctFedEx
STRING

thirdPartyAcctUps
STRING

thirdPartyCountryFedEx
VARIES

thirdPartyCountryUps
VARIES

thirdPartyTypeFedEx
VARIES

thirdPartyTypeUps
VARIES

thirdPartyZipcodeUps
STRING

threeDStatusCode
STRING

CashSale, CustomerDeposit, CustomerPayment - The payer authentication status.

timeDiscAmount
NUMBER, STRING

CashSale - The discount or markup amount applied to billable time for the transaction.

timeDiscPrint
BOOLEAN, STRING

CashSale - Indicates if discounts or markups applied to billable time should be printed on the invoice for the transaction.

timeDiscRate
STRING

CashSale - The rate of the discount or markup item applied to billable time for the transaction.

timeDiscTax1Amt
NUMBER, STRING

CashSale -

timeDiscTaxable
BOOLEAN, STRING

CashSale - Indicates if the discount or markup item shouled be applied to billable time before taxes are calculated for the transaction.

timeDiscount
VARIES

CashSale - The discount or markup item to apply to billable time for the transaction.

timeList
VARIES

CashSale -

timeTaxCode
VARIES

CashSale - The default tax code for all time entries in the transaction.

timeTaxRate1
NUMBER, STRING

CashSale - The tax rate for timeTaxCode.

timeTaxRate2
NUMBER, STRING

CashSale - The tax rate for timeTaxCode.

title
STRING

Estimate - The title for the estimate.

toAch
BOOLEAN, STRING

toBeEmailed
BOOLEAN, STRING

CashRefund, CashSale, CreditMemo, Estimate - Indicates if the cash refund should be sent to all emails in the email field.

toBeFaxed
BOOLEAN, STRING

CashRefund, CashSale, CreditMemo, Estimate - Indicates if the cash refund should be sent to all fax numbers in the fax field.

toBePrinted
BOOLEAN, STRING

Indicates if the transaction should be saved in a queue of checks to print.

toPrint2
BOOLEAN, STRING

CashRefund, CashSale - Indicates if the refund check should be added to the check printing queue.

toSubsidiary
VARIES

The second subsidiary for the ledger transaction.

total
NUMBER, STRING

AssemblyBuild, AssemblyUnbuild - The projected value of the assembly.
CashRefund, CashSale, CreditMemo, CustomerRefund, Estimate - The total of line items, tax, and shipping costs.
CustomerPayment - The sum of the payment amount and any applied credits.
Deposit - The total amount being deposited.
DepositApplication - The total amount to apply.
InventoryCostRevaluation - The total of the adjustment.

totalCostEstimate
NUMBER, STRING

CashRefund, CashSale, CreditMemo, Estimate - The estimated cost of the specific number of items. This is calculated as: estimated rate x quantity = estimated cost

trackingNumbers
STRING

CashSale, Estimate - The shipping tracking number from the shipping company.

tranDate
DATE-TIME

AssemblyBuild, AssemblyUnbuild - The date of the transaction.
BinTransfer - The date of the transfer.
BinWorksheet - The date of the transaction.
The posting date of the check, by default.
CashRefund, CashSale, CreditMemo, CustomerDeposit, CustomerPayment, CustomerRefund, DepositApplication, Estimate - The date of the transaction.
Deposit - The posting date of the deposit, by default.

tranId
STRING

The NetSuite-generated number associated with the transaction.

tranIsVsoeBundle
BOOLEAN, STRING

CashRefund, CashSale, CreditMemo - Indicates if all items in the transaction shouldb e included as a VSOE bundle.

transactionNumber
STRING

The NetSuite-generated number for the transaction.

transferLocation
VARIES

InventoryTransfer - The location the item will be transferred to.

unapplied
NUMBER, STRING

CreditMemo - The remaining amount of credit to be applied.
CustomerPayment - The difference between available and applied payment amounts.
DepositApplication - The remaining amount of deposit to be applied.

undepFunds
BOOLEAN, STRING

CashSale - Indicates if payment is received by cash or check (TRUE) or by account (FALSE).
CustomerPayment - Indicates if the payment will be deposited to a bank account later.

unitCost
NUMBER, STRING

InventoryCostRevaluation - The new unit cost.

units
VARIES

AssemblyBuild, AssemblyUnbuild - If the assembly uses Units of Measure, this is the value of the base units.

unitsType
VARIES

useItemCostAsTransferCost
BOOLEAN, STRING

useMultiCurrency
BOOLEAN, STRING

ExpenseReport - Indicates if expenses are allowed to be entered in foreign currencies on the report.

userTaxTotal
NUMBER, STRING

userTotal
NUMBER, STRING

The dollar amount of the check.

validFrom
DATE-TIME

CashRefund, CashSale, CustomerDeposit, CustomerPayment, CustomerRefund - The date when the card first became valid.

vatRegNum
STRING

CashRefund, CashSale, CreditMemo, Estimate - The tax ID for UK accounts.

visibleToCustomer
BOOLEAN, STRING

Estimate - Indicates that the estimate is available to customers in the Customer Center.

voidJournal
VARIES

CustomerRefund - If the refund was voided, this will be a reference to the journal entry voiding the transaction.

vsoeAutoCalc
BOOLEAN, STRING

CashRefund, CashSale, CreditMemo - The VSOE allocation amount for the transaction.

UnitsType

View table schema on GitHub

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

The UnitsType table contains info about the unit types, or Units of Measure, in your NetSuite account.

UnitsType table replication requirements

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

Company > Multiple Units of Measure
Accounting > Multiple Units of Measure

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

UnitsType table schema

internalId
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

uomList
VARIES

Usage

View table schema on GitHub

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

The Usage table contains info about the subscription billing lines in your NetSuite account. For example: Money, time, cellular data, internet data, etc.

Usage table replication requirements

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

SuiteBilling

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

Usage table schema

internalId
STRING

customForm
VARIES

customer
VARIES

externalId
STRING

item
VARIES

memo
STRING

nullFieldList
VARIES

subscriptionPlan
VARIES

usageDate
DATE-TIME

usageQuantity
NUMBER, STRING

usageSubscription
VARIES

usageSubscriptionLine
VARIES

Vendor

View table schema on GitHub

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

The Vendor table contains info about the vendors in your NetSuite account.

Vendor table replication requirements

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

Vendor table schema

internalId
STRING

lastModifiedDate
DATE-TIME

accountNumber
STRING

addressbookList
VARIES

altEmail
STRING

altName
STRING

altPhone
STRING

balance
NUMBER, STRING

balancePrimary
NUMBER, STRING

bcn
STRING

billPay
BOOLEAN, STRING

category
VARIES

comments
STRING

companyName
STRING

creditLimit
NUMBER, STRING

currency
VARIES

currencyList
VARIES

customFieldList
VARIES

customForm
VARIES

dateCreated
DATE-TIME

defaultAddress
STRING

eligibleForCommission
BOOLEAN, STRING

email
STRING

emailPreference
VARIES

emailTransactions
BOOLEAN, STRING

entityId
STRING

expenseAccount
VARIES

externalId
STRING

fax
STRING

faxTransactions
BOOLEAN, STRING

firstName
STRING

giveAccess
BOOLEAN, STRING

globalSubscriptionStatus
VARIES

homePhone
STRING

image
VARIES

incoterm
VARIES

is1099Eligible
BOOLEAN, STRING

isAccountant
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

isJobResourceVend
BOOLEAN, STRING

isPerson
BOOLEAN, STRING

laborCost
NUMBER, STRING

lastName
STRING

legalName
STRING

middleName
STRING

mobilePhone
STRING

nullFieldList
VARIES

openingBalance
NUMBER, STRING

openingBalanceAccount
VARIES

openingBalanceDate
DATE-TIME

password
STRING

password2
STRING

payablesAccount
VARIES

phone
STRING

phoneticName
STRING

pricingScheduleList
VARIES

printOnCheckAs
STRING

printTransactions
BOOLEAN, STRING

purchaseOrderAmount
NUMBER, STRING

purchaseOrderQuantity
NUMBER, STRING

purchaseOrderQuantityDiff
NUMBER, STRING

receiptAmount
NUMBER, STRING

receiptQuantity
NUMBER, STRING

receiptQuantityDiff
NUMBER, STRING

representingSubsidiary
VARIES

requirePwdChange
BOOLEAN, STRING

rolesList
VARIES

salutation
STRING

sendEmail
BOOLEAN, STRING

subscriptionsList
VARIES

subsidiary
VARIES

taxIdNum
STRING

taxItem
VARIES

terms
VARIES

title
STRING

unbilledOrders
NUMBER, STRING

unbilledOrdersPrimary
NUMBER, STRING

url
STRING

vatRegNumber
STRING

workCalendar
VARIES

VendorCategory

View table schema on GitHub

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

The VendorCategory table contains info about the categories that can be applied to vendors in your NetSuite account.

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

VendorCategory table schema

internalId
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

isTaxAgency
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

WinLossReason

View table schema on GitHub

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

The WinLossReason table contains info about the win/loss reasons in your NetSuite account.

WinLossReason table replication requirements

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

CRM > Opportunities

WinLossReason table schema

internalId
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

name
STRING

nullFieldList
VARIES

Campaign

View table schema on GitHub

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.

Campaign table schema

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

View table schema on GitHub

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

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

Contact

View table schema on GitHub

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

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.

customrecord_[custom_record_name]

View table schema on GitHub

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.

customrecord_[custom_record_name] table schema

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.

Employee

View table schema on GitHub

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

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

File

View table schema on GitHub

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

The File table contains info about the files in your NetSuite File Cabinet.

File table replication requirements

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

File table schema

internalId
STRING

lastModifiedDate
DATE-TIME

_class
STRING

altTagCaption
STRING

attachFrom
VARIES

bundleable
BOOLEAN, STRING

caption
STRING

content
STRING

createdDate
DATE-TIME

department
STRING

description
STRING

encoding
VARIES

externalId
STRING

featuredDescription
STRING

fileSize
NUMBER, STRING

fileType
VARIES

folder
VARIES

hideInBundle
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

isOnline
BOOLEAN, STRING

isPrivate
BOOLEAN, STRING

mediaFile
VARIES

mediaTypeName
STRING

name
STRING

nullFieldList
VARIES

owner
VARIES

siteCategoryList
VARIES

siteDescription
STRING

storeDisplayThumbnail
VARIES

textFileEncoding
VARIES

url
STRING

urlComponent
STRING

Item

View table schema on GitHub

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

The Item table contains info about items.

Item table replication requirements

Replicating this table requires the Lists > [Item Type] (View) permission, where [Item Type] is a supported item type, in NetSuite. Refer to the Configure the Stitch role section for instructions on adding this permission.

Item table schema

internalId
STRING

lastModifiedDate
DATE-TIME

_class
VARIES

_type
STRING

account
VARIES

accountingBookDetailList
VARIES

alternateDemandSourceItem
VARIES

amortizationPeriod
INTEGER, STRING

amortizationTemplate
VARIES

assetAccount
VARIES

authCodesList
VARIES

autoLeadTime
BOOLEAN, STRING

autoPreferredStockLevel
BOOLEAN, STRING

autoReorderPoint
BOOLEAN, STRING

availableToPartners
BOOLEAN, STRING

averageCost
NUMBER, STRING

backwardConsumptionDays
INTEGER, STRING

billExchRateVarianceAcct
VARIES

billOfMaterialsList
VARIES

billPriceVarianceAcct
VARIES

billQtyVarianceAcct
VARIES

billingRatesMatrix
VARIES

billingSchedule
VARIES

binNumberList
VARIES

buildEntireAssembly
BOOLEAN, STRING

buildTime
INTEGER, STRING

cogsAccount
VARIES

contingentRevenueHandling
BOOLEAN, STRING

copyDescription
BOOLEAN, STRING

cost
NUMBER, STRING

costCategory
VARIES

costEstimate
NUMBER, STRING

costEstimateType
VARIES

costEstimateUnits
STRING

costUnits
STRING

costingMethod
VARIES

costingMethodDisplay
STRING

countryOfManufacture
VARIES

createJob
BOOLEAN, STRING

createRevenuePlansOn
VARIES

createdDate
DATE-TIME

currency
STRING

customFieldList
VARIES

customForm
VARIES

dateConvertedToInv
DATE-TIME

daysBeforeExpiration
INTEGER, STRING

defaultItemShipMethod
VARIES

defaultReturnCost
NUMBER, STRING

defaultRevision
STRING

deferRevRec
BOOLEAN, STRING

deferralAccount
VARIES

deferredRevenueAccount
VARIES

demandModifier
NUMBER, STRING

demandSource
VARIES

demandTimeFence
INTEGER, STRING

department
VARIES

description
STRING

directRevenuePosting
BOOLEAN, STRING

displayName
STRING

distributionCategory
VARIES

distributionNetwork
VARIES

dontShowPrice
BOOLEAN, STRING

dropshipExpenseAccount
VARIES

effectiveBomControl
VARIES

enforceMinQtyInternally
BOOLEAN, STRING

excludeFromSitemap
BOOLEAN, STRING

expenseAccount
VARIES

expirationDate
DATE-TIME

externalId
STRING

featuredDescription
STRING

fixedLotSize
NUMBER, STRING

forwardConsumptionDays
INTEGER, STRING

fraudRisk
VARIES

gainLossAccount
VARIES

generateAccruals
BOOLEAN, STRING

handlingCost
NUMBER, STRING

handlingCostUnits
STRING

hazmatHazardClass
STRING

hazmatId
STRING

hazmatItemUnits
STRING

hazmatItemUnitsQty
NUMBER, STRING

hazmatPackingGroup
VARIES

hazmatShippingName
STRING

immediateDownload
BOOLEAN, STRING

includeChildren
BOOLEAN, STRING

includeStartEndLines
BOOLEAN, STRING

incomeAccount
VARIES

intercoCogsAccount
VARIES

intercoDefRevAccount
VARIES

intercoExpenseAccount
VARIES

intercoIncomeAccount
VARIES

invtClassification
VARIES

invtCountInterval
INTEGER, STRING

isDonationItem
BOOLEAN, STRING

isDropShipItem
BOOLEAN, STRING

isFulfillable
BOOLEAN, STRING

isGcoCompliant
BOOLEAN, STRING

isHazmatItem
BOOLEAN, STRING

isInactive
BOOLEAN, STRING

isOnline
BOOLEAN, STRING

isPhantom
BOOLEAN, STRING

isPreTax
BOOLEAN, STRING

isSpecialOrderItem
BOOLEAN, STRING

isSpecialWorkOrderItem
BOOLEAN, STRING

isStorePickupAllowed
BOOLEAN, STRING

isTaxable
BOOLEAN, STRING

isVsoeBundle
BOOLEAN, STRING

issueProduct
VARIES

itemCarrier
VARIES

itemId
STRING

itemNumberOptionsList
VARIES

itemOptionsList
VARIES

itemRevenueCategory
VARIES

itemShipMethodList
VARIES

itemTaskTemplatesList
VARIES

itemVendorList
VARIES

lastInvtCountDate
DATE-TIME

lastPurchasePrice
NUMBER, STRING

leadTime
INTEGER, STRING

liabilityAccount
VARIES

location
VARIES

locationsList
VARIES

manufacturer
STRING

manufacturerAddr1
STRING

manufacturerCity
STRING

manufacturerState
STRING

manufacturerTariff
STRING

manufacturerTaxId
STRING

manufacturerZip
STRING

manufactureraddr1
STRING

manufacturingChargeItem
BOOLEAN, STRING

matchBillToReceipt
BOOLEAN, STRING

matrixItemNameTemplate
STRING

matrixOptionList
VARIES

matrixType
VARIES

maxDonationAmount
NUMBER, STRING

memberList
VARIES

metaTagHtml
STRING

minimumQuantity
INTEGER, STRING

minimumQuantityUnits
STRING

mpn
STRING

multManufactureAddr
BOOLEAN, STRING

nexTagCategory
STRING

nextInvtCountDate
DATE-TIME

noPriceMessage
STRING

nonPosting
BOOLEAN, STRING

nullFieldList
VARIES

numOfAllowedDownloads
INTEGER, STRING

numbersList
VARIES

offerSupport
BOOLEAN, STRING

onHandValueMli
NUMBER, STRING

onSpecial
BOOLEAN, STRING

originalItemSubtype
VARIES

originalItemType
VARIES

outOfStockBehavior
VARIES

outOfStockMessage
STRING

overallQuantityPricingType
VARIES

overheadType
VARIES

pageTitle
STRING

parent
VARIES

paymentMethod
VARIES

periodicLotSizeDays
INTEGER, STRING

periodicLotSizeType
VARIES

preferenceCriterion
VARIES

preferredLocation
VARIES

preferredStockLevel
NUMBER, STRING

preferredStockLevelDays
NUMBER, STRING

preferredStockLevelUnits
STRING

presentationItemList
VARIES

pricesIncludeTax
BOOLEAN, STRING

pricingGroup
VARIES

pricingMatrix
VARIES

printItems
BOOLEAN, STRING

prodPriceVarianceAcct
VARIES

prodQtyVarianceAcct
VARIES

producer
BOOLEAN, STRING

productFeedList
VARIES

purchaseDescription
STRING

purchaseOrderAmount
NUMBER, STRING

purchaseOrderQuantity
NUMBER, STRING

purchaseOrderQuantityDiff
NUMBER, STRING

purchasePriceVarianceAcct
VARIES

purchaseTaxCode
VARIES

purchaseUnit
VARIES

quantityAvailable
NUMBER, STRING

quantityAvailableUnits
STRING

quantityBackOrdered
NUMBER, STRING

quantityCommitted
NUMBER, STRING

quantityCommittedUnits
STRING

quantityOnHand
NUMBER, STRING

quantityOnHandUnits
STRING

quantityOnOrder
NUMBER, STRING

quantityOnOrderUnits
STRING

quantityPricingSchedule
VARIES

quantityReorderUnits
STRING

rate
NUMBER, STRING

receiptAmount
NUMBER, STRING

receiptQuantity
NUMBER, STRING

receiptQuantityDiff
NUMBER, STRING

relatedItemsDescription
STRING

reorderMultiple
INTEGER, STRING

reorderPoint
NUMBER, STRING

reorderPointUnits
STRING

rescheduleInDays
INTEGER, STRING

rescheduleOutDays
INTEGER, STRING

residual
STRING

revRecForecastRule
VARIES

revRecSchedule
VARIES

revReclassFXAccount
VARIES

revenueAllocationGroup
VARIES

revenueRecognitionRule
VARIES

roundUpAsComponent
BOOLEAN, STRING

safetyStockLevel
NUMBER, STRING

safetyStockLevelDays
INTEGER, STRING

safetyStockLevelUnits
STRING

saleUnit
VARIES

salesDescription
STRING

salesTaxCode
VARIES

scheduleBCode
VARIES

scheduleBNumber
STRING

scheduleBQuantity
INTEGER, STRING

scrapAcct
VARIES

searchKeywords
STRING

seasonalDemand
BOOLEAN, STRING

serialNumbers
STRING

shipIndividually
BOOLEAN, STRING

shipPackage
VARIES

shippingCost
NUMBER, STRING

shippingCostUnits
STRING

shoppingDotComCategory
STRING

shopzillaCategoryId
INTEGER, STRING

showDefaultDonationAmount
BOOLEAN, STRING

siteCategoryList
VARIES

sitemapPriority
VARIES

softDescriptor
VARIES

specialsDescription
STRING

stockDescription
STRING

stockUnit
VARIES

storeDescription
STRING

storeDetailedDescription
STRING

storeDisplayImage
VARIES

storeDisplayName
STRING

storeDisplayThumbnail
VARIES

storeItemTemplate
VARIES

subsidiaryList
VARIES

supplyLotSizingMethod
VARIES

supplyReplenishmentMethod
VARIES

supplyTimeFence
INTEGER, STRING

supplyType
VARIES

taxSchedule
VARIES

totalValue
NUMBER, STRING

trackLandedCost
BOOLEAN, STRING

transferPrice
NUMBER, STRING

translationsList
VARIES

unbuildVarianceAccount
VARIES

undepFunds
BOOLEAN, STRING

unitsType
VARIES

upcCode
STRING

urlComponent
STRING

useBins
BOOLEAN, STRING

useComponentYield
BOOLEAN, STRING

useMarginalRates
BOOLEAN, STRING

vendor
VARIES

vendorName
STRING

vsoeDeferral
VARIES

vsoeDelivered
BOOLEAN, STRING

vsoePermitDiscount
VARIES

vsoePrice
NUMBER, STRING

vsoeSopGroup
VARIES

weight
NUMBER, STRING

weightUnit
VARIES

weightUnits
STRING

wipAcct
VARIES

wipVarianceAcct
VARIES

Location

View table schema on GitHub

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

The Location table contains info about locations.

Location table replication requirements

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

Company > Locations

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

Location table schema

internalId
STRING

allowStorePickup
BOOLEAN, STRING

Indicates if store pickup is allowed for the location.

autoAssignmentRegionSetting
VARIES

Indicates how location assignment works for the location. Possible values are:

Disallow
Allow Worldwide
Allow Worldwide Except Excluded Regions
Allow Specified Regions Only

bufferStock
INTEGER, STRING

The minimum quantity of inventory to be maintained at the location.

businessHoursList
VARIES

classTranslationList
VARIES

customFieldList
VARIES

dailyShippingCapacity
INTEGER, STRING

The maximum number of orders that can be shipped from the location in a single day. Shipping capacity is based on the number of fulfillment requests created for the location in a one day interval.

excludeLocationRegionsList
VARIES

externalId
STRING

geolocationMethod
VARIES

The method by which automatic location assignment establishes the geographic position of the location:

includeChildren
BOOLEAN, STRING

Indicates whether the location associated with all the sub-subsidiaries associated with each selected subsidiary.

includeLocationRegionsList
VARIES

isInactive
BOOLEAN, STRING

Indicates if the location is inactive.

latitude
NUMBER, STRING

The latitude coordinate of the location.

locationType
VARIES

The type of the location. Possible values include:

Store
Warehouse
Undefined

logo
VARIES

The logo for the location.

longitude
NUMBER, STRING

The longitude coordinate of the location.

mainAddress
VARIES

The main address of the location.

makeInventoryAvailable
BOOLEAN, STRING

Indicates if on-hand inventory stored at the location is available to orders.

makeInventoryAvailableStore
BOOLEAN, STRING

Indicates if on-hand inventory stored at the location is included in the total quantity available that displays in the Web Store.

name
STRING

The name of the location.

nextPickupCutOffTime
DATE-TIME

The next cut-off time for same-day pickup orders at the location.

nullFieldList
VARIES

parent
VARIES

The parent location, if applicable.

returnAddress
VARIES

The return address for the location.

storePickupBufferStock
NUMBER, STRING

The minimum inventory to be maintained at the location when creating store pickup orders.

subsidiaryList
VARIES

timeZone
VARIES

The time zone of the location.

totalShippingCapacity
INTEGER, STRING

The maximum number of shipping orders that can accumulate in the backlog of orders to be shipped from the location.

tranPrefix
STRING

The value that is prefixed to transactions from this location.

useBins
BOOLEAN, STRING

Indicates if bins are used to track inventory at the location.

Nexus

View table schema on GitHub

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

The Nexus table contains info about the tax jurisdictions - or nexus - in your NetSuite account. A nexus is a tax jurisdiction, usually defined at the country level.

Nexus table replication requirements

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

Tax > Advanced Taxes

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

Nexus table schema

internalId
STRING

country
VARIES

description
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

nullFieldList
VARIES

parentNexus
VARIES

state
VARIES

taxAgency
VARIES

taxAgencyPst
VARIES

taxCode
VARIES

Partner

View table schema on GitHub

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

The Partner table contains info about the partners in your NetSuite account.

Partner table replication requirements

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

CRM > Partner Relationship Management

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

Partner table schema

internalId
STRING

lastModifiedDate
DATE-TIME

_class
VARIES

accessRole
VARIES

addressbookList
VARIES

altEmail
STRING

altName
STRING

bcn
STRING

categoryList
VARIES

comments
STRING

companyName
STRING

contactRolesList
VARIES

customFieldList
VARIES

customForm
VARIES

dateCreated
DATE-TIME

defaultAddress
STRING

department
VARIES

eligibleForCommission
BOOLEAN, STRING

email
STRING

emailPreference
VARIES

entityId
STRING

externalId
STRING

fax
STRING

firstName
STRING

giveAccess
BOOLEAN, STRING

globalSubscriptionStatus
VARIES

homePhone
STRING

image
VARIES

isInactive
BOOLEAN, STRING

isPerson
BOOLEAN, STRING

lastName
STRING

location
VARIES

loginAs
STRING

middleName
STRING

mobilePhone
STRING

nullFieldList
VARIES

parent
VARIES

partnerCode
STRING

password
STRING

password2
STRING

phone
STRING

phoneticName
STRING

printOnCheckAs
STRING

promoCodeList
VARIES

referringUrl
STRING

requirePwdChange
BOOLEAN, STRING

roleList
VARIES

salutation
STRING

sendEmail
BOOLEAN, STRING

subPartnerLogin
BOOLEAN, STRING

subscriptionsList
VARIES

subsidiary
VARIES

taxFractionUnit
VARIES

taxIdNum
STRING

taxRounding
VARIES

title
STRING

url
STRING

vatRegNumber
STRING

Topic

View table schema on GitHub

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

The Topic table contains info about the topics used to organize knowledge base solutions in your NetSuite account.

Topic table replication requirements

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

CRM > Knowledge Base

Topic table schema

internalId
STRING

description
STRING

externalId
STRING

isInactive
BOOLEAN, STRING

longDescription
STRING

nullFieldList
VARIES

parentTopic
VARIES

solutionList
VARIES

title
STRING

Questions? Feedback?

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

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Syncing Historical SaaS Data Resetting Replication Keys Nested Data Structures & Row Count Impact	Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues