-- Create Table Statement for 'Reseller Statement'
DROP TABLE IF EXISTS `IAPP_RESELLER_STATEMENT`;
CREATE TABLE `IAPP_RESELLER_STATEMENT` (
	ID bigint(20) NOT NULL,
	CREATE_DATE datetime,
	MERCHANT_ACCOUNT_CODE int(11),
	STATUS_CL varchar,
	AMOUNT int(11),
	ADJUSTED_AMOUNT int(11),
	START_DATE datetime,
	END_DATE datetime,
	TRANSACTION_CODE varchar,
	APPROVER_CODE varchar,
	REMITTER_CODE varchar,
	NOTE varchar,
	RESELLER_FK int(11),
	RESELLER_COMMISSION_FK bigint(20),
	EMAIL_SENT_DATE datetime,
	DUE_DATE datetime,
	RESELLER_STATEMENT_DETAIL_FK bigint(20),
	PROCESSING_FEE_TOTAL_AMOUNT int(11),
	FLAT_FEE_TOTAL_AMOUNT int(11),
	RECURRING_FEE_TOTAL_AMOUNT int(11),
	PROCESSING_COST_TOTAL_AMOUNT int(11),
	MERCHANT_ACCOUNT_GROUP_FK bigint(20),
	MERCHANT_ACCOUNT_GROUP_FK bigint(20),
	MERCHANT_ACCOUNT_GROUP_FK bigint(20),
	RESELLER_FLAT_FEE_AMOUNT int(11),
	RESELLER_PROCESSING_FEE_AMOUNT int(11),
	RESELLER_RECURRING_FEE_AMOUNT int(11),
	ADJUSTMENT_TOTAL_AMOUNT int(11),
	RESELLER_FLAT_FEE_AMOUNT int(11),
	RESELLER_PROCESSING_FEE_AMOUNT int(11),
	RESELLER_RECURRING_FEE_AMOUNT int(11),
	FACILITATOR_PROCESSING_COST_AMOUNT int(11),
	FACILITATOR_PROCESSING_COST_AMOUNT int(11),
	ADJUSTMENT_TOTAL_AMOUNT int(11),
	FACILITATOR_PROCESSING_COST_AMOUNT int(11),
	ADJUSTMENT_TOTAL_AMOUNT int(11),
	RESELLER_FLAT_FEE_AMOUNT int(11),
	RESELLER_PROCESSING_FEE_AMOUNT int(11),
	RESELLER_RECURRING_FEE_AMOUNT int(11),
	APPROVAL_DATE datetime,
	APPROVAL_DATE datetime,
	APPROVAL_DATE datetime,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;