-- Create Table Statement for 'Charge'
DROP TABLE IF EXISTS `CHARGE`;
CREATE TABLE `CHARGE` (
	ID bigint(20) NOT NULL,
	REF_CODE varchar,
	CHARGE_INDEX int(11),
	CREATE_DATE datetime,
	PROCESSED_DATE datetime,
	IS_PREPAID tinyint(1),
	CHARGE_CL varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	COLLECTOR_ACCOUNT_CODE int(11),
	VALUE int(11),
	LENGTH int(11),
	PAYMENT_PLAN_ID bigint(20),
	ADJUSTMENT_FK bigint(20),
	PAYMENT_PLAN_FK bigint(20),
	PAYMENT_PLAN_CHARGES_IDX int(11),
	VALUE_1 int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;