We are trying to create SQL query connecting revenue element to source transaction line id. What is the database name of the field line id referenced by source transaction from a specific revenue element id?

Which of the two data sources are you using?

We created saved search from revenue element table and we got the internal transaction and the transaction line id from source transaction join field. We are trying to create a SQL query that connect revenue element the invoice transaction line using the invoice internal id and invoice line id. Unfortunately, we cannot find the line id of the source transaction.

are you using netsuite.com or netsuite2.com?