A sales order has several lines, each of them having a field "job", which connects to a project. How do I get the value in this field with SuiteQL , given that the transactionline field is not called "job" what is it called instead? please give me a valid SuiteQL statement that will list the jobs/projects on each transaction line

AI generated answer (using internal Slack threads):

In NetSuite, the field that connects to a project on a sales order line is not called "job", it's called "Project". You can access this field in SuiteQL using the "Project" field in the "TransactionLine" table. Here is a sample SuiteQL statement that will list the projects on each transaction line:

sql
SELECT TransactionLine.Transaction, TransactionLine.Project
FROM TransactionLine

This statement will return a list of transactions and the associated projects. Please note that the project field will return the internal ID of the project, not the project name. If you want to get the project name, you would need to join with the "Project" table. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******