Following up from my question from yesterday, I’m still having trouble wrapping my head around how to find the correct names for fields to query on. For example, when doing a query for transactions, I need to add a where clause for the shipmethod. For example, where shipmethod id is 520:

SELECT transaction.id FROM transaction WHERE shipmethod = 520

Using the Schema Browser online I cannot wrap my head around how to map things out to get the select statement to pull in the shipmethod. Any body have experience with this or a good resource about how to read the Scheme Browser to make these connections?

I'd suggest using the Records Catalog (Setup > Records Catalog) instead of the Schema Browser

That looks much easier to use, thank you for that suggestion! I will look into that.

It's also really useful to build queries in the Analytics UI and export the SQL https://netsuiteprofessionals.slack.com/archives/C01FBBZ8PQC/p1618354636084000

Whoa, I missed that. That looks golden! Thank you!