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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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.