-- Create Table Statement for 'Payment Plan Statistics'
DROP TABLE IF EXISTS `PAYMENT_PLAN_STATISTICS`;
CREATE TABLE `PAYMENT_PLAN_STATISTICS` (
	ID bigint(20) NOT NULL,
	CREATE_DATE datetime,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	UNBILLED_VALUE int(11),
	PAID_VALUE int(11),
	UNPAID_VALUE int(11),
	CANCELLED_VALUE int(11),
	COLLECTIONS_VALUE int(11),
	UPGRADED_VALUE int(11),
	PAYMENT_PLAN_FK bigint(20),
	INVOICE_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;