Determining the Sublist ID for a Child Record
This topic explains where and how to find the internal ID of a custom child record sublist in NetSuite. For a general overview, see Custom Child Record Sublist IDs Overview.
The internal ID for a custom child record sublist is recmach + field_id_for_the_parent_field (for example: recmachcustrecord102).
Use Record.getSublistValue(options) or CurrentRecord.getSublistValue(options).
// Add code.
...
var sublistFieldValue = objRecord.getSublistValue({ sublistId: 'item', fieldId: 'item', line: 3
});
...
// Add code.
Finding the Internal ID of a Custom Child Record Sublist
The following steps describe where to look in NetSuite to get the internal ID of a custom child record sublist.
To get the internal ID of a custom child record sublist (the field ID for the parent record):
-
Go to the record definition for the custom record type. For example, Fixed Assets, as shown in the following screenshot.
-
On the Fields subtab, notice that the ID column lists a List/Record field type.
The New Customer field (internal ID: custrecord102) is the parent field for the fixed assets records that appear as children on customer records. Therefore, the internal ID for the custom child Fixed Assets sublist on customer records is recmachcustrecord102.
Obtaining the Internal ID of the Parent Field
The following is an alternative approach for obtaining the internal ID of the parent field.
To obtain the internal ID of the parent field:
-
On the custom child record sublist, click the New child record button. In the following example, the button is New Fixed Assets.
-
When the new child record opens, notice the field that ties the child record to the parent record.
In this case, the New Customer field shows that the customer record for Abe Simpson is the parent of the fixed assets record. The field level help popup window for New Customer lists the field's internal ID as custrecord102. Therefore, the internal ID for the Fixed Assets sublist appearing on the (parent) customer record is recmachcustrecord102.
Internal IDs for custom child record sublists also appear in the SuiteScript Debugger when you load the record that includes the sublist.