How can I pull all the custom fields ids and name from a custom record table through suiteQL?

AI generated answer (using internal Slack threads):

To pull all the custom fields ids and names from a custom record table through SuiteQL, you can use the following query:

sql
SELECT 
    scriptid, 
    name 
FROM 
    CustomField 
WHERE 
    recType = '<custom record internal id>'

In the above query, replace

<custom record internal id>

with the internal id of your custom record. This query will return all the custom fields (both ids and names) associated with the specified custom record. Please note that you need to have the necessary permissions to run SuiteQL queries and access the

CustomField

table. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******