<@UD5AG5SGM> This might be more than you need, but...
# suiteql
t
@NickSuite This might be more than you need, but it's a start:
Copy code
SELECT
	Transaction.TranID,
	BUILTIN.DF( Transaction.Entity ) AS EntityName,
	BUILTIN.DF( TransactionAccountingLine.AccountingBook ) AS AccountingBookName,
	Account.AcctNumber,
	Account.Fullname AS AccountName,
	TransactionAccountingLine.Debit,
	TransactionAccountingLine.Credit,
	TransactionAccountingLine.Posting,
	TransactionLine.Memo
FROM 
	Transaction
	INNER JOIN TransactionAccountingLine ON
		( TransactionAccountingLine.Transaction = Transaction.ID )
	LEFT OUTER JOIN TransactionLine ON
		( TransactionLine.Transaction = TransactionAccountingLine.Transaction )
		AND ( TransactionLine.LineSequenceNumber = TransactionAccountingLine.TransactionLine )
	LEFT OUTER JOIN Account ON
		( Account.ID = TransactionAccountingLine.Account )
WHERE 
	( Transaction.ID = 2808592 )
	AND ( TransactionAccountingLine.Account IS NOT NULL )
	-- AND ( TransactionAccountingLine.NetAmount <> 0 )
	-- AND ( TransactionAccountingLine.Posting = 'T' )
ORDER BY
	TransactionAccountingLine.TransactionLine
I hope that helps.