-- Create Table Statement for 'Revenue Transaction'
DROP TABLE IF EXISTS `REVENUE_TRANSACTION`;
CREATE TABLE `REVENUE_TRANSACTION` (
	ID bigint(20) NOT NULL,
	IS_COMPLIMENTARY tinyint(1),
	IS_INACTIVE_PAYMENT_OPTION tinyint(1),
	IS_FIRST_TIME tinyint(1),
	IS_LAST_TIME tinyint(1),
	LAST_BILLING_DATE datetime,
	IS_FORCE_STATEMENT tinyint(1),
	CHARGE_FK bigint(20),
	ITEM_FK bigint(20),
	PAYMENT_OPTION_FK bigint(20),
	ITEM_DESCRIPTION varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;