Aex Verification Transaction UML


Added On:  03/28/18 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  AexVerificationTransaction 
Added On:  03/28/18
SQL Column:  USER_NAME
Java Field:  userName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  COMPANY_KEY
Java Field:  companyKey
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Added On:  03/28/18
SQL Column:  COMPANY_ID
Java Field:  companyId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  TRANSACTION_REFERENCE
Java Field:  transactionReference
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  FOLDER_ID
Java Field:  folderId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  PRINCIPAL1_FIRST_NAME
Java Field:  principal1FirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  PRINCIPAL1_LAST_NAME
Java Field:  principal1LastName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  PRINCIPAL1_RESIDENTIAL_ADDRESS
Java Field:  principal1ResidentialAddress
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  PRINCIPAL1_CITY
Java Field:  principal1City
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  PRINCIPAL1_STATE
Java Field:  principal1State
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  PRINCIPAL1_ZIP
Java Field:  principal1Zip
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  PRINCIPAL1_DOB
Java Field:  principal1Dob
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  PRINCIPAL1_SSN
Java Field:  principal1Ssn
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Added On:  03/28/18
SQL Column:  PRINCIPAL1_PHONE
Java Field:  principal1Phone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  PRINCIPAL1_EMAIL
Java Field:  principal1Email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  BUSINESS_DBA
Java Field:  businessDba
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  BUSINESS_NAME_LEGAL
Java Field:  businessNameLegal
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  BUSINESS_TYPE
Java Field:  businessType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  MERCHANT_DBA_BUSINESS_ADDRESS
Java Field:  merchantDbaBusinessAddress
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  MERCHANT_DBA_BUSINESS_CITY
Java Field:  merchantDbaBusinessCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  MERCHANT_DBA_BUSINESS_STATE
Java Field:  merchantDbaBusinessState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  MERCHANT_DBA_BUSINESS_ZIP
Java Field:  merchantDbaBusinessZip
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  BUSINESS_PHONE
Java Field:  businessPhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  MERCHANT_WEB_ADDRESS
Java Field:  merchantWebAddress
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  MERCHANT_INDUSTRY_NAICS
Java Field:  merchantIndustryNaics
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  ANNUAL_DIRECT_DEBIT_VOLUME
Java Field:  annualDirectDebitVolume
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/28/18
SQL Column:  ANNUAL_CARDS_VOLUME
Java Field:  annualCardsVolume
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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:
Added On:  03/28/18
SQL Column:  AVG_CARDS_TRANSACTION_AMOUNT
Java Field:  avgCardsTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/28/18
SQL Column:  MAX_TRANSACTION_AMOUNT
Java Field:  maxTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/28/18
SQL Column:  ROUTING_NUMBER_ACCOUNT1
Java Field:  routingNumberAccount1
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes: Transient
Added On:  03/28/18
SQL Column:  ACCOUNT_NUMBER_ACCOUNT1
Java Field:  accountNumberAccount1
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes: Transient
Added On:  03/28/18
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  ERROR_CODE
Java Field:  errorCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  MESSAGE
Java Field:  message
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  TRANSACTION_ID
Java Field:  transactionId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  DOC_ID
Java Field:  docId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  ONBOARDING_APPLICATION_FK
Java Field:  onboardingApplication
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/28/18
SQL Column:  RESELLER_NAME
Java Field:  resellerName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  RESELLER_EMAIL
Java Field:  resellerEmail
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
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
Added On:  03/28/18
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/28/18
SQL Column:  BUSINESS_DESCRIPTION
Java Field:  businessDescription
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  BUSINESS_TIN
Java Field:  businessTin
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  DRIVER_LICENSE
Java Field:  driverLicense
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  DRIVER_LICENSE_STATE
Java Field:  driverLicenseState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  DEPOSIT_HOLDER_NAME
Java Field:  depositHolderName
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  DEPOSIT_BANK_NAME
Java Field:  depositBankName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  03/28/18
SQL Column:  DEPOSIT_ACCOUNT_TYPE
Java Field:  depositAccountType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes: