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

Does anyone know how a sales order record maps into the database? the connect browser has a Transactions table which looks partially the same as a sales order

Sales Order is a type of Transaction.  All sorts of transactions are stored in that same table (e.g. Estimates, Vendor Bills, Invoices, Purchase Orders, etc).  The `type` will tell you which is which.

I've got a list of records where I need to pull data from ODBC to feed a business intelligence system- I need to do an exercise in mapping records to tables then

e.g. SalesOrder = select from Transactions where type='SALES_ORDER'

Would you know where to find a table/list of possible values for things like transaction_type?

Is there any docs from Oracle on the database structure etc?

So this isn’t quite the same schema as you get with ODBC, but the Records Browser is pretty handy

you can get lots of information by clicking around

An ODBC tool such as DBeaver will help to look at the actual underlying schema