Table paypal testing

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

Database Version

1.3.5


Description

Help.gif


Table Details

Primary Key

paypal_ipn_id
txn_id

Indexed Fields

zen_order_id


Columns

paypal_ipn_id Primary Key

A unique, auto incremented value to identify each paypal record.
Type: int(11)
Null: No
Default:
Atributes: UNSIGNED
Extra: auto_increment


zen_order_id Index

Cross-reference link to the orders table.
Type: int(11)
Null: No
Default: 0
Atributes: UNSIGNED


custom

Help.gif
Type: varchar(255)
Null: No
Default:


txn_type

Help.gif
Type: varchar(10)
Null: No
Default:


reason_code

Help.gif
Type: varchar(15)
Null: Yes
Default: NULL


payment_type

Help.gif
Type: varchar(7)
Null: No
Default:


payment_status

Help.gif
Type: varchar(17)
Null: No
Default:


pending_reason

Help.gif
Type: varchar(14)
Null: Yes
Default: NULL


invoice

Passthrough variable used to identify the invoice number for this purchase.
Type: varchar(64)
Null: Yes
Default: NULL


mc_currency

Help.gif
Type: char(3)
Null: No
Default:


first_name

First name of the customer.
Type: varchar(32)
Null: No
Default:


last_name

Last name of the customer.
Type: varchar(32)
Null: No
Default:


payer_business_name

Help.gif
Type: varchar(64)
Null: Yes
Default: NULL


address_name

Help.gif
Type: varchar(32)
Null: Yes
Default: NULL


address_street

Street address of the customer.
Type: varchar(64)
Null: Yes
Default: NULL


address_city

City of the customer.
Type: varchar(32)
Null: Yes
Default: NULL


address_state

State of the customer.
Type: varchar(32)
Null: Yes
Default: NULL


address_zip

Zip code of the customer.
Type: varchar(10)
Null: Yes
Default: NULL


address_country

Country of the customer.
Type: varchar(64)
Null: Yes
Default: NULL


address_status

Help.gif
Type: varchar(11)
Null: Yes
Default: NULL


payer_email

Help.gif
Type: varchar(96)
Null: No
Default:


payer_id

Help.gif
Type: varchar(32)
Null: No
Default:


payer_status

Help.gif
Type: varchar(10)
Null: No
Default:


payment_date

Date the order was placed.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


business

Email address for your PayPal™ account.
Type: varchar(96)
Null: No
Default:


receiver_email

Help.gif
Type: varchar(96)
Null: No
Default:


receiver_id

Help.gif
Type: varchar(32)
Null: No
Default:


txn_id Primary Key

Help.gif
Type: varchar(17)
Null: No
Default:


parent_txn_id

Help.gif
Type: varchar(17)
Null: Yes
Default: NULL


num_cart_items

Help.gif
Type: tinyint(4)
Null: No
Attributes: UNSIGNED
Default: 1


mc_gross

Help.gif
Type: decimal(7,2)
Null: No
Default: 0.00


mc_fee

Help.gif
Type: decimal(7,2)
Null: No
Default: 0.00


payment_gross

Help.gif
Type: decimal(7,2)
Null: Yes
Default: NULL


payment_fee

Help.gif
Type: decimal(7,2)
Null: Yes
Default: NULL


settle_amount

Help.gif
Type: decimal(7,2)
Null: Yes
Default: NULL


settle_currency

Help.gif
Type: char(3)
Null: Yes
Default: NULL


exchange_rate

Help.gif
Type: decimal(4,2)
Null: Yes
Default: NULL


notify_version

Help.gif
Type: decimal(2,1)
Null: No
Default: 0.0


verify_sign

Help.gif
Type: varchar(128)
Null: No
Default:


last_modified

Date and time the record was last modified.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


date_added

Date and time the record was first added.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


memo

Help.gif
Type: text
Null: Yes
Default: NULL


Default Entries

None.