I'm seeking assistance with Oracle NetSuite Integration as we are new to NetSuite, specifically to extract data for the following entities:
1. Customers and contacts
2. Invoices and their PDF versions
3. Credit memos
4. Payments and payment links - to know whether link between invoice and payment or creditmemo and invoice link.
We are unsure which table to use for extracting the "Currency Revaluation" adjustment entry.
Since Oracle is quite restrictive with its REST API, I've begun learning SuiteQL, but I have many questions. Could you please let me know if anyone can assist us?