-- Create Table Statement for 'EFT ISO20022 Profile'
DROP TABLE IF EXISTS `EFT_ISO20022_PROFILE`;
CREATE TABLE `EFT_ISO20022_PROFILE` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	INITIATING_PARTY_BIC_OR_BEI varchar,
	INITIATING_PARTY_NAME varchar,
	CREDITOR_ACCOUNT_IDENTIFICATION varchar,
	CREDITOR_ACCOUNT_IBAN varchar,
	CREDITOR_TOWN_NAME varchar,
	CREDITOR_ACCOUNT_PROPRIETARY varchar,
	CREDITOR_POST_CODE varchar,
	CREDITOR_ADDRESS_LINE varchar,
	CREDITOR_COUNTRY_SUB_DIVISION varchar,
	CREDITOR_COUNTRY varchar,
	INITIATING_PARTY_IDENTIFICATION varchar,
	CREDITOR_NAME varchar,
	CREDITOR_STREET_NAME varchar,
	REQUEST_FILE_NAME_PREFIX varchar,
	ACKNOWLEDGEMENT_FILE_NAME_PREFIX varchar,
	DESCRIPTOR_PREFIX varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;