-- Create Table Statement for 'Vantiv Lowell Retail File Batch'
DROP TABLE IF EXISTS `VANTIV_LOWELL_RETAIL_FILE_BATCH`;
CREATE TABLE `VANTIV_LOWELL_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_ID varchar,
	USER varchar,
	NUM_CAPTURES int(11),
	CAPTURE_AMOUNT int(11),
	LITLE_BATCH_ID varchar,
	LITLE_SESSION_ID varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;