-- 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;