-- Create Table Statement for 'Master Reseller Statement Detail'
DROP TABLE IF EXISTS `IAPP_MASTER_RESELLER_STATEMENT_DETAIL`;
CREATE TABLE `IAPP_MASTER_RESELLER_STATEMENT_DETAIL` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	AMOUNT int(11),
	ACTIVITY_DATE datetime,
	CREATOR_CODE varchar,
	DESCRIPTION varchar,
	IS_VISIBLE_EXTERNALLY tinyint(1),
	PROCESSING_FEE_TOTAL_AMOUNT int(11),
	FLAT_FEE_TOTAL_AMOUNT int(11),
	RECURRING_FEE_TOTAL_AMOUNT int(11),
	PROCESSING_COST_TOTAL_AMOUNT int(11),
	RESELLER_STATEMENT_FK bigint(20),
	DUE_DATE datetime,
	MERCHANT_REQUIRED_AMOUNT int(11),
	MERCHANT_COLLECTED_AMOUNT int(11),
	ADJUSTMENT_TOTAL_AMOUNT int(11),
	MERCHANT_REQUIRED_AMOUNT int(11),
	MERCHANT_COLLECTED_AMOUNT int(11),
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	ADJUSTMENT_TOTAL_AMOUNT int(11),
	MERCHANT_REQUIRED_AMOUNT int(11),
	MERCHANT_COLLECTED_AMOUNT int(11),
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MASTER_RESELLER_STATEMENT_FK bigint(20),
	MASTER_RESELLER_STATEMENT_FK bigint(20),
	AMOUNT int(11),
	MERCHANT_REQUIRED_AMOUNT int(11),
	MERCHANT_COLLECTED_AMOUNT int(11),
	AMOUNT int(11),
	ADJUSTMENT_TOTAL_AMOUNT int(11),
	MERCHANT_REQUIRED_AMOUNT int(11),
	MERCHANT_COLLECTED_AMOUNT int(11),
	MERCHANT_REQUIRED_AMOUNT int(11),
	MERCHANT_COLLECTED_AMOUNT int(11),
	MASTER_RESELLER_STATEMENT_FK bigint(20),
	MASTER_RESELLER_STATEMENT_FK bigint(20),
	MASTER_RESELLER_STATEMENT_FK bigint(20),
	PRIMARY KEY (ID, ID, ID)
) ENGINE=InnoDB;