Is this table supposed to exist in the NS2 schema?...
# suiteqlc
Craig
10/29/2025, 3:55 PMIs this table supposed to exist in the NS2 schema?
Copy code
Invalid search type: Transactionsg
Geo
10/29/2025, 4:50 PMDo you have access to the NS account to use the new records catalog under setup?
c
Craig
10/29/2025, 4:50 PMYes
Craig
10/29/2025, 4:51 PMI'm not clear on the terminology either: the concept of a record doesn't really apply in the datanase.
Craig
10/29/2025, 4:51 PMa record is a view of data pulled from several tables, probably though object relational mapping.
Craig
10/29/2025, 4:52 PMAt the DB level, we're looking directly into the tables that sit beneath the records
g
Geo
10/29/2025, 4:58 PMRight so the transaction table gets you some info, transactonline get you more, there is also transactionaccountline depending on what you are looking for. The records catalog is just dynamic to your account so will include custom fields and such as well so if you know the field you can search for it and maybe figure out what table its in.
b
Bryan Miller
10/29/2025, 9:36 PMYou are looking at the wrong catalog. You need the Records Catalog located in SETUP > Records Catalog . This will show you all the table names for suiteql and the NS2 datasource.
c
Craig
10/29/2025, 10:15 PM@Bryan Miller
Thanks - do you know why transactionline isn't in the top level of that list and I can only find it via looking into the transaction table?
Craig
10/29/2025, 10:27 PMIt's a bit difficult to explore because some tables are only discoverable by looking into their parent. e.g.
b
Bryan Miller
10/29/2025, 10:31 PMYeah that can be a little icky to have to go through the parents. I would guess that they made a decision about what they consider to be the root record and what branches off of it. You can manipulate the url a little if you know the table name you are looking for
c
Craig
10/29/2025, 11:18 PMTherein lies the problem, we're migrating from NS1 to NS2 and we don't always know the table names.
Craig
10/29/2025, 11:19 PMand the record browser hides tables within tables. It's a case of having to discover things yourself.
r
RJMNS
10/29/2025, 11:27 PMThis might help. It's not all-encompassing or anything, but it has a lot of the major stuff. It's what I put together when I had to do the transition. Disclaimer: this is not guaranteed to be correct, I'm not going to bother to update it further, blah blah blah legalese
RJMNS
10/29/2025, 11:31 PMSuiteAnswers has something similar to that ☝️, but I found it lacking in a bunch of areas and wrong in others, so I stopped bothering trying to use it and made my own. NetSuite's may be useful for ones not covered by mine though.
c
Craig
10/29/2025, 11:48 PMLooks good - thanks.
3 Views