-- 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;