-- Create Table Statement for 'Merchant Object'
DROP TABLE IF EXISTS `MERCHANT_OBJECT`;
CREATE TABLE `MERCHANT_OBJECT` (
	CODE int(11),
	REF_CODE varchar,
	NAME varchar,
	CREATE_DATE datetime,
	IS_ACTIVE tinyint(1),
	NOTES varchar,
	CONTACT_NAME varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	PHONE varchar,
	FAX varchar,
	EMAIL varchar,
	COUNTRY_CODE varchar,
	BUSINESS_INFO bigint(20),
	DEFAULT_USER bigint(20),
	TIME_ZONE_CODE varchar,
	TIME_ZONE_SYSTEM_CODE varchar,
	IDENTITIES varchar,
	MERCHANT_PROFILE varchar,
	DEACTIVATE_DATE datetime,
	PORTFOLIO bigint(20),
	FEE_PROCESSOR bigint(20),
	TAGLIST varchar,
	DIRECTORY_CODE varchar,
	PRIMARY KEY ()
) ENGINE=InnoDB;