-- Create Table Statement for 'Vantiv Lowell Batch Transaction'
DROP TABLE IF EXISTS `VANTIV_LOWELL_BATCH_TRANSACTION`;
CREATE TABLE `VANTIV_LOWELL_BATCH_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_TYPE varchar,
	CUSTOMER_ID varchar,
	ORDER_ID varchar,
	ORDER_SOURCE varchar,
	AMOUNT int(11),
	NAME varchar,
	ADDRESS_LINE1 varchar,
	CITY varchar,
	STATE varchar,
	ZIP varchar,
	TYPE varchar,
	LITLE_TOKEN varchar,
	ACC_TYPE varchar,
	LITLE_TXN_ID varchar,
	RESPONSE varchar,
	RESPONSE_TIME varchar,
	MESSAGE varchar,
	AUTH_CODE varchar,
	AVS_RESULT varchar,
	TOKEN_RESPONSE_CODE varchar,
	TOKEN_MESSAGE varchar,
	BIN varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	LITLE_BATCH_FK bigint(20),
	LITLE_BATCH_PROVIDER_CHARGE_TRANSACTIONS_IDX int(11),
	REPORT_GROUP varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	VANTIV_LOWELL_BATCH_FK bigint(20),
	NETWORK_TRANSACTION_ID varchar,
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	PROCESSING_TYPE varchar,
	NETWORK_TRANSACTION_ID varchar,
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	PROCESSING_TYPE varchar,
	NETWORK_TRANSACTION_ID varchar,
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	PROCESSING_TYPE varchar,
	VANTIV_LOWELL_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	VANTIV_LOWELL_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;