This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

How do we pull the **subsidiary** shown at the header level of a sales order via SuiteQL? It doesn't appear to be on the transaction table like it is in suitescript?

I see _subsidiary_ at the line level, but not at the body level.

<@U5375UUJ2> Join to the "mainline" lineitem, like this:
```SELECT
	Transaction.TranID,
	Transaction.TranDate,
	TransactionLine.Subsidiary
FROM
	Transaction
	INNER JOIN TransactionLine ON
		( TransactionLine.Transaction = Transaction.ID )
		AND ( TransactionLine.MainLine = 'T' )
WHERE
	( Transaction.Type = 'SalesOrd' )```
