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

what table are the line items of a purchase order located in for the <http://NetSuite2.com|NetSuite2.com> data source

&gt;*AI generated answer (using internal Slack threads):*
The line items of a purchase order in the <http://NetSuite2.com|NetSuite2.com> data source are located in the `PurchaseOrderItem` table. This table contains all the line item details associated with a purchase order, including item, quantity, rate, amount, and other related fields. 

Please note that the `PurchaseOrderItem` table is linked to the `PurchaseOrder` table through the `internalId` field in the `PurchaseOrder` table, which corresponds to the `orderdoc` field in the `PurchaseOrderItem` table. 

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C29J1BPM3/p1614980664153300|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.829660773

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1672746575360569|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.817362309

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1643213244379600|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.815730453



Please provide your feedback on this answer.

What permissions are needed to have access to those tables within ODBC?

What permissions are required to have access to the PurchaseOrder and PurchaseOrderItem tables through SuiteAnalytics connect?