-- Create Table Statement for 'Vantiv Lowell Processing Cost'
DROP TABLE IF EXISTS `VANTIV_LOWELL_PROCESSING_COST`;
CREATE TABLE `VANTIV_LOWELL_PROCESSING_COST` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	COST_MATCHING_STATUS_CL varchar,
	REPORTING_GROUP varchar,
	REPORTING_GROUP_TYPE varchar,
	PAYMENT_TYPE varchar,
	SETTLEMENT_CURRENCY varchar,
	FEE_CATEGORY_TYPE varchar,
	FEE_CATEGORY varchar,
	FEE_SUB_CATEGORY varchar,
	DESCRIPTION varchar,
	TRANSACTION_COUNT varchar,
	FEE_PER_TRANSACTION varchar,
	TRANSACTION_AMOUNT varchar,
	TRANSACTION_PERCENTAGE_FEE varchar,
	TOTAL_FEES varchar,
	LITLE_PROCESSING_COST_BATCH_FK bigint(20),
	MERCHANT_ID varchar,
	MERCHANT_ID varchar,
	MERCHANT_ID varchar,
	VANTIV_LOWELL_PROCESSING_COST_BATCH_FK bigint(20),
	VANTIV_LOWELL_PROCESSING_COST_BATCH_FK bigint(20),
	VANTIV_LOWELL_PROCESSING_COST_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;