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 how to find the table for a custom segment in <http://NetSuite2.com|NetSuite2.com> via ODBC?

pretty strange that i can find it using suite analytics

<@U3J3E9R50> I think this is how you'd do it with SuiteQL:

-- Use this to get the "RecordType."
-- In my case, 275 is the RecordType.
`SELECT TOP 10 * FROM CustomSegment`

-- Use this to get the ScriptID.
-- In my case, CUSTOMRECORD_CSEG_REGION is the ScriptID.
`SELECT TOP 10 * FROM CustomRecordType WHERE InternalID = 275`

-- The ScriptID is the name of the custom table with the segment's values.
`SELECT TOP 10 * FROM CUSTOMRECORD_CSEG_REGION`

Hope that helps. Have a great weekend!

Description	Resource	Path	Location	Type
SQL Error [10129] [42S02]: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Base table:CUSTOMRECORD_CSEG_PRODUCT not found.