what's the best/easiest way to get the createdfrom field? For example on a Credit Memo. The field on NetSuite is at the header level but when I try adding Transaction.createdfrom I get an error of invalid field.

{
  "q": "SELECT ID,Transaction.TranID,Transaction.Type,BUILTIN.DF(Transaction.Status) AS Status,Transaction.Total,Transaction.otherrefnum AS ponum,BUILTIN.DF(Transaction.custbody_ait_rma_return_type) AS rmatype,Transaction.custbody11 AS requestedamount,Transaction.createdfrom FROM Transaction WHERE Transaction.TranID = 'CM39549' AND Transaction.Type IN ('CustCred','RtnAuth')"
}

In SuiteQL,

createdfrom

is a field on the

transactionLine

table.

Join to

transactionLine

but filter by mainline = 'T' to get just the header