When editing an item record one can attach Files to the item record.
When using drag and drop we can do the same.
But when I want to build a search on the item record I do not find the Files sublist.
Also when using the '....&xml=T' view of the Item form no mention is made of a Files 'Machine'.
Approaching this issue from the other side I'm stumped not to find a join to entity , item or transaction in the record browser of the 'File' record type https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2021_1/script/record/file.html
However, NetSuite must store this link somewhere otherwise it would be impossible to show the correct records in the Files sublists. I guess it's in a seperate table because it must be possible to join one single file to many database objects of different types(entity,item, transaction) .
But why this linking table should not be accessible is a mistery to me.
With the exact same question I only found this link to a netsuiteprofessionals page
But it contains no solution.
I still hope I'm stupidly overlooking something known to all. Please enlighten me.