-- Create Table Statement for 'CC First Data Compass Batch Transaction '
DROP TABLE IF EXISTS `CC_FIRST_DATA_COMPASS_BATCH_TRANSACTION`;
CREATE TABLE `CC_FIRST_DATA_COMPASS_BATCH_TRANSACTION` (
	ID bigint(20) NOT NULL,
	FIRST_DATA_TOKEN_CODE varchar,
	DESCRIPTION varchar,
	MERCHANT_CONTACT_INFORMATION varchar,
	MERCHANT_CITY varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	DIVISION_NUMBER varchar,
	ORDER_NUMBER varchar,
	ACTION_CODE varchar,
	MOP varchar,
	EXPIRATION_DATE varchar,
	AMOUNT varchar,
	NAME_TEXT varchar,
	ADDRESS_LINE1 varchar,
	CITY varchar,
	STATE varchar,
	POSTAL_CODE varchar,
	COUNTRY_CODE varchar,
	ENCRYPTION_FLAG varchar,
	RESPONSE_REASON_CODE varchar,
	RESPONSE_DATE varchar,
	AUTHORIZATION_VERIFICATION_CODE varchar,
	AVS_RESPONSE_CODE varchar,
	DEPOSIT_FLAG varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CC_FIRST_DATA_COMPASS_BATCH_FK bigint(20),
	CC_FIRST_DATA_BATCH_FK bigint(20),
	CHECK_TYPE varchar,
	TELE_CHECK_PRODUCT varchar,
	CHECK_NUMBER varchar,
	ACH_STATUS varchar,
	DENIAL_RECORD_NUMBER varchar,
	PREFERRED_FLAG varchar,
	CONSUMER_DATE_OF_BIRTH varchar,
	CONSUMER_REGISTRATION_NUMBER varchar,
	CONSUMER_REGISTRATION_DATE varchar,
	CLERK_AGENT_ID varchar,
	TERMINAL_ID varchar,
	TELE_CHECK_TRACE_ID varchar,
	TRANSACTION_TYPE varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	TELEPHONE_NUMBER varchar,
	CHECK_TYPE varchar,
	TELE_CHECK_PRODUCT varchar,
	CHECK_NUMBER varchar,
	ACH_STATUS varchar,
	DENIAL_RECORD_NUMBER varchar,
	PREFERRED_FLAG varchar,
	CONSUMER_DATE_OF_BIRTH varchar,
	CONSUMER_REGISTRATION_NUMBER varchar,
	CONSUMER_REGISTRATION_DATE varchar,
	CLERK_AGENT_ID varchar,
	TERMINAL_ID varchar,
	TELE_CHECK_TRACE_ID varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	TELEPHONE_NUMBER varchar,
	TRANSACTION_TYPE varchar,
	CHECK_TYPE varchar,
	TELE_CHECK_PRODUCT varchar,
	CHECK_NUMBER varchar,
	ACH_STATUS varchar,
	DENIAL_RECORD_NUMBER varchar,
	PREFERRED_FLAG varchar,
	CONSUMER_DATE_OF_BIRTH varchar,
	CONSUMER_REGISTRATION_NUMBER varchar,
	CONSUMER_REGISTRATION_DATE varchar,
	CLERK_AGENT_ID varchar,
	TERMINAL_ID varchar,
	TELE_CHECK_TRACE_ID varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	TELEPHONE_NUMBER varchar,
	TRANSACTION_TYPE varchar,
	CURRENCY_CODE varchar,
	EMAIL_ADDRESS varchar,
	TRACKING_NUMBER varchar,
	INITIATION_INDICATOR varchar,
	ORIGINAL_VISA_TRANSACTION_ID varchar,
	SCHEDULE_INDICATOR varchar,
	STORED_CREDENTIAL_INDICATOR varchar,
	VISA_TRANSACTION_ID varchar,
	MESSAGE_TYPE varchar,
	TRACKING_NUMBER varchar,
	INITIATION_INDICATOR varchar,
	ORIGINAL_VISA_TRANSACTION_ID varchar,
	SCHEDULE_INDICATOR varchar,
	STORED_CREDENTIAL_INDICATOR varchar,
	VISA_TRANSACTION_ID varchar,
	TRANSACTION_IDENTITY varchar,
	TRANSACTION_IDENTITY varchar,
	TRACKING_NUMBER varchar,
	INITIATION_INDICATOR varchar,
	ORIGINAL_VISA_TRANSACTION_ID varchar,
	SCHEDULE_INDICATOR varchar,
	STORED_CREDENTIAL_INDICATOR varchar,
	VISA_TRANSACTION_ID varchar,
	TRANSACTION_IDENTITY varchar,
	CURRENCY_CODE varchar,
	EMAIL_ADDRESS varchar,
	MESSAGE_TYPE varchar,
	CC_FIRST_DATA_COMPASS_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	CC_FIRST_DATA_COMPASS_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	CURRENCY_CODE varchar,
	EMAIL_ADDRESS varchar,
	MESSAGE_TYPE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;