-- Create Table Statement for 'EFT NACHA Batch Transaction'
DROP TABLE IF EXISTS `EFT_NACHA_BATCH_TRANSACTION`;
CREATE TABLE `EFT_NACHA_BATCH_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_CODE varchar,
	ROUTING_CHECK varchar,
	AMOUNT varchar,
	INDIVIDUAL_ID_NUMBER varchar,
	INDIVIDUAL_NAME varchar,
	TRACE_NUMBER varchar,
	RETURN_TRANSACTION_CODE varchar,
	RETURN_TYPE varchar,
	RETURN_REASON_CODE varchar,
	DATE_OF_DEATH varchar,
	RETURN_DESCRIPTION varchar,
	EFT_NACHA_BATCH_FK bigint(20),
	EFT_NACHA_BATCH_PROVIDER_CHARGE_TRANSACTIONS_IDX int(11),
	CUSTOM_FIELD varchar,
	NOC_REASON_CODE varchar,
	NUMBER_OF_ADDENDA_RECORDS varchar,
	TRANSACTION_TYPE_CODE varchar,
	RECEIVING_COMPANY_NAME varchar,
	ORIGINATOR_STREET_ADDRESS varchar,
	ORIGINATOR_CITY_STATE varchar,
	ORIGINATOR_COUNTRY_POSTAL_CODE varchar,
	RECEIVING_DFI_NAME varchar,
	RECEIVING_DFI_BRANCH_COUNTRY_CODE varchar,
	RECEIVER_ID varchar,
	RECEIVER_STREET_ADDRESS varchar,
	RECEIVER_CITY_STATE varchar,
	RECEIVER_COUNTRY_POSTAL_CODE varchar,
	ORIGINATOR_NAME varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	DISCRETIONARY_DATA varchar,
	DISCRETIONARY_DATA varchar,
	DISCRETIONARY_DATA varchar,
	EFT_NACHA_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	EFT_NACHA_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PAYMENT_RELAITED_INFORMATION varchar,
	PAYMENT_RELAITED_INFORMATION varchar,
	PAYMENT_RELAITED_INFORMATION varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;