```SELECT Credit.TranDate, Credit.TranID, BUILT...
# suiteql
t
Copy code
SELECT
	Credit.TranDate,
	Credit.TranID,
	BUILTIN.DF( Credit.Entity ) AS Vendor,
	BUILTIN.DF( CreditLine.CreatedFrom ) AS Bill,
	CreditLine.ForeignAmount,
	CreditLine.*
FROM
	Transaction AS Credit
	INNER JOIN TransactionLine AS CreditLine ON
		( CreditLine.Transaction = Credit.ID )
		AND ( CreditLine.Mainline = 'T' )
WHERE
	Credit.ID = 1438783