[achandlerworth@dwr.com]

How do you determine the name of the ‘table’ to reference in Netsuite’s ODBC connector for Custom Record Types?

I have one record type, for example name = Department, ID = customrecord_hm_dept and in the ODBC I found it via

[LINKEDSERVER].[ENVIRONMENTNAME].Administrator.DEPARTMENT

However, I have another near-identical record type called Class. name = Class, ID = customrecord_hm_itemclass but in the ODBC

I cannot connect via

[LINKEDSERVER].[ENVIRONMENTNAME].Administrator.CLASS

What is the name of the ‘table’ in the odbc and I how to I determine that?

Thank you.
This is a cached copy. Click here to see the original post.

[DBL]

There is a [LINKEDSERVER].[ENVIRONMENTNAME].Administrator.CLASSES, could that be it?

You cannot really determine table names as, like field names, you are depending on their creators following whatever (if any) naming convention Netsuite have.

Table and field info is available in SYSTEM_OA_COLUMNS (if they’ve been made available to ODBC – not all of them are)

[Author]

Posts