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

Hi guys i have a simple query

           SELECT
                trx.recordtype,
                trx.id as id,
                trx.tranId,
                trx.location,
                trx.account
            FROM
                transaction as trx
            WHERE
                trx.id = 881264

but the location and account shows null on the result, where do we see the fields available for the transaction...

You could try the following and see if you get the correct results. It works on our account
```SELECT
                trx.recordtype,
                trx.id as id,
                trx.tranId,
                trx.location,
                tl.location,
                tl.account
            FROM
                transaction as trx
                join transactionLine tl on tl.transaction = trx.id
                    and tl.mainline = 'T'
            WHERE
              trx.id = 881264```