Table paypal testing

From Zen Cart(tm) Wiki

Contents 1 Database Version 2 Description 3 Table Details 3.1 Primary Key 3.2 Indexed Fields 4 Columns 4.1 paypal_ipn_id 4.2 zen_order_id 4.3 custom 4.4 txn_type 4.5 reason_code 4.6 payment_type 4.7 payment_status 4.8 pending_reason 4.9 invoice 4.10 mc_currency 4.11 first_name 4.12 last_name 4.13 payer_business_name 4.14 address_name 4.15 address_street 4.16 address_city 4.17 address_state 4.18 address_zip 4.19 address_country 4.20 address_status 4.21 payer_email 4.22 payer_id 4.23 payer_status 4.24 payment_date 4.25 business 4.26 receiver_email 4.27 receiver_id 4.28 txn_id 4.29 parent_txn_id 4.30 num_cart_items 4.31 mc_gross 4.32 mc_fee 4.33 payment_gross 4.34 payment_fee 4.35 settle_amount 4.36 settle_currency 4.37 exchange_rate 4.38 notify_version 4.39 verify_sign 4.40 last_modified 4.41 date_added 4.42 memo 5 Default Entries

Database Version

1.3.5

Description

Table Details

Primary Key

paypal_ipn_id

txn_id

Indexed Fields

zen_order_id

Columns

paypal_ipn_id

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

Type:	int(11)
Null:	No
Default:
Atributes:	UNSIGNED
Extra:	auto_increment

zen_order_id

Cross-reference link to the orders table.

Type:	int(11)
Null:	No
Default:	0
Atributes:	UNSIGNED

custom

Type:	varchar(255)
Null:	No
Default:

txn_type

Type:	varchar(10)
Null:	No
Default:

reason_code

Type:	varchar(15)
Null:	Yes
Default:	NULL

payment_type

Type:	varchar(7)
Null:	No
Default:

payment_status

Type:	varchar(17)
Null:	No
Default:

pending_reason

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

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

Type:	varchar(64)
Null:	Yes
Default:	NULL

address_name

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

Type:	varchar(11)
Null:	Yes
Default:	NULL

payer_email

Type:	varchar(96)
Null:	No
Default:

payer_id

Type:	varchar(32)
Null:	No
Default:

payer_status

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

Type:	varchar(96)
Null:	No
Default:

receiver_id

Type:	varchar(32)
Null:	No
Default:

txn_id

Type:	varchar(17)
Null:	No
Default:

parent_txn_id

Type:	varchar(17)
Null:	Yes
Default:	NULL

num_cart_items

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

mc_gross

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

mc_fee

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

payment_gross

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

payment_fee

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

settle_amount

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

settle_currency

Type:	char(3)
Null:	Yes
Default:	NULL

exchange_rate

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

notify_version

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

verify_sign

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

Type:	text
Null:	Yes
Default:	NULL

Default Entries

None.