-- Create Table Statement for 'CС Elavon Batch'
DROP TABLE IF EXISTS `CC_ELAVON_BATCH`;
CREATE TABLE `CC_ELAVON_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_FI_NUMBER varchar,
	MERCHANT_NUMBER varchar,
	CREATION_DATE varchar,
	BANKCARD_COUNT varchar,
	BANKCARD_NET varchar,
	BANKCARD_SIGN varchar,
	AMEX_COUNT varchar,
	AMEX_NET varchar,
	AMEX_SIGN varchar,
	DISCOVER_COUNT varchar,
	DISCOVER_NET varchar,
	DISCOVER_SIGN varchar,
	OTHER_COUNT varchar,
	OTHER_NET varchar,
	OTHER_SIGN varchar,
	SALES_COUNT varchar,
	SALES_AMOUNT varchar,
	RETURN_COUNT varchar,
	RETURN_AMOUNT varchar,
	NET_COUNT varchar,
	NET_AMOUNT varchar,
	NET_SIGN varchar,
	DEPOSIT_FLAG varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;