Where do I find Sales Order quantity, units, and rate?
Hi, I need to create an open sales order report and am using the SuiteAnalytics ODBC connection. Can anyone tell me the table and fields where I will find the line item order quantity, and unit sales price? Thanks in advance for any assistance.
The schema browser has a tab for the tables and columns available in the analytics schema (depending on your connection string you will either be using the analytics 2.0 schema or the connect 1.0 schema). https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2021_1/analytics/record/transactionLine.html
Generally speaking you will want to use the following tables: