Business Info UML


Added On:  09/17/12 
SQL Table:  IAPP_BUSINESS_INFO 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  BusinessInfo 
Business information of a company, which at present stage is a merchant or a reseller.
Added On:  05/17/18
SQL Column:  ADDRESS
Java Field:  address
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Calculated
Address associated with a payment card or bank account holder.

The value is a concatenation of the street, city, state, zipCode, countryCode field values separated by commas (,).
Added On:  04/01/13
SQL Column:  AMEX_MID
Java Field:  amexMid
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Existing merchant ID with American Express.
Added On:  10/16/15
SQL Column:  BUSINESS_ESTIMATES_FK
Java Field:  businessEstimates
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Business Estimates
Attributes:
Reference to the entity that represents business estimation information.
Added On:  07/31/15
SQL Column:  BUSINESS_LOCATION_CL
Java Field:  businessLocationCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents current business location.
Added On:  04/01/13
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:  04/01/13
SQL Column:  CARD_DESCRIPTOR
Java Field:  cardDescriptor
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
The desired description for transactions when they appear on the banking statement of a customer.
Added On:  09/17/12
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City name of a company's mailing address.
Added On:  07/19/16
SQL Column:  CONTRACT_BEGIN_DATE
Java Field:  contractBeginDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  07/19/16
SQL Column:  CONTRACT_END_DATE
Java Field:  contractEndDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  09/17/12
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code of a company's mailing address.
Added On:  09/17/12
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created.
Added On:  09/17/12
SQL Column:  CURRENCY_CODE
Java Field:  currencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
The code of currency which the company processes transactions in.
Added On:  07/29/13
SQL Column:  CUSTOMER_SERVICE_PHONE
Java Field:  customerServicePhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Phone number of the customer service.
Added On:  07/31/15
SQL Column:  DESCRIPTOR_CITY
Java Field:  descriptorCity
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
City of the processor's address.
Added On:  07/31/15
SQL Column:  DESCRIPTOR_NAME
Java Field:  descriptorName
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Name of the processor.
Added On:  07/31/15
SQL Column:  DESCRIPTOR_PHONE
Java Field:  descriptorPhone
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Customer service phone number.
Added On:  07/31/15
SQL Column:  DESCRIPTOR_STATE
Java Field:  descriptorState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
State of the processor's address.
Added On:  04/01/13
SQL Column:  DISCOVER_MID
Java Field:  discoverMid
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Existing merchant ID with Discover.
Added On:  05/03/13
SQL Column:  ECHECK_DESCRIPTOR
Java Field:  echeckDescriptor
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
The desired description for eCheck transactions when they appear on the banking statement of a customer.
Added On:  05/03/13
SQL Column:  ECHECK_MERCHANT_NAME
Java Field:  echeckMerchantName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
The merchant's name for eCheck transactions when they appear on the banking statement of a customer.
Added On:  01/13/15
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email address of a company.
Added On:  09/17/12
SQL Column:  ESTIMATED_AVG_TRANSACTION_AMOUNT
Java Field:  estimatedAvgTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The estimated average amount of transactions expected to be processed during the indicated estimation period.
Added On:  10/16/15
SQL Column:  ESTIMATED_MAX_TRANSACTION_AMOUNT
Java Field:  estimatedMaxTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  09/17/12
SQL Column:  ESTIMATED_TRANSACTION_VOLUME
Java Field:  estimatedTransactionVolume
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The estimated volume of transactions expected to be processed during the indicated estimation period.
Added On:  09/17/12
SQL Column:  ESTIMATION_PERIOD_CL
Java Field:  estimationPeriodCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Enumeration of possible time periods for which transaction volume and average transaction amount are defined.
Added On:  09/17/12
SQL Column:  FEDERAL_TAX_ID
Java Field:  federalTaxId
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Federal Tax identifier of the company.
Added On:  09/17/12
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:  09/17/12
SQL Column:  IS_ACTIVE
Java Field:  isActive
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:true
Indicates whether the record is currently active.
Added On:  09/17/12
SQL Column:  LEGAL_NAME
Java Field:  legalName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The legal name of the company.
Added On:  04/12/14
SQL Column:  LICENSE_AGREEMENT_ACCEPTANCE_DATE
Java Field:  licenseAgreementAcceptanceDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when merchant accepted the license agreement.
Added On:  08/02/14
SQL Column:  LICENSE_AGREEMENT_ACCEPTANCE_HOST
Java Field:  licenseAgreementAcceptanceHost
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Added On:  07/29/13
SQL Column:  MAXIMUM_TRANSACTION_AMOUNT
Java Field:  maximumTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The maximum amount of a transaction.
Added On:  09/17/12
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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:  04/01/13
SQL Column:  MERCHANT_CATEGORY_CODE
Java Field:  merchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
A 4-digit code classifying the nature of merchant business for merchant account underwriting.
Added On:  07/31/15
SQL Column:  NUMBER_OF_EMPLOYEES
Java Field:  numberOfEmployees
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Number of employees registered in the company.
Added On:  09/17/12
SQL Column:  OWNERSHIP_STRUCTURE_CL
Java Field:  ownershipStructureCl
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Enumeration of possible ownership types of the company.
Added On:  04/01/13
SQL Column:  PRIMARY_OWNER_FK
Java Field:  primaryOwner
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Business Owner
Attributes:
Reference to the entity that represents primary owner.
Added On:  04/01/13
SQL Column:  PRIMARY_REFERENCE_FK
Java Field:  primaryReference
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Business Reference
Attributes:
Reference to the entity that represents primary business reference.
Added On:  06/13/14
SQL Column:  REGISTRATION_COUNTRY_CODE
Java Field:  registrationCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The country where the merchant's business was established.
Added On:  04/01/13
SQL Column:  REGISTRATION_STATE
Java Field:  registrationState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
The state where the merchant's business was established.
Added On:  04/01/13
SQL Column:  REGISTRATION_YEAR
Java Field:  registrationYear
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The year when the merchant's business was established.
Added On:  09/17/12
SQL Column:  RELATIONSHIP_BEGIN_DATE
Java Field:  relationshipBeginDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the business relationship with this company was officially established.
Added On:  09/17/12
SQL Column:  SALE_TAX_ID
Java Field:  saleTaxId
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Sale Tax identifier of the company.
Added On:  04/01/13
SQL Column:  SECONDARY_OWNER_FK
Java Field:  secondaryOwner
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Business Owner
Attributes:
Reference to the entity that represents secondary business owner profile.
Added On:  09/17/12
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State of a company's mailing address.
Added On:  09/17/12
SQL Column:  STATE_TAX_ID
Java Field:  stateTaxId
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
State Tax identifier of the company.
Added On:  09/17/12
SQL Column:  STREET1
Java Field:  street1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street1 of a company's mailing address.
Added On:  09/17/12
SQL Column:  STREET2
Java Field:  street2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street2 of a company's mailing address.
Added On:  04/02/13
SQL Column:  VERIFICATION_RESULT_FK
Java Field:  verificationResult
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents verification result.
Added On:  09/17/12
SQL Column:  WEB_SITE
Java Field:  webSite
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
URL of the corporate website of the company.
Added On:  04/17/15
SQL Column:  WORK_HOURS
Java Field:  workHours
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes:
Working hours of the company.
Added On:  09/17/12
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP code of a company's mailing address.