Is there anywhere in the DB that links a transacti...
# suitescriptc
Craig
10/29/2025, 2:44 PMIs there anywhere in the DB that links a transaction to an account?
I looked through the transaction table but don't see anywhere an account is stored
This is on netsuite2.com
d
Dmitry Masanov
10/29/2025, 2:53 PMI did it through transactionline:
INNER JOIN account ON TL.expenseaccount = account.id
c
Craig
10/29/2025, 2:55 PMI'll try to twist that into our usecase but it looks crazy
Craig
10/29/2025, 3:12 PMI can't even find the expenseaccount column on the transactionline
Craig
10/29/2025, 3:12 PMAlthough that's specifically for expense lines which won't work more broadly.
Craig
10/29/2025, 3:37 PMLooks like it should be there.
g
Geo
10/29/2025, 4:48 PMexpenseaccount on transactionline should be what you are after. mainline = T for header level stuff. At least in suiteql anyway. I think the new records catalog is more accurate for tables/columns.
c
Craig
10/29/2025, 4:49 PM@Geo Why would mainline matter at the table level? I'd also say you want the connect browser instead of the record browser when you're using JDBC/ODBC.
g
Geo
10/29/2025, 5:04 PMIsn't netsuite2 is just suiteql more or less? The records browser is the new connect browser from my understanding. If you look at a single transaction id = 1234 or transactionline transaction = 1234. The transaction table should only return 1 record where the transactionline table will return at least two, one mainline T and one mainline F for each transactionline. Unless JDBC/ODBC is completely different.
c
Craig
10/29/2025, 8:24 PM Copy code
select * from Transactionline where transaction = 4132581✅ 1
Craig
10/29/2025, 8:25 PMI'm looking at a journal entry with five lines (rows) but there is no column/field that links to the account - I can see the account column in NS UI though so I'm not sure how they're doing this?
Craig
10/29/2025, 8:27 PMand there is no column called 'expenseaccount'
Craig
10/29/2025, 8:34 PMI figured it out.
The accounts are on the transactionaccountingline table and required joining via the transaction id
💯 1
3 Views