-- Create Table Statement for 'Merchant Fee Detail'
DROP TABLE IF EXISTS `IAPP_MERCHANT_FEE_DETAIL`;
CREATE TABLE `IAPP_MERCHANT_FEE_DETAIL` (
	ID bigint(20) NOT NULL,
	DESCRIPTION varchar,
	FORMULA varchar,
	FEE_VARIABLE1 int(11),
	FEE_VARIABLE2 int(11),
	BUY_RATE_VARIABLE1 int(11),
	BUY_RATE_VARIABLE2 int(11),
	IS_VARIABLE1_PERCENT tinyint(1),
	IS_VARIABLE2_PERCENT tinyint(1),
	FEE_FREQUENCY_CL varchar,
	IS_COMMISSIONABLE tinyint(1),
	CAPTION varchar,
	CAPTION_VAR0 varchar,
	CAPTION_VAR1 varchar,
	CAPTION_VAR2 varchar,
	CAPTION_VAR3 varchar,
	REMITTANCE_SOURCE_CL varchar,
	IS_SUBMISSION_BASED tinyint(1),
	SUBMISSION_CL varchar,
	TRANSACTION_CL varchar,
	POSITION int(11),
	STEREOTYPE varchar,
	DELAY_PERIOD int(11),
	CHARGE_DATE datetime,
	FEE_FUNDING_POLICY_CL varchar,
	STATEMENT_DETAIL_GROUP_FK bigint(20),
	GL_ACCOUNT_FK bigint(20),
	FEE_SCHEMA_DETAIL_FK bigint(20),
	STEREOTYPE varchar,
	STEREOTYPE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;