-- Create Table Statement for 'Account Activity'
DROP TABLE IF EXISTS `ACCOUNT_ACTIVITY`;
CREATE TABLE `ACCOUNT_ACTIVITY` (
	ID bigint(20) NOT NULL,
	REF_CODE varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	COLLECTOR_ACCOUNT_CODE int(11),
	ACCOUNT_ACTIVITY_CL varchar,
	CREATE_DATE datetime,
	IMPORT_DATE datetime,
	SEQUENCE_NUMBER int(11),
	CUSTOMER_ACCOUNT_FK bigint(20),
	ACTIVITY_CAUSE_FK bigint(20),
	SEQUENCE_NUMBER int(11),
	SEQUENCE_NUMBER int(11),
	NEW_FIELD varchar,
	TEST_FIELD_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;