Include Reference Columns
A comma separated list representing the columns to include when retrieving data from a field representing a record reference.
Data Type
string
Default Value
"InternalId, Name"
Remarks
Many fields in NetSuite are references to other types of records. For instance, an Invoice might reference an Account and a Customer record. There are several pieces of data that can be returned by NetSuite when retrieving data from a record reference field. The available values are:
| InternalId | The NetSuite foreign key for the record reference. |
| ExternalId | An optional foreign key stored in a data source other than NetSuite associated with the record. ExternalIds are used for synchronizing NetSuite data with other data sources. |
| Name | A readable name for the record referenced. |
| Type | The type of record referenced. This is not always given a value as the given field may only have one type. |