Aex Verification Transaction UML

Added On:  03/28/18 

SQL Table:  AEX_VERIFICATION_TRANSACTION 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  AexVerificationTransaction 

Available Fields:

• Account Holder Title
• Account Number Account 1
• Annual Cards Volume
• Annual Direct Debit Volume
• Application Id
• Avg Cards Transaction Amount
• Avg Direct Debit Transaction Amount
• Business Dba
• Business Description
• Business Name Legal
• Business Phone
• Business Tin
• Business Type
• Callback Raw Data
• Company Id
• Company Key
• Control Address 2
• Control Country
• Control Ownership Percent
• Deposit Account Type
• Deposit Bank Name
• Deposit Holder Name
• Doc Id
• Driver License
• Driver License State

• Error Code
• Fee Amex Per Item
• Fee Amex Processing
• Fee Annual Fee 01
• Fee Chargeback Fee
• Fee Decline Fee
• Fee Direct Debit Noc Fee
• Fee Monthly Fee 01
• Fee Monthly Fee 02
• Fee Monthly Fee 03
• Fee Monthly Fee 04
• Fee Submission Fee
• Fee Visa Per Item
• Fee Visa Per Item Fee
• Fee Visa Processing
• Fee Visa Processing Fee
• Folder Id
• Id
• Is Signature Required
• Key
• Max Transaction Amount
• Merchant Account Code
• Merchant Dba Business Address
• Merchant Dba Business Address 2
• Merchant Dba Business City

• Merchant Dba Business State
• Merchant Dba Business Zip
• Merchant Industry Naics
• Merchant Web Address
• Message
• Onboarding Application
• Principal 1 City
• Principal 1 Dob
• Principal 1 Email
• Principal 1 First Name
• Principal 1 Last Name
• Principal 1 Phone
• Principal 1 Residential Address
• Principal 1 Ssn
• Principal 1 State
• Principal 1 Zip
• Profile Id
• Reseller Email
• Reseller Name
• Routing Number Account 1
• Status Cl
• Transaction Id
• Transaction Reference
• Underwriter Decision
• User Name

Account Holder Title

Added On:  02/05/20

SQL Column:  ACCOUNT_HOLDER_TITLE

Java Field:  accountHolderTitle

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Account Number Account 1

Added On:  03/28/18

SQL Column:  ACCOUNT_NUMBER_ACCOUNT1

Java Field:  accountNumberAccount1

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes: Transient

Annual Cards Volume

Added On:  03/28/18

SQL Column:  ANNUAL_CARDS_VOLUME

Java Field:  annualCardsVolume

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Annual Direct Debit Volume

Added On:  03/28/18

SQL Column:  ANNUAL_DIRECT_DEBIT_VOLUME

Java Field:  annualDirectDebitVolume

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Application Id

Added On:  02/05/20

SQL Column:  APPLICATION_ID

Java Field:  applicationId

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Avg Cards Transaction Amount

Added On:  03/28/18

SQL Column:  AVG_CARDS_TRANSACTION_AMOUNT

Java Field:  avgCardsTransactionAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Avg Direct Debit Transaction Amount

Added On:  03/28/18

SQL Column:  AVG_DIRECT_DEBIT_TRANSACTION_AMOUNT

Java Field:  avgDirectDebitTransactionAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Business Dba

Added On:  03/28/18

SQL Column:  BUSINESS_DBA

Java Field:  businessDba

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Business Description

Added On:  03/28/18

SQL Column:  BUSINESS_DESCRIPTION

Java Field:  businessDescription

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Business Name Legal

Added On:  03/28/18

SQL Column:  BUSINESS_NAME_LEGAL

Java Field:  businessNameLegal

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Business Phone

Added On:  03/28/18

SQL Column:  BUSINESS_PHONE

Java Field:  businessPhone

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Business Tin

Added On:  03/28/18

SQL Column:  BUSINESS_TIN

Java Field:  businessTin

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Business Type

Added On:  03/28/18

SQL Column:  BUSINESS_TYPE

Java Field:  businessType

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Callback Raw Data

Added On:  02/21/19

SQL Column:  CALLBACK_RAW_DATA

Java Field:  callbackRawData

Status:  Active

SQL Type:  longtext

Java Type:  String

Attributes:

Company Id

Added On:  03/28/18

SQL Column:  COMPANY_ID

Java Field:  companyId

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Company Key

Added On:  03/28/18

SQL Column:  COMPANY_KEY

