Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
New to NetSuite | SuiteQL: Finding Record Type and Field Names Using NetSuite UI
In the New to NetSuite | SuiteQL Overview article, we explored the fundamental concepts and capabilities of SuiteQL. One of the first things you'll need is the correct names of record types and fields for your queries. For example, a simple query like the one below returns a list of employee IDs:
SELECT employee.entityid FROM employee
In this query:
employee
is the record type.entityid
is the field on that record.
But how do you know which record types and fields you can use? One helpful method is to use the NetSuite UI to find the internal IDs of these elements.
Richard James Uri - SuiteCloud | WMS Tech | SuiteCommerce Advanced
----
- New to NetSuite
- Explore the NSC Webinars Category
- Join our poll and share your ideas! We want to know what you think. Don't forget to comment and make your voice heard!
- Expand your NetSuite knowledge by joining this month's Ask A Guru Live about Basic Accounting. RSVP on this event now!