This is only possible using the AIM method, in the AIM Method the transaction ID is set to the sessionID, you could store the session ID in the database.
With the SIM, the transaction ID is set by the authorize.net server and is not passed back to the site.