-- Create Table Statement for 'Eft First Data Telecheck Retail Transaction'
DROP TABLE IF EXISTS `EFT_FIRST_DATA_TELECHECK_RETAIL_TRANSACTION`;
CREATE TABLE `EFT_FIRST_DATA_TELECHECK_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CHARGE_TRANSACTION_FK bigint(20),
	MERCHANT_ID varchar,
	VERSION_CONTROL varchar,
	ECHO_DATA varchar,
	TRANSACTION_TYPE varchar,
	APPLICATION_TYPE varchar,
	MICR_TYPE varchar,
	CHECK_TYPE varchar,
	MERCHANT_TRACE_ID varchar,
	TOTAL_CHECK_AMOUNT varchar,
	MANUAL_ID_TYPE varchar,
	SUPPLEMENTAL_ID_TYPE varchar,
	BILL_TO_FIRST_NAME varchar,
	BILL_TO_LAST_NAME varchar,
	BILL_TO_ADDRESS_LINE1 varchar,
	BILL_TO_CITY varchar,
	BILL_TO_STATE varchar,
	BILL_TO_ZIP varchar,
	BILL_TO_PHONE varchar,
	BILL_TO_EMAIL varchar,
	BILL_TO_ISO_COUNTRY_CODE varchar,
	DATE_OF_BIRTH varchar,
	MERCHANT_DATE_TIME varchar,
	RECURRING_PAYMENT varchar,
	CREDIT_DEBIT_INDICATOR varchar,
	ACCOUNT_TYPE varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	TELE_CHECK_TRACE_ID varchar,
	ADJUSTMENT_REASON_CODE varchar,
	RESPONSE_CODE varchar,
	APPROVAL_CODE varchar,
	ERROR_LOCATION varchar,
	TELE_CHECK_TRACE_ID_RESPONSE varchar,
	ACH_TRANSACTION_STATUS varchar,
	DENIAL_RECORD_NUMBER varchar,
	TELE_CHECK_DATE_TIME varchar,
	PREFERRED_FLAG varchar,
	SCORE varchar,
	REASON_CODE varchar,
	RETURN_REASON_CODE varchar,
	RETURN_DESCRIPTION varchar,
	FILE_BATCH_FK bigint(20),
	CLIENT_REF varchar,
	TERMINAL_ID varchar,
	FILE_BATCH_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	FILE_BATCH_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;