Select Reference Types

A reference type lets you map a column in your CSV to a NetSuite field that has list values, like dropdowns or multi-selects. You set reference types on the Field Mapping page by clicking the edit icon next to a mapped dropdown or multi-select field.

Default Value or Reference Type popup window.
Note:

Not all fields support reference types.

Possible reference types include External ID, Internal ID, Name and Script ID.

Displaying Internal IDs

You can configure NetSuite to show internal IDs. During development, internal IDs help you verify that the internal ID values submitted for import match those in the existing records.

Go to Home > Set Preferences and under Defaults on the General tab, check the Show Internal IDs box. Lists will then show the Internal ID column, as shown in the following screenshot. This change affects the current user only.

Internal ID column.

If lists show Internal IDs, you can usually export them to a CSV file using the Export to CSV button on list pages.

Internal IDs are assigned in order, but the sequence doesn’t tell you when or in what order records were added. This is true even within specific record groups where internal IDs are unique. So, don’t assume that lower internal IDs mean a record was added first or that higher ones were added last.

If you need to know when data was entered, use the Date Modified or Date Created fields, as they’re always chronological. For transactions with auto-generated numbers, the sequence number (like “tranid”) is also in order by date. Never use internal IDs to figure out when data was entered, and don’t build anything that relies on their sequence to work.

Note:

The user preference setting specifies the display of the internal ID, however, some records have an ID that cannot be hidden. For example, customer J Wolfe has an ID of 87 and an internal ID of 18834. The ID column cannot be removed from the customer list page.

Related Topics

General Notices