Anthony OConnor
SELECT t.entity AS customerId, t.amountremaining AS openBalance, t.subsidiary AS subsidiaryId, FROM transaction AS t