Is there a transaction search join field on Customer(Main) that includes both the Customer's ID and Name together, or do I need to get them both in the results and concatenate them together if I want that?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Based on the conversations, there isn't a transaction search join field on Customer(Main) that includes both the Customer's ID and Name together. You would need to get them both in the results and concatenate them together if you want that. In NetSuite, you can join fields from related records in a search, but the join is based on the relationship between the records, not the fields within the records. So, you can't directly join the Customer ID and Name fields together in a search. You can, however, include both fields in your search results and then concatenate them together in your results processing. Here's an example of how you might do this:

javascript
var search = nlapiCreateSearch('transaction', 
    [new nlobjSearchFilter('mainline', null, 'is', 'T')], 
    [
        new nlobjSearchColumn('entityid', 'customerMain'), 
        new nlobjSearchColumn('companyname', 'customerMain')
    ]
);

var resultSet = search.runSearch();
resultSet.forEachResult(function(result) {
    var customerId = result.getValue('entityid', 'customerMain');
    var customerName = result.getValue('companyname', 'customerMain');
    var combined = customerId + ' ' + customerName;
    // Do something with combined...
    return true; // Continue to next result
});

In this example, the 'entityid' and 'companyname' fields from the 'customerMain' join are included in the search results. Then, in the results processing, the values of these fields are concatenated together for each result.