-- Create Table Statement for 'Client Fee'
DROP TABLE IF EXISTS `IAPP_CLIENT_FEE`;
CREATE TABLE `IAPP_CLIENT_FEE` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	CREATE_DATE datetime,
	ACH_PROCESSING_FEE int(11),
	CARDS_PROCESSING_FEE int(11),
	PRINCIPAL_CLIENT_PAYOUT_RATE int(11),
	PRINCIPAL_PARTNER_PAYOUT_RATE int(11),
	PRINCIPAL_AGENT_PAYOUT_RATE int(11),
	REINSTATEMENT_FEE_AGENT_PAYOUT_RATE int(11),
	REINSTATEMENT_FEE int(11),
	CANCELLATION_FEE int(11),
	CREDIT_REPORTING_FEE int(11),
	PARTNER_FK int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;