Hi,
I am trying to figure out the best way to create rest API queries that match the clients needs.
The client is unsure at this point of what tables they are using. They have something that was previously set up for them with another party.
I could use some help with Saved Transaction Search and underlying Tables
Currently the client has a previously saved transaction search :
https://xxx.app.netsuite.com/app/common/search/search.nl ...
Their client search seems to be under the transactions tab...
- I can click on the results tab in the middle of the page - and I can see the list of fields that are used to export to Excel.
- > My problem is that I am unsure what underlying tables these fields are related to.
- > If I did know the underlying tables then my rest API query SQL searches would be improved.
- If I click on "add row" at the bottom - then I am able to add additional fields. I was hoping to see the underlying tables that these fields are associated with but I do not see that.
A related issue is that some of the field names may be the same in various tables - so that is part of my confusion
The Tables I have been working with previously are transaction - transactionline - vendor - customer - subsidiary - transactionaccountingline and others.
#1 Question: how can I figure out the underlying tables that these transaction search fields are associated with?
UPDATE: - When I click on "add row" at the bottom - I see some choices that show things like Account Fields... then if I add one it will be listed like Account:Name or Activity: Company etc.
So that is helpful!
#2 Can I assume that if there is a field that does NOT look like XXX:XXX then it would be part of the base Table? If so What is the base table for what I am looking at now? IS it Transaction or transactionline or transactionaccountingline or what?
#3 More Problem : some fields just say "Name" and "Subsidiary" but I do not know what base table they come from ?
#4 Also I can NOT seem to add basic id fields like entity or id or subsidiary id etc. How can I do that?
Thanks for the Help - Dave