- Introduction
- Getting Started
- Creating an Account in Hevo
- Subscribing to Hevo via AWS Marketplace
-
Connection Options
- Connecting Through SSH
- Connecting Through Reverse SSH Tunnel
- Connecting Through VPN
- Connecting Through Mongo PrivateLink
- Connecting Through AWS Transit Gateway
- Connecting Through AWS VPC Endpoint
- Connecting Through AWS VPC Peering
- Using Google Account Authentication
- How Hevo Authenticates Sources and Destinations using OAuth
- Reauthorizing an OAuth Account
- Familiarizing with the UI
- Creating your First Pipeline
- Data Loss Prevention and Recovery
- Data Ingestion
- Data Loading
- Loading Data in a Database Destination
- Loading Data to a Data Warehouse
- Optimizing Data Loading for a Destination Warehouse
- Deduplicating Data in a Data Warehouse Destination
- Manually Triggering the Loading of Events
- Scheduling Data Load for a Destination
- Loading Events in Batches
- Data Loading Statuses
- Data Spike Alerts
- Name Sanitization
- Table and Column Name Compression
- Parsing Nested JSON Fields in Events
- Pipelines
- Data Flow in a Pipeline
- Familiarizing with the Pipelines UI
- Working with Pipelines
- Managing Objects in Pipelines
- Pipeline Jobs
-
Transformations
-
Python Code-Based Transformations
- Supported Python Modules and Functions
-
Transformation Methods in the Event Class
- Create an Event
- Retrieve the Event Name
- Rename an Event
- Retrieve the Properties of an Event
- Modify the Properties for an Event
- Fetch the Primary Keys of an Event
- Modify the Primary Keys of an Event
- Fetch the Data Type of a Field
- Check if the Field is a String
- Check if the Field is a Number
- Check if the Field is Boolean
- Check if the Field is a Date
- Check if the Field is a Time Value
- Check if the Field is a Timestamp
-
TimeUtils
- Convert Date String to Required Format
- Convert Date to Required Format
- Convert Datetime String to Required Format
- Convert Epoch Time to a Date
- Convert Epoch Time to a Datetime
- Convert Epoch to Required Format
- Convert Epoch to a Time
- Get Time Difference
- Parse Date String to Date
- Parse Date String to Datetime Format
- Parse Date String to Time
- Utils
- Examples of Python Code-based Transformations
-
Drag and Drop Transformations
- Special Keywords
-
Transformation Blocks and Properties
- Add a Field
- Change Datetime Field Values
- Change Field Values
- Drop Events
- Drop Fields
- Find & Replace
- Flatten JSON
- Format Date to String
- Format Number to String
- Hash Fields
- If-Else
- Mask Fields
- Modify Text Casing
- Parse Date from String
- Parse JSON from String
- Parse Number from String
- Rename Events
- Rename Fields
- Round-off Decimal Fields
- Split Fields
- Examples of Drag and Drop Transformations
- Effect of Transformations on the Destination Table Structure
- Transformation Reference
- Transformation FAQs
-
Python Code-Based Transformations
-
Schema Mapper
- Using Schema Mapper
- Mapping Statuses
- Auto Mapping Event Types
- Manually Mapping Event Types
- Modifying Schema Mapping for Event Types
- Schema Mapper Actions
- Fixing Unmapped Fields
- Resolving Incompatible Schema Mappings
- Resizing String Columns in the Destination
- Schema Mapper Compatibility Table
- Limits on the Number of Destination Columns
- File Log
- Troubleshooting Failed Events in a Pipeline
- Mismatch in Events Count in Source and Destination
- Audit Tables
- Activity Log
-
Pipeline FAQs
- Can multiple Sources connect to one Destination?
- What happens if I re-create a deleted Pipeline?
- Why is there a delay in my Pipeline?
- Can I change the Destination post-Pipeline creation?
- Why is my billable Events high with Delta Timestamp mode?
- Can I drop multiple Destination tables in a Pipeline at once?
- How does Run Now affect scheduled ingestion frequency?
- Will pausing some objects increase the ingestion speed?
- Can I see the historical load progress?
- Why is my Historical Load Progress still at 0%?
- Why is historical data not getting ingested?
- How do I set a field as a primary key?
- How do I ensure that records are loaded only once?
- Events Usage
- Sources
- Free Sources
-
Databases and File Systems
- Data Warehouses
-
Databases
- Connecting to a Local Database
- Amazon DocumentDB
- Amazon DynamoDB
- Elasticsearch
-
MongoDB
- Generic MongoDB
- MongoDB Atlas
- Support for Multiple Data Types for the _id Field
- Example - Merge Collections Feature
-
Troubleshooting MongoDB
-
Errors During Pipeline Creation
- Error 1001 - Incorrect credentials
- Error 1005 - Connection timeout
- Error 1006 - Invalid database hostname
- Error 1007 - SSH connection failed
- Error 1008 - Database unreachable
- Error 1011 - Insufficient access
- Error 1028 - Primary/Master host needed for OpLog
- Error 1029 - Version not supported for Change Streams
- SSL 1009 - SSL Connection Failure
- Troubleshooting MongoDB Change Streams Connection
- Troubleshooting MongoDB OpLog Connection
-
Errors During Pipeline Creation
- SQL Server
-
MySQL
- Amazon Aurora MySQL
- Amazon RDS MySQL
- Azure MySQL
- Generic MySQL
- Google Cloud MySQL
- MariaDB MySQL
-
Troubleshooting MySQL
-
Errors During Pipeline Creation
- Error 1003 - Connection to host failed
- Error 1006 - Connection to host failed
- Error 1007 - SSH connection failed
- Error 1011 - Access denied
- Error 1012 - Replication access denied
- Error 1017 - Connection to host failed
- Error 1026 - Failed to connect to database
- Error 1027 - Unsupported BinLog format
- Failed to determine binlog filename/position
- Schema 'xyz' is not tracked via bin logs
- Errors Post-Pipeline Creation
-
Errors During Pipeline Creation
- MySQL FAQs
- Oracle
-
PostgreSQL
- Amazon Aurora PostgreSQL
- Amazon RDS PostgreSQL
- Azure PostgreSQL
- Generic PostgreSQL
- Google Cloud PostgreSQL
- Heroku PostgreSQL
-
Troubleshooting PostgreSQL
-
Errors during Pipeline creation
- Error 1003 - Authentication failure
- Error 1006 - Connection settings errors
- Error 1011 - Access role issue for logical replication
- Error 1012 - Access role issue for logical replication
- Error 1014 - Database does not exist
- Error 1017 - Connection settings errors
- Error 1023 - No pg_hba.conf entry
- Error 1024 - Number of requested standby connections
- Errors Post-Pipeline Creation
-
Errors during Pipeline creation
- PostgreSQL FAQs
- Troubleshooting Database Sources
- File Storage
- Engineering Analytics
- Finance & Accounting Analytics
-
Marketing Analytics
- ActiveCampaign
- AdRoll
- Amazon Ads
- Apple Search Ads
- AppsFlyer
- CleverTap
- Criteo
- Drip
- Facebook Ads
- Facebook Page Insights
- Firebase Analytics
- Freshsales
- Google Ads
- Google Analytics
- Google Analytics 4
- Google Analytics 360
- Google Play Console
- Google Search Console
- HubSpot
- Instagram Business
- Klaviyo v2
- Lemlist
- LinkedIn Ads
- Mailchimp
- Mailshake
- Marketo
- Microsoft Ads
- Onfleet
- Outbrain
- Pardot
- Pinterest Ads
- Pipedrive
- Recharge
- Segment
- SendGrid Webhook
- SendGrid
- Salesforce Marketing Cloud
- Snapchat Ads
- SurveyMonkey
- Taboola
- TikTok Ads
- Twitter Ads
- Typeform
- YouTube Analytics
- Product Analytics
- Sales & Support Analytics
- Source FAQs
- Destinations
- Familiarizing with the Destinations UI
- Cloud Storage-Based
- Databases
-
Data Warehouses
- Amazon Redshift
- Amazon Redshift Serverless
- Azure Synapse Analytics
- Databricks
- Firebolt
- Google BigQuery
- Hevo Managed Google BigQuery
- Snowflake
-
Destination FAQs
- Can I change the primary key in my Destination table?
- How do I change the data type of table columns?
- Can I change the Destination table name after creating the Pipeline?
- How can I change or delete the Destination table prefix?
- Why does my Destination have deleted Source records?
- How do I filter deleted Events from the Destination?
- Does a data load regenerate deleted Hevo metadata columns?
- How do I filter out specific fields before loading data?
- Transform
- Alerts
- Account Management
- Activate
- Glossary
Releases- Release 2.30.3 (Dec 02-09, 2024)
- Release 2.30.2 (Nov 25-Dec 02, 2024)
- Release 2.30.1 (Nov 18-25, 2024)
- Release 2.30 (Oct 21-Nov 18, 2024)
-
2024 Releases
- Release 2.29 (Sep 30-Oct 22, 2024)
- Release 2.28 (Sep 02-30, 2024)
- Release 2.27 (Aug 05-Sep 02, 2024)
- Release 2.26 (Jul 08-Aug 05, 2024)
- Release 2.25 (Jun 10-Jul 08, 2024)
- Release 2.24 (May 06-Jun 10, 2024)
- Release 2.23 (Apr 08-May 06, 2024)
- Release 2.22 (Mar 11-Apr 08, 2024)
- Release 2.21 (Feb 12-Mar 11, 2024)
- Release 2.20 (Jan 15-Feb 12, 2024)
-
2023 Releases
- Release 2.19 (Dec 04, 2023-Jan 15, 2024)
- Release Version 2.18
- Release Version 2.17
- Release Version 2.16 (with breaking changes)
- Release Version 2.15 (with breaking changes)
- Release Version 2.14
- Release Version 2.13
- Release Version 2.12
- Release Version 2.11
- Release Version 2.10
- Release Version 2.09
- Release Version 2.08
- Release Version 2.07
- Release Version 2.06
-
2022 Releases
- Release Version 2.05
- Release Version 2.04
- Release Version 2.03
- Release Version 2.02
- Release Version 2.01
- Release Version 2.00
- Release Version 1.99
- Release Version 1.98
- Release Version 1.97
- Release Version 1.96
- Release Version 1.95
- Release Version 1.93 & 1.94
- Release Version 1.92
- Release Version 1.91
- Release Version 1.90
- Release Version 1.89
- Release Version 1.88
- Release Version 1.87
- Release Version 1.86
- Release Version 1.84 & 1.85
- Release Version 1.83
- Release Version 1.82
- Release Version 1.81
- Release Version 1.80 (Jan-24-2022)
- Release Version 1.79 (Jan-03-2022)
-
2021 Releases
- Release Version 1.78 (Dec-20-2021)
- Release Version 1.77 (Dec-06-2021)
- Release Version 1.76 (Nov-22-2021)
- Release Version 1.75 (Nov-09-2021)
- Release Version 1.74 (Oct-25-2021)
- Release Version 1.73 (Oct-04-2021)
- Release Version 1.72 (Sep-20-2021)
- Release Version 1.71 (Sep-09-2021)
- Release Version 1.70 (Aug-23-2021)
- Release Version 1.69 (Aug-09-2021)
- Release Version 1.68 (Jul-26-2021)
- Release Version 1.67 (Jul-12-2021)
- Release Version 1.66 (Jun-28-2021)
- Release Version 1.65 (Jun-14-2021)
- Release Version 1.64 (Jun-01-2021)
- Release Version 1.63 (May-19-2021)
- Release Version 1.62 (May-05-2021)
- Release Version 1.61 (Apr-20-2021)
- Release Version 1.60 (Apr-06-2021)
- Release Version 1.59 (Mar-23-2021)
- Release Version 1.58 (Mar-09-2021)
- Release Version 1.57 (Feb-22-2021)
- Release Version 1.56 (Feb-09-2021)
- Release Version 1.55 (Jan-25-2021)
- Release Version 1.54 (Jan-12-2021)
-
2020 Releases
- Release Version 1.53 (Dec-22-2020)
- Release Version 1.52 (Dec-03-2020)
- Release Version 1.51 (Nov-10-2020)
- Release Version 1.50 (Oct-19-2020)
- Release Version 1.49 (Sep-28-2020)
- Release Version 1.48 (Sep-01-2020)
- Release Version 1.47 (Aug-06-2020)
- Release Version 1.46 (Jul-21-2020)
- Release Version 1.45 (Jul-02-2020)
- Release Version 1.44 (Jun-11-2020)
- Release Version 1.43 (May-15-2020)
- Release Version 1.42 (Apr-30-2020)
- Release Version 1.41 (Apr-2020)
- Release Version 1.40 (Mar-2020)
- Release Version 1.39 (Feb-2020)
- Release Version 1.38 (Jan-2020)
- Early Access New
- Upcoming Features
NetSuite ERP
NetSuite ERP is a cloud business management platform that provides an integrated suite of applications to manage various business operations, such as account management, order processing, warehouse operations, and customer relationship management (CRM). This platform empowers companies to gain valuable insights into their business and enhance their decision-making capabilities.
Hevo uses the SuiteTalk SOAP Web Services Platform, which uses an XML-based API to replicate the data present in your Netsuite ERP account.
Hevo classifies the NetSuite objects into four categories: Transaction, Item, Custom objects, based on the type of data they contain. All the Standard and Custom NetSuite objects are ingested in Full Load mode while the Transaction and Item objects are ingested in Incremental mode. Refer to section, Data Model for the list of supported objects.
Prerequisites
-
An active Netsuite ERP account from which data is to be ingested exists.
-
You are logged in as an Administrator to create a role and user for Hevo and obtain the API credentials.
-
Hevo is assigned the required permissions to access your NetSuite ERP data.
-
You are assigned the Team Administrator, Team Collaborator, or Pipeline Administrator role in Hevo to create the Pipeline.
Obtaining the API Credentials
Hevo uses the Account ID, Consumer Key and Secret, and the Token ID and Secret for authentication on your NetSuite ERP account.
Note: You must log in as an Administrator to perform these steps.
To obtain these credentials, perform the following steps:
Step 1: Enable web services and token-based authentication
You must enable web services and token-based authentication for your NetSuite account, to use the SuiteTalk API and generate the access tokens to authenticate Hevo.
-
Log in to your NetSuite account as an Administrator user.
-
On the Home page, in the NetSuite global search bar, enter page: enable, and click the Page: Enable Features result.
-
On the Enable Features page, click SuiteCloud.
-
In the SuiteCloud tab:
-
In the SuiteTalk (Web Services) section, select the SOAP WEB SERVICES and REST WEB SERVICES check boxes.
-
In the Manage Authentication section, select the TOKEN-BASED AUTHENTICATION check box.
-
-
Click Save.
Step 2: Create an integration record for Hevo
An integration record is required to uniquely identify Hevo in your NetSuite account.
-
In the NetSuite global search bar, enter page: integrations, and click Page: Manage Integrations.
-
On the Integrations page, click New, and specify the following settings:
-
Name: A unique name for the integration. For example, HEVO.
-
Token-based Authentication: Select this check box to allow Hevo to access your data.
-
-
Click Save.
-
On the confirmation page that is displayed, from the Consumer key/secret section, copy the consumer key and secret and save them securely like any other password.
You can use these credentials while configuring your Hevo Pipeline.
Step 3: Create a role for Hevo and configure permissions
We recommend that you create a Hevo-specific role and user so that it is easier to assign and manage the permissions required for Hevo to replicate your data.
To do this, perform the following steps:
-
In the NetSuite global search bar, enter page: new role, and click Page: New Role.
-
On the Role page, enter a name for the role in the Name field. For example, HevoRole.
-
In the Authentication section, select the WEB SERVICES ONLY ROLE check box.
-
On the Role page, under the Permissions section, click on each tab, add the permissions for the role, and click Add. Read Hevo Role Permissions to know about the permissions required for Hevo to access data.
-
After permissions for all tabs are added, click Save.
Step 4: Create a Hevo user
-
In the NetSuite global search bar, enter page: new employee, and click Page: New Employees.
-
On the Employee page, enter the NAME, EMAIL, SUBSIDIARY, and any other required fields.
-
Scroll down and click the Access tab. In the Access tab, do the following:
-
Select the GIVE ACCESS check box.
-
Select the MANUALLY ASSIGN OR CHANGE PASSWORD check box to create a password for the Hevo user.
-
In the Roles section, from the ROLE drop-down, select the Hevo role that you created in Step 3.
-
Click Add.
-
-
Click Save.
You have successfully created a user for Hevo.
Step 5: Create an access token
Perform the following steps to create an access token for Hevo:
-
In the NetSuite global search bar, enter page: tokens, and click Page: Access Tokens.
-
On the Access Tokens page, click New Access Token.
-
On the Access Token page, specify the following details:
-
Click Save.
-
From the confirmation page that is displayed, copy the Token ID and Secret and save them securely like any other password.
You can use these credentials while configuring your Hevo Pipeline.
Step 6: Find your NetSuite account ID and subdomain
Hevo needs your NetSuite account ID and subdomain to identify your account and access the NetSuite data for ingestion.
To obtain these:
-
In the NetSuite global search, enter page: web services and click Page: Web Services Preferences.
-
On the SOAP Web Services Preferences page, from the Primary Information section, copy the Account ID and save it securely like any other password.
-
Extract your NetSuite ERP subdomain from your dashboard URL. For example, if your dashboard URL is https://xyz.app.netsuite.com/, the subdomain is xyz.
You can use these credentials while configuring your Hevo Pipeline.
Configuring Netsuite ERP as a Source
Perform the following steps to configure Netsuite ERP as the Source in your Pipeline:
-
Click PIPELINES in the Navigation Bar.
-
Click + CREATE PIPELINE in the Pipelines List View.
-
On the Select Source Type page, select Netsuite ERP.
-
On the Configure your Netsuite ERP Source page, specify the following:
-
Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.
-
Account ID: The unique ID that you obtained from your Netsuite account.
-
Subdomain: The subdomain that you obtained from your Netsuite account URL. For example, in https://53434645-sb1.app.netsuite.com, the subdomain is 53434645-sb1.
-
Consumer Key: The key that you obtained upon creating the integration record for Hevo.
-
Consumer Secret: The consumer secret that you obtained from your Netsuite account upon creating the integration record for Hevo.
-
Token ID: The ID of the access token that you created in your Netsuite account, to allow Hevo to access your data.
-
Token Secret: The secret for the token that you created in your Netsuite account.
-
Historical Sync Duration: The duration for which you want to ingest the existing data from the Source. Default duration: 1 Year.
Note: If you select All Available Data, Hevo ingests all the data available in your NetSuite ERP account since January 01, 1970.
-
-
Click TEST & CONTINUE.
-
Proceed to configuring the data ingestion and setting up the Destination.
Data Replication
For Teams Created | Default Ingestion Frequency | Minimum Ingestion Frequency | Maximum Ingestion Frequency | Custom Frequency Range (in Hrs) |
---|---|---|---|---|
Before Release 2.21 | 3 Hrs | 1 Hr | 24 Hrs | 1-12 |
After Release 2.21 | 6 Hrs | 30 Mins | 24 Hrs | 1-24 |
Note: The custom frequency must be set in hours as an integer value. For example, 1, 2, or 3 but not 1.5 or 1.75.
-
Historical Data: The first run of the Pipeline ingests historical data for the selected objects on the basis of the historical sync duration specified at the time of creating the Pipeline and loads it to the Destination. Default duration: 1 Year.
-
Incremental Data: Once the historical load is completed, all new and updated records for the Transaction and Item objects are ingested as per the ingestion frequency. The Standard and Custom objects are ingested in Full Load mode.
Note: Full Load objects are ingested every 24 hours irrespective of the ingestion frequency.
Schema and Primary Keys
Hevo uses the following schema to upload the records in the Destination database:
Note: For the Transaction and Item objects, the schema of the Destination tables varies based on the transaction and item types. In the ERD below, the headers of the Destination table schema are suffixed with -<transaction type> and -<item type> to provide clarity about different transaction and item types. The actual tables in the Destination database are not demarcated this way.
Note: Hevo uses InternalId
as the primary key for all objects.
Data Model
The NetSuite objects are classified by Hevo into four categories to distinguish the type of data being ingested:
-
Transaction: The transaction object contains data about your business events, such as financial agreements between your business and your customers or vendors, and inventory adjustments. The various categories of business transactions within NetSuite are referred to as transaction types. Each type represents a different kind of business activity. Depending on the transaction type, the columns replicated in the Transaction table at the Destination vary.
-
Item: The item object contains details of the inventory items that you buy and sell, assemblies you manufacture, or services you provide to customers. The various categories of items that can be managed within NetSuite are referred to as item types. Each item type has a specific set of attributes. Depending on the item type, the columns replicated in the Item table at the Destination vary.
-
Custom: Custom objects created in your NetSuite account store data that is unique to your organization’s business needs.
-
Standard: All other objects are classified as standard objects, and are ingested into their respective tables.
Transaction Types
The following are the types of transactions that determine the schema of the Transaction table replicated at the Destination database:
Note: All transaction types are ingested using incremental mode.
Transaction Types |
---|
Assembly Build |
Assembly Unbuild |
Bin Transfer |
Bin Worksheet |
Cash Refund |
Cash Sale |
Check |
Credit Memo |
Customer Deposit |
Customer Payment |
Customer Refund |
Deposit |
Deposit Application |
Estimate |
Expense Report |
Inventory Transfer |
Inter Company Journal Entry |
Inventory Adjustment |
Inventory Cost Revaluation |
Invoice |
Item Fullfilment |
Item Receipt |
Journal Entry |
Paycheck Journal |
Purchase Order |
Return Authorization |
Sales Order |
Statistical Journal Entry |
Transfer Order |
VendorBill |
Vendor Credit |
Vendor Payment |
Vendor Return Authorization |
Work Order |
Work Order Close |
Work Order Completion |
Work Order Issue |
Item Types
The following are the types of items that determine the schema of the Item table replicated at the Destination database:
Note: All item types are ingested using incremental mode.
Item Types |
---|
Assembly Item |
Description Item |
Discount Item |
Download Item |
GiftCertificate Item |
Inventory Item |
Item Group |
Kit Item |
Lot Numbered Assembly Item |
Lot Numbered Inventory Item |
Markup Item |
NonInventory Purchase Item |
NonInventory Resale Item |
NonInventorySaleItem |
Other Charge Purchase Item |
Other Charge Resale Item |
Other Charge SaleItem |
Payment Item |
Serialized Assembly Item |
Serialized Inventory Item |
Service Purchase Item |
Service Resale Item |
Service Sale Item |
Subtotal Item |
Standard Objects
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
Note: All standard objects are Full Load.
Object | Description |
---|---|
Account | Contains the details of all the accounts in the Chart of Accounts (COA) in your NetSuite account. |
Accounting Period | Contains the details about all the accounting periods in your NetSuite account. |
Address | Contains the details about the custom address forms used to store addresses such as customer and vendor addresses in your NetSuite account. |
Billing Account | Contains the details about the billing information for a customer such as billing-specific information, including billing schedule, default payment terms, bill-to address, and currency. |
Billing Schedule | Contains the details of the billing schedules in your NetSuite account which are used to define how bills for transactions are sent to customers. |
Bin | Contains the details of the locations in your warehouse used to store inventory items. |
Budget | Contains the details of expected income and expenses for your business. |
Calendar Event | Contains details about the events on the calendar in your NetSuite account. |
Campaign | Contains the details of the marketing campaigns in your NetSuite account. |
Charge | Contains the details of all the billable amounts for your clients in your NetSuite account. |
Classification | Contains details about the categories that you can use to identify and categorize records in your NetSuite account. |
Consolidated Exchange Rate | Contains the details of the consolidate exchange rate used to translate financial reports from one subsidiary’s base currency to its parent company’s base currency. |
Contact | Contains the details of all the individuals that you have business relationships with. |
Contact Category | Contains the details about the types of contacts in your NetSuite account. |
ContactRole | Contains the details of all the roles that have been assigned to your contacts. |
Cost Category | Contains the details about the categories used to classify the different types of costs associated with items. |
Coupon Code | Contains the details of all the coupon codes in your NetSuite account. |
CurrencyRate | Contains the details of all the currency rate records in you NetSuite account. |
Customer | Contains the details of all your customers. |
Customer Category | Contains the details of the groups used to classify your customers. |
Customer Message | Contains details about the standardized customer messages in your NetSuite account. |
Customer Status | Contains the details about all the deal stages that are used to classify your leads, prospects, and customers. |
Custom List | Contains the list of values that you can use in custom fields on your forms and records. |
Department | Contains the details about the categories that you can create to classify and track records in your NetSuite account. |
Employee | Contains the details about all the employees in your NetSuite account such as name and address. |
Entity Group | Contains the details about all the groups in your NetSuite account. A group is a set of employees, contacts, customers, partners or vendors. |
Expense Category | Contains the details about the type of expenses in your NetSuite account. |
Fair Value Price | Contains the details of all the fair value prices of different items in your NetSuite account. |
File | Contains the details of all the files in your Netsuite file cabinet which is used to store your business documents. |
Folder | Contains the details of all the folders in your NetSuite file cabinet. |
Gift Certificate | Contains the details of all the gift certificates that allow customers to purchase store credit to send to someone as a gift. |
Global Account Mapping | Contains the details of the global account mapping records that enable you to configure secondary accounting books to post to accounts different from the primary book. |
HcmJob | Contains the details about the employee jobs such as the job title and jobID. |
Inbound Shipment | Contains the details of all the info about inbound shipments in your NetSuite account. |
Inventory Number | Contains the details of the numbers used to uniquely identify an item in physical inventory. |
Issue | Contains the details of the defects or enhancement requests in your NetSuite account. |
Item Account Mapping | Contains the details of the mapping of an item to an accounting book for accounts using multi-book accounting. |
Item Demand Plan | Contains the details such as quantity expected to be needed, during specified time periods, for an item. |
ItemRevision | Contains the details of item revision records. Item revision records define the items which should be included in assembly builds during specific time frames. |
Item Supply Plan | Contains details about the item supply plan which lists the purchase orders or work orders required to ensure that item quantity meets expected demand. |
Job | Contains the details about the projects in your NetSuite account. |
Job Status | Contains the statuses that can be applied to projects in your NetSuite account. |
Job Type | Contains the details about the types that can be applied to projects in your NetSuite account. |
Location | Contains the details about the locations of employees and transactions. |
Manufacturing Cost Template | Contains the details of the manufacturing cost template which contains the list of rates that can be associated with completing a specific operation. |
Manufacturing Operation Task | Contains the details of all the manufacturing operation tasks in your NetSuite account. |
Manufacturing Routing | Contains the details about the manufacturing routing templates in your NetSuite account. The templates contain the list of steps required to build an assembly item. |
Message | Contains the details of the messages sent to an existing customer, contact, or a lead. |
Nexus | Contains the details about the tax jurisdictions for your NetSuite account. |
Note | Contains the details about the notes used to track any changes made to a record. |
NoteType | Contains the details of all the types that can be used to separate notes. |
Opportunity | Contains the details of the conversations with prospects in your NetSuite account. |
Other Name Category | Contains the details of the categories used to classify people or companies who are not vendors, customers, or employees. |
Partner | Contains the details about the partners that help you implement and configure NetSuite based on your particular business needs. |
Partner Category | Contains the details of the categories used to classify your partners. |
Paycheck | Contains the details of all the pay checks in your NetSuite account. |
Payment Method | Contains the details of all the payment methods used by your customers. |
Payroll Item | Contains the details of payroll items such as salary and expenses. |
Phone Call | Contains the details of the phone call records in your NetSuite account. |
Price Level | Contains the list of prices that can be applied to an item. |
Pricing Group | Contains the details of all the pricing groups. For example, a pricing group called Chairs and associate the pricing group with all of your chair items. |
Project Task | Contains the details of the individual actions in a list of actions that must be completed to finish a project. |
Promotion Code | Contains the details of all the promotion codes in your NetSuite account. |
Resource Allocation | Contains the details about the resource allocation for the projects in your NetSuite account. |
RevRec Schedule | Contains the details of the time periods for which revenue should be recorded along with the amount of revenue, for an item sale. |
RevRec Template | Contains the details of the format in which the revenue should be recorded for items. |
Sales Role | Contains the details of the various sales roles in your NetSuite account. |
Sales Tax Item | Contains the details of the correct tax to be applied on an item ordered by a customer. |
Site Category | Contains the details of the categories used to organize items for sale in your store. |
Solution | Contains the details of all the replies to customer issues in your NetSuite account. |
Subsidiary | Contains the details of the companies within your organization. |
Support Case | Contains the details of the support issues submitted for your company to NetSuite support. |
Task | Contains the details of the tasks assigned to employees within your organization. |
Tax Group | Contains the details of all the tax groups in your NetSuite account. A tax group contains all the tax codes that can be applied to an item. |
Tax Type | Contains the details of the different types of taxes collected for an item. For example, VAT and GST. |
Term | Contains the details of the terms of payment on customer invoices. Terms specify when a payment is due. |
Time Bill | Contains the details of the hours worked by employees in an organization. |
Time Entry | Contains the details of the time entries submitted by employees to record the time spent on their tasks. |
Time Sheet | Contains the details of the timesheets which allow you to track the total number of hours that the employees have invested in a particular project. |
Topic | Contains the details about the topics used to organize knowledge base solutions. |
Units Type | Contains the details of the units of measurement in your NetSuite account. |
Usage | Contains the details of the charges for line items that can be consumed such as time and internet data. |
Vendor | Contains the details of all the vendors in your NetSuite account such as name and address. |
Vendor Category | Contains the details of all the categories used to classify vendors in your NetSuite account. |
WinLoss Reason | Contains the details of the reasons for winning or losing an opportunity. |
Source Considerations
Rate Limit: NetSuite imposes a limit on the concurrent API requests for each integration, for example, Hevo. This limit varies depending on your Netsuite account. Read Concurrency Governance Limits Based on Service Tiers and SuiteCloud Plus Licenses.
Revision History
Refer to the following table for the list of key updates made to this page:
Date | Release | Description of Change |
---|---|---|
Mar-05-2024 | 2.21 | Updated the ingestion frequency table in the Data Replication section. |
Apr-04-2023 | NA | Updated section, Configuring NetSuite ERP as a Source to update the information about historical sync duration. |
Feb-20-2023 | 2.08 | Removed the limitation about Hevo not supporting custom objects in Netsuite ERP as Hevo supports them now. |
Sep-02-2022 | 1.95 | New document. |