SELECT
	Transaction.TranID,
	Transaction.TranDate AS date,
	Transaction.duedate AS due_date,
	Transaction.foreigntotal as total,
	Transaction.foreignamountunpaid AS amount_paid,
	Transaction.foreignamountpaid AS remaining_balance,
	BUILTIN.DF( Transaction.Status ) AS Status,
FROM
	Transaction
	INNER JOIN Entity ON
		( Entity.ID = Transaction.Entity )
WHERE
	Transaction.Type = 'CustInvc' AND Entity.Id = 23268