SuiteQL to list items on an Opportunity.

AI generated answer (using internal Slack threads):

To list items on an Opportunity using SuiteQL, you would need to join the

transaction

table with the

transactionline

table. The

transaction

table contains the Opportunity records, and the

transactionline

table contains the line items associated with each transaction. Here is a sample SuiteQL query:

sql
SELECT T.id, T.tranid, TL.item 
FROM Transaction T
JOIN TransactionLine TL ON T.id = TL.transaction 
WHERE T.type = 'Opprtnty'

This query will return the ID and transaction ID of the Opportunity, along with the item ID for each line item on the Opportunity. Please note that the account you're using will need to have permissions on: Transactions > Opportunity. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******