-- Create Table Statement for 'Convenience Fee'
DROP TABLE IF EXISTS `CONVENIENCE_FEE`;
CREATE TABLE `CONVENIENCE_FEE` (
	ID bigint(20) NOT NULL,
	ACCOUNT_PROCESSING_POLICY varchar,
	PROCESSING_COST_CL varchar,
	AMOUNT_LEVEL1 int(11),
	PERCENTAGE_LEVEL1 int(11),
	THRESHOLD_LEVEL1 int(11),
	AMOUNT_LEVEL2 int(11),
	PERCENTAGE_LEVEL2 int(11),
	THRESHOLD_LEVEL3 int(11),
	AMOUNT_LEVEL4 int(11),
	PERCENTAGE_LEVEL4 int(11),
	THRESHOLD_LEVEL4 int(11),
	AMOUNT_LEVEL5 int(11),
	PERCENTAGE_LEVEL5 int(11),
	MERCHANT_ACCOUNT_PROFILE_FK bigint(20),
	THRESHOLD_LEVEL2 int(11),
	AMOUNT_LEVEL3 int(11),
	PERCENTAGE_LEVEL3 int(11),
	IS_ACTIVE tinyint(1),
	IS_ACTIVE tinyint(1),
	IS_ACTIVE tinyint(1),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;