Using SuiteQL, check to see if

custitem_procurify_sync

exists as a custom field

AI generated answer (using internal Slack threads):

To check if

custitem_procurify_sync

exists as a custom field using SuiteQL, you can use the

CustomField

table. Here is a sample query:

sql
SELECT scriptid FROM CustomField WHERE scriptid = 'custitem_procurify_sync'

This query will return the

scriptid

if the custom field

custitem_procurify_sync

exists. If the query returns no results, it means that the custom field does not exist. Please note that you need to have the necessary permissions to access the

CustomField

table and the specific custom field. If you are unable to find the custom field, it could be due to a permissions issue or the field might not be storing a value. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******