-- Create Table Statement for 'EFT ISO20022 Batch'
DROP TABLE IF EXISTS `EFT_ISO20022_BATCH`;
CREATE TABLE `EFT_ISO20022_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	NUMBER_OF_TRANSACTIONS varchar,
	INITIATING_PARTY_BIC_OR_BEI varchar,
	MESSAGE_IDENTIFICATION varchar,
	INITIATING_PARTY_NAME varchar,
	CREATION_DATE_TIME varchar,
	CREDITOR_TOWN_NAME varchar,
	REQUESTED_COLLECTION_DATE varchar,
	PAYMENT_INFORMATION_IDENTIFICATION varchar,
	CONTROL_SUM varchar,
	CREDITOR_POST_CODE varchar,
	CREDITOR_ADDRESS_LINE varchar,
	LOCAL_INSTRUMENT_CODE varchar,
	CREDITOR_COUNTRY varchar,
	CREDITOR_NAME varchar,
	CREDITOR_STREET_NAME varchar,
	RESPONSE_STATUS varchar,
	REASON_CODE varchar,
	REASON_ADDITIONAL_INFORMATION varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	CREDITOR_COUNTRY_SUB_DIVISION varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;