-- Create Table Statement for 'EFT NACHA Batch'
DROP TABLE IF EXISTS `EFT_NACHA_BATCH`;
CREATE TABLE `EFT_NACHA_BATCH` (
	ID bigint(20) NOT NULL,
	PROFILE_ID varchar,
	FILE_CREATION_DATE varchar,
	FILE_CREATION_TIME varchar,
	FILE_ID_MODIFIER varchar,
	ORIGIN varchar,
	COMPANY_NAME varchar,
	COMPANY_ID varchar,
	ORIGINATING_DFI_IDENTIFICATION varchar,
	STANDARD_ENTRY_CLASS varchar,
	COMPANY_DESCRIPTIVE_DATE varchar,
	EFFECTIVE_ENTRY_DATE varchar,
	DESCRIPTION varchar,
	ENTRY_COUNT varchar,
	ENTRY_HASH varchar,
	TOTAL_DEBIT_ENTRY_DOLLAR_AMOUNT varchar,
	TOTAL_CREDIT_ENTRY_DOLLAR_AMOUNT varchar,
	BLOCK_COUNT varchar,
	VERIFICATION_PROFILE_ID varchar,
	POINT_NAME varchar,
	CONTACT_NAME varchar,
	CONTACT_PHONE_NUMBER varchar,
	DEBIT_COUNT varchar,
	DEBIT_AMOUNT varchar,
	CREDIT_COUNT varchar,
	CREDIT_AMOUNT varchar,
	IMMEDIATE_ORIGIN varchar,
	MERCHANT_NAME varchar,
	MERCHANT_PHONE_NUMBER varchar,
	USER_ID varchar,
	APPLICATION_ID varchar,
	SALE_COMPANY_ID varchar,
	REFUND_COMPANY_ID varchar,
	DESTINATION_COUNTRY_CODE varchar,
	ORIGINATING_CURRENCY_CODE varchar,
	DESTINATION_CURRENCY_CODE varchar,
	MERCHANT_CODE int(11),
	PROVIDER_CHARGE_TRANSACTIONS bigint(20),
	FILE_PROCESS_DATE varchar,
	DATE_VERIFICATION_TOTALS_PROVIDED varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;