How to access Netsuite Project (recordtype=job) using SuiteAnalytics Connect?

Viewed 40

How can I access Netsuite projects (recordtype=job) using Suiteanalytics Connect to create queries? I'm not able to find the records into these tables:

enter image description here

enter image description here

1 Answers

To access the projects you need to do as follows:

select * from customers where customer_id='xxx';

Note: customer_id is the internal id of the Project record.

Related