Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
In SuiteConnect is the a Table that lists every Custom Record Type with its ID and Name?
I asked this question years ago in the community but no one had an answer.
We use the ODBC SuiteConnect feature to build a BI data warehouse in SQL Server that supports all our BI analytics.
I have wanted to be able to look up information related to Custom Record Types and their attributes. Take for instance if you were querying System_Notes table and it has the field RECORD_TYPE_ID which correlates with a Custom Record Type, and currently I have to go into NetSuite and look up the individual ID numbers to see the Name of the Custom Record Type. I'm hoping there is a System table like CUSTOM_RECORD_TYPES that lists all the Custom Record Types and their attributes but I can't find it in the Connect Tables.