-- Create Table Statement for 'EFT1464 Canada Batch'
DROP TABLE IF EXISTS `EFT1464_CANADA_BATCH`;
CREATE TABLE `EFT1464_CANADA_BATCH` (
	ID bigint(20) NOT NULL,
	ORIGINATOR_ID_NUMBER varchar,
	FILE_CREATION_NUMBER varchar,
	FILE_CREATION_DATE varchar,
	DUE_DATE varchar,
	ORIGINATOR_SHORT_NAME varchar,
	ORIGINATOR_LONG_NAME varchar,
	TOTAL_DEBIT_AMOUNT varchar,
	TOTAL_DEBIT_NUMBER varchar,
	TOTAL_CREDIT_AMOUNT varchar,
	TOTAL_CREDIT_NUMBER varchar,
	CONTACT_NAME varchar,
	CONTACT_PHONE_NUMBER varchar,
	REPORT_DATE varchar,
	SETTLEMENT_DATE varchar,
	FILE_REJECT_REASON_CODE varchar,
	FILE_REJECT_MESSAGE varchar,
	DESTINATION_DATA_CENTER_CODE varchar,
	CPA_CODE varchar,
	ORIGINATOR_SUNDRY_INFORMATION varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;