I see there are 4 tables for KN module.  KNNOTEH is the main one.

KNNTDIS is apparently to make a list of notes that have been dismissed, however, these records remain if you restore the note so this cannot be where Sage records the note status. 
KNSEQ just stored the next note number.

KNNTBLOB just shows me that everything is an OLE object so again not helpful.

If it is stored in the main KNNOTEH table, I can't figure out what field it is.  This table really doesn't have many fields and the only one that remotely makes sense is the NOTETYPE field, but that indicates if the note entry is for VENDOR, ITEM, or CUSTOMER.

My end goal for this question is I have a custom report where I would like to only see 'active' notes for the vendors. The active being the key.  I don't want to see future, expired or dismissed ones.  Usually Sage has a status field, but I can't find it.

Thanks for any help in advance!