Custom records and custom fields are available over ODBC. However, names of such records may contain space or capital letters. Since SQL standard has naming restrictions, here is a list of facts about naming in NetSuite ODBC:
- Name of a custom record will be the same as the name of table representing it only spaces are replaced by underscores.
- Name of a custom field will be the same as the name of column representing it only the spaces are replaced by underscores.
- NetSuite ODBC interface operates in case insensitive mode. Therefore case does not matter.
Example #1 (custom record):
Custom record name: Nature of Transaction
Table name in ODBC: Nature_of_Transaction
Example #2 (custom field):
Custom field name: Coupon code
Column name in ODBC: coupon_code
Example #3 (case insensitivity):
"NATURE_OF_TRANSACTION" is the same as "Nature_of_Transaction"
Another option, more precise I would say.
ReplyDeleteUse the following SQL code:
SELECT* FROM oa_tables;
allows you to get all the tables, included the custom records
SELECT* FROM oa_columns;
allows you to get all the columns, included the custom fields
Hope this can help!