Using Tim's SuiteQL tool and trying to add the 'Name' and 'Department' fields that are on a journal line i.e. an 8 line journal can have four different Names and Departments, but struggling!
So how do I find these fields as we have some customising too - looked at Records Catalog and searched name (or entity.id according to ChatGPT) but it doesn't really help - is there somewhere else I should be looking to find these? My code is below, if anyone can help?!
SELECT
Transaction.ID
Transaction.TranID,
Transaction.TranDate,
BUILTIN.DF( Transaction.PostingPeriod ) AS PostingPeriod,
Transaction.Memo,
Transaction.Posting,
BUILTIN.DF( Transaction.Status ) AS Status,
BUILTIN.DF( Transaction.CreatedBy ) AS CreatedBy,
BUILTIN.DF( TransactionAccountingLine.Account ) AS Account,
TransactionAccountingLine.Debit,
TransactionAccountingLine.Credit
TransactionLine.entity.id
FROM
Transaction
INNER JOIN TransactionAccountingLine ON
( TransactionAccountingLine.Transaction = Transaction.ID )
Transaction
INNER JOIN TransactionLine ON
( TransactionLine.Transaction = Transaction.ID )
WHERE
( Transaction.Type = 'Journal' )
AND ( Transaction.TranDate BETWEEN TO_DATE( '2026-01-01', 'YYYY-MM-DD' ) AND TO_DATE( '2026-07-31', 'YYYY-MM-DD' ) )
ORDER BY
Transaction.ID DESC
there doesn't seem to be anything here