Anyone has been able to get Document/File ID from a custom field of type List/Record Document using SuiteQL? When I try NetSuite say DOCUMENT is not supported, I'm unable to make a left join with file...

no joy on my end. It’s weird because you can

JOIN

to files if the field is native, such as an attachment on a message, just doesn’t seem to be exposed if the file is a custom field.