-- Create Table Statement for 'Merchant Deposit Statistics'
DROP TABLE IF EXISTS `IAPP_MERCHANT_DEPOSIT_STATISTICS`;
CREATE TABLE `IAPP_MERCHANT_DEPOSIT_STATISTICS` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	CREATE_DATE datetime,
	SUBMISSION_DATE datetime,
	RESPONSE_DATE datetime,
	ADJUSTED_PROCESSING_DATE datetime,
	ADJUSTMENT_MESSAGE varchar,
	DEPOSIT_DATE datetime,
	DEPOSIT_CL varchar,
	SUBMISSION_CODE bigint(20),
	SUB_BATCH_CODE bigint(20),
	SUB_BATCH_CL varchar,
	DEPOSIT_AMOUNT int(11),
	PROVIDER_NAME varchar,
	FUNDING_DATE datetime,
	REQUEST_DATE datetime,
	REMITTANCE_DATE datetime,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;