-- Create Table Statement for 'Reseller Statement Detail'
DROP TABLE IF EXISTS `IAPP_RESELLER_STATEMENT_DETAIL`;
CREATE TABLE `IAPP_RESELLER_STATEMENT_DETAIL` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	AMOUNT int(11),
	BASIS_AMOUNT int(11),
	RATE int(11),
	DESCRIPTION varchar,
	ACTIVITY_DATE datetime,
	CREATOR_CODE varchar,
	IS_VISIBLE_EXTERNALLY tinyint(1),
	RESELLER_COMMISSION_DETAIL_FK bigint(20),
	MERCHANT_FEE_DETAIL_FK bigint(20),
	MERCHANT_STATEMENT_DETAIL_FK bigint(20),
	RESELLER_STATEMENT_FK bigint(20),
	RESELLER_STATEMENT_RESELLER_STATEMENT_DETAILS_IDX int(11),
	MERCHANT_STATEMENT_DETAIL_FK bigint(20),
	MERCHANT_STATEMENT_DETAIL_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;