-- Create Table Statement for 'Master Reseller Statement'
DROP TABLE IF EXISTS `IAPP_MASTER_RESELLER_STATEMENT`;
CREATE TABLE `IAPP_MASTER_RESELLER_STATEMENT` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	AMOUNT int(11),
	ADJUSTED_AMOUNT int(11),
	TOTAL_PROCESSING_FEE_TOTAL_AMOUNT int(11),
	TOTAL_FLAT_FEE_TOTAL_AMOUNT int(11),
	TOTAL_RECURRING_FEE_TOTAL_AMOUNT int(11),
	TOTAL_PROCESSING_COST_TOTAL_AMOUNT int(11),
	CREATE_DATE datetime,
	DUE_DATE datetime,
	STATUS_CL varchar,
	RESELLER_FK int(11),
	APPROVER_CODE varchar,
	REMITTER_CODE varchar,
	TRANSACTION_CODE varchar,
	NOTE varchar,
	EMAIL_SENT_DATE datetime,
	MERCHANT_FEE_POLICY varchar,
	BASIS_CL varchar,
	MERCHANT_FEE_MIN_AMOUNT int(11),
	TOTAL_ADJUSTMENT_TOTAL_AMOUNT int(11),
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TOTAL_ADJUSTMENT_TOTAL_AMOUNT int(11),
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	AMOUNT int(11),
	AMOUNT int(11),
	TOTAL_ADJUSTMENT_TOTAL_AMOUNT int(11),
	END_DATE datetime,
	DEPOSIT_DATE datetime,
	START_DATE datetime,
	END_DATE datetime,
	DEPOSIT_DATE datetime,
	END_DATE datetime,
	DEPOSIT_DATE datetime,
	REMITTANCE_DATE datetime,
	RESELLER_DEPOSIT_DATE datetime,
	RESELLER_DEPOSIT_DATE datetime,
	TOTAL_FACILITATOR_PROCESSING_COST_AMOUNT int(11),
	TOTAL_FACILITATOR_PROCESSING_COST_AMOUNT int(11),
	TOTAL_FACILITATOR_PROCESSING_COST_AMOUNT int(11),
	RESELLER_DEPOSIT_DATE datetime,
	START_DATE datetime,
	START_DATE datetime,
	PRIMARY KEY (ID, ID, ID)
) ENGINE=InnoDB;