-- Create Table Statement for 'Convenience Fee Registry'
DROP TABLE IF EXISTS `CONVENIENCE_FEE_REGISTRY`;
CREATE TABLE `CONVENIENCE_FEE_REGISTRY` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	FEE_PROCESSOR_CODE int(11),
	TRANSACTION_AMOUNT int(11),
	FEE_AMOUNT int(11),
	CHARGE_DATE datetime,
	CHARGE_STATUS_CL varchar,
	CHARGE_RESPONSE_CODE varchar,
	CHARGE_RESPONSE_MESSAGE varchar,
	REFUND_STATUS_CL varchar,
	REFUND_DATE datetime,
	REFUND_RESPONSE_CODE varchar,
	REFUND_RESPONSE_MESSAGE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_CONVENIENCE_FEE_FK bigint(20),
	REFUND_TRANSACTION_FK bigint(20),
	REFUND_CONVENIENCE_FEE_FK bigint(20),
	CHARGE_RESPONSE_CODE varchar,
	REFUND_RESPONSE_CODE varchar,
	CHARGE_RESPONSE_CODE varchar,
	REFUND_RESPONSE_CODE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;