Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and 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:
employeeis the record type.entityidis 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
----
- NetSuite Admin Corner | 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 Advanced Accounting. RSVP on this event now!
Tagged:
0