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.

Available Fields:

Account Usage CL Charge
Amex Mid
Annual Cards Volume
Annual Direct Debit Volume
Avg Cards Transaction Amount
Avg Direct Debit Transaction Amount
Business Name
Card Descriptor
Card Type Distribution
Charge Account Number
Charge Bank Name
Charge Bank Phone
Charge Holder Name
Charge Routing Number
City
Contact Phone
Country Code
Currency Code
Deposit Account Number
Deposit Account Store
Deposit Account Type CL

Deposit Bank Name
Deposit Bank Phone
Deposit Holder Name
Deposit Routing Number
Description
Descriptor Phone
Direct Debit Descriptor
Direct Debit Descriptor Item
Direct Debit Descriptor Merchant Name
Driver License
Driver License Country Code
Driver License State
Email
Entry Mode Distribution
Fee Prefix
Fee Processor Code
Fee Schema
Fee Template Code
Fee Template Code Encrypted
Id
Is Amex Opt Blue Acquired

Legal Name
Max Transaction Amount
Merchant Account Code
Merchant Category Code
Onboarding Ownership Structure
Portfolio Code
Registration Country Code
Registration State
Registration Year
Relationship Begin Date
Remitter Code
Settlement Cutoff
Settlement Type
State
Street 1
Street 2
Tax ID
Vat Number
Web Site
Work Hours
ZIP Code

Account Usage CL Charge

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.

Amex Mid

Added On: 01/30/18

SQL Column: AMEX_MID

Java Field: amexMid

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Annual Cards Volume

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.

Annual Direct Debit Volume

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.

Avg Cards Transaction Amount

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.

Avg Direct Debit Transaction Amount

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.

Business Name

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.

Card Descriptor

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. Shows up on cardholder statements.

Card Type Distribution

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.

Charge Account Number

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.

Charge Bank Name

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.

Charge Bank Phone

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.

Charge Holder Name

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.

Charge Routing Number

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.

City

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.

Contact Phone

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.

Country Code

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.

Currency Code

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.

Deposit Account Number

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.

Deposit Account Store

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.

Deposit Account Type CL

Added On: 05/17/16

SQL Column: DEPOSIT_ACCOUNT_TYPE_CL

Java Field: depositAccountTypeCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Deposit Account Type Classifier

Attributes:

Represents the type of deposit account of the merchant.

Deposit Bank Name

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.

Deposit Bank Phone

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.

Deposit Holder Name

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.

Deposit Routing Number

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.

Description

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.

Descriptor Phone

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.

Direct Debit Descriptor

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. Shows up on account holder statements.

Direct Debit Descriptor Item

Added On: 10/09/17

SQL Column: DIRECT_DEBIT_DESCRIPTOR_ITEM

Java Field: directDebitDescriptorItem

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Direct Debit Descriptor Merchant Name

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.

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.

Driver License Country Code

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.

Driver License State

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: 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.

Entry Mode 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.

Fee Prefix

Added On: 01/30/18

SQL Column: FEE_PREFIX

Java Field: feePrefix

Status: Active

SQL Type: varchar(23)

Java Type: String

Attributes:

Fee Processor Code

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.

Fee Schema

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.

Fee Template Code

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.

Fee Template Code Encrypted

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: 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.

Is Amex Opt Blue Acquired

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

Legal Name

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.

Max Transaction Amount

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.

Merchant Account Code

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.

Merchant Category Code

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.

Onboarding Ownership Structure

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.

Portfolio Code

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.

Registration Country Code

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.

Registration State

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.

Registration Year

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.

Relationship Begin Date

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.

Remitter Code

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.

Settlement Cutoff

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.

Settlement Type

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.

State

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.

Street 1

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.

Street 2

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.

Tax ID

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.

Vat Number

Added On: 12/21/21

SQL Column: VAT_NUMBER

Java Field: vatNumber

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Web Site

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.

Work Hours

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.

ZIP Code

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.