NetSuite Connector Communication with Internal IDs and Field IDs
NetSuite Connector communicates with NetSuite using internal IDs and field IDs. For example, an order ID like SO12345 is the order ID you see in NetSuite. When you view the order, the internal ID (an integer) is displayed in the URL. This is the internal ID. Likewise, a field like Item Name/Number has a field ID of itemId. NetSuite Connector cannot communicate with NetSuite using the visible transaction numbers, entity IDs, or field labels you displayed on the NetSuite user interface.
If you change the labels of NetSuite standard fields, NetSuite Connector will not be able to reference the correct field and its corresponding field ID. For example, you modify the Category field (with corresponding Category field ID) on a standard customer record, and rename it to Class, NetSuite Connector cannot detect that the Class field now represents the Category field ID. So you'll need to let us know what the field ID is and not the label.
Every NetSuite record has an internal ID and every field has a field ID. These IDs are the permanent IDs associated with the records and fields and are often visible in the URL when viewing a record.
Field IDs are in SuiteScript format, and the field IDs of standard NetSuite fields (non-custom fields) are in lowercase. However, NetSuite Connector communicates with NetSuite using SuiteTalk, and not SuiteScript. In SuiteTalk, all field IDs are in camel case. For example, Item Name/Number field ID is itemid in SuiteScript, but it is itemId in SuiteTalk.
All the standard SuiteTalk field IDs and internal IDs on all NetSuite records are listed here: Schema and Records Browser.
To reference records, click the Records Browser tab.
To reference fields, click the Schema Browser tab.
To find an entity, click the initial letter of the name of the entity from the alphabetical row. For example, to find the valid field IDs of inventory items, click the Schema Browser tab and click the I. Then, in the left column, click InventoryItem. All valid field IDs on inventory item records are in the Name column.