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

Anyone know why the JDBC connection to NS doesn't let you SELECT * on the TRANSACTIONS table? I think it's because there are too many columns, I trued to add the column names manually to the query and it breaks at around 1000 columns.

&gt; Note Due to an internal limitation, queries over SuiteAnalytics Connect schema tables that have more than 1000 columns only work if you retrieve 1000 columns or less in the query. This run failure can occur when using the “Select * From” construct to query tables that have many custom fields or when joining multiple tables in a single query and trying to retrieve all their fields. For more information, see <https://763631.app.netsuite.com/app/help/helpcenter.nl?fid=section_N751341.html#bridgehead_4781145588|Custom Field Limitations>.

<https://system,netsuite.com/app/help/helpcenter.nl?fid=section_4407755805.html>

I think the limit is actually 1004 based on my testing :-)

I'm just running two extracts for transactions.

Can I piggy back here? Am I crazy (or if there is a reason) that the transaction table here doesn't have amount fields? i.e. amount paid, amount remaining

It's in the transactionaccountingline table