does anyone know to what table the

systemnote.type

field links to? (SuiteQL)

I don't know if it helps, but the ODBC foreign key is to the

NOTETYPE

table.

NOTETYPE.NOTE_TYPE_ID

thanks, that may be a clue

@tdietrich ^ ?

I've run into that, too. I mentioned it in this post: https://timdietrich.me/blog/netsuite-suiteql-system-notes-auditing/ I never did figure it out. I think it maps to something like "set," but I could never find the related table. And the BUILTIN.DF function just returns the numeric value. blobthinkingeyes

exactly, the closest I was able to get was using Analytics to derives the key/values 1-4