Authorize.Net AIM Logging

[Butta]

Does anyone know of any transaction logging extensions to the Authorize.Net AIM module? I need accountability and logs of accepts/declines/etcs, and their corresponding transaction ids from Authorize.Net.

[Butta]

ok, its stored in TABLE_AUTHORIZENET => <prefix>_authorizenet, but that table isn't created by default. Where can I find the schema?

[Butta]

found the schema:

CREATE TABLE `<DB PREFIX>_authorizenet` (
id int(11) unsigned not null primary key auto_increment ,
customer_id int(11) unsigned not null default 0,
order_id int(11) unsigned not null default 0,
response_code int(11) unsigned not null default 0,
response_text varchar(255) not null default '',
authorization_type text not null default '',
transaction_id int(15) not null default 0,
sent longtext not null default '',
received longtext not null default '',
time varchar(50) not null default '',
session_id varchar(255) not null default '');

Now I need to write something to easily look this up in the order screen.

[dpicella]

Thank you!

This was very helpful! AIM message received... problem solved!

I'll drink to that!

[DrByte]

ok, its stored in TABLE_AUTHORIZENET => <prefix>_authorizenet, but that table isn't created by default. Where can I find the schema?

This table "is" created by default in Zen Cart v1.3.x and newer.

Setting the "Enable Database Storage" option in the AIM configuration parameters will store the data. The data will show in the Admin on the order page for each individual order.