I am trying to create a SuiteQL query for something that can’t be created in a Dataset/Workbook. Specifically, we have a custom File field on transactions, which links to a PDF stored in the filing cabinet. all I want to do is return the id of that file. For some reason, the field is not available to be added to a Dataset. Will SuiteQL be able to access this field? If so, what identifier do I use for the field? Would it be the scriptid, or something else? I have noticed that some things like internalid are just id in SuiteQL.

use the custom field internalid e.g.

custbody_my_field

thanks!