-- Create Table Statement for 'Business Info'
DROP TABLE IF EXISTS `IAPP_BUSINESS_INFO`;
CREATE TABLE `IAPP_BUSINESS_INFO` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	CREATE_DATE datetime,
	IS_ACTIVE tinyint(1),
	RELATIONSHIP_BEGIN_DATE datetime,
	WEB_SITE varchar,
	FEDERAL_TAX_ID varchar,
	STATE_TAX_ID varchar,
	SALE_TAX_ID varchar,
	OWNERSHIP_STRUCTURE_CL varchar,
	ESTIMATED_TRANSACTION_VOLUME int(11),
	ESTIMATED_AVG_TRANSACTION_AMOUNT int(11),
	ESTIMATION_PERIOD_CL varchar,
	CURRENCY_CODE varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	COUNTRY_CODE varchar,
	LEGAL_NAME varchar,
	BUSINESS_NAME varchar,
	MERCHANT_CATEGORY_CODE varchar,
	REGISTRATION_YEAR int(11),
	REGISTRATION_STATE varchar,
	AMEX_MID varchar,
	DISCOVER_MID varchar,
	CARD_DESCRIPTOR varchar,
	PRIMARY_OWNER_FK bigint(20),
	SECONDARY_OWNER_FK bigint(20),
	PRIMARY_REFERENCE_FK bigint(20),
	VERIFICATION_RESULT_FK bigint(20),
	ECHECK_DESCRIPTOR varchar,
	ECHECK_MERCHANT_NAME varchar,
	MAXIMUM_TRANSACTION_AMOUNT int(11),
	CUSTOMER_SERVICE_PHONE varchar,
	LICENSE_AGREEMENT_ACCEPTANCE_DATE datetime,
	REGISTRATION_COUNTRY_CODE varchar,
	LICENSE_AGREEMENT_ACCEPTANCE_HOST varchar,
	EMAIL varchar,
	WORK_HOURS varchar,
	DESCRIPTOR_NAME varchar,
	DESCRIPTOR_CITY varchar,
	DESCRIPTOR_STATE varchar,
	DESCRIPTOR_PHONE varchar,
	NUMBER_OF_EMPLOYEES int(11),
	BUSINESS_LOCATION_CL varchar,
	ESTIMATED_MAX_TRANSACTION_AMOUNT int(11),
	BUSINESS_ESTIMATES_FK bigint(20),
	CONTRACT_BEGIN_DATE datetime,
	CONTRACT_END_DATE datetime,
	ADDRESS varchar,
	ADDRESS varchar,
	COUNTRY_CODE varchar,
	REGISTRATION_COUNTRY_CODE varchar,
	COUNTRY_CODE varchar,
	REGISTRATION_COUNTRY_CODE varchar,
	ADDRESS varchar,
	ADDRESS varchar,
	COUNTRY_CODE varchar,
	CURRENCY_CODE varchar,
	EMAIL varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;