Supported Sublist Imports
The following table shows the sublists for which you may be able to add or update data through CSV imports. These sublists depend upon the features enabled in your account. You can see the sublists available in your account for a particular record type on the Import Assistant's Field Mapping page.
Some related data may be structured as a subrecord rather than as a sublist of a record type. If you do not see a sublist in the table below, see Supported Subrecord Imports to check if the data is set up as a subrecord instead.
Record Type |
Sublist |
Notes |
---|---|---|
Accounting: Chart of Accounts |
Translations |
When Multi-Language feature enabled. Selectively updatable based on the Language key field. |
|
|
|
Accounting: Expense Categories |
Rates |
Sublist available to OneWorld accounts only. Selectively updatable based on the Subsidiary field. |
|
|
|
Accounting: Price Book |
Price Book Lines |
When SuiteBilling feature enabled. Selectively updatable based on the Subscription Plan Line field. |
|
|
|
Accounting: Price Plan |
Pricing |
When SuiteBilling feature enabled. Selectively updatable based on the Above Quantity field. |
|
|
|
Activities: Events |
Attendees |
Selectively updatable based on the Attendee field. |
— |
Resources |
Selectively updatable based on the Resource field. For more information, see Event CSV File Examples. |
— |
Time Track |
— |
|
|
|
Activities: Phone Calls |
Contacts |
Selectively updatable based on the Participant or Contact key field. |
— |
Time Tracking |
When Time Tracking feature enabled. |
|
|
|
Activities: Tasks |
Contacts |
Selectively updatable based on the Company/Project or Contact key field. |
|
Time Tracking |
When Time Tracking feature enabled. |
|
|
|
Classification: Class |
Class Translations |
When Multi-Language feature enabled. Selectively updatable based on the Language key field. |
|
|
|
Classification: Department |
Department Translations |
When Multi-Language feature enabled. Selectively updatable based on the Language key field. |
|
|
|
Classification: Location |
Location Translations |
When Multi-Language feature enabled. Selectively updatable based on the Language key field. |
|
|
|
Classification: Merchandise Hierarchy Node |
Hierarchy Versions |
The Included in Version box on the Hierarchy Versions subtab indicates if the hierarchy node is assigned to a hierarchy version. You can assign a node to multiple versions. |
|
|
|
Custom Records: Translations |
Translations |
When Multi-Language feature is enabled. |
|
|
|
Customization: Custom Lists |
Custom List Values |
Selectively updatable based on the ID field. For more information, see Custom List CSV Multiple File Examples. |
— |
Custom List Translations |
When Multi-Language feature enabled. Selectively updatable based on the Language key field. |
|
|
|
Employees: Employees |
Payroll Accrued Times |
Selectively updatable based on the Payroll Item key field. When Payroll feature enabled. |
— |
Address |
Selectively updatable based on the Internal ID or Label key field. |
— |
Payroll Contributions |
Selectively updatable based on the Payroll Item key field. When Payroll feature enabled. |
— |
Payroll Deductions |
Selectively updatable based on the Payroll Item key field. When Payroll feature enabled. |
— |
Direct Deposit |
Selectively updatable based on the Internal ID key field. When Direct Deposit feature enabled. |
— |
Payroll Earnings |
Selectively updatable based on the Payroll Item key field. When Payroll feature enabled. |
— |
Education |
— |
— |
Emergency Contacts |
— |
— |
Roles |
— |
— |
Subscriptions |
Selectively updatable based on the Subscriptions key field. |
|
|
|
Employees: Expense Reports |
Expenses |
Available when Expense Reports feature is enabled. Selectively updatable based on the Line Id or Ref No. field. For more information, see Expense Report CSV Examples. |
— |
Accounting Book Detail |
Available when the Multi-Book Accounting feature is enabled, and when more than one active accounting book exists. Selectively updateable based on the Accounting Book key field. |
|
|
|
Items |
Bin Numbers |
When Bin Management or Advanced Bin/Numbered Inventory Management feature enabled. Selectively updatable based on the Bin Number key field. For Assembly/BOM Item and Inventory Item imports.
Note:
If you are importing bin records, you should complete this import before you import items with associated bin numbers. See Bin Import. |
— |
Locations |
When Multi-Location Inventory feature enabled. Selectively updatable based on Internal ID, External ID, or Location. For Assembly/BOM Item and Inventory Item imports. For more information, see Updating Locations on Items. |
— |
Members |
For Assembly/BOM Item, Item Group, and Kit/Package Item imports. |
— |
Merchandise Hierarchy |
For Inventory Items, Lot Numbered Inventory Items, and Serialized Inventory Items. Available when the Merchandise Hierarchy feature is enabled. |
— |
Pricing |
When Multiple Prices, Quantity Pricing, or Multiple Currencies features are enabled. Selectively updatable based on Currency, Quantity, and Level fields, depending on enabled features. |
— |
Related Items |
When Web Site feature enabled. Not available for Non-Inventory Item for Purchase, Service Item for Purchase, or any Other Charge Item imports. For more information, see Importing Related Items Groups. |
— |
Site Category |
When Web Site feature enabled. Not available for Non-Inventory Item for Purchase, Service Item for Purchase, or any Other Charge Item imports. For more information, see Site Category Import. |
— |
Task Templates |
When Project Management feature enabled. For Service Item for Sale imports. |
— |
Translations |
When Multi-Language feature enabled. Selectively updatable based on the Language key field. |
— |
Vendors |
When Multiple Vendors feature enabled. Selectively updatable based on the Vendor. For Inventory Item, Non-Inventory Item for Resale or Purchase, Service Item for Resale or Purchase, and Other Charge Item for Resale or Purchase imports, and Assembly/BOM Item when Allow Purchase of Assembly Items preference is enabled. For more information, see Updating Vendors on Items. |
|
|
|
Items: Subscription Plan |
Subscription Plan Members |
When SuiteBilling feature enabled. |
|
|
|
Relationships: Contacts |
Address |
Selectively updatable based on Internal ID or Label key field. Available for Contacts Only imports. Not available for Customers and Contacts Together, Leads and Contacts Together, or Prospects and Contacts Together imports. |
— |
Subscriptions |
Selectively updatable based on Subscription key field. |
|
|
|
Relationships: Customers |
Address |
Selectively updatable based on the Internal ID or Label key field. |
— |
Contact Access |
Available for updates of existing customers only, to add or update NetSuite access information for existing customer contacts. Selectively updatable based on the Contact key field. |
— |
Credit Cards |
Addition of new records is supported; update of existing lines is not supported. |
— |
Currencies |
When Multiple Currencies feature enabled. For more information, see Setting Multiple Transaction Currencies for Customers. |
— |
Downloads |
When Sell Downloadable Files feature enabled. |
— |
Group Pricing |
When Multiple Prices feature enabled. |
— |
Item Pricing |
When Multiple Prices feature enabled. |
— |
Partners |
When Multi-Partner Management feature enabled. Selectively updatable based on Internal ID, External ID, or Partner. |
— |
Sales Team |
When Team Selling feature enabled. |
— |
Subscriptions |
Selectively updatable based on Subscription key field. |
— |
Tax Registrations |
Available when the SuiteTax feature is enabled. |
|
|
|
Relationships: Groups |
Group Members |
Can be updated using Internal ID, External ID or Names key field for the group member. |
|
|
|
Relationships: Jobs |
Address |
When Project Management feature disabled. Selectively updatable based on the Internal ID or Label key field. |
— |
Resource |
When Project Management feature enabled. |
|
|
|
Relationships: Leads |
Address |
Selectively updatable based on the Internal ID or Label key field. |
— |
Credit Cards |
Addition of new records is supported. Update of existing lines is not supported. |
— |
Downloads |
When Sell Downloadable Files feature enabled. |
— |
Group Pricing |
When Multiple Prices feature enabled. |
— |
Item Pricing |
When Multiple Prices feature enabled. |
— |
Partners |
When Multi-Partner Management feature enabled. Selectively updatable based on Internal ID, External ID, or Partner. |
— |
Sales Team |
When Team Selling feature enabled. |
|
|
|
Relationships: Partners |
Address |
Selectively updatable based on the Internal ID or Label key field. |
— |
Contact Access |
Available for updates of existing partners only, to add or update NetSuite access information for existing partner contacts. Selectively updatable based on the Contact key field. |
— |
Promotion Codes |
— |
— |
Subscriptions |
Selectively updatable based on the Subscription key field. |
— |
Tax Registrations |
Available when the SuiteTax feature is enabled. |
|
|
|
Relationships: Prospects |
Address |
Selectively updatable based on the Internal ID or Label key field. |
— |
Credit Cards |
Addition of new records is supported. Update of existing lines is not supported. |
— |
Downloads |
When Sell Downloadable Files feature enabled. |
— |
Group Pricing |
When Multiple Prices feature enabled. |
— |
Item Pricing |
When Multiple Prices feature enabled. |
— |
Partners |
When Multi-Partner Management feature enabled. Selectively updatable based on Internal ID, External ID, or Partner. |
— |
Sales Team |
When Team Selling feature enabled. |
|
|
|
Relationships: Vendors |
Address |
Selectively updatable based on the Internal ID or Label key field. |
— |
Roles |
— |
— |
Subscriptions |
Selectively updatable based on the Subscription key field. |
— |
Tax Registrations |
Available when the SuiteTax feature is enabled. |
|
|
|
Rules Setup: Foreign Currency Variance Posting Rule |
Criteria |
Available when the Foreign Currency Variance Mapping feature is enabled. |
|
|
|
Supply Chain: Bill of Materials Revision |
Bill of Materials Revision Components |
Available when the Advanced Bill of Materials feature is enabled. |
|
|
|
Supply Chain: Manufacturing Cost Template |
Cost Detail |
At least one line item is required for new records. (See Cost Template Body and Sublist Fields.) |
|
|
|
Supply Chain: Manufacturing Routing |
Routing Steps |
Selectively updatable based on the Operation Sequence key field. At least one line item is required for new records. (See Routing Body and Sublist Fields.) |
— |
Component per Operation |
— |
|
|
|
Support: Solutions |
Solutions |
— |
— |
Topics |
— |
|
|
|
Support: Support Cases |
Escalate to |
— |
|
|
|
Transactions: Advanced Intercompany Journal Entry |
Advanced Intercompany Journal Entry Line |
Each imported intercompany journal entry must include at least 4 lines, with one debit and one credit each for originating and receiving subsidiary. Line debits and credits must balance. For more information, see Advanced Intercompany Journal Entry Import. |
|
|
|
Transactions: Cash Sale |
Auth. Code |
When Gift Certificates feature enabled. |
— |
Billable Time |
Selectively updatable based on related transaction ID (***doc). |
— |
Items |
Selectively updatable based on the Line/Order Line or Item key field (See Line Item Updates on Transactions Imports). At least one line item is required for new records. (See Required Items Sublist Fields for Transactions Imports.) |
— |
Partners |
When Team Selling feature enabled. Selectively updatable based on Internal ID, External ID, or Partner. |
— |
Sales Team |
When Team Selling feature enabled. |
— |
Shipment |
When Multiple Shipping Routes feature enabled. |
|
|
|
Transactions: Check |
Accounting Books |
When Multi-Book Accounting feature is enabled, and when more than one active accounting book exists. |
— |
Expenses |
Selectively updatable based on Line. |
— |
Items |
Selectively updatable based on Item. |
Transactions: Credit Card Charge |
Accounting Books |
When Multi-Book Accounting feature is enabled, and when more than one active accounting book exists. Selectively updatable based on Line or Order Line. |
— |
Expenses |
Selectively updatable based on Line. |
— |
Items |
Selectively updatable based on Item. |
|
|
|
Transactions: Credit Card Refund |
Accounting Books |
When Multi-Book Accounting feature is enabled, and when more than one active accounting book exists. Selectively updatable based on Line or Order Line. |
— |
Expenses |
Selectively updatable based on Line. |
— |
Items |
Selectively updatable based on Item. |
|
|
|
Transactions: Credit Memo |
Apply |
For more information, see Credit Memo Import. |
— |
Items |
For more information, see Credit Memo Import. |
|
|
|
Transactions: Custom Transaction |
Accounting Books |
|
— |
Lines |
When Custom Transactions feature is enabled and at least one custom transaction type is created. Selectively updatable based on the Line and Account fields. Note that the Account field can be used as the key only when every line in the sublist has a unique value in the Account field. This behavior differs from SOAP web services, where you can use only Line as a key, even when every line has a unique Account value. For more information, see Custom Transaction CSV File Examples. |
— |
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. Selectively updateable based on the Accounting Book key field. |
|
|
|
Transactions: Customer Payment |
Invoices |
Selectively updatable based on the Invoice key field (and optionally Line key field). |
— |
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. Selectively updateable based on the Accounting Book key field. |
|
|
|
Transactions: Estimate |
Items |
Selectively updatable based on the Line/Order Line or Item key field (See Line Item Updates on Transactions Imports). At least one line item is required for new records. (See Required Items Sublist Fields for Transactions Imports.) |
— |
Partners |
When Multi-Partner Management feature enabled. Selectively updatable based on Internal ID, External ID, or Partner. |
— |
Sales Team |
When Team Selling feature enabled. |
— |
Shipment |
When Multiple Shipping Routes feature enabled. |
|
|
|
Transactions: Inbound Shipment |
Items |
— |
|
|
|
Transactions: Intercompany Journal Entry |
Intercompany Journal Entry Line |
Each imported intercompany journal entry must include at least 4 lines, with one debit and one credit each for originating and receiving subsidiary. Line debits and credits must balance. For more information, see Journal Entry Import and Intercompany Journal Entry Import. |
— |
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. Selectively updateable based on the Accounting Book key field. |
|
|
|
Transactions: Inventory Cost Revaluation |
Cost Components |
Available when Standard Costing feature is enabled. Selectively updatable based on the Component and Cost Category fields. |
— |
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. Selectively updateable based on the Accounting Book key field. |
|
|
|
Transactions: Inventory Transfer |
Adjustments |
— |
— |
Adjustments — Inventory Detail |
Available with the Advanced Bin/Numbered inventory Management feature is enabled |
|
|
|
Transactions: Invoice |
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. Selectively updateable based on the Accounting Book key field. |
— |
Auth. Code |
When Gift Certificates feature enabled. |
— |
Billable Time |
Selectively updatable based on related transaction ID (***doc). |
— |
Items |
Selectively updatable based on the Line/Order Line or Item key field (See Line Item Updates on Transactions Imports). At least one line item is required for new records. (see Required Items Sublist Fields for Transactions Imports) |
— |
Partners |
When Multi-Partner Management feature enabled. Selectively updatable based on Internal ID, External ID, or Partner. |
— |
Sales Team |
When Team Selling feature enabled. |
— |
Shipment |
When Multiple Shipping Routes feature enabled. |
|
|
|
Transactions: Item Demand Plan |
Demand Planning |
Fields vary according to type of demand plan: monthly, weekly, or daily. |
|
|
|
Transactions: Item Supply Plan |
Orders |
— |
|
|
|
Transactions: Journal Entry |
Journal Entry Line |
Each imported journal entry must include at least 2 lines, with balancing debits and credits. For more information, see Journal Entry Import and Intercompany Journal Entry Import. |
— |
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. Selectively updateable based on the Accounting Book key field. |
|
|
|
Transactions: Opportunity |
Items |
Selectively updatable based on the Line/Order Line or Item key field (See Line Item Updates on Transactions Imports). |
— |
Opportunity |
— |
— |
Partners |
When Multi-Partner Management feature enabled. Selectively updatable based on Internal ID, External ID, or Partner. |
— |
Sales Team |
When Team Selling feature enabled. |
|
|
|
Transactions: Paycheck |
Contributions, Deductions, Earnings, Expenses, Taxes, Time |
— |
|
|
|
Transactions: Period End Journal Entry |
Period End Journal Entry Line |
— |
|
|
|
Transactions: Purchase Order |
Items |
Selectively updatable based on the Line/Order Line or Item key field (See Line Item Updates on Transactions Imports). At least one line item is required for new records. (See Required Items Sublist Fields for Transactions Imports.) For more information, see Purchase Order Import. |
|
Expenses |
When Allow Expenses on Purchase Orders preference enabled. Expenses data must be in a separate CSV file. For more information, see Purchase Order Import. |
|
|
|
Transactions: Return Authorization |
Items |
Selectively updatable based on Order Line or Item key field. |
— |
Partners |
When Multi-Partner Management feature enabled. Selectively updatable based on Partner key field. |
— |
Sales Team |
When Team Selling feature enabled. Selectively updatable based on Employee key field. |
|
|
|
Transactions: Sales Order |
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. Selectively updateable based on the Accounting Book key field. |
— |
Auth. Code |
When Gift Certificates feature enabled. |
— |
Items |
Selectively updatable based on the Line/Order Line or Item key field (See Line Item Updates on Transactions Imports). At least one line item is required for new records. (See Required Items Sublist Fields for Transactions Imports.) |
— |
Partners |
When Multi-Partner Management feature enabled. Selectively updatable based on Internal ID, External ID, or Partner. |
— |
Sales Team |
When Team Selling feature enabled. |
— |
Shipment |
When Multiple Shipping Routes feature enabled. |
|
|
|
Transactions: Statistical Journal Entry |
Line |
At least one line is required for new records (see Statistical Journal Entry Body and Sublist Fields). |
|
|
|
Transactions: Subscription |
Price Book Lines |
When SuiteBilling feature enabled. |
|
|
|
Transactions: Subscription Change Order |
Subscription Change Order Items |
When SuiteBilling feature enabled. Selectively updatable based on the Line Number field. |
|
|
|
Transactions: Transfer Order |
Accounting Books |
— |
— |
Items |
Selectively updatable based on the Line/Order Line or Item key field (See Line Item Updates on Transactions Imports). |
|
|
|
Transactions: Vendor Bill |
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. selectively updateable based on the Accounting Book key field |
— |
Items |
Selectively updatable based on the Line/Order Line or Item key field (See Line Item Updates on Transactions Imports). At least one item line is required for new records (see Required Items Sublist Fields for Transactions Imports). For more information, see Vendor Bill Import. |
— |
Expenses |
Expenses data must be in a separate file. For more information, see Vendor Bill Import. |
|
|
|
Transactions: Vendor Credit |
Items |
Selectively updatable based on the Line/Order Line or Item key field (See Line Item Updates on Transactions Imports). At least one item line is required for new records (see Required Items Sublist Fields for Transactions Imports). |
— |
Expenses |
Expenses data must be in a separate file. Selectively updatable based on the Line/Order Line key field. |
— |
Apply |
Apply data must be in a separate file. Selectively updatable based on the Apply or Line key field. |
— |
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. Selectively updateable based on the Accounting Book key field. |
|
|
|
Transactions: Vendor Payment |
Bills |
Selectively updatable based on the Bill key field (and optionally Line key field). |
— |
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. Selectively updateable based on the Accounting Book key field. |
|
|
|
Transactions: Vendor Return Authorization |
Items |
Selectively updatable based on the Line/Order Line or Item key field (See Line Item Updates on Transactions Imports). At least one item line is required for new records (see Required Items Sublist Fields for Transactions Imports). |
— |
Expenses |
Expenses data must be in a separate file. Selectively updatable based on the Line/Order Line key field. |
— |
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. Selectively updateable based on the Accounting Book key field. |
|
|
|
Website: Site Category |
Presentation Items |
— |