-- Create Table Statement for 'Merchant Account'
DROP TABLE IF EXISTS `IAPP_MERCHANT_ACCOUNT`;
CREATE TABLE `IAPP_MERCHANT_ACCOUNT` (
	CODE int(11) NOT NULL,
	REF_CODE varchar,
	EXTERNAL_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,
	TIME_ZONE_CODE varchar,
	TAX_RATE1 decimal(10,2),
	TAX_RATE2 decimal(10,2),
	TAX_RATE3 decimal(10,2),
	TAX_RATE4 decimal(10,2),
	TAX_RATE5 decimal(10,2),
	AGE_LIMIT int(11),
	TAX_ID_CODE varchar,
	MERCHANT_FK int(11),
	MERCHANT_ACCOUNT_GROUP_FK bigint(20),
	CREDIT_AGENCY_STATUS_CL varchar,
	COUNTRY_CODE varchar,
	BUSINESS_INFO_FK bigint(20),
	DEFAULT_USER_FK int(11),
	AVS_RESPONSE_MASK int(11),
	CSC_RESPONSE_MASK int(11),
	CLIENT_FEE_FK bigint(20),
	MERCHANT_ACCOUNT_ACTIVITY_FK bigint(20),
	IDENTITIES varchar,
	MERCHANT_PROFILE varchar,
	PORTFOLIO_FK int(11),
	IS_BATCH_REVIEW_REQUIRED tinyint(1),
	DEACTIVATE_DATE datetime,
	ENROLLMENT_FEE_FK bigint(20),
	TIME_ZONE_SYSTEM_CODE varchar,
	DIRECTORY_CODE varchar,
	NOTES varchar,
	NOTES varchar,
	NOTES varchar,
	TAG_LIST varchar,
	RESELLER_FK bigint(20),
	TAG_LIST varchar,
	TAG_LIST varchar,
	TAX_RATE1 decimal(10,2),
	TAX_RATE2 decimal(10,2),
	TAX_RATE3 decimal(10,2),
	TAX_RATE4 decimal(10,2),
	TAX_RATE5 decimal(10,2),
	TAX_RATE1 decimal(10,2),
	TAX_RATE2 decimal(10,2),
	TAX_RATE3 decimal(10,2),
	TAX_RATE4 decimal(10,2),
	TAX_RATE5 decimal(10,2),
	CONTACT_NAME varchar,
	CONTACT_NAME varchar,
	PHONE varchar,
	FAX varchar,
	PHONE varchar,
	FAX varchar,
	PRIMARY KEY (CODE)
) ENGINE=InnoDB;