-- Create Table Statement for 'Vantiv Lowell Sub Merchant Transaction'
DROP TABLE IF EXISTS `VANTIV_LOWELL_SUB_MERCHANT_TRANSACTION`;
CREATE TABLE `VANTIV_LOWELL_SUB_MERCHANT_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	PROVISION_PROFILE_NAME varchar,
	LEGAL_ENTITY_ID varchar,
	STREET_ADDRESS1 varchar,
	STREET_ADDRESS2 varchar,
	CITY varchar,
	STATE_PROVINCE varchar,
	POSTAL_CODE varchar,
	COUNTRY_CODE varchar,
	AMEX_MID varchar,
	CUSTOMER_SERVICE_NUMBER varchar,
	DISCOVER_CONVEYED_MID varchar,
	HARD_CODED_BILLING_DESCRIPTOR varchar,
	MAX_TRANSACTION_AMOUNT varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_NAME varchar,
	PSP_MERCHANT_ID varchar,
	URL varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	PHONE varchar,
	EMAIL_ADDRESS varchar,
	CREATE_CREDENTIALS varchar,
	VANTIV_LOWELL_LEGAL_ENTITY_TRANSACTION_FK bigint(20),
	RETAIL_VANTIV_LOWELL_PROFILE_FK bigint(20),
	CC_VANTIV_LOWELL_PROFILE_FK bigint(20),
	EFT_VANTIV_LOWELL_PROFILE_FK bigint(20),
	ERROR_MESSAGE varchar,
	SUBMERCHANT_ID varchar,
	MERCHANT_IDENT_STRING varchar,
	DISABLED varchar,
	ECHECK_BILLING_DESCRIPTOR varchar,
	ECHECK_COMPANY_NAME varchar,
	USERNAME varchar,
	PAYPAGE_USERNAME varchar,
	PAYPAGE_ID varchar,
	TRANSACTION_ID varchar,
	PURCHASE_CURRENCY varchar,
	CREATE_DATE datetime,
	REQUEST_CL varchar,
	SETTLEMENT_CURRENCY varchar,
	AMEX_SELLER_ID varchar,
	IS_AMEX_ACQUIRED tinyint(1),
	PORTFOLIO_CODE int(11),
	RESELLER_CODE int(11),
	ACCOUNT_NUMBER_MASKED varchar,
	ROUTING_NUMBER_MASKED varchar,
	IS_ECHECK_ENABLED tinyint(1),
	PROVISIONING_TRANSACTION_FK bigint(20),
	CC_VANTIV_LOWELL_PROFILE_FK bigint(20),
	EFT_VANTIV_LOWELL_PROFILE_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	RETAIL_VANTIV_LOWELL_PROFILE_FK bigint(20),
	VANTIV_LOWELL_LEGAL_ENTITY_TRANSACTION_FK bigint(20),
	CC_VANTIV_LOWELL_PROFILE_FK bigint(20),
	EFT_VANTIV_LOWELL_PROFILE_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	RETAIL_VANTIV_LOWELL_PROFILE_FK bigint(20),
	VANTIV_LOWELL_LEGAL_ENTITY_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;