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