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.
This table would look like the list/view in NetSuite > Customization > List Records & Fields > Record Types
or @ app.netsuite.com/app/common/custom/custrecords.nl
That List shows these fields:
- Custom Record Name
- From Bundle
- ID
- Internal ID
- Owner
It would be helpful to have access to the list in Connect and allow us to automate processes related to our BI infrastructure.
