-- Create Table Statement for 'EFT Canada Batch'
DROP TABLE IF EXISTS `EFT_CANADA_BATCH`;
CREATE TABLE `EFT_CANADA_BATCH` (
	ID bigint(20) NOT NULL,
	PROCESS_DATE varchar,
	TOTAL_AMOUNT int(11),
	SALE_COUNT int(11),
	SALE_AMOUNT int(11),
	CREDIT_COUNT int(11),
	CREDIT_AMOUNT int(11),
	MERCHANT_NAME varchar,
	MERCHANT_CODE int(11),
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;