-- Create Table Statement for 'EFT ISO20022 Batch Transaction'
DROP TABLE IF EXISTS `EFT_ISO20022_BATCH_TRANSACTION`;
CREATE TABLE `EFT_ISO20022_BATCH_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	DEBTOR_NAME varchar,
	DEBTOR_POST_CODE varchar,
	INSTRUCTED_AMOUNT varchar,
	DEBTOR_COUNTRY varchar,
	DEBTOR_ACCOUNT_TYPE_CODE varchar,
	END_TO_END_IDENTIFICATION varchar,
	DEBTOR_AGENT_COUNTRY varchar,
	DEBTOR_ACCOUNT_TYPE_PROPRIETARY varchar,
	EFT_ISO20022_BATCH_FK bigint(20),
	DEBTOR_TOWN_NAME varchar,
	DEBTOR_COUNTRY_SUB_DIVISION varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	DEBTOR_ADDRESS_LINE varchar,
	SUBSCRIPTION_TRANSACTION_FK bigint(20),
	MANDATE_IDENTIFICATION varchar,
	TYPE_REASON_ADDITIONAL_INFORMATION varchar,
	REASON_CODE varchar,
	UK_IT_REASON_ADDITIONAL_INFORMATION varchar,
	US_REASON_CODE varchar,
	TRANSACTION_STATUS varchar,
	ACCOUNT_SERVICER_REFERENCE varchar,
	GACH_REASON_ADDITIONAL_INFORMATION varchar,
	GACH_REASON_CODE varchar,
	NORDIC_MAND_REASON_ADDITIONAL_INFORMATION varchar,
	UK_ADDACS_REASON_ADDITIONAL_INFORMATION varchar,
	US_REASON_ADDITIONAL_INFORMATION varchar,
	RETURN_INSTRUCTED_AMOUNT varchar,
	RETURN_AMOUNT int(11),
	ACCEPTANCE_DATETIME varchar,
	EFT_ISO20022_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	EFT_ISO20022_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;