NetSuite integration summary

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

NetSuite feature snapshot

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

STITCH
Release status

Sunset on August 15, 2019

Supported by

Stitch

Stitch plan

Standard

API availability

Not available

Singer GitHub repository

Not applicable

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Unsupported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Unsupported

Select all

Supported

TRANSPARENCY
Extraction Logs

Unsupported

Loading Reports

Supported

NetSuite table reference

Deleted records

Stitch’s NetSuite integration includes a table called netsuite_deleted; this table contains a row for every deleted record that supports deletes. Accounting for deleted records is especially important if you’re performing any sort of aggregate function - for example, totaling invoices or balancing your books.

For this reason, we recommend setting this table to replicate.

netsuite_deleted Table Schema

The attributes of the netsuite_deleted table include:

  • type: This indicates the type of record. For example: invoice.
  • name: This is the name of the record. For example: Invoice #INV197
  • deletedDate: The date the record was deleted.
  • customRecord: This indicates if the record was a custom record.
  • internalId: This is the numerical ID of the record.

Custom records will look a little different than other records. In this case, you’ll see the following:

  • type: This column will contain a numerical ID.
  • name and internalId: The internalId of the record will display in both columns.
  • customRecord: This column will contain a true value.

For example: The first two records in this table are “normal” records, while the third is a custom record:

type internalId name customRecord deletedDate
invoice 124831 Invoice #INV197 false 2016-08-02T09:33:07.000-07:00
journalEntry 111366 Journal #JV13526 false 2016-08-04T12:01:22.000-07:00
19 128 128 true 2016-07-21T12:05:26.000-07:00

Accounting for deleted records

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 netsuite_transaction and netsuite_deleted tables:

   SELECT * 
     FROM netsuite_transactions tran 
LEFT JOIN netsuite_deleted del
       ON tran.internalId = del.internalId 
      AND tran.type = 'invoice'
      AND del.type = 'invoice'

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

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

Supported transaction types

The following table contains the transaction types Stitch’s NetSuite integration currently supports.

AssemblyBuild AssemblyUnBuild BinTransfer BinWorksheet
CashRefund CashSale Check CreditMemo
Custom CustomerDeposit CustomerPayment CustomerRefund
Deposit DepositApplication Estimate ExpenseReport
InventoryAdjustment InventoryCostRevaluation InventoryTransfer Invoice
ItemFulfillment ItemReceipt Journal Opportunity
PaycheckJournal PurchaseOrder Requisition ReturnAuthorization
SalesOrder TransferOrder VendorBill VendorCredit
VendorPayment VendorReturnAuthorization WorkOrder WorkOrderClose
WorkOrderCompletion WorkOrderIssue

netsuite_accounting_period

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_accounting_period table contains info about accounting periods in your NetSuite instance.

internalId
INTEGER

The accounting period ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_app_definition

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_app_definition table contains info about the app definitions in your NetSuite instance.

internalId
INTEGER

The app definition ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_app_package

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_app_package table contains info about the app packages in your NetSuite instance.

internalId
INTEGER

The app package ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_billing_schedule

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_billing_schedule table contains info about the accounts in your NetSuite instance.

internalId
INTEGER

The account ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_calendar_event

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_calendar_event table contains info about calendar events.

internalId
INTEGER

The calendar event ID.

lastModifiedDate
DATE-TIME

The time the calendar event was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_campaign

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_campaign table contains info about campaigns.

internalId
INTEGER

The campaign ID.

lastModifiedDate
DATE-TIME

The time the campaign was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_classification

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_classification table contains info about classifications.

internalId
INTEGER

The classification ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_contact_category

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_contact_category table contains info about contact categories.

internalId
INTEGER

The contact category ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_contact_role

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_contact_role table contains info about contact roles.

internalId
INTEGER

The contact role ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_coupon_code

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_coupon_code table contains info about coupon codes.

internalId
INTEGER

The coupon code ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_currency_rate

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_currency_rate table contains info about currency rates.

internalId
INTEGER

The currency rate ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_customer

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_customer table contains info about customers.

internalId
INTEGER

The customer ID.

lastModifiedDate
DATE-TIME

The time the customer was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_customer_category

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_customer_category table contains info about customer categories.

internalId
INTEGER

