|
customer_given_name
|
varchar(48)
|
|
|
|
|
customer_middle_name
|
varchar(50)
|
|
|
|
|
customer_surname
|
varchar(48)
|
|
|
|
|
customer_ip
|
varchar(255)
|
|
|
|
|
customer_merchant_customer_id
|
varchar(16)
|
|
|
|
|
merchant_transaction_id
|
varchar(255)
|
|
|
|
|
customer_email
|
varchar(128)
|
|
|
|
|
customer_identification_doc_type
|
enum
|
-- |
|
|
|
customer_identification_doc_id
|
char(10)
|
|
|
|
|
cart_items_name
|
varchar(255)
|
|
|
|
|
cart_items_description
|
varchar(255)
|
|
|
|
|
cart_items_price
|
decimal(13,2)
|
|
|
|
|
cart_items_quantity
|
decimal(12,3)
|
|
|
|
|
customer_phone
|
varchar(25)
|
|
|
|
|
shipping_street1
|
varchar(100)
|
|
|
|
|
billing_street1
|
varchar(100)
|
|
|
|
|
shipping_country
|
char(2)
|
|
|
|
|
billing_country
|
char(2)
|
|
|
|
|
test_mode
|
enum
|
-- |
|
|
|
customParameters_SHOPPER_VAL_BASE0
|
decimal(7,2)
|
|
|
0.00
|
|
customParameters_SHOPPER_VAL_BASEIMP
|
decimal(7,2)
|
|
|
0.00
|
|
customParameters_SHOPPER_VAL_IVA
|
decimal(7,2)
|
|
|
0.00
|
|
customParameters_SHOPPER_MID
|
varchar(10)
|
|
|
|
|
customParameters_SHOPPER_TID
|
varchar(10)
|
|
|
|
|
customParameters_SHOPPER_ECI
|
varchar(10)
|
|
|
|
|
customParameters_SHOPPER_PSERV
|
varchar(10)
|
|
|
|
|
customParameters_SHOPPER_VERSIONDF
|
int(11)
|
|
|
2
|
|
risk_parameters_USER_DATA2
|
varchar(30)
|
|
|
|