anyone here worked with the systemnote table via SuiteQL? From Tim's blog post (https://timdietrich.me/blog/netsuite-suiteql-system-notes-auditing/) i get that "Type" is the type of change action (create, set etc). but i can't find a table/ function that maps the type (which is a number) to a descriptive text.. can anyone give me a hand here? thanks a lot!

Find one of each number, look up the Record in NetSuite proper and check the system notes for the corresponding change. Then you will know what number goes with what type.