I'm using suiteQL to fetch transactions. Can you help with the table and data field where GL code information is stored?

AI generated answer (using internal Slack threads):

In NetSuite, the GL code information is typically stored in the

Account

record. When you're using SuiteQL to fetch transactions, you can join the

Transaction

table with the

Account

table to get the GL code information. Here's a simple example of how you might do this:

sql
SELECT T.id, T.type, T.date, A.acctname, A.acctnumber
FROM Transaction T
JOIN Account A ON T.account = A.id
WHERE T.type = 'Journal'

In this example,

T.account

is the account ID on the transaction,

A.acctname

is the account name (which often includes the GL code), and

A.acctnumber

is the GL code itself. Please note that the actual field names and table names may vary depending on your NetSuite setup. You may need to adjust the query to match your specific configuration. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******