N/search Module
Column.join
Property Description: Join ID for a search column as a string.
Type: string (read-only)
Supported Script Types: All script types For more information, see SuiteScript 2.0 Script Types.
Module: N/search Module
Since: 2015.2
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=Column.join

// Code Example 1

// Add additional code

//...

// Create a joined column. The name parameter is a field name on

// the joined record type, and the join parameter is a field name

// on the base record type that references the joined record type.

//

// In this example, a search is created for customer records.

// Customer records include a 'salesrep' field, which references an

// employee record. This joined column represents the value of the

// 'firstname' field on the referenced employee record.

var myColumn = search.createColumn({

    name: 'firstname',

    join: 'salesrep'

});



var mySearch = search.create({

    type: search.Type.CUSTOMER,

    columns: [

        'entityid',

        'email',

        myColumn

    ]

});



var theJoin = myColumn.join;

//...

// Add additional code



//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_460655456542.html