-- Create Table Statement for 'Merchant Processing Statistics'
DROP TABLE IF EXISTS `MERCHANT_PROCESSING_STATISTICS`;
CREATE TABLE `MERCHANT_PROCESSING_STATISTICS` (
	ID bigint(20) NOT NULL,
	CREATE_DATE datetime,
	MERCHANT_ACCOUNT_CODE int(11),
	PORTFOLIO_CODE int(11),
	RESELLER_CODE int(11),
	MERCHANT_ACCOUNT_GROUP_CODE bigint(20),
	FEES_RESPONSIBLE_CL varchar,
	BATCH_DEPOSIT_POLICY varchar,
	REALTIME_DEPOSIT_POLICY varchar,
	SUBMISSION_CODE bigint(20),
	SUBMISSION_CL varchar,
	AUTHORIZATION_CURRENCY_CODE varchar,
	SETTLEMENT_CURRENCY_CODE varchar,
	ACTIVITY_DATE datetime,
	REMITTANCE_DATE datetime,
	RECONCILIATION_DATE datetime,
	PROCESSOR_IDENTITY varchar,
	PROCESSOR_NAME varchar,
	GATEWAY_PAYMENT_COUNT int(11),
	GATEWAY_PAYMENT_AMOUNT bigint(20),
	GATEWAY_PAYMENT_DECLINE_COUNT int(11),
	GATEWAY_PAYMENT_DECLINE_AMOUNT bigint(20),
	GATEWAY_PAYMENT_VOID_COUNT int(11),
	GATEWAY_PAYMENT_VOID_AMOUNT bigint(20),
	GATEWAY_PAYMENT_BLACKLIST_COUNT int(11),
	GATEWAY_PAYMENT_BLACKLIST_AMOUNT bigint(20),
	GATEWAY_PAYMENT_ERROR_COUNT int(11),
	GATEWAY_PAYMENT_ERROR_AMOUNT bigint(20),
	GATEWAY_PAYMENT_AGGREGATED_COUNT int(11),
	GATEWAY_PAYMENT_AGGREGATED_AMOUNT bigint(20),
	GATEWAY_REFUND_COUNT int(11),
	GATEWAY_REFUND_AMOUNT bigint(20),
	GATEWAY_REFUND_DECLINE_COUNT int(11),
	GATEWAY_REFUND_DECLINE_AMOUNT bigint(20),
	GATEWAY_REFUND_VOID_COUNT int(11),
	GATEWAY_REFUND_VOID_AMOUNT bigint(20),
	GATEWAY_REFUND_BLACKLIST_COUNT int(11),
	GATEWAY_REFUND_BLACKLIST_AMOUNT bigint(20),
	GATEWAY_REFUND_ERROR_COUNT int(11),
	GATEWAY_REFUND_ERROR_AMOUNT bigint(20),
	GATEWAY_REFUND_AGGREGATED_COUNT int(11),
	GATEWAY_REFUND_AGGREGATED_AMOUNT bigint(20),
	GATEWAY_PAYMENT_CHARGEBACK_COUNT int(11),
	GATEWAY_PAYMENT_CHARGEBACK_AMOUNT bigint(20),
	GATEWAY_PAYMENT_CHARGEBACK_AGGREGATED_COUNT int(11),
	GATEWAY_PAYMENT_CHARGEBACK_AGGREGATED_AMOUNT bigint(20),
	GATEWAY_REFUND_CHARGEBACK_COUNT int(11),
	GATEWAY_REFUND_CHARGEBACK_AMOUNT bigint(20),
	GATEWAY_REFUND_CHARGEBACK_AGGREGATED_COUNT int(11),
	GATEWAY_REFUND_CHARGEBACK_AGGREGATED_AMOUNT bigint(20),
	GATEWAY_PAYMENT_REVERSAL_COUNT int(11),
	GATEWAY_PAYMENT_REVERSAL_AMOUNT bigint(20),
	GATEWAY_PAYMENT_REVERSAL_AGGREGATED_COUNT int(11),
	GATEWAY_PAYMENT_REVERSAL_AGGREGATED_AMOUNT bigint(20),
	GATEWAY_REFUND_REVERSAL_COUNT int(11),
	GATEWAY_REFUND_REVERSAL_AMOUNT bigint(20),
	GATEWAY_REFUND_REVERSAL_AGGREGATED_COUNT int(11),
	GATEWAY_REFUND_REVERSAL_AGGREGATED_AMOUNT bigint(20),
	GATEWAY_PAYMENT_RETURN_COUNT int(11),
	GATEWAY_PAYMENT_RETURN_AMOUNT bigint(20),
	GATEWAY_PAYMENT_RETURN_AGGREGATED_COUNT int(11),
	GATEWAY_PAYMENT_RETURN_AGGREGATED_AMOUNT bigint(20),
	GATEWAY_REFUND_RETURN_COUNT int(11),
	GATEWAY_REFUND_RETURN_AMOUNT bigint(20),
	GATEWAY_REFUND_RETURN_AGGREGATED_COUNT int(11),
	GATEWAY_REFUND_RETURN_AGGREGATED_AMOUNT bigint(20),
	GATEWAY_ACTIVITY_COUNT int(11),
	GATEWAY_ACTIVITY_AMOUNT bigint(20),
	GATEWAY_INTERCHANGE_COST_AMOUNT bigint(20),
	GATEWAY_ASSESSMENT_COST_AMOUNT bigint(20),
	GATEWAY_PROCESSOR_COST_AMOUNT bigint(20),
	GATEWAY_MERCHANT_COST_AMOUNT bigint(20),
	GATEWAY_PROCESSING_FEE_AMOUNT bigint(20),
	GATEWAY_FLAT_FEE_AMOUNT bigint(20),
	GATEWAY_RECURRING_FEE_AMOUNT bigint(20),
	GATEWAY_FEE_ADJUSTMENT_AMOUNT bigint(20),
	GATEWAY_PROCESSING_COMMISSIONS_AMOUNT bigint(20),
	GATEWAY_FLAT_COMMISSIONS_AMOUNT bigint(20),
	GATEWAY_RECURRING_COMMISSIONS_AMOUNT bigint(20),
	GATEWAY_COMMISSIONS_ADJUSTMENT_AMOUNT bigint(20),
	GATEWAY_MERCHANT_CHARGES_AMOUNT bigint(20),
	PROCESSOR_CHARGEBACK_COUNT int(11),
	PROCESSOR_CHARGEBACK_AMOUNT bigint(20),
	PROCESSOR_REVERSAL_COUNT int(11),
	PROCESSOR_REVERSAL_AMOUNT bigint(20),
	PROCESSOR_RETURN_COUNT int(11),
	PROCESSOR_RETURN_AMOUNT bigint(20),
	PROCESSOR_ACTIVITY_COUNT int(11),
	PROCESSOR_ACTIVITY_AMOUNT bigint(20),
	PROCESSOR_FEE_AMOUNT bigint(20),
	MERCHANT_STATEMENT_CODE bigint(20),
	MASTER_RESELLER_STATEMENT_CODE bigint(20),
	MERCHANT_PROCESSING_STATISTICS_DETAILS_FK bigint(20),
	MERCHANT_PROCESSING_STATISTICS_FEE_DETAILS_FK bigint(20),
	GATEWAY_ADJUSTMENT_AMOUNT bigint(20),
	GATEWAY_REMITTANCE_RETURN_AMOUNT bigint(20),
	GATEWAY_MERCHANT_CHARGE_AMOUNT bigint(20),
	GATEWAY_SPLIT_AMOUNT bigint(20),
	GATEWAY_RETURN_RESERVE_AMOUNT bigint(20),
	GATEWAY_CHARGEBACK_RESERVE_AMOUNT bigint(20),
	GATEWAY_REFUND_RESERVE_AMOUNT bigint(20),
	GATEWAY_REFUND_REJECT_AMOUNT bigint(20),
	GATEWAY_PAYMENT_REJECT_AMOUNT bigint(20),
	GATEWAY_CONVENIENCE_FEE_ADJUSTMENT_AMOUNT bigint(20),
	FRANCHISE_FEE_AMOUNT bigint(20),
	GATEWAY_PROCESSOR_TAX_AMOUNT int(11),
	GATEWAY_TAX_AMOUNT int(11),
	GATEWAY_PROCESSOR_TAX_AMOUNT int(11),
	GATEWAY_TAX_AMOUNT int(11),
	GATEWAY_PROCESSOR_TAX_AMOUNT int(11),
	GATEWAY_TAX_AMOUNT int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;