how can I query systemnote2 for notes on transaction records with suiteql?

AI generated answer (using internal Slack threads):

To query systemnote2 for notes on transaction records with SuiteQL, you can use the following query:

sql
SELECT * FROM systemnote2 WHERE recordtype = 'transaction'

This query will return all system notes associated with transaction records. The 'recordtype' field in the systemnote2 table corresponds to the type of record the note is associated with. In this case, we're looking for notes associated with 'transaction' records. Please note that the actual fields you select in your query may vary depending on the specific information you're looking for. For example, you might want to select the 'note' field to get the text of the note, or the 'date' field to see when the note was added. Also, please note that SuiteQL is case-insensitive, so it doesn't matter whether you use upper-case or lower-case letters in your query. Remember to have the necessary permissions to access the systemnote2 table. You can check the required permissions here: https://timdietrich.me/blog/netsuite-suiteql-tables-permissions-reference/ ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******