-- Create Table Statement for 'EFT Optimal Payment Netbanx Return Batch'
DROP TABLE IF EXISTS `EFT_OPTIMAL_PAYMENT_NETBANX_RETURN_BATCH`;
CREATE TABLE `EFT_OPTIMAL_PAYMENT_NETBANX_RETURN_BATCH` (
	ID bigint(20) NOT NULL,
	END_DATE_DAY int(11),
	END_DATE_YEAR int(11),
	END_DATE_MONTH int(11),
	MERCHANT_ACCOUNT_NUMBER varchar,
	START_DATE_DAY int(11),
	START_DATE_MONTH int(11),
	START_DATE_YEAR int(11),
	STORE_ID varchar,
	DIRECT_DEBIT_SYSTEM_CL varchar,
	STATUS varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;