Table authorizenet

From Zen Cart(tm) Wiki
Jump to: navigation, search

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 Primary Key

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.
Type: varchar(255)
Null: No
Default:


Default Entries

None.