The customer category ID.

lastModifiedDate
DATE-TIME

The time the customer category was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_customer_message

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_customer_message table contains info about customer messages.

internalId
INTEGER

The customer message ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_customer_status

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_customer_status table contains info about customer statuses.

internalId
INTEGER

The customer status ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_custom_list

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_custom_list table contains info about custom lists.

internalId
INTEGER

The custom list ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_custom_records

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_custom_records table contains info about custom records.

internalId
INTEGER

The custom records ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_deleted

Replication Method :

Full Table

Primary Key :

internalId : type

Official docs :

Official Docs

The netsuite_deleted table contains info about deleted records.

internalId
INTEGER

The record ID.

type
STRING

The type of record that was deleted. For example: invoice

deletedDate
DATE-TIME

The time the record was deleted.

customRecord
BOOLEAN

Indicates if the deleted record was a custom record.

name
STRING

The name of the record that was deleted. For example: Invoice #INV197


netsuite_department

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_department table contains info about departments.

internalId
INTEGER

The department ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_entity_group

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_entity_group table contains info about entity groups.

internalId
INTEGER

The entity group ID.

lastModifiedDate
DATE-TIME

The time the entity group was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_expense_category

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_expense_category table contains info about expense categories.

internalId
INTEGER

The expense category ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_folder

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_folder table contains info about folders.

internalId
INTEGER

The folder ID.

lastModifiedDate
DATE-TIME

The time the folder was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_gift_certificate

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_gift_certificate table contains info about gift certificates.

internalId
INTEGER

The gift certificate ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_global_account_mapping

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_global_account_mapping table contains info about global account mappings.

internalId
INTEGER

The global account mapping ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_inventory_number

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_inventory_number table contains info about inventory numbers.

internalId
INTEGER

The inventory number ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_item_account_mapping

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_item_account_mapping table contains info about item account mappings.

internalId
INTEGER

The item account mapping ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_item_demand_plan

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_item_demand_plan table contains info about item demand plans.

internalId
INTEGER

The item demand plan ID.

lastModifiedDate
DATE-TIME

The time the item demand plan was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_item_revision

Replication Method :

Full Table

Primary Key :

internalId : _type

Official docs :

Official Docs

The netsuite_item_revision table contains info about item revisions.

internalId
INTEGER

The item revision ID.

_type
STRING

The type of item that was revised.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_item_supply_plan

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_item_supply_plan table contains info about item supply plans.

internalId
INTEGER

The item supply plan ID.

lastModifiedDate
DATE-TIME

The time the item supply plan was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_job

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_job table contains info about jobs.

internalId
INTEGER

The job ID.

lastModifiedDate
DATE-TIME

The time the job was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_job_status

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_job_status table contains info about job statuses.

internalId
INTEGER

The job status ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_job_type

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_job_type table contains info about job types.

internalId
INTEGER

The job type ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_manufacturing_cost_template

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_manufacturing_cost_template table contains info about manufacturing cost templates.

internalId
INTEGER

The manufacturing cost template ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_manufacturing_operation_task

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_manufacturing_operation_task table contains info about manufacturing operation tasks.

internalId
INTEGER

The manufacturing operation task ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_manufacturing_routing

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_manufacturing_routing table contains info about manufacturing routings.

internalId
INTEGER

The manufacturing routing ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_message

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_message table contains info about messages.

internalId
INTEGER

The message ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_nexus

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_nexus table contains info about nexus tax items.

internalId
INTEGER

The record ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_note

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_note table contains info about notes.

internalId
INTEGER

The note ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_note_type

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_note_type table contains info about note types.

internalId
INTEGER

The note type ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_opportunity

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_opportunity table contains info about opportunities.

internalId
INTEGER

The opportunity ID.

lastModifiedDate
DATE-TIME

The time the opportunity was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_originating_lead

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_originating_lead table contains info about originating leads.

internalId
INTEGER

The originating lead ID.

type
STRING

The originating lead type.

lastModifiedDate
DATE-TIME

The time the originating lead was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_other_name_category

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_other_name_category table contains info about other name categories.

internalId
INTEGER

The other name category ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_partner_category

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_partner_category table contains info about partner categories.

internalId
INTEGER

The partner category ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_payment_method

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_payment_method table contains info about payment methods.

internalId
INTEGER

The payment method ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_payroll_item

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_payroll_item table contains info about payroll items.

internalId
INTEGER

The payroll item ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_phone_call

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_phone_call table contains info about phone calls.

internalId
INTEGER

The phone call ID.

lastModifiedDate
DATE-TIME

The time the phone call was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_price_level

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_price_level table contains info about [price levels.

internalId
INTEGER

The price level ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_pricing_group

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_pricing_group table contains info about pricing groups.

internalId
INTEGER

The pricing group ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_project_task

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_project_task table contains info about project tasks.

internalId
INTEGER

The project task ID.

lastModifiedDate
DATE-TIME

The time the project task was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_promotion_code

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_promotion_code table contains info about promotion codes.

internalId
INTEGER

The promotion code ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_resource_allocation

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_resource_allocation table contains info about resource allocations.

internalId
INTEGER

The resource allocation ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_rev_rec_schedule

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_rev_rec_schedule table contains info about revenue recognition schedules.

internalId
INTEGER

The revenue recognition schedule ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_rev_rec_template

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_rev_rec_template table contains info about revenue recognition templates.

internalId
INTEGER

The revenue recognition template ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_sales_role

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_sales_role table contains info about sales roles.

internalId
INTEGER

The sales role ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_site_category

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_site_category table contains info about site categories.

internalId
INTEGER

The site category ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_solution

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_solution table contains info about solutions.

internalId
INTEGER

The solution ID.

lastModifiedDate
DATE-TIME

The time the solution was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_subsidiary

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_subsidiary table contains info about subsidiaries.

internalId
INTEGER

The subsidiary ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_support_case

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_support_case table contains info about support cases.

internalId
INTEGER

The support case ID.

lastModifiedDate
DATE-TIME

The time the support case was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_task

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_task table contains info about tasks.

internalId
INTEGER

The task ID.

lastModifiedDate
DATE-TIME

The time the task was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_term

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_term table contains info about terms.

internalId
INTEGER

The term ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_time_bill

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_time_bill table contains info about time bills.

internalId
INTEGER

The time bill ID.

lastModifiedDate
DATE-TIME

The time the time bill was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_time_entry

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_time_entry table contains info about time entries.

internalId
INTEGER

The time entry ID.

lastModifiedDate
DATE-TIME

The time the time entry was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_time_sheet

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_time_sheet table contains info about time sheets.

internalId
INTEGER

The time sheet ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_transaction

Replication Method :

Key-based Incremental

Replication Key :

lastModifiedDate

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_transaction table contains info about transactions.

internalId
INTEGER

The transaction ID.

_type
STRING

The transaction type. Possible values are:

  • AssemblyBuild

  • AssemblyUnBuild

  • BinTransfer

  • BinWorksheet

  • CashRefund

  • CashSale

  • Check

  • CreditMemo

  • Custom

  • CustomerDeposit

  • CustomerPayment

  • CustomerRefund

  • Deposit

  • DepositApplication

  • Estimate

  • ExpenseReport

  • InventoryAdjustment

  • InventoryCostRevaluation

  • InventoryTransfer

  • Invoice

  • ItemFulfillment

  • ItemReceipt

  • Journal

  • Opportunity

  • PaycheckJournal

  • PurchaseOrder

  • Requisition

  • ReturnAuthorization

  • SalesOrder

  • TransferOrder

  • VendorBill

  • VendorCredit

  • VendorPayment

  • VendorReturnAuthorization

  • WorkOrder

  • WorkOrderClose

  • WorkOrderCompletion

  • WorkOrderIssue

lastModifiedDate
DATE-TIME

The time the transaction was last updated.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_units_type

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_units_type table contains info about unit types.

internalId
INTEGER

The units type ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_vendor_category

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_vendor_category table contains info about vendor categories.

internalId
INTEGER

The vendor category ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.


netsuite_win_loss_reason

Replication Method :

Full Table

Primary Key :

internalId

Official docs :

Official Docs

The netsuite_win_loss_reason table contains info about win loss reasons.

internalId
INTEGER

The win loss reason ID.

Additional fields

For a list of available attributes, refer to NetSuite’s documentation. Note: You will need to log into your NetSuite account to view the documentation.



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.