Hi all! Is it possible to select all files attached to a transaction (a Bill for example)? I can't seem to find the relationship between the transactions and the files

I've had trouble with this, too - and it doesn't matter whether you're trying to get the attachments for a transaction, entity, etc. From what I can tell, when you attach a file to an entity, NetSuite adds a record to the MessageFile table. However, the record has a NULL value for the Message column. For example:

SELECT * FROM MessageFile WHERE file = 1377

Also, if you query the Message table (based on the Entity ID), there is no new record. I think this is a defect.

Thanks for the help! I've ran into the same issues. As an alternative I was trying to use SuiteScript and trying to get the

MediaItem

field (sublist?) in the records but it appears to always be empty.

@Diogo did you have any luck finding a solution for this? I have the same issue. I know that the file information is stored in the FILE table but haven't found a way to join that to my transaction table

I couldn't do it using SuiteQL

thank you!