Is this table supposed to exist in the NS2 schema?...
# suiteql
c
Is this table supposed to exist in the NS2 schema?
Copy code
Invalid search type: Transactions
select top 1 * from transaction works fine though. Why is the naming on the connect browser wrong?
g
Do you have access to the NS account to use the new records catalog under setup?
c
Yes
I'm not clear on the terminology either: the concept of a record doesn't really apply in the datanase.
a record is a view of data pulled from several tables, probably though object relational mapping.
At the DB level, we're looking directly into the tables that sit beneath the records
g
Right 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
You 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
@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?
It's a bit difficult to explore because some tables are only discoverable by looking into their parent. e.g.
b
Yeah 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
Therein lies the problem, we're migrating from NS1 to NS2 and we don't always know the table names.
and the record browser hides tables within tables. It's a case of having to discover things yourself.
r
This 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
SuiteAnswers 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
Looks good - thanks.