I'm using SuiteQL to query transaction records. I'm using "Select * From transaction" what is the reason I don't see the class field in the results? seems like class is not included in SuiteQL (transaction body field = class)

AI generated answer (using internal Slack threads):

The reason you don't see the class field in the results when using SuiteQL to query transaction records with "Select * From transaction" is because the class field is not directly included in the transaction table in SuiteQL. In NetSuite, the class field is a type of custom field that is often used for classification purposes. However, it is not directly included in the transaction table in SuiteQL. Instead, it is stored in a separate table and linked to the transaction table through a relationship. If you want to include the class field in your SuiteQL query results, you would need to join the transaction table with the appropriate table that contains the class field. This can be done using a JOIN clause in your SuiteQL query. Please note that the exact table and field names may vary depending on your NetSuite setup, so you may need to adjust the query accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******