-- Create Table Statement for 'Aex Verification Transaction'
DROP TABLE IF EXISTS `AEX_VERIFICATION_TRANSACTION`;
CREATE TABLE `AEX_VERIFICATION_TRANSACTION` (
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),
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,
STATUS_CL varchar,
UNDERWRITER_DECISION varchar,
CALLBACK_RAW_DATA longtext,
PROFILE_ID varchar,
PRIMARY KEY (ID)
) ENGINE=InnoDB;