Hi team, I am using the suiteapi tool, runquery, and I need to get the vendor VAT number, which I am unable to find in the vendor table. It feels like some of the metadata tables for vendor, transactions are not visible. can someone please help. @tdietrich Please help if you get time. https://suiteapi.com/

The field is not exposed for us. We use a custom field

custentity_vatregnumber

that copies the

vatregnumber

when a vendor is created/edited. Then we can use the custom field in sql queries.

Thanks @Edgar Valdes, I will use similar logic 🙂