RE: 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.

D3 Rookie Asked on October 5, 2021 in SuiteAnalytics Connect.
Add Comment
1 Answers

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:

  1. transaction
  2. transactionline
  3. item
  4. untsTypeUom

 

Good luck.

Rookie Answered on October 6, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.