-- Create Table Statement for 'Merchant Account Payment Statistics'
DROP TABLE IF EXISTS `IAPP_MERCHANT_ACCOUNT_PAYMENT_STATISTICS`;
CREATE TABLE `IAPP_MERCHANT_ACCOUNT_PAYMENT_STATISTICS` (
	ID bigint(20) NOT NULL,
	CREATE_DATE datetime,
	MERCHANT_ACCOUNT_CODE int(11),
	EFFECTIVE_DATE datetime,
	TRANSACTION_SOURCE_CL varchar,
	VISA_PAYMENT_COUNT int(11),
	VISA_PAYMENT_AMOUNT int(11),
	VISA_REFUND_COUNT int(11),
	VISA_REFUND_AMOUNT int(11),
	VISA_DECLINE_COUNT int(11),
	VISA_DECLINE_AMOUNT int(11),
	VISA_CHARGEBACK_COUNT int(11),
	VISA_CHARGEBACK_AMOUNT int(11),
	VISA_REVERSAL_COUNT int(11),
	VISA_REVERSAL_AMOUNT int(11),
	MASTER_CARD_PAYMENT_COUNT int(11),
	MASTER_CARD_PAYMENT_AMOUNT int(11),
	MASTER_CARD_REFUND_COUNT int(11),
	MASTER_CARD_REFUND_AMOUNT int(11),
	MASTER_CARD_DECLINE_COUNT int(11),
	MASTER_CARD_DECLINE_AMOUNT int(11),
	MASTER_CARD_CHARGEBACK_COUNT int(11),
	MASTER_CARD_CHARGEBACK_AMOUNT int(11),
	MASTER_CARD_REVERSAL_COUNT int(11),
	MASTER_CARD_REVERSAL_AMOUNT int(11),
	AMEX_PAYMENT_COUNT int(11),
	AMEX_PAYMENT_AMOUNT int(11),
	AMEX_REFUND_COUNT int(11),
	AMEX_REFUND_AMOUNT int(11),
	AMEX_DECLINE_COUNT int(11),
	AMEX_DECLINE_AMOUNT int(11),
	AMEX_CHARGEBACK_COUNT int(11),
	AMEX_CHARGEBACK_AMOUNT int(11),
	AMEX_REVERSAL_COUNT int(11),
	AMEX_REVERSAL_AMOUNT int(11),
	DISCOVER_PAYMENT_COUNT int(11),
	DISCOVER_PAYMENT_AMOUNT int(11),
	DISCOVER_REFUND_COUNT int(11),
	DISCOVER_REFUND_AMOUNT int(11),
	DISCOVER_DECLINE_COUNT int(11),
	DISCOVER_DECLINE_AMOUNT int(11),
	DISCOVER_CHARGEBACK_COUNT int(11),
	DISCOVER_CHARGEBACK_AMOUNT int(11),
	DISCOVER_REVERSAL_COUNT int(11),
	DISCOVER_REVERSAL_AMOUNT int(11),
	DINNERS_PAYMENT_COUNT int(11),
	DINNERS_PAYMENT_AMOUNT int(11),
	DINNERS_REFUND_COUNT int(11),
	DINNERS_REFUND_AMOUNT int(11),
	DINNERS_DECLINE_COUNT int(11),
	DINNERS_DECLINE_AMOUNT int(11),
	DINNERS_CHARGEBACK_COUNT int(11),
	DINNERS_CHARGEBACK_AMOUNT int(11),
	DINNERS_REVERSAL_COUNT int(11),
	DINNERS_REVERSAL_AMOUNT int(11),
	EFT_PAYMENT_COUNT int(11),
	EFT_PAYMENT_AMOUNT int(11),
	EFT_REFUND_COUNT int(11),
	EFT_REFUND_AMOUNT int(11),
	EFT_DECLINE_COUNT int(11),
	EFT_DECLINE_AMOUNT int(11),
	EFT_REVERSAL_COUNT int(11),
	EFT_REVERSAL_AMOUNT int(11),
	OTHER_PAYMENT_COUNT int(11),
	OTHER_PAYMENT_AMOUNT int(11),
	OTHER_REFUND_COUNT int(11),
	OTHER_REFUND_AMOUNT int(11),
	RECLEAR_COUNT int(11),
	REBILL_PAYMENT_COUNT int(11),
	REBILL_PAYMENT_AMOUNT int(11),
	REBILL_REFUND_COUNT int(11),
	REBILL_REFUND_AMOUNT int(11),
	REBILL_DECLINE_COUNT int(11),
	REBILL_DECLINE_AMOUNT int(11),
	VOID_COUNT int(11),
	VOID_AMOUNT int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;