Friday, April 19, 2019

Custom Record and Custom Field Name in ODBC

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:

  1. Name of a custom record will be the same as the name of table representing it only spaces are replaced by underscores.
  2. Name of a custom field will be the same as the name of column representing it only the spaces are replaced by underscores.
  3. 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"

1 comment:

  1. Another option, more precise I would say.

    Use 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!


    ReplyDelete