Discussions
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Finding Custom Transactions With ODBC
Trying to use the CData ODBC connector to view a custom transaction we have created. I can see our custom fields and custom records, but don't know where to query the custom transactions. Is it something I have to build from the Transactions table? Where is the link?
All I see where I query that transaction is this:
Enter your SQL query: select * from Transactions where InternalId = 1193561
(u'1193561', u'setupCustom:CustomTransaction', None, None, None, None, None, None, None, datetime.datetime(2017, 5, 19, 14, 12, 16), None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, datetime.datetime(2017, 5, 19, 14, 12, 16), None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, 1.0, datetime.datetime(2017, 5, 19, 0, 0), u'AWP-7', None, None)