-- Create Table Statement for 'ProPay Return Transaction'
DROP TABLE IF EXISTS `PRO_PAY_RETURN_TRANSACTION`;
CREATE TABLE `PRO_PAY_RETURN_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	SENDING_ACCOUNT_NUM varchar,
	USER_NAME varchar,
	BANK_CITY varchar,
	AVS_CODE_DESCRIPTION varchar,
	LAST_NAME varchar,
	SHIPPING_ADDRESS1 varchar,
	FIRST_NAME varchar,
	EMAIL varchar,
	ACCOUNT_NUM1 varchar,
	BILLING_CITY varchar,
	OWNER_ADDRESS3 varchar,
	CARD_PRESENT varchar,
	DISC_FEE varchar,
	SWEEP_ID varchar,
	OWNER_STATE varchar,
	BILLING_ADDRESS3 varchar,
	BILLING_ADDRESS2 varchar,
	BANK_NAME varchar,
	GROSS_AMOUNT varchar,
	RECEIVING_ACCOUNT_NUM varchar,
	BANK_TELEPHONE varchar,
	OWNER_FIRST_NAME varchar,
	SENDING_PAYER_NAME varchar,
	CREDIT varchar,
	COMMENT11 varchar,
	HAS_CVV2 varchar,
	PER_TRANS_FEE varchar,
	OWNER_CITY varchar,
	AVS_CODE varchar,
	SENDING_PAYER_EMAIL varchar,
	EXP_DATE varchar,
	BANK_STATE_PROVINCE varchar,
	INV_NUM1 varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RESPONSE_CODE_DESCRIPTION varchar,
	DOING_BUSINESS_AS varchar,
	TRANSACTION_DATE varchar,
	TRANSACTION_INFO_ID varchar,
	OWNER_LAST_NAME varchar,
	OWNER_ADDRESS2 varchar,
	COMMENT21 varchar,
	SHIPPING_STATE varchar,
	BILLING_STATE varchar,
	PRO_PAY_RETURN_BATCH_FK bigint(20),
	AFFILIATE_NAME1 varchar,
	CVV2_RESP varchar,
	BILLING_COUNTRY varchar,
	RECEIVING_PAYER_EMAIL varchar,
	TRANSACTION_DETAIL_TYPE varchar,
	TRANSACTION_DETAIL_NAME varchar,
	TRANSACTION_DETAIL_ACCOUNT varchar,
	SHIPPING_POSTAL_CODE varchar,
	BANK_POSTAL_CODE varchar,
	AUTH_CODE varchar,
	BATCH_ID varchar,
	BUSINESS_LEGAL_NAME varchar,
	RESPONSE_CODE varchar,
	TRANSACTION_DETAIL_EMAIL varchar,
	OWNER_ADDRESS1 varchar,
	ATT_NUM1 varchar,
	TRANS_DESCRIPTION1 varchar,
	RECEIVING_PAYER_NAME varchar,
	BILLING_POSTAL_CODE varchar,
	OWNER_POSTAL_CODE varchar,
	OWNER_COUNTRY_CODE varchar,
	AUTH_AMOUNT1 varchar,
	BILLING_ADDRESS1 varchar,
	SHIPPING_CITY varchar,
	AFFILIATE_ID varchar,
	FUND_DATE varchar,
	BANK_ADDRESS1 varchar,
	SHIPPING_NAME varchar,
	BANK_ADDRESS2 varchar,
	SHIPPING_ADDRESS2 varchar,
	CONSUMER_ID varchar,
	EXTERNAL_ID varchar,
	NET_AMOUNT varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;