where can I find the transaction field ids to be used with the query module (the columns)}?

AI generated answer (using internal Slack threads):

You can find the transaction field ids to be used with the query module in the NetSuite Record Browser. Here is the link to the NetSuite Record Browser: https://www.netsuite.com/portal/developers/resources/apis/record-browser.shtml In the Record Browser, you can navigate to the specific transaction record type you are interested in (e.g., Sales Order, Invoice, etc.). Once you are on the page for that record type, you can find a list of all the fields for that record, including their ids, labels, and descriptions. These field ids can be used in your SuiteQL queries. For example, if you are looking for the field id for the 'Amount' field on the 'Invoice' record, you would navigate to the 'Invoice' record in the Record Browser and find the 'Amount' field in the list. The id for this field is 'total'. Please note that custom fields have their own ids which are usually prefixed with 'custcol_' or 'custbody_' for column and body fields respectively. These can also be found in the Record Browser under the 'Custom' section. Here is an example of how you might use a field id in a SuiteQL query:

SELECT total FROM transaction WHERE id = 12345

In this example, 'total' is the field id for the 'Amount' field on the 'Invoice' record, and '12345' is the id of a specific transaction. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******