-- Create Table Statement for 'Portfolio'
DROP TABLE IF EXISTS `IAPP_PORTFOLIO`;
CREATE TABLE `IAPP_PORTFOLIO` (
	CREATE_DATE datetime,
	IS_ACTIVE tinyint(1),
	CODE int(11) NOT NULL,
	NAME varchar,
	SUBNAME varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	COUNTRY_CODE varchar,
	PHONE varchar,
	FAX varchar,
	EMAIL varchar,
	UNIPAY_NAME varchar,
	UNICHARGE_NAME varchar,
	UNIBILL_NAME varchar,
	UNICHARGE_REALTIME_PROCESSING_URL varchar,
	UNICHARGE_BATCH_PROCESSING_URL varchar,
	UNICHARGE_REALTIME_SPECIFICATION_URL varchar,
	UNICHARGE_BATCH_SPECIFICATION_URL varchar,
	UNIBILL_PROCESSING_URL varchar,
	UNIBILL_SPECIFICATION_URL varchar,
	UNIPAY_PORTAL_URL varchar,
	EMAIL_SUPPORT varchar,
	WORK_HOURS varchar,
	PHONE_SUPPORT varchar,
	FAX_SUPPORT varchar,
	WORK_HOURS_SUPPORT varchar,
	UNIPAY_DOCUMENTATION_URL varchar,
	SUPPORT_SYSTEM_URL varchar,
	MERCHANT_STATEMENT_NOTIFICATION_CODE varchar,
	DATA_EXPORT_POLICY varchar,
	LAST_PROVISIONING_REPORT_DATE datetime,
	SUPPORT_SYSTEM_PASSWORD varchar,
	SUPPORT_SYSTEM_USERNAME varchar,
	FACILITATOR_PREFIX varchar,
	ANNUAL_FEE_POLICY varchar,
	ANNUAL_FEE_POLICY varchar,
	ANNUAL_FEE_POLICY varchar,
	IS_MULTIPLE_RETURNS_FILE_SUPPORTED tinyint(1),
	IS_MULTIPLE_RETURNS_FILE_SUPPORTED tinyint(1),
	TAG_LIST varchar,
	TAG_LIST varchar,
	TAG_LIST varchar,
	IS_MULTIPLE_RETURNS_FILE_SUPPORTED tinyint(1),
	DATA_EXPORT_POLICY varchar,
	TEST_PORTFOLIO bigint(20),
	NEXT_FEE_TEMPLATE_CODE int(11),
	NEXT_FEE_TEMPLATE_CODE int(11),
	NEXT_FEE_TEMPLATE_CODE int(11),
	CLOUD_CODE varchar,
	CLOUD_CODE varchar,
	REF_CODE varchar,
	REF_CODE varchar,
	CLOUD_CODE varchar,
	REF_CODE varchar,
	ANNUAL_FEE_POLICY varchar,
	ANNUAL_FEE_POLICY varchar,
	PRIMARY KEY (CODE)
) ENGINE=InnoDB;