NetSuite.com to NetSuite2.com Map
When you modify your existing queries from NetSuite.com to NetSuite2.com, you need to know the ID of the corresponding record and field in NetSuite2.com. The following link provides a spreadsheet that includes a list of records and fields in NetSuite.com and their corresponding NetSuite2.com records and fields. This list is not exhaustive and will be continually updated with new record mappings.
To access the spreadsheet, click this link: NS_to_NS2.xlsx
The spreadsheet includes the following tabs:
-
Records - Tab that contains a list of records and includes the following columns:
-
Record ID in NetSuite.com - ID of the record that should be used when using NetSuite.com.
-
Record ID in NetSuite2.com - ID of the corresponding record in NetSuite2.com.
-
Record Name in NetSuite2.com - Name of the corresponding record in NetSuite2.com.
-
Notes - Additional notes about the corresponding record in NetSuite2.com.
-
-
Fields - Tab that contains a list of records and fields and includes the following columns:
-
Record ID in NetSuite.com - Name of the record in NetSuite.com.
-
Field ID in NetSuite.com - ID of the field in NetSuite.com.
-
Record Name in NetSuite2.com - Name of the corresponding record in NetSuite2.com.
-
Field ID in NetSuite2.com - ID of the corresponding field in NetSuite2.com.
-
Field Name in NetSuite2.com - Name of the corresponding field in NetSuite2.com.
-
Notes - Additional notes about the corresponding record and field in NetSuite2.com.
-
-
Understanding this spreadsheet - Contains information about how to search for the corresponding record and field IDs for NetSuite2.com.
The spreadsheet does not include all records and fields.
There is not always a 1:1 mapping between NetSuite.com and NetSuite2.com. For information about the differences between records in NetSuite.com and NetSuite2.com, see NetSuite.com Records Not Directly Mapped to NetSuite2.com Records.
How to Find Records and Field IDs in the Spreadsheet
To find the corresponding field ID in NetSuite2.com, go to the Fields tab. In the Field ID in NetSuite.com column, search for the field ID that you used to use in your NetSuite.com queries. The corresponding field ID for NetSuite2.com appears under the Field ID in NetSuite2.com column.
To find the corresponding record ID in NetSuite2.com, go to the Records tab. In the Record ID in NetSuite.com column, search for the record ID that you used to use in your NetSuite.com queries. The corresponding record ID for NetSuite2.com appears under the Record ID in NetSuite2.com column.
Requesting a New Mapping
The list of mappings is not exhaustive. The worksheet includes the records and fields most commonly used in Connect queries and is constantly being updated with new mappings. If this list does not include the corresponding records and fields that you need for your NetSuite2.com queries, you can send a message with your request using the How helpful was this topic? section at the bottom of this topic.
When you request a new mapping, ensure that you provide the ID of the record or field that you are currently using in your NetSuite.com queries and that you want to use in NetSuite2.com. The following example illustrates how you can request a new record mapping:
I'd like to request the following record mapping:
I need to create a NetSuite2.com query to get the same data that I get when I use the "LOCATION_ID" field of the "CUSTOMER" record.