How do you find tables in the new NetSuite2.com connector?

I am having trouble finding some basic tables in the new NetSuite2.com connection. Things like Product_Line and PRODUCT_TYPE, basic smaller tables that you need just to pull in the description of something. I've tried looking into NetSuite resources and their connection reference table looks like it probably only has a quarter of the available tables. Are there any other resources out there that have mapped NetSuite.com to NetSuite2.com?

Answers

  • chapman
    chapman Member

    Setup a new NetSuite2.com ODBC dataset in Domo and use this query:SELECT * FROM OA_TABLES

    This will give you a list of all the tables in your instance. You can also use SELECT * FROM OA_COLUMNS which will give you all the columns in all the tables.

  • Shana
    Shana Member

    Hi Chapman!

    I do have these but I'm missing A LOT of tables and fields within tables that I have found. Is there an a accurate listing of table/field name conversions someone for the NetSuite to NetSuite2 conversion?