Onboarding Business Info UML


Added On:  05/16/16 
SQL Table:  ONBOARDING_BUSINESS_INFO 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  OnboardingBusinessInfo 
Entity that represents merchant business information used for onboarding.
Added On:  05/16/16
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  05/16/16
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  05/16/16
SQL Column:  WEB_SITE
Java Field:  webSite
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Web site URL of the business company.
Added On:  05/16/16
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State code of the business company mailing address.
Added On:  05/16/16
SQL Column:  ANNUAL_CARDS_VOLUME
Java Field:  annualCardsVolume
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated number of the payment card transactions within a year.
Added On:  05/16/16
SQL Column:  DEPOSIT_BANK_NAME
Java Field:  depositBankName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the deposit account assigned by the bank.
Added On:  05/16/16
SQL Column:  DEPOSIT_ACCOUNT_NUMBER
Java Field:  depositAccountNumber
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Number of the deposit account assigned by the bank.
Added On:  05/16/16
SQL Column:  MAX_TRANSACTION_AMOUNT
Java Field:  maxTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Maximum allowed amount of transactions.
Added On:  05/16/16
SQL Column:  ONBOARDING_OWNERSHIP_STRUCTURE
Java Field:  onboardingOwnershipStructure
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Represents the type of ownership structure.
Added On:  05/17/16
SQL Column:  DESCRIPTOR_PHONE
Java Field:  descriptorPhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Customer service phone. Shown on payment card or account holder statements.
Added On:  05/17/16
SQL Column:  DEPOSIT_ACCOUNT_TYPE_CL
Java Field:  depositAccountTypeCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of deposit account of the merchant.
Added On:  05/17/16
SQL Column:  DEPOSIT_HOLDER_NAME
Java Field:  depositHolderName
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Name of the deposit account holder.
Added On:  05/17/16
SQL Column:  ANNUAL_DIRECT_DEBIT_VOLUME
Java Field:  annualDirectDebitVolume
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Volume of the direct debit transactions processed within a year.
Added On:  05/17/16
SQL Column:  AVG_DIRECT_DEBIT_TRANSACTION_AMOUNT
Java Field:  avgDirectDebitTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated average amount of direct debit transactions.
Added On:  05/17/16
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code of the business company mailing address.
Added On:  05/17/16
SQL Column:  AVG_CARDS_TRANSACTION_AMOUNT
Java Field:  avgCardsTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated average amount of the payment card transactions within a year.
Added On:  05/17/16
SQL Column:  PORTFOLIO_CODE
Java Field:  portfolioCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the portfolio the record belongs to.
Added On:  05/17/16
SQL Column:  DESCRIPTION
Java Field:  description
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Short description of the company.
Added On:  05/17/16
SQL Column:  MERCHANT_CATEGORY_CODE
Java Field:  merchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Code of the associated category of the merchant.
Added On:  05/17/16
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP (or postal) code of the business company mailing address.
Added On:  05/17/16
SQL Column:  STREET1
Java Field:  street1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street (line 1) of the business company mailing address.
Added On:  05/17/16
SQL Column:  STREET2
Java Field:  street2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street (line 2) of the business company mailing address.
Added On:  05/17/16
SQL Column:  CONTACT_PHONE
Java Field:  contactPhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Contact phone of the business company for discussing any processing issues.
Added On:  05/17/16
SQL Column:  TAX_ID
Java Field:  taxId
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Identifier of the assigned federal tax.
Added On:  05/17/16
SQL Column:  LEGAL_NAME
Java Field:  legalName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Legal name of the business company.
Added On:  05/17/16
SQL Column:  BUSINESS_NAME
Java Field:  businessName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
The DBA ("doing business as") name.
Added On:  05/17/16
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City of the mailing address.
Added On:  06/01/16
SQL Column:  DEPOSIT_ROUTING_NUMBER
Java Field:  depositRoutingNumber
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Routing number of the bank deposit account.
Added On:  06/07/16
SQL Column:  FEE_SCHEMA
Java Field:  feeSchema
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
Fee schema applied to the merchant.
Added On:  10/21/16
SQL Column:  REGISTRATION_STATE
Java Field:  registrationState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State of the business entity registration.
Added On:  10/21/16
SQL Column:  REGISTRATION_YEAR
Java Field:  registrationYear
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Year when business entity was registered.
Added On:  10/21/16
SQL Column:  REGISTRATION_COUNTRY_CODE
Java Field:  registrationCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the country where registration of the business entity was arranged.
Added On:  10/21/16
SQL Column:  RELATIONSHIP_BEGIN_DATE
Java Field:  relationshipBeginDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when business relationship began.
Added On:  10/21/16
SQL Column:  WORK_HOURS
Java Field:  workHours
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes:
Work hours of the business entity.
Added On:  10/21/16
SQL Column:  CURRENCY_CODE
Java Field:  currencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the currency used in the transactions.
Added On:  10/21/16
SQL Column:  DEPOSIT_BANK_PHONE
Java Field:  depositBankPhone
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Telephone number of the bank associated with merchant's deposit account.
Added On:  10/21/16
SQL Column:  CARD_DESCRIPTOR
Java Field:  cardDescriptor
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Descriptor assigned to payment card transactions associated with the merchant. Shown on cardholder statements.
Added On:  10/21/16
SQL Column:  DIRECT_DEBIT_DESCRIPTOR
Java Field:  directDebitDescriptor
Status:  Active
SQL Type:  varchar(27)
Java Type:  String
Attributes:
Descriptor assigned to direct debit transactions associated with the merchant. Shown on account holder statements.
Added On:  10/21/16
SQL Column:  FEE_PROCESSOR_CODE
Java Field:  feeProcessorCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the fee processor assigned to the record.
Added On:  10/21/16
SQL Column:  REMITTER_CODE
Java Field:  remitterCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the remitter assigned to the record.
Added On:  10/21/16
SQL Column:  DRIVER_LICENSE_STATE
Java Field:  driverLicenseState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State of the user's driver license.
Added On:  10/21/16
SQL Column:  DRIVER_LICENSE
Java Field:  driverLicense
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Number of the user's driver license.
Added On:  10/21/16
SQL Column:  CARD_TYPE_DISTRIBUTION
Java Field:  cardTypeDistribution
Status:  Active
SQL Type:  varchar(31)
Java Type:  String
Attributes:
Type of the card used for distribution.
Added On:  10/21/16
SQL Column:  ENTRY_MODE_DISTRIBUTION
Java Field:  entryModeDistribution
Status:  Active
SQL Type:  varchar(31)
Java Type:  String
Attributes:
Entry mode used for distribution.
Added On:  10/21/16
SQL Column:  DRIVER_LICENSE_COUNTRY_CODE
Java Field:  driverLicenseCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the country where the driver license was issued.
Added On:  10/27/16
SQL Column:  SETTLEMENT_TYPE
Java Field:  settlementType
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Type of the settlement assigned to the record.
Added On:  10/27/16
SQL Column:  SETTLEMENT_CUTOFF
Java Field:  settlementCutoff
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Processing cutoff time set for a processor.
Added On:  10/27/16
SQL Column:  FEE_TEMPLATE_CODE
Java Field:  feeTemplateCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the fee template assigned to this record.
Added On:  10/27/16
SQL Column:  CHARGE_BANK_NAME
Java Field:  chargeBankName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the charge account assigned by the bank.
Added On:  10/27/16
SQL Column:  CHARGE_BANK_PHONE
Java Field:  chargeBankPhone
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Telephone number of the bank assigned to the charge account.
Added On:  10/27/16
SQL Column:  CHARGE_HOLDER_NAME
Java Field:  chargeHolderName
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Name of the holder that a charge account is assigned to.
Added On:  10/27/16
SQL Column:  CHARGE_ACCOUNT_NUMBER
Java Field:  chargeAccountNumber
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Number of the charge account.
Added On:  10/27/16
SQL Column:  CHARGE_ROUTING_NUMBER
Java Field:  chargeRoutingNumber
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Routing number of the bank associated with merchant's deposit operations.
Added On:  10/31/16
SQL Column:  ACCOUNT_USAGE_CL_CHARGE
Java Field:  accountUsageClCharge
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Reference to the entity that represents possible values for account usage.
Added On:  11/15/16
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email address asigned to the record.
Added On:  12/13/16
SQL Column:  DIRECT_DEBIT_DESCRIPTOR_MERCHANT_NAME
Java Field:  directDebitDescriptorMerchantName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the merchant's company. Shown on account holder statements.
Added On:  01/20/17
SQL Column:  FEE_TEMPLATE_CODE_ENCRYPTED
Java Field:  feeTemplateCodeEncrypted
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Encrypted code of the fee template associated with the merchant.
Added On:  06/12/17
SQL Column:  DEPOSIT_ACCOUNT_STORE_FK
Java Field:  depositAccountStore
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Account Store
Attributes:
Storage for the account numbers represented as tokens.
Added On:  10/09/17
SQL Column:  DIRECT_DEBIT_DESCRIPTOR_ITEM
Java Field:  directDebitDescriptorItem
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  01/30/18
SQL Column:  IS_AMEX_OPT_BLUE_ACQUIRED
Java Field:  isAmexOptBlueAcquired
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  01/30/18
SQL Column:  AMEX_MID
Java Field:  amexMid
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  01/30/18
SQL Column:  FEE_PREFIX
Java Field:  feePrefix
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
Added On:  05/16/16
SQL Column:  DEPOSIT_BANK_NAME
Java Field:  depositBankName
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Name of the deposit account assigned by the bank.
Added On:  05/17/16
SQL Column:  DEPOSIT_HOLDER_NAME
Java Field:  depositHolderName
Status:  Active
SQL Type:  varchar(56)
Java Type:  String
Attributes:
Name of the deposit account holder.