How do I reference the memo field at the header and the message field at the line level in a SuiteQL query

AI generated answer (using internal Slack threads):

To reference the memo field at the header level in a SuiteQL query, you would use the

{memo}

field with

Main Line

set to

true

. This is because the header level information is considered the "main line" of the transaction. Here is an example of how you might structure your query:

sql
SELECT {memo} 
FROM Transaction 
WHERE {Main Line} = true

For the message field at the line level, you would use the

{description}

field with

Main Line

set to

false

. This is because line level information is not considered the "main line" of the transaction. Here is an example of how you might structure your query:

sql
SELECT {description} 
FROM Transaction 
WHERE {Main Line} = false

Please note that SuiteQL is read-only, so you cannot use it to update the memo or description fields. You would need to use SuiteScript or another method to update these fields. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******