how to get tax code from transaction line via ODBC

AI generated answer (using internal Slack threads):

To get the tax code from a transaction line via ODBC, you would need to query the

TRANSACTION_LINES

table. However, the tax code might not be directly available in this table. In NetSuite, tax information is typically stored in the

TRANSACTION_LINES

table, but it might not be directly accessible or visible. You might need to join it with other tables to get the desired information. Unfortunately, the specific field for tax code in the

TRANSACTION_LINES

table is not mentioned in the provided conversations. If you are trying to get the old and new values of the tax code for auditing purposes, you might need to do a Transaction search and join Line System Notes. However, it's worth noting that the field IDs might be stored differently in system notes, and the tax item might not be directly available. For Journal Entry records, you can refer to the NetSuite Record Browser for the appropriate joins. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******