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

recommend posting that in <#C01FBBZ8PQC|>

for SuiteQL it's the _Records Catalog_ that should be your guide to the schema, not the Analytics screens

Thank-you.  I was unaware of the Records Catalog.  Super helpful!

yes, back in the beginning it was the Analytics screens which were often incorrect. IIRC the new Records Catalog often just died when it was new. Now it's semi stable and seems to be semi-correct so improvements over the frustration that came before!

<@UHF2QGCUX> This might help.
```SELECT
	Transaction.TranID,
	Transaction.TranDate,
	TransactionLine.Location,
	BUILTIN.DF( TransactionLine.Location ) AS LocationName
FROM
	Transaction
	INNER JOIN TransactionLine ON
		( TransactionLine.Transaction = Transaction.ID )
		AND ( TransactionLine.MainLine = 'T' )
WHERE
	( Transaction.Type = 'SalesOrd' )```


Thanks!  It was the `MainLine = 'T'` that I was missing.  I’ve worked extensively with the ODBC tables which has location on the transactions table so I wasn’t expecting this.

it is unfortunate that NS presents a different schema for each access method.