-- Create Table Statement for 'CC Vantiv Tandem Batch Transaction'
DROP TABLE IF EXISTS `CC_VANTIV_TANDEM_BATCH_TRANSACTION`;
CREATE TABLE `CC_VANTIV_TANDEM_BATCH_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CC_VANTIV_TANDEM_BATCH_FK bigint(20),
	TRANSACTION_TYPE varchar,
	DRAFT_LOCATOR_NUMBER varchar,
	TRANSACTION_DATE varchar,
	TRANSACTION_AMOUNT varchar,
	CARDHOLDER_ID_METHOD varchar,
	CARDHOLDER_STREET_ADDRESS varchar,
	ZIP_CODE varchar,
	FIRST_PAYMENT varchar,
	MERCHANT_DESCRIPTOR varchar,
	RESPONSE_CODE varchar,
	RESPONSE_AUTHORIZATION_NUMBER varchar,
	RESPONSE_AUTHORIZATION_DATE varchar,
	RESPONSE_ADDRESS_VERIFICATION_RESP varchar,
	RESPONSE_RECURRING_PAYMENT_ADVICE_CODE varchar,
	RESPONSE_VISA_RETRIEVAL_REFERENCE_NUMBER varchar,
	RESPONSE_VISA_AUTHORIZATION_CHARACTERISTICS_INDICATOR varchar,
	RESPONSE_VISA_TRANSACTION_ID varchar,
	RESPONSE_VISA_VALIDATION_CODE varchar,
	RESPONSE_VISA_CODE varchar,
	RESPONSE_VISA_TOTAL_AUTHORIZED_AMOUNT varchar,
	RESPONSE_VISA_CARD_LEVEL_RESULTS_CODE varchar,
	RESPONSE_MASTERCARD_BANK_NET_REFERENCE_NUMBER varchar,
	RESPONSE_MASTERCARD_RETRIEVAL_REFERENCE_NUMBER varchar,
	RESPONSE_AMEX_TRANSACTION_IDENTIFIER varchar,
	RESPONSE_AMEX_CARD_DATA_INPUT_CAPABILITY varchar,
	RESPONSE_AMEX_CARD_CAPTURE_CAPABILITY varchar,
	RESPONSE_AMEX_OPERATING_ENVIRONMENT varchar,
	RESPONSE_AMEX_CARDHOLDER_PRESENT varchar,
	RESPONSE_AMEX_CARD_PRESENT varchar,
	RESPONSE_AMEX_CARD_DATA_INPUT_MODE varchar,
	RESPONSE_AMEX_CARDMEMBER_AUTHENTICATION varchar,
	RESPONSE_AMEX_CARDMEMBER_AUTHENTICATION_ENTITY varchar,
	RESPONSE_AMEX_CARD_DATA_OUTPUT_CAPABILITY varchar,
	RESPONSE_AMEX_TERMINAL_OUTPUT_CAPABILITY varchar,
	RESPONSE_AMEX_PIN_CAPTURE_CAPABILITY varchar,
	RESPONSE_DISCOVER_PROCESSING_CODE varchar,
	RESPONSE_DISCOVER_AUDIT_TRACE varchar,
	RESPONSE_DISCOVER_POS_ENTRY_MODE varchar,
	RESPONSE_DISCOVER_TRACK_STATUS varchar,
	RESPONSE_DISCOVER_POS_COND_CODE varchar,
	RESPONSE_DISCOVER_RESPONSE varchar,
	RESPONSE_DISCOVER_NETWORK_REFERENCE_ID varchar,
	RESPONSE_DISCOVER_AUTH_DATE_TIME varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RESPONSE_MASTERCARD_BANK_NET_SETTLEMENT_DATE varchar,
	RESPONSE_AMEX_CARDHOLDER_AUTHENTICATION varchar,
	TRANSACTION_FORMAT_CODE varchar,
	MEDIA_CODE varchar,
	CURRENCY_CODE varchar,
	MARKET_SPECIFIC_DATA_INDICATOR varchar,
	MARKET_SPECIFIC_DATA_INDICATOR varchar,
	POS_ENVIRONMENT_INDICATOR varchar,
	SUBSEQUENT_TRANSACTION_REASON_CODE varchar,
	POS_ENTRY_MODE varchar,
	VISA_TRANSACTION_ID varchar,
	POS_ENVIRONMENT_INDICATOR varchar,
	SUBSEQUENT_TRANSACTION_REASON_CODE varchar,
	POS_ENTRY_MODE varchar,
	VISA_TRANSACTION_ID varchar,
	POS_ENVIRONMENT_INDICATOR varchar,
	SUBSEQUENT_TRANSACTION_REASON_CODE varchar,
	POS_ENTRY_MODE varchar,
	VISA_TRANSACTION_ID varchar,
	MARKET_SPECIFIC_DATA_INDICATOR varchar,
	TRANSACTION_IDENTITY varchar,
	TRANSACTION_IDENTITY varchar,
	CC_VANTIV_TANDEM_BATCH_FK bigint(20),
	CC_VANTIV_TANDEM_BATCH_FK bigint(20),
	TRANSACTION_IDENTITY varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;