translate transaction_id to transaction.id