-- Create Table Statement for 'Merchant Remittance Statistics'
DROP TABLE IF EXISTS `IAPP_MERCHANT_REMITTANCE_STATISTICS`;
CREATE TABLE `IAPP_MERCHANT_REMITTANCE_STATISTICS` (
	CREATE_DATE datetime,
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	STATEMENT_APPROVE_DATE datetime,
	RESELLER_CODE int(11),
	PORTFOLIO_CODE int(11),
	MERCHANT_ACCOUNT_GROUP_CODE bigint(20),
	PROCESSOR_NAME_LIST varchar,
	PROCESSOR_IDENTITY_LIST varchar,
	PRICING_CL varchar,
	PROCESSOR_COST_AMOUNT int(11),
	PAYMENTS_AMOUNT bigint(20),
	PAYMENTS_COUNT int(11),
	REFUNDS_AMOUNT bigint(20),
	REFUNDS_COUNT int(11),
	CHARGEBACKS_AMOUNT bigint(20),
	CHARGEBACKS_COUNT int(11),
	REVERSALS_AMOUNT bigint(20),
	REVERSALS_COUNT int(11),
	RETURNS_AMOUNT bigint(20),
	RETURNS_COUNT int(11),
	MERCHANT_BALANCE_AMOUNT bigint(20),
	MERCHANT_FEES_BALANCE_AMOUNT int(11),
	MERCHANT_FEES_AMOUNT int(11),
	MERCHANT_FEE_ADJUSTMENTS_AMOUNT int(11),
	MERCHANT_PROCESSING_COST_AMOUNT int(11),
	MERCHANT_PROCESSING_COST_ADJUSTMENTS_AMOUNT int(11),
	RESELLER_BALANCE_AMOUNT bigint(20),
	RESELLER_COMMISSIONS_AMOUNT int(11),
	RESELLER_FEES_AMOUNT int(11),
	RESELLER_PROCESSING_COST_AMOUNT int(11),
	RESELLER_PROCESSING_COST_ADJUSTMENTS_AMOUNT int(11),
	STATEMENT_END_DATE datetime,
	RECONCILIATION_DAYS varchar,
	STATEMENT_MONTH int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;