-- Create Table Statement for 'CC Vantiv Tandem Batch'
DROP TABLE IF EXISTS `CC_VANTIV_TANDEM_BATCH`;
CREATE TABLE `CC_VANTIV_TANDEM_BATCH` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
CURRENTDATE varchar,
CURRENTTIME varchar,
RELATIVE_FILE_NUMBER varchar,
ORIGINATING_ID varchar,
RELATIVE_BATCH_NUMBER varchar,
STORE_MERCHANT_NUMBER varchar,
MERCHANT_NAME varchar,
MERCHANT_CITY varchar,
MERCHANT_STATE varchar,
MERCHANT_COUNTRY varchar,
CURRENCY_CODE varchar,
TOTAL_RECORD_COUNT varchar,
TOTAL_TRANSACTION_COUNT varchar,
TOTAL_AMOUNT varchar,
RESPONSE_NUMBER_AUTHORIZED varchar,
RESPONSE_TOTAL_AUTHORIZED varchar,
RESPONSE_NUMBER_DEPOSITED varchar,
RESPONSE_TOTAL_DEPOSITED varchar,
RESPONSE_NUMBER_REFERRALS varchar,
RESPONSE_NUMBER_DECLINED varchar,
RESPONSE_NUMBER_NO_RESPONSE varchar,
RESPONSE_NUMBER_REJECTED varchar,
RESPONSE_NUMBER_FOR_REAUTH varchar,
PRIMARY KEY (ID)
) ENGINE=InnoDB;