added method to update transactionTargetId in transactionIn table