-- Create Table Statement for 'EFT NACHA Profile'
DROP TABLE IF EXISTS `EFT_NACHA_PROFILE`;
CREATE TABLE `EFT_NACHA_PROFILE` (
	ID bigint(20) NOT NULL,
	IMMEDIATE_ORIGIN varchar,
	SALE_COMPANY_ID varchar,
	REFUND_COMPANY_ID varchar,
	COMPANY_NAME varchar,
	ORIGINATING_DFI_IDENTIFICATION varchar,
	REQUEST_PROFILE_ID varchar,
	RESPONSE_PROFILE_ID varchar,
	VERIFICATION_PROFILE_ID varchar,
	POINT_NAME varchar,
	CONTACT_NAME varchar,
	CONTACT_PHONE_NUMBER varchar,
	DESCRIPTION varchar,
	EFT_NACHA_PROFILE_CL varchar,
	FILENAME varchar,
	USER_ID varchar,
	APPLICATION_ID varchar,
	STREET varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	COUNTRY_CODE varchar,
	CURRENCY_CODE varchar,
	COMPANY_PREFIX varchar,
	DESCRIPTOR varchar,
	RESPONSE_PGP_ACTION_CL varchar,
	RESPONSE_PGP_ACTION_CL varchar,
	IMMEDIATE_ORIGIN_NAME varchar,
	IMMEDIATE_ORIGIN_NAME varchar,
	RESPONSE_PGP_ACTION_CL varchar,
	IMMEDIATE_ORIGIN_NAME varchar,
	MERCHANT_ID varchar,
	MERCHANT_ROUTING_NUMBER varchar,
	MERCHANT_ACCOUNT_NUMBER varchar,
	CUSTOMER_ACCOUNT_LOCATION_CL varchar,
	CUSTOMER_ACCOUNT_LOCATION_CL varchar,
	MERCHANT_ID varchar,
	MERCHANT_ROUTING_NUMBER varchar,
	MERCHANT_ACCOUNT_NUMBER varchar,
	CUSTOMER_ACCOUNT_LOCATION_CL varchar,
	MERCHANT_ID varchar,
	MERCHANT_ROUTING_NUMBER varchar,
	MERCHANT_ACCOUNT_NUMBER varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;