-- Create Table Statement for 'Vantiv Lowell Batch'
DROP TABLE IF EXISTS `VANTIV_LOWELL_BATCH`;
CREATE TABLE `VANTIV_LOWELL_BATCH` (
	ID bigint(20) NOT NULL,
	USER varchar,
	MERCHANT_ID varchar,
	NUM_SALES int(11),
	SALE_AMOUNT int(11),
	NUM_CREDITS int(11),
	CREDIT_AMOUNT int(11),
	NUM_ECHECK_SALES int(11),
	ECHECK_SALES_AMOUNT int(11),
	NUM_ECHECK_CREDIT int(11),
	ECHECK_CREDIT_AMOUNT int(11),
	LITLE_SESSION_ID varchar,
	LITLE_BATCH_ID varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;