-- Create Table Statement for 'WorldPay Secure Net Auth Retail Transaction'
DROP TABLE IF EXISTS `WORLD_PAY_SECURE_NET_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `WORLD_PAY_SECURE_NET_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	SECURE_NET_ID varchar,
	TRANSACTION_ID varchar,
	AMOUNT varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	LINE1 varchar,
	CITY varchar,
	STATE varchar,
	ZIP varchar,
	COUNTRY varchar,
	COMPANY varchar,
	PHONE varchar,
	EMAIL varchar,
	DEVELOPER_ID varchar,
	VERSION varchar,
	CASH_BACK_AMOUNT varchar,
	ALLOW_PARTIAL_CHANGES varchar,
	TRANSACTION_DUPLICATE_CHECK_INDICATOR varchar,
	ORDER_ID varchar,
	TYPE_OF_GOODS varchar,
	TYPE varchar,
	TOTAL_NUMBER_OF_INSTALLMENTS varchar,
	CURRENT_INSTALLMENT varchar,
	GRATUITY_AMOUNT varchar,
	SERVER varchar,
	NOTES varchar,
	RESULT varchar,
	RESPONSE_CODE varchar,
	MESSAGE varchar,
	TRANSACTION_TYPE varchar,
	RESPONSE_TEXT varchar,
	TRANSACTION_ID_RESPONSE varchar,
	AUTHORIZATION_CODE varchar,
	AUTHORIZED_AMOUNT varchar,
	PAYMENT_TYPE_CODE varchar,
	PAYMENT_TYPE_RESULT varchar,
	SETTLEMENT_DATA_DATE varchar,
	SETTLEMENT_DATA_AMOUNT varchar,
	SETTLEMENT_DATA_BATCH_ID varchar,
	CREDIT_CARD_TYPE varchar,
	CARD_NUMBER varchar,
	AVS_CODE varchar,
	AVS_RESULT varchar,
	CARD_CODE_CODE varchar,
	CARD_CODE_RESULT varchar,
	SURCHARGE_AMOUNT varchar,
	INDUSTRY_SPECIFIC_DATA varchar,
	NETWORK_CODE varchar,
	ADDITIONAL_AMOUNT varchar,
	METHOD varchar,
	CUSTOMER_ID varchar,
	RESPONSE_DATE_TIME varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	REQUEST_TYPE varchar,
	ORDER_DATE varchar,
	PURCHASE_ORDER varchar,
	DUTY_AMOUNT varchar,
	FREIGHT_AMOUNT varchar,
	RETAIL_LANE_NUMBER varchar,
	TAX_AMOUNT varchar,
	STATUS varchar,
	SUCCESS varchar,
	LEVEL2_VALID varchar,
	LEVEL3_VALID varchar,
	REQUEST_DATE_TIME varchar,
	ACCOUNT_TYPE varchar,
	CHECK_TYPE varchar,
	CHECK_NUMBER varchar,
	VERIFICATION varchar,
	AMOUNT_RESPONSE 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;