-- Create Table Statement for 'Merchant Statement Activity'
DROP TABLE IF EXISTS `IAPP_MERCHANT_STATEMENT_ACTIVITY`;
CREATE TABLE `IAPP_MERCHANT_STATEMENT_ACTIVITY` (
	ID bigint(20) NOT NULL,
	EMAIL_SENT_DATE datetime,
	EXPORT_DATE datetime,
	PORTFOLIO_EXPORT_DATE datetime,
	PORTFOLIO_DEPOSIT_LIST datetime,
	PORTFOLIO_MERCHANT_STATEMENT_EXPORT datetime,
	RESELLER_DEPOSIT_LIST datetime,
	RESELLER_MERCHANT_STATEMENT_EXPORT datetime,
	MERCHANT_ACCOUNT_CODE int(11),
	PORTFOLIO_MERCHANT_STATEMENT_DATA datetime,
	PORTFOLIO_TRANSACTION_DATA datetime,
	PORTFOLIO_MERCHANT_STATEMENT_EXTENDED datetime,
	PORTFOLIO_MERCHANT_STATEMENT_DATA datetime,
	PORTFOLIO_TRANSACTION_DATA datetime,
	PORTFOLIO_MERCHANT_STATEMENT_EXTENDED datetime,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;