-- Create Table Statement for 'Evo Auth Retail Transaction'
DROP TABLE IF EXISTS `EVO_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `EVO_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	RESPONSE_TIME varchar,
	LANE_ID varchar,
	PHONE_RESULT varchar,
	RESPONSE_AMOUNT varchar,
	STATE_PROVINCE varchar,
	CHARGE_TYPE varchar,
	ORIGINATOR_TRANSACTION_ID varchar,
	DESCRIPTION varchar,
	ORDER_NUMBER varchar,
	LAST varchar,
	POSTAL_CODE varchar,
	REFERENCE_RESULT varchar,
	TAX_AMOUNT varchar,
	TRANSACTION_DATE_TIME varchar,
	INDUSTRY_TYPE varchar,
	PIN_DEBIT_REASON varchar,
	EMPLOYEE_ID varchar,
	CITY varchar,
	CUSTOMER_SERVICE_INTERNET varchar,
	PREPAID_CARD varchar,
	CAPTURE_STATE varchar,
	CV_RESULT varchar,
	TIP_AMOUNT varchar,
	RESPONSE_DATE varchar,
	SETTLEMENT_DATE varchar,
	TAX_EXEMPT_NUMBER varchar,
	COUNTRY_RESULT varchar,
	TRANSACTION_STATE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	TOTAL_NUMBER_OF_INSTALLMENTS varchar,
	FEE_AMOUNT varchar,
	RESPONSE_STATUS_CODE varchar,
	BILL_PAYMENT varchar,
	RESPONSE_STATUS_MESSAGE varchar,
	AMOUNT varchar,
	CV_DATA_PROVIDED varchar,
	IS_TAX_EXEMPT varchar,
	INVOICE_NUMBER varchar,
	CAPTURE_AMOUNT varchar,
	CARDHOLDER_NAME_RESULT varchar,
	COMPANY_NAME varchar,
	ADVICE_RESPONSE varchar,
	CARDHOLDER_NAME varchar,
	RETURN_AMOUNT varchar,
	APPLICATION_PROFILE_ID varchar,
	SHIP_DATE varchar,
	APPROVAL_CODE varchar,
	ACCOUNT_TYPE varchar,
	BATCH_ID varchar,
	DOWNGRADE_CODE varchar,
	SIGNATURE_CAPTURED varchar,
	RESUBMIT varchar,
	ENTRY_MODE varchar,
	COUNTRY_CODE varchar,
	PHONE varchar,
	CITY_RESULT varchar,
	RETURNED_ACI varchar,
	RESPONSE_TIME_ZONE varchar,
	FIRST varchar,
	CUSTOMER_PRESENT varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	RETRIEVAL_REFERENCE_NUMBER varchar,
	HEALTHCARE_AMOUNT varchar,
	STREET1 varchar,
	CARD_TYPE varchar,
	RESPONSE_STATUS varchar,
	ORDER_ID varchar,
	REFERENCE varchar,
	STATE_RESULT varchar,
	NAME varchar,
	CUSTOMER_SERVICE_PHONE varchar,
	CURRENT_INSTALLMENT_NUMBER varchar,
	FINAL_BALANCE varchar,
	CURRENCY_CODE varchar,
	SERVICE_TRANSACTION_ID varchar,
	ACTUAL_RESULT varchar,
	IS_ACKNOWLEDGED varchar,
	EMAIL varchar,
	POSTAL_CODE_RESULT varchar,
	CARD_LEVEL varchar,
	CASH_BACK_AMOUNT varchar,
	BASE_AMOUNT varchar,
	COMMERCIAL_CARD_RESPONSE varchar,
	MASKED_PAN varchar,
	SERVICE_ID varchar,
	ADDRESS_RESULT varchar,
	TRANSACTION_ID varchar,
	BUSINESS_NAME varchar,
	PAYMENT_ACCOUNT_DATA_TOKEN varchar,
	REQUEST_TYPE varchar,
	MERCHANT_PROFILE_ID varchar,
	AUTHORIZATION_SERVER_URL varchar,
	RETURN_TOTALS_NET_AMOUNT varchar,
	BATCH_AMOUNT varchar,
	RETURN_TOTALS_COUNT varchar,
	SALE_TOTALS_NET_AMOUNT varchar,
	VOID_TOTALS_COUNT varchar,
	VOID_TOTALS_NET_AMOUNT varchar,
	FORCE_POST_CODE varchar,
	MESSAGE_AUTHENTICATION_CODE varchar,
	LAST_PAN_DIGITS varchar,
	TOKEN_INFORMATION varchar,
	PIN_DEBIT_RETURN_TOTALS_NET_AMOUNT varchar,
	PIN_DEBIT_SALE_TOTALS_NET_AMOUNT varchar,
	ERROR_STRING varchar,
	PIN_DEBIT_SALE_TOTALS_COUNT varchar,
	HOST_MESSAGE_ID varchar,
	SALE_TOTALS_COUNT varchar,
	NET_TOTALS_COUNT varchar,
	ERROR_CODE varchar,
	ERROR_TYPE varchar,
	PROCESSED_AS3_D varchar,
	TRANSMISSION_NUMBER varchar,
	NET_TOTALS_NET_AMOUNT varchar,
	CASH_BACK_TOTALS_NET_AMOUNT varchar,
	TRANSACTION_CODE varchar,
	TERMINAL_ID varchar,
	PAYMENT_AUTHORIZATION_REQUEST varchar,
	PIN_DEBIT_RETURN_TOTALS_COUNT varchar,
	CASH_BACK_TOTALS_COUNT varchar,
	LEVEL3_ADDED varchar,
	EXISTING_DEBT varchar,
	ORDER_NUMBER_LEVEL2 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;