-- Create Table Statement for 'Remittance Reconciliation Statistics'
DROP TABLE IF EXISTS `IAPP_REMITTANCE_RECONCILIATION_STATISTICS`;
CREATE TABLE `IAPP_REMITTANCE_RECONCILIATION_STATISTICS` (
	ID bigint(20) NOT NULL,
	CREATE_DATE datetime,
	ACTIVITY_DATE datetime,
	MERCHANT_ACCOUNT_CODE int(11),
	PORTFILIO_CODE int(11),
	RESELLER_CODE int(11),
	RECORD_CL varchar,
	PROCESSED_AMOUNT bigint(20),
	UNREMITTED_AMOUNT bigint(20),
	BALANCE bigint(20),
	RESERVE_AMOUNT bigint(20),
	ADJUSTMENT_AMOUNT bigint(20),
	SPLIT_AMOUNT bigint(20),
	MERCHANT_CHARGE_AMOUNT bigint(20),
	TAX_AMOUNT_DUE bigint(20),
	TAX_AMOUNT_RECEIVABLE bigint(20),
	FEE_AMOUNT_DUE bigint(20),
	FEE_AMOUNT_RECEIVABLE bigint(20),
	PROCESSING_COST_AMOUNT_DUE bigint(20),
	PROCESSING_COST_AMOUNT_RECEIVABLE bigint(20),
	WITHDRAWAL_AMOUNT bigint(20),
	REMITTANCE_AMOUNT bigint(20),
	REMITTER_CODE int(11),
	MERCHANT_STATEMENT_CODE bigint(20),
	FEE_SCHEMA_CODE int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;