Java Field:  companyKey

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Control Address 2

Added On:  02/05/20

SQL Column:  CONTROL_ADDRESS2

Java Field:  controlAddress2

Status:  Active

SQL Type:  varchar(128)

Java Type:  String

Attributes:

Control Country

Added On:  02/05/20

SQL Column:  CONTROL_COUNTRY

Java Field:  controlCountry

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Control Ownership Percent

Added On:  02/05/20

SQL Column:  CONTROL_OWNERSHIP_PERCENT

Java Field:  controlOwnershipPercent

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Deposit Account Type

Added On:  03/28/18

SQL Column:  DEPOSIT_ACCOUNT_TYPE

Java Field:  depositAccountType

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Deposit Bank Name

Added On:  03/28/18

SQL Column:  DEPOSIT_BANK_NAME

Java Field:  depositBankName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Deposit Holder Name

Added On:  03/28/18

SQL Column:  DEPOSIT_HOLDER_NAME

Java Field:  depositHolderName

Status:  Active

SQL Type:  varchar(32)

Java Type:  String

Attributes:

Doc Id

Added On:  03/28/18

SQL Column:  DOC_ID

Java Field:  docId

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Driver License

Added On:  03/28/18

SQL Column:  DRIVER_LICENSE

Java Field:  driverLicense

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Driver License State

Added On:  03/28/18

SQL Column:  DRIVER_LICENSE_STATE

Java Field:  driverLicenseState

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Error Code

Added On:  03/28/18

SQL Column:  ERROR_CODE

Java Field:  errorCode

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Fee Amex Per Item

Added On:  02/05/20

SQL Column:  FEE_AMEX_PER_ITEM

Java Field:  feeAmexPerItem

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Amex Processing

Added On:  02/05/20

SQL Column:  FEE_AMEX_PROCESSING

Java Field:  feeAmexProcessing

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Annual Fee 01

Added On:  02/05/20

SQL Column:  FEE_ANNUAL_FEE01

Java Field:  feeAnnualFee01

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Chargeback Fee

Added On:  02/05/20

SQL Column:  FEE_CHARGEBACK_FEE

Java Field:  feeChargebackFee

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Decline Fee

Added On:  02/05/20

SQL Column:  FEE_DECLINE_FEE

Java Field:  feeDeclineFee

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Direct Debit Noc Fee

Added On:  02/05/20

SQL Column:  FEE_DIRECT_DEBIT_NOC_FEE

Java Field:  feeDirectDebitNocFee

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Monthly Fee 01

Added On:  02/05/20

SQL Column:  FEE_MONTHLY_FEE01

Java Field:  feeMonthlyFee01

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Monthly Fee 02

Added On:  02/05/20

SQL Column:  FEE_MONTHLY_FEE02

Java Field:  feeMonthlyFee02

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Monthly Fee 03

Added On:  02/05/20

SQL Column:  FEE_MONTHLY_FEE03

Java Field:  feeMonthlyFee03

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Monthly Fee 04

Added On:  02/05/20

SQL Column:  FEE_MONTHLY_FEE04

Java Field:  feeMonthlyFee04

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Submission Fee

Added On:  02/05/20

SQL Column:  FEE_SUBMISSION_FEE

Java Field:  feeSubmissionFee

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Visa Per Item

Added On:  02/05/20

SQL Column:  FEE_VISA_PER_ITEM

Java Field:  feeVisaPerItem

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Visa Per Item Fee

Added On:  02/05/20

SQL Column:  FEE_VISA_PER_ITEM_FEE

Java Field:  feeVisaPerItemFee

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Visa Processing

Added On:  02/05/20

SQL Column:  FEE_VISA_PROCESSING

Java Field:  feeVisaProcessing

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Fee Visa Processing Fee

Added On:  02/05/20

SQL Column:  FEE_VISA_PROCESSING_FEE

Java Field:  feeVisaProcessingFee

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Folder Id

Added On:  03/28/18

SQL Column:  FOLDER_ID

Java Field:  folderId

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Id

Added On:  03/28/18

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes: Unique

Is Signature Required

Added On:  02/05/20

SQL Column:  IS_SIGNATURE_REQUIRED

Java Field:  isSignatureRequired

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Key

Added On:  02/21/19

SQL Column:  KEY

Java Field:  key

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Max Transaction Amount

Added On:  03/28/18

SQL Column:  MAX_TRANSACTION_AMOUNT

Java Field:  maxTransactionAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Merchant Account Code

Added On:  03/28/18

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Merchant Dba Business Address

Added On:  03/28/18

SQL Column:  MERCHANT_DBA_BUSINESS_ADDRESS

Java Field:  merchantDbaBusinessAddress

Status:  Active

SQL Type:  varchar(128)

Java Type:  String

Attributes:

Merchant Dba Business Address 2

Added On:  02/05/20

SQL Column:  MERCHANT_DBA_BUSINESS_ADDRESS2

Java Field:  merchantDbaBusinessAddress2

Status:  Active

SQL Type:  varchar(128)

Java Type:  String

Attributes:

Merchant Dba Business City

Added On:  03/28/18

SQL Column:  MERCHANT_DBA_BUSINESS_CITY

Java Field:  merchantDbaBusinessCity

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Merchant Dba Business State

Added On:  03/28/18

SQL Column:  MERCHANT_DBA_BUSINESS_STATE

Java Field:  merchantDbaBusinessState

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Merchant Dba Business Zip

Added On:  03/28/18

SQL Column:  MERCHANT_DBA_BUSINESS_ZIP

Java Field:  merchantDbaBusinessZip

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Merchant Industry Naics

Added On:  03/28/18

SQL Column:  MERCHANT_INDUSTRY_NAICS

Java Field:  merchantIndustryNaics

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Merchant Web Address

Added On:  03/28/18

SQL Column:  MERCHANT_WEB_ADDRESS

Java Field:  merchantWebAddress

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Message

Added On:  03/28/18

SQL Column:  MESSAGE

Java Field:  message

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Onboarding Application

Added On:  03/28/18

SQL Column:  ONBOARDING_APPLICATION_FK

Java Field:  onboardingApplication

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Onboarding Application

Attributes:

Principal 1 City

Added On:  03/28/18

SQL Column:  PRINCIPAL1_CITY

Java Field:  principal1City

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Principal 1 Dob

Added On:  03/28/18

SQL Column:  PRINCIPAL1_DOB

Java Field:  principal1Dob

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Principal 1 Email

Added On:  03/28/18

SQL Column:  PRINCIPAL1_EMAIL

Java Field:  principal1Email

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Principal 1 First Name

Added On:  03/28/18

SQL Column:  PRINCIPAL1_FIRST_NAME

Java Field:  principal1FirstName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Principal 1 Last Name

Added On:  03/28/18

SQL Column:  PRINCIPAL1_LAST_NAME

Java Field:  principal1LastName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Principal 1 Phone

Added On:  03/28/18

SQL Column:  PRINCIPAL1_PHONE

Java Field:  principal1Phone

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Principal 1 Residential Address

Added On:  03/28/18

SQL Column:  PRINCIPAL1_RESIDENTIAL_ADDRESS

Java Field:  principal1ResidentialAddress

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Principal 1 Ssn

Added On:  03/28/18

SQL Column:  PRINCIPAL1_SSN

Java Field:  principal1Ssn

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Principal 1 State

Added On:  03/28/18

SQL Column:  PRINCIPAL1_STATE

Java Field:  principal1State

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Principal 1 Zip

Added On:  03/28/18

SQL Column:  PRINCIPAL1_ZIP

Java Field:  principal1Zip

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Profile Id

Added On:  02/21/19

SQL Column:  PROFILE_ID

Java Field:  profileId

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Reseller Email

Added On:  03/28/18

SQL Column:  RESELLER_EMAIL

Java Field:  resellerEmail

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Reseller Name

Added On:  03/28/18

SQL Column:  RESELLER_NAME

Java Field:  resellerName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Routing Number Account 1

Added On:  03/28/18

SQL Column:  ROUTING_NUMBER_ACCOUNT1

Java Field:  routingNumberAccount1

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes: Transient

Status Cl

Added On:  03/28/18

SQL Column:  STATUS_CL

Java Field:  statusCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Onboarding Stage Status Classifier

Attributes:

Transaction Id

Added On:  03/28/18

SQL Column:  TRANSACTION_ID

Java Field:  transactionId

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Transaction Reference

Added On:  03/28/18

SQL Column:  TRANSACTION_REFERENCE

Java Field:  transactionReference

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Underwriter Decision

Added On:  02/21/19

SQL Column:  UNDERWRITER_DECISION

Java Field:  underwriterDecision

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

User Name

Added On:  03/28/18

SQL Column:  USER_NAME

Java Field:  userName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes: