Suiteql Get the subsidiary of a customer

AI generated answer (using internal Slack threads):

To get the subsidiary of a customer using SuiteQL, you can use the

CustomerSubsidiaryRelationshipSearchAdvanced

API. This API corresponds to the Saved Customer-Subsidiary Relationship Search in the UI. Here is a general example of how you might use this API:

javascript
var search = nlapiCreateSearch('customer',
    [new nlobjSearchFilter('internalid', null, 'anyof', customerId)],
    [new nlobjSearchColumn('subsidiary')]
);
var resultSet = search.runSearch();

In this example,

customerId

is the internal ID of the customer for whom you want to get the subsidiary. The search returns a set of results, each of which represents a customer-subsidiary relationship. You can then iterate over these results to get the subsidiaries for the customer. Please note that this is a general example and you might need to adjust it to fit your specific needs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******