using sql how do i get the meta data for a custom record including the name of the fields

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To get the metadata for a custom record including the name of the fields in NetSuite, you would typically need to load the custom record definition and then inspect the sublist. However, it seems there is no direct way to get this metadata using SQL or SuiteQL. Here are a few alternative methods discussed in the threads: 1. Use the N/record module to create a record and then get the fields from it. However, this method might have performance issues. 2. Use SuiteQL to run a

SELECT *

query and add conditions and tables as necessary to limit the results to your particular type. 3. If you are client-side, you can call the records catalog internal endpoint. Here is an example of how to do this using jQuery:

javascript
jQuery.get(location+'&xml=t',function(r){
    let xml=new XMLSerializer().serializeToString(r);
    console.log(xml);
    console.log(/_bluchat_mention/ig.test(xml));
})

This method involves loading the XML representation of the record via the browser and then parsing the XML. 4. If you are looking for the name of a custom record or a custom segment (including fields) in SuiteQL, it should be the same as the name of the custom record type. Data for each custom record type in your account is exposed as a table. The name of each table corresponds to the name of the custom record type. Each table includes all custom columns and the following additional columns. You can refer to page 110 in the SuiteAnalytics Connect guide for more information. Please note that these methods might not be the most efficient or the best way to get the metadata for a custom record, and you might need to adjust them based on your specific requirements and the performance of your NetSuite account.