-- Create Table Statement for 'Processing Reconciliation Statistics'
DROP TABLE IF EXISTS `IAPP_PROCESSING_RECONCILIATION_STATISTICS`;
CREATE TABLE `IAPP_PROCESSING_RECONCILIATION_STATISTICS` (
	PORTFOLIO_CODE int(11),
	RESELLER_CODE int(11),
	MERCHANT_ACCOUNT_CODE int(11),
	RECONCILIATION_DATE datetime,
	PROCESSOR_NAME varchar,
	CARRYOVER_CHARGE_AMOUNT bigint(20),
	DIFFERENCE_CHARGE_AMOUNT bigint(20),
	CARRYOVER_RETURN_AMOUNT bigint(20),
	DIFFERENCE_RETURN_AMOUNT bigint(20),
	ID bigint(20) NOT NULL,
	GATEWAY_SALE_AMOUNT bigint(20),
	PROCESSOR_SALE_AMOUNT bigint(20),
	GATEWAY_CREDIT_AMOUNT bigint(20),
	PROCESSOR_CREDIT_AMOUNT bigint(20),
	GATEWAY_RETURN_AMOUNT bigint(20),
	PROCESSOR_RETURN_AMOUNT bigint(20),
	GATEWAY_CHARGEBACK_AMOUNT bigint(20),
	PROCESSOR_CHARGEBACK_AMOUNT bigint(20),
	GATEWAY_REVERSAL_AMOUNT bigint(20),
	PROCESSOR_REVERSAL_AMOUNT bigint(20),
	READJUSTMENT_CHARGE_AMOUNT bigint(20),
	READJUSTMENT_RETURN_AMOUNT bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;