-- Create Table Statement for 'ProPay Auth Retail Transaction'
DROP TABLE IF EXISTS `PROPAY_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `PROPAY_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	STATE varchar,
	AUTH_CODE varchar,
	PER_TRANS_FEE varchar,
	TRANS_TYPE varchar,
	INV_NUM varchar,
	CONVERTED_CURRENCY_CODE varchar,
	ZIP varchar,
	ADDR varchar,
	RESPONSE_TRANS_NUM varchar,
	RECURRING_PAYMENT varchar,
	COMMENT1 varchar,
	CITY varchar,
	ACCOUNT_NUM int(11),
	AMOUNT int(11),
	AVS varchar,
	CURRENCY_CONVERSION_RATE varchar,
	TRANS_NUM varchar,
	CONVERTED_AMOUNT varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	STATUS varchar,
	RESPONSE_CODE varchar,
	RESP varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	NET_AMT varchar,
	GROSS_AMT varchar,
	GROSS_AMT_LESS_NET_AMT varchar,
	RATE varchar,
	CVV2_RESP varchar,
	CARDHOLDER_NAME varchar,
	STANDARD_ENTRY_CLASS_CODE varchar,
	ACCOUNT_TYPE varchar,
	ACCOUNT_NAME varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;