Table authorizenet

From Zen Cart(tm) Wiki

Database Version

1.3.5

Description

Stores debug and transaction-related data for authorize.net-AIM transactions. Only used when the authorize.net AIM module is activated, and then only when "Enable Database Storage" is selected. Generally only used for debugging purposes; however, can be useful in tracking potential fraud activities too.

Table Details

Primary Key

id

Indexed Fields

None

Columns

id

A unique, auto incremented value, to identify each authorizenet record.

Type: int(11)

Null: No

Default:

Extra: auto_increment

Attributes: UNSIGNED

customer_id

Links the specific authorizenet record to the customer that created it.

Type: int(11)

Null: No

Default: 0

order_id

The order_id of the specific order.

Type: int(11)

Null: No

Default: 0

response_code

A code provided to the merchant by the card issuing bank that indicates the results of a transaction request; and if declined, the reason why the transaction was rejected.

Type: int(1)

Null: No

Default: 0

response_text

The text the corresponds to the returned response code.

Type: varchar(255)

Null: No

Default:

authorization_type

Indicates the type of authorization request made/approved by authorize.net. Values are: auth_only and capture.

Type: text

Null: No

Default:

transaction_id

A unique identification value assigned to each transaction processed through the payment gateway. This ID may be used to search for or sort transactions.

Type: int(15)

Null: No

Default: 0

sent

The actual data sent to authorize.net for processing. Used for debugging purposes.

Type: longtext

Null: No

Default:

received

The actual data received back from authorize.net. Used for debugging purposes.

Type: longtext

Null: No

Default:

time

The date/time stamp of the transaction as it occurred on the authorize.net server.

Type: varchar(50)

Null: No

Default:

session_id

The session id (zenid) during which the transaction was initiated.