-- Create Table Statement for 'Aex Verification Transaction'
DROP TABLE IF EXISTS `AEX_VERIFICATION_TRANSACTION`;
CREATE TABLE `AEX_VERIFICATION_TRANSACTION` (
	STATUS_CL varchar,
	USER_NAME varchar,
	COMPANY_ID varchar,
	TRANSACTION_REFERENCE varchar,
	FOLDER_ID varchar,
	PRINCIPAL1_FIRST_NAME varchar,
	PRINCIPAL1_LAST_NAME varchar,
	PRINCIPAL1_RESIDENTIAL_ADDRESS varchar,
	PRINCIPAL1_CITY varchar,
	PRINCIPAL1_STATE varchar,
	PRINCIPAL1_ZIP varchar,
	PRINCIPAL1_DOB varchar,
	PRINCIPAL1_PHONE varchar,
	PRINCIPAL1_EMAIL varchar,
	BUSINESS_DBA varchar,
	BUSINESS_NAME_LEGAL varchar,
	BUSINESS_TYPE varchar,
	MERCHANT_DBA_BUSINESS_ADDRESS varchar,
	MERCHANT_DBA_BUSINESS_CITY varchar,
	MERCHANT_DBA_BUSINESS_STATE varchar,
	MERCHANT_DBA_BUSINESS_ZIP varchar,
	BUSINESS_PHONE varchar,
	MERCHANT_WEB_ADDRESS varchar,
	MERCHANT_INDUSTRY_NAICS varchar,
	ANNUAL_DIRECT_DEBIT_VOLUME int(11),
	ANNUAL_CARDS_VOLUME int(11),
	AVG_DIRECT_DEBIT_TRANSACTION_AMOUNT int(11),
	AVG_CARDS_TRANSACTION_AMOUNT int(11),
	MAX_TRANSACTION_AMOUNT int(11),
	STATUS_CL varchar,
	ERROR_CODE varchar,
	MESSAGE varchar,
	TRANSACTION_ID varchar,
	DOC_ID varchar,
	ONBOARDING_APPLICATION_FK bigint(20),
	RESELLER_NAME varchar,
	RESELLER_EMAIL varchar,
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	BUSINESS_DESCRIPTION varchar,
	BUSINESS_TIN varchar,
	DRIVER_LICENSE varchar,
	DRIVER_LICENSE_STATE varchar,
	DEPOSIT_HOLDER_NAME varchar,
	DEPOSIT_BANK_NAME varchar,
	DEPOSIT_ACCOUNT_TYPE varchar,
	UNDERWRITER_DECISION varchar,
	CALLBACK_RAW_DATA longtext,
	PROFILE_ID varchar,
	APPLICATION_ID varchar,
	CONTROL_ADDRESS2 varchar,
	CONTROL_COUNTRY varchar,
	CONTROL_OWNERSHIP_PERCENT varchar,
	MERCHANT_INDUSTRY_NAICS varchar,
	MERCHANT_DBA_BUSINESS_ADDRESS2 varchar,
	ACCOUNT_HOLDER_TITLE varchar,
	FEE_VISA_PROCESSING int(11),
	FEE_VISA_PROCESSING_FEE int(11),
	FEE_VISA_PER_ITEM int(11),
	FEE_VISA_PER_ITEM_FEE int(11),
	FEE_AMEX_PROCESSING int(11),
	FEE_AMEX_PER_ITEM int(11),
	FEE_DECLINE_FEE int(11),
	FEE_CHARGEBACK_FEE int(11),
	FEE_SUBMISSION_FEE int(11),
	FEE_DIRECT_DEBIT_NOC_FEE int(11),
	FEE_MONTHLY_FEE01 int(11),
	FEE_MONTHLY_FEE02 int(11),
	FEE_MONTHLY_FEE03 int(11),
	FEE_MONTHLY_FEE04 int(11),
	FEE_ANNUAL_FEE01 int(11),
	IS_SIGNATURE_REQUIRED tinyint(1),
	UNDERWRITER_DECISION varchar,
	CALLBACK_RAW_DATA longtext,
	PROFILE_ID varchar,
	TRANSACTION_REFERENCE varchar,
	APPLICATION_ID varchar,
	CONTROL_ADDRESS2 varchar,
	CONTROL_COUNTRY varchar,
	CONTROL_OWNERSHIP_PERCENT varchar,
	MERCHANT_INDUSTRY_NAICS varchar,
	MERCHANT_DBA_BUSINESS_ADDRESS2 varchar,
	ACCOUNT_HOLDER_TITLE varchar,
	FEE_VISA_PROCESSING int(11),
	FEE_VISA_PROCESSING_FEE int(11),
	FEE_VISA_PER_ITEM int(11),
	FEE_VISA_PER_ITEM_FEE int(11),
	FEE_AMEX_PROCESSING int(11),
	FEE_AMEX_PER_ITEM int(11),
	FEE_DECLINE_FEE int(11),
	FEE_CHARGEBACK_FEE int(11),
	FEE_SUBMISSION_FEE int(11),
	FEE_DIRECT_DEBIT_NOC_FEE int(11),
	FEE_MONTHLY_FEE01 int(11),
	FEE_MONTHLY_FEE02 int(11),
	FEE_MONTHLY_FEE03 int(11),
	FEE_MONTHLY_FEE04 int(11),
	FEE_ANNUAL_FEE01 int(11),
	IS_SIGNATURE_REQUIRED tinyint(1),
	TRANSACTION_REFERENCE varchar,
	APPLICATION_ID varchar,
	CONTROL_ADDRESS2 varchar,
	CONTROL_COUNTRY varchar,
	CONTROL_OWNERSHIP_PERCENT varchar,
	MERCHANT_DBA_BUSINESS_ADDRESS2 varchar,
	ACCOUNT_HOLDER_TITLE varchar,
	FEE_VISA_PROCESSING int(11),
	FEE_VISA_PROCESSING_FEE int(11),
	FEE_VISA_PER_ITEM int(11),
	FEE_VISA_PER_ITEM_FEE int(11),
	FEE_AMEX_PROCESSING int(11),
	FEE_AMEX_PER_ITEM int(11),
	FEE_DECLINE_FEE int(11),
	FEE_CHARGEBACK_FEE int(11),
	FEE_SUBMISSION_FEE int(11),
	FEE_DIRECT_DEBIT_NOC_FEE int(11),
	FEE_MONTHLY_FEE01 int(11),
	FEE_MONTHLY_FEE02 int(11),
	FEE_MONTHLY_FEE03 int(11),
	FEE_MONTHLY_FEE04 int(11),
	FEE_ANNUAL_FEE01 int(11),
	IS_SIGNATURE_REQUIRED tinyint(1),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;