Netsuite
Netsuite is an enterprise resource planning (ERP) system. Use the Netsuite connector to replicate data from your Netsuite account into your data warehouse.
Netsuite integration replicates data using the Netsuite SOAP API.
See the Schema section for a list of objects available for replication.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
You need administrator permissions in your Netsuite account. Log into your Netsuite account before completing the following procedures.
To enable the Connect Service feature:
- Navigate to Setup > Company > Enable Features.
- Click the SuiteCloud subtab.
- Locate the SuiteTalk Web Services section.
- Select the SOAP Web Services checkbox.
- Click Save.
To retrieve your service host, service port and account ID:
- On the homepage, locate the Settings module and click Set Up SuiteAnalytics Connect.
- Copy and paste your service host, service port and account ID into a secured file.
To enable token-based authentication:
- Navigate to Setup > Company > Enable Features.
- Click the SuiteCloud subtab.
- In the Manage Authentication section, select the Token-based Authentication checkbox.
- Click Save.
To create an integration record for an application:
- Navigate to Setup > Integration > Manage Integrations > New.
- Enter a Name and a Description for your application.
- Set State to Enabled.
- On the Authentication subtab, select the Token-based Authentication checkbox and clear the Authorization Code Grant checkbox.
- Click Save.
- Copy and paste your consumer key and secret into a secured file.
To create a role:
- Navigate to Setup > Users/Roles > Manage Roles > New Role.
- In the General subtab, enter the role details.
- In the Authentication subtab, select Web Service only role. Click Save.
- In the Permissions subtab, under Setup, add the following permissions:
Permissions Level Custom Body Field View Custom Fields View Custom Record Types View Deleted Records Full SOAP Web Services Full User Access Token Full - Click Save.
The permissions listed above are the minimum required to create a successful connection between Qlik Talend Cloud and your Netsuite instance. Qlik Talend Cloud may not be able to replicate every Netsuite object. To access additional objects or tables, you may need to grant extra permissions for specific use cases.
To assign a role to a user:
- Navigate to Setup > Users/Roles > Manage User.
- Click Edit next to the user.
- Click the Access subtab.
- On the Roles subtab, select the role you previously created.
- Click Save.
To create your token ID and token secret:
- Navigate to Setup > Users/Roles > Access Tokens > New.
- Enter the following information:
- In Application Name, select the application you created.
- In User, select the integration user.
- In Role, select the role you created.
- Click Save.
- Copy and paste your token ID and token secret into a secured file.
To retrieve the internal ID of the role you created:
- Navigate to Setup > Users/Roles > Manage Roles.
- Locate the internal ID next to the role you created.
In Netsuite, the list view does not display the internal ID of roles by default. To view the internal ID, customize the list view to include this column.
To authorize the Qlik Talend Cloud IP address:
This step is only required if IP Address rules are enabled in your Netsuite account.
- Find your Qlik Talend Cloud IP address: Qlik Cloud IP addresses.
- Log into your Netsuite account.
- Navigate to Setup > Company > Company Information.
- In the Allowed IP Addresses field, enter the Qlik Talend Cloud IP addresses.
For more details, see the Netsuite help documentation.
Creating the connection
For more information, see Connecting to SaaS applications.
- Fill in the required connection properties.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.
Click Create.
| Setting | Description |
|---|---|
| Data gateway | Select a Data Movement gateway if required by your use case. Information note This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None. For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement. |
| Start Date | Enter the date, in the format |
| Account ID | Account ID. |
| Role ID | Internal role ID. |
| Host | Service host name. |
| Port | Service port number. |
| Consumer Key | Consumer key. |
| Consumer Secret | Consumer secret. |
| Token ID | Token ID. |
| Token Secret | Token secret. |
Supported Netsuite transaction types
Qlik Talend Cloud supports replicating the following transaction types. Data for these records is available 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
Qlik Talend Cloud supports replicating the following item types. Data for these records is available 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
Qlik Talend Cloud supports replicating all record types from Netsuite’s 2017.2 WSDL, except for the following:
- AccountingTransaction
- AssemblyItemBom
- Entity
- InventoryDetail
- InventoryNumberbin
- ItemBinNumber
- MseSubsidary
- OriginatingLead
- Pricing
- ProjectTaskAssignment
- TaxDetail
Custom records
Custom record tables are named custrecord_[custom_record_name], where [custom_record_name] is the value of the ID field in the Custom Record Setup page in Netsuite.
Example: If a custom record is named promo discount in Netsuite, the corresponding table would be custrecord_promo_discount.
If the ID field is left blank, Netsuite auto-assigns a numerical ID, such as custrecord_123, where 123 is the generated ID.
The replication method that Qlik Talend Cloud uses for each custom record type depends on whether the Show Last Modified setting is enabled in Netsuite. This setting controls if the Netsuite SuiteTalk API provides a timestamp column for use as a replication key.
- If Show Last Modified is enabled, Qlik Talend Cloud uses Key-based Incremental Replication. Only new and updated records are replicated for each job.
- If Show Last Modified is not enabled, Qlik Talend Cloud uses Full Table Replication. All records are 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 the global search and select the Page: Record Types result.
- Find and click the custom record type in the list to open its Custom Record Type page.
- Locate the Show Last Modified setting.
If you do not see datasets available for selection, verify that the integration user is using the custom role described above and that the role has access to the required tables.
To review role permissions in Netsuite, navigate to Setup > Users/Roles > Manage Roles, search for the role, click Edit, and then open the Permissions tab and the Lists section. For details, see Netsuite role permissions.
When selecting datasets for replication, Qlik Talend Cloud recommends replicating the oa_fkeys table to help build analytics across explicit and custom foreign keys. For reference, see Netsuite foreign keys documentation. The foreign key information in that table may be inaccurate and is provided for reference only.
Deleted records
To track deleted records in Netsuite, Qlik Talend Cloud’s Netsuite integration provides a table named Deleted. When replication for this table is enabled, it serves as a log for records deleted in Netsuite.
According to Netsuite documentation, only certain record types support the getDeleted API operation used by Qlik Talend Cloud to retrieve deleted record data through the SuiteTalk API.
The table below lists record types that support deletes and shows the corresponding table or dataset name for each type. If a record type appears in this list, deleted records of that type will be logged in the Deleted table.
Note: If a record type is not in this list, it does not support deletes. Records not listed will not be included in the Deleted table, even if deleted in Netsuite.
| Netsuite Record Type | Dataset/Table Name |
|---|---|
| AdvInterCompanyJournalEntry | Transaction |
| AssemblyBuild | Transaction |
| AssemblyItem | Item |
| AssemblyUnbuild | Transaction |
| BillingSchedule | BillingSchedule |
| Bin | Bin |
| BinTransfer | Transaction |
| BinWorksheet | Transaction |
| Bom | Bom |
| BomRevision | BomRevision |
| CalendarEvent | CalendarEvent |
| Campaign | Campaign |
| CashRefund | Transaction |
| CashSale | Transaction |
| Charge | Charge |
| Check | Transaction |
| Contact | Contact |
| ContactCategory | ContactCategory |
| CostCategory | CostCategory |
| CouponCode | CouponCode |
| CreditMemo | Transaction |
| CurrencyRate | CurrencyRate |
| customRecord | customrecord_[custom_record_name] |
| CustomTransaction | Transaction |
| Customer | Customer |
| CustomerCategory | CustomerCategory |
| CustomerMessage | CustomerMessage |
| CustomerDeposit | Transaction |
| CustomerPayment | Transaction |
| CustomerRefund | Transaction |
| CustomerStatus | CustomerStatus |
| CustomerSubsidiaryRelationship | CustomerSubsidiaryRelationship |
| Deposit | Transaction |
| DepositApplication | Transaction |
| DescriptionItem | Item |
| DiscountItem | Item |
| DownloadItem | Item |
| Employee | Employee |
| Estimate | Transaction |
| ExpenseReport | Transaction |
| File | File |
| Folder | Folder |
| GiftCertificateItem | Item |
| GlobalAccountMapping | GlobalAccountMapping |
| InterCompanyJournalEntry | Transaction |
| InterCompanyTransferOrder | Transaction |
| InventoryAdjustment | Transaction |
| InventoryCostRevaluation | Transaction |
| InventoryItem | Item |
| InventoryNumber | InventoryNumber |
| InventoryTransfer | Transaction |
| Invoice | Transaction |
| Issue | Issue |
| ItemAccountMapping | ItemAccountMapping |
| ItemDemandPlan | ItemDemandPlan |
| ItemFulfillment | Transaction |
| ItemSupplyPlan | ItemSupplyPlan |
| ItemGroup | Item |
| ItemRevision | ItemRevision |
| Job | Job |
| JobStatus | JobStatus |
| JournalEntry | Transaction |
| KitItem | Item |
| LotNumberedAssemblyItem | Item |
| LotNumberedInventoryItem | Item |
| MarkupItem | Item |
| Message | Message |
| ManufacturingCostTemplate | ManufacturingCostTemplate |
| ManufacturingOperationTask | ManufacturingOperationTask |
| ManufacturingRouting | ManufacturingRouting |
| MerchandiseHierarchyNode | MerchandiseHierarchyNode |
| Nexus | Nexus |
| NonInventoryPurchaseItem | Item |
| NonInventoryResaleItem | Item |
| NonInventorySaleItem | Item |
| Note | Note |
| NoteType | NoteType |
| Opportunity | Opportunity |
| OtherChargePurchaseItem | Item |
| OtherChargeResaleItem | Item |
| OtherChargeSaleItem | Item |
| OtherNameCategory | OtherNameCategory |
| Partner | Partner |
| Paycheck | Transaction |
| PaymentItem | Item |
| PaymentMethod | PaymentMethod |
| PayrollItem | PayrollItem |
| PhoneCall | PhoneCall |
| PriceLevel | PriceLevel |
| PricingGroup | PricingGroup |
| ProjectTask | ProjectTask |
| PromotionCode | PromotionCode |
| PurchaseOrder | Transaction |
| ResourceAllocation | ResourceAllocation |
| ReturnAuthorization | Transaction |
| SalesOrder | Transaction |
| SalesTaxItem | Item |
| SerializedAssemblyItem | Item |
| SerializedInventoryItem | Item |
| ServicePurchaseItem | Item |
| ServiceResaleItem | Item |
| ServiceSaleItem | Item |
| StatisticalJournalEntry | Transaction |
| SubtotalItem | Item |
| SupportCase | SupportCase |
| Task | Task |
| Term | Term |
| TimeSheet | TimeSheet |
| TransferOrder | Transaction |
| Usage | Usage |
| Vendor | Vendor |
| VendorBill | Transaction |
| VendorCredit | Transaction |
| VendorPayment | Transaction |
| VendorReturnAuthorization | Transaction |
| VendorSubsidiaryRelationship | VendorSubsidiaryRelationship |
| WinLossReason | WinLossReason |
| WorkOrder | Transaction |
| WorkOrderIssue | Transaction |
| WorkOrderCompletion | Transaction |
| WorkOrderClose | Transaction |
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 2.
To ensure we can provide you with up-to-date documentation, this section will only cover a few of the most popular tables NetSuite integration offers.
Refer to the NetSuite SuiteTalk Schema Browser for information on objects not listed here, including the fields available in each object.
Depending on your destination, table and column names may not appear as they are outlined below.
Account
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 View permission in NetSuite.
| Replication Method | Full Table |
| Primary Key | internalId |
| Useful links |
AccountingPeriod
The AccountingPeriod table contains info about the accounting periods in your NetSuite account.
AccountingPeriod table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Address
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.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
BillingAccount
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
BillingSchedule
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Bin
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Bom
The Bom table contains info about bills of materials (BOM): the quantities of raw materials, assemblies, sub-components, and parts needed to manufacture a product.
Bom table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
BomRevision
The BomRevision table contains info about updates on bills of materials.
BomRevision table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Budget
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 View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
CalendarEvent
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 View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
Campaign
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 the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
| Useful links |
Charge
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Classification
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.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
ConsolidatedExchangeRate
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Contact
The Contact table contains info about contacts.
Contact table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
ContactCategory
The ContactCategory table contains info about the types of contacts in your NetSuite account.
ContactCategory table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
ContactRole
The ContactRole table contains info about contact roles in your NetSuite account.
ContactRole table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
CostCategory
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
CouponCode
The CouponCode table contains info about the coupon codes in your NetSuite account.
CouponCode table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
CurrencyRate
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 View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
CustomList
The CustomList table contains info about
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Customer
The Customer table contains info about customers.
Customer table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
CustomerCategory
The CustomerCategory table contains info about the types of customers in your NetSuite account.
CustomerCategory table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
CustomerMessage
The CustomerMessage table contains info about standardized customer messages in your NetSuite account.
CustomerMessage table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
CustomerStatus
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 View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
CustomerSubsidiaryRelationship
The CustomerSubsidiaryRelationship table contains info about customers shared with multiple subsidiaries.
CustomerSubsidiaryRelationship table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Deleted
The Deleted table contains info about deleted records.
Deleted table replication requirements
Replicating this table requires the View permission in NetSuite.
Objects with delete support
According to NetSuite’s documentation, only certain objects support the `` operation Qlik Talend Cloud 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.
Replication Method | CDC |
Primary Keys | internalId type |
Replication Key | deletedDate |
| Useful links |
Department
The Department table contains info about the departments in your NetSuite account.
Department table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Employee
The Employee table contains info about the employees in your NetSuite account.
Employee table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
EntityGroup
The EntityGroup table contains info about the groups in your NetSuite account.
EntityGroup table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
| Useful links |
ExpenseCategory
The ExpenseCategory table contains info about the expense categories in your NetSuite account.
ExpenseCategory table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
FairValuePrice
The FairValuePrice table contains info about the fair value price list in your NetSuite account.
FairValuePrice table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
File
The File table contains info about the files in your NetSuite File Cabinet.
File table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
| Useful links |
Folder
The Folder table contains info about the folders in your NetSuite File Cabinet.
Folder table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
| Useful links |
GiftCertificate
The GiftCertificate table contains info about the gift certificates in your NetSuite account.
GiftCertificate table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
GlobalAccountMapping
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
HcmJob
HcmJob table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
InboundShipment
The InboundShipment table contains info about inbound shipments in your NetSuite account.
InboundShipment table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
InventoryNumber
The InventoryNumber table contains info about the serial or lot numbers in your NetSuite account.
InventoryNumber table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Issue
The Issue table contains info about the support cases in your NetSuite account.
Issue table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
Item
The Item table contains info about items.
Item table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
ItemAccountMapping
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
ItemDemandPlan
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 the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
| Useful links |
ItemRevision
The ItemRevision table contains info about item revisions in your NetSuite account.
ItemRevision table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
ItemSupplyPlan
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 the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
| Useful links |
Job
The Job table contains info about the projects in your NetSuite account.
Job table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
JobStatus
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
JobType
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Location
The Location table contains info about locations.
Location table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
ManufacturingCostTemplate
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
ManufacturingOperationTask
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
ManufacturingRouting
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
MerchandiseHierarchyNode
The MerchandiseHierarchyNode table contains info about the the categorization of inventory items in your NetSuite account.
MerchandiseHierarchyNode table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Message
The Message table contains info about the messages in your NetSuite account.
Message table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Nexus
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Note
The Note table contains info about the notes in your NetSuite account.
Note table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
NoteType
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 View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Opportunity
The Opportunity table contains info about the opportunities in your NetSuite account.
Opportunity table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
OtherNameCategory
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Partner
The Partner table contains info about the partners in your NetSuite account.
Partner table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
PartnerCategory
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Paycheck
The Paycheck table contains info about the paycheck records in your NetSuite account.
Paycheck table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
PaymentMethod
The PaymentMethod table contains info about the customer payment methods in your NetSuite account.
PaymentMethod table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
PayrollItem
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
PhoneCall
The PhoneCall table contains info about the phone call records in your NetSuite account.
PhoneCall table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
PriceLevel
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 View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
PricingGroup
The PricingGroup table contains info about the pricing groups in your NetSuite account.
PricingGroup table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
ProjectTask
The ProjectTask table contains info about the project tasks in your NetSuite account.
ProjectTask table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
| Useful links |
PromotionCode
The PromotionCode table contains info about the promotion codes in your NetSuite account.
PromotionCode table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
ResourceAllocation
The ResourceAllocation table contains info about resource allocations, or employee time reservations, in your NetSuite account.
ResourceAllocation table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
RevRecSchedule
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
RevRecTemplate
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
SalesRole
The SalesRole table contains info about the sales roles in your NetSuite account.
SalesRole table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
SalesTaxItem
The SalesTaxItem table contains info about the sales tax items in your NetSuite account.
SalesTaxItem table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
SiteCategory
The SiteCategory table contains info about the categories used to organize your website.
SiteCategory table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Solution
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 the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
Subsidiary
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
SupportCase
The SupportCase table contains info about the support cases in your NetSuite account.
SupportCase table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
Task
The Task table contains info about the tasks in your NetSuite account.
Task table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
TaxGroup
The TaxGroup table contains info about the tax groups in your NetSuite account.
TaxGroup table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
TaxType
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 View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Term
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 View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
TimeBill
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 the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
TimeEntry
The TimeEntry table contains info about the time entries in your NetSuite account.
TimeEntry table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
TimeSheet
The TimeSheet table contains info about the time sheets in your NetSuite account.
TimeSheet table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Topic
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Transaction
The Transaction table contains info about transactions.
Supported transaction types
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 View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
UnitsType
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Usage
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 the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
Vendor
The Vendor table contains info about the vendors in your NetSuite account.
Vendor table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | CDC |
Primary Key | internalId |
Replication Key | lastModifiedDate |
| Useful links |
VendorCategory
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 View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
VendorSubsidiaryRelationship
The VendorSubsidiaryRelationship table contains info about vendors shared with multiple subsidiaries.
VendorSubsidiaryRelationship table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |
WinLossReason
The WinLossReason table contains info about the win/loss reasons in your NetSuite account.
WinLossReason table replication requirements
Replicating this table requires the View permission in NetSuite.
Replication Method | Full Table |
Primary Key | internalId |
| Useful links |