-- Create Table Statement for 'Billing Cycle Activity'
DROP TABLE IF EXISTS `BILLING_CYCLE_ACTIVITY`;
CREATE TABLE `BILLING_CYCLE_ACTIVITY` (
	ID bigint(20) NOT NULL,
	CREATE_DATE datetime,
	ACTIVITY_CL varchar,
	PAYMENT_PLAN_CL varchar,
	CLAIM_CL varchar,
	AMOUNT int(11),
	VALUE int(11),
	LENGTH int(11),
	COUNT int(11),
	DEFERRED_VALUE int(11),
	DEFERRED_LENGTH int(11),
	DEFERRED_COUNT int(11),
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	REF_CODE varchar,
	BILLING_CYCLE_FK bigint(20),
	INVOICING_HISTORY_FK bigint(20),
	PAYMENT_PLAN_FK bigint(20),
	CHARGE_FK bigint(20),
	CUSTOMER_ACCOUNT_FK bigint(20),
	ADJUSTMENT_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;