-- Create Table Statement for 'Merchant Activity'
DROP TABLE IF EXISTS `IAPP_MERCHANT_ACTIVITY`;
CREATE TABLE `IAPP_MERCHANT_ACTIVITY` (
	ID bigint(20) NOT NULL,
	version int(11) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	BALANCE int(11),
	LAST_STATISTICS_UPDATE_DATE datetime,
	LAST_FINANCIAL_STATISTICS_UPDATE_DATE datetime,
	LAST_BILLING_STATISTICS_UPDATE_DATE datetime,
	LAST_DEPOSIT_STATISTICS_UPDATE_DATE datetime,
	LAST_BATCH_RESPONSE_DATE datetime,
	LAST_MERCHANT_STATEMENT_DATE datetime,
	PREV_AGENT_STATEMENT_DATE datetime,
	LAST_AGENT_STATEMENT_DATE datetime,
	PREV_AGENT_REMITTANCE_DATE datetime,
	LAST_AGENT_REMITTANCE_DATE datetime,
	PREV_PARTNER_STATEMENT_DATE datetime,
	LAST_PARTNER_STATEMENT_DATE datetime,
	PREV_PARTNER_REMITTANCE_DATE datetime,
	LAST_PARTNER_REMITTANCE_DATE datetime,
	PREV_COMPANY_STATEMENT_DATE datetime,
	LAST_COMPANY_STATEMENT_DATE datetime,
	PREV_COMPANY_REMITTANCE_DATE datetime,
	LAST_COMPANY_REMITTANCE_DATE datetime,
	LAST_SETTLEMENT_CURRENCY_UPDATE_DATE datetime,
	LAST_REMITTANCE_RETURNS_IMPORT_DATE datetime,
	LAST_PROCESSING_STATISTICS_UPDATE_DATE datetime,
	LAST_FUNDS_DISTRIBUTION_UPDATE_DATE datetime,
	LAST_DATA_EXPORT_DATE datetime,
	LAST_UPDATE_RESPONSE_DATE datetime,
	LAST_SUBSCRIPTION_RESPONSE_DATE datetime,
	LAST_RETURNS_RESPONSE_DATE datetime,
	RETURN_SEQUENCE_NUMBER int(11),
	LAST_RETURNS_RESPONSE_DATE datetime,
	RETURN_SEQUENCE_NUMBER int(11),
	LAST_RETURNS_RESPONSE_DATE datetime,
	RETURN_SEQUENCE_NUMBER int(11),
	LAST_MERCHANT_PROCESSING_STATISTICS_UPDATE_DATE datetime,
	LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE1 datetime,
	PROCESSOR_NAME1 varchar,
	LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE2 datetime,
	PROCESSOR_NAME2 varchar,
	LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE3 datetime,
	PROCESSOR_NAME3 varchar,
	LAST_MERCHANT_PROCESSING_STATISTICS_UPDATE_DATE datetime,
	LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE1 datetime,
	PROCESSOR_NAME1 varchar,
	LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE2 datetime,
	PROCESSOR_NAME2 varchar,
	LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE3 datetime,
	PROCESSOR_NAME3 varchar,
	LAST_MERCHANT_PROCESSING_STATISTICS_UPDATE_DATE datetime,
	LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE1 datetime,
	PROCESSOR_NAME1 varchar,
	LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE2 datetime,
	PROCESSOR_NAME2 varchar,
	LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE3 datetime,
	PROCESSOR_NAME3 varchar,
	BALANCE bigint(20),
	LAST_PROCESSING_RECONCILIATION_STATISTICS_UPDATE_DATE datetime,
	LAST_PROCESSING_RECONCILIATION_STATISTICS_UPDATE_DATE datetime,
	LAST_PROCESSING_RECONCILIATION_STATISTICS_UPDATE_DATE datetime,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;