-- Create Table Statement for 'Merchant Financial Statistics'
DROP TABLE IF EXISTS `IAPP_MERCHANT_FINANCIAL_STATISTICS`;
CREATE TABLE `IAPP_MERCHANT_FINANCIAL_STATISTICS` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	CREATE_DATE datetime,
	AMOUNT int(11),
	SUBMISSION_DATE datetime,
	REQUEST_DATE datetime,
	RESPONSE_DATE datetime,
	DEPOSIT_DATE datetime,
	REMITTANCE_DATE datetime,
	TRANSACTION_SOURCE_CL varchar,
	PAYMENT_CL varchar,
	ATTEMPT_COUNT int(11),
	SUBMISSION_CODE bigint(20),
	IS_SUBMISSION_CLOSED tinyint(1),
	IS_OUTSIDE_SUBMISSION tinyint(1),
	TRANSACTION_CL varchar,
	TRANSACTION_CODE bigint(20),
	MERCHANT_ACCOUNT_GROUP_CODE bigint(20),
	SUBMISSION_CL varchar,
	PROVIDER_NAME varchar,
	IS_FINAL_ATTEMPT tinyint(1),
	FUNDING_DATE datetime,
	ENTRY_CL varchar,
	IS_INTERREGIONAL tinyint(1),
	IS_PREPAID tinyint(1),
	INTERCHANGE_RATE_NAME varchar,
	INTERCHANGE_PERCENTAGE_FEE4P int(11),
	INTERCHANGE_FEE_AMOUNT4P bigint(20),
	INTERCHANGE_FLAT_FEE4P int(11),
	PROCESSOR_FEE_AMOUNT4P int(11),
	ASSESSMENTS_FEE_AMOUNT4P int(11),
	PROCESSING_FEE_AMOUNT4P int(11),
	PERITEM_FEE_AMOUNT4P int(11),
	PROCESSING_COST_AMOUNT4P int(11),
	REBILL_ATTEMPT_COUNT int(11),
	SETTLEMENT_RECONCILIATION_DATE datetime,
	AUTHORIZATION_RECONCILIATION_DATE datetime,
	IS_AVS_ENABLED tinyint(1),
	SETTLEMENT_AMOUNT int(11),
	AUTHORIZATION_CURRENCY_CODE varchar,
	SETTLEMENT_CURRENCY_CODE varchar,
	AGGREGATE_TRANSACTION_CODE bigint(20),
	FEE_AMOUNT int(11),
	IS_CHARGEBACK_TRANSACTION tinyint(1),
	PROVIDER_TRANSACTION_CODE varchar,
	USER_CODE varchar,
	ADJUSTMENT_DATE datetime,
	ADJUSTMENT_NOTE varchar,
	PORTFOLIO_CODE int(11),
	SPLIT_MERCHANT_ACCOUNT_CODE int(11),
	PROCESSOR_RECONCILIATION_DATE datetime,
	ORIGINAL_TRANSACTION_CODE bigint(20),
	PROCESSOR_RECONCILIATION_DATE datetime,
	ORIGINAL_TRANSACTION_CODE bigint(20),
	IS_CSC_ENABLED tinyint(1),
	IS_CSC_ENABLED tinyint(1),
	RESELLER_CODE int(11),
	RESELLER_CODE int(11),
	PROCESSOR_RECONCILIATION_DATE datetime,
	ORIGINAL_TRANSACTION_CODE bigint(20),
	IS_CSC_ENABLED tinyint(1),
	RESELLER_CODE int(11),
	FLAT_FEE_AMOUNT_4P int(11),
	PROCESSING_FEE_RATE_4P int(11),
	FLAT_FEE_AMOUNT_4P int(11),
	PROCESSING_FEE_RATE_4P int(11),
	IS_AGGREGATE tinyint(1),
	FLAT_FEE_AMOUNT_4P int(11),
	PROCESSING_FEE_RATE_4P int(11),
	IS_AGGREGATE tinyint(1),
	IS_AGGREGATE tinyint(1),
	INTERCHANGE_FEE_AMOUNT4P bigint(20),
	INTERCHANGE_FEE_AMOUNT4P bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;