Business Estimates


Added On:  10/16/15 
SQL Table:  IAPP_BUSINESS_ESTIMATES 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  BusinessEstimates 
Represents information about business estimated values.
Added On:  08/29/16
SQL Column:  CARD_TYPE_AMEX
Java Field:  cardTypeAmex
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated card type for American Express.
Added On:  05/10/16
SQL Column:  CARD_TYPE_DIRECT_DEBIT
Java Field:  cardTypeDirectDebit
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated card type for direct debit transactions.
Added On:  08/29/16
SQL Column:  CARD_TYPE_DISCOVER
Java Field:  cardTypeDiscover
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated card type for Discover.
Added On:  08/29/16
SQL Column:  CARD_TYPE_MASTERCARD
Java Field:  cardTypeMastercard
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated card type for MasterCard.
Added On:  08/29/16
SQL Column:  CARD_TYPE_OTHER
Java Field:  cardTypeOther
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated card type for providers that do not correspond to Visa, MasterCard, American Express or Discover.
Added On:  08/29/16
SQL Column:  CARD_TYPE_VISA
Java Field:  cardTypeVisa
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated card type for Visa.
Added On:  08/29/16
SQL Column:  ENTRY_MODE_ECOMMERCE
Java Field:  entryModeEcommerce
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Entry mode used for eCommerce.
Added On:  08/29/16
SQL Column:  ENTRY_MODE_MAIL
Java Field:  entryModeMail
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Entry mode used for mail.
Added On:  05/10/16
SQL Column:  ENTRY_MODE_OTHER
Java Field:  entryModeOther
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  08/29/16
SQL Column:  ENTRY_MODE_PHONE
Java Field:  entryModePhone
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Entry mode used for phone number.
Added On:  08/29/16
SQL Column:  ENTRY_MODE_RETAIL
Java Field:  entryModeRetail
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated entry mode for retail transactions.
Added On:  08/29/16
SQL Column:  ENTRY_MODE_TRADESHOW
Java Field:  entryModeTradeshow
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Entry mode used for tradeshow.
Added On:  01/18/16
SQL Column:  ESTIMATED_AVG_TRANSACTION_AMOUNT
Java Field:  estimatedAvgTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated AVG transaction amount.
Added On:  01/18/16
SQL Column:  ESTIMATED_MAX_TRANSACTION_AMOUNT
Java Field:  estimatedMaxTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated maximum transaction amount.
Added On:  01/18/16
SQL Column:  ESTIMATED_TRANSACTION_VOLUME
Java Field:  estimatedTransactionVolume
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Estimated transaction volume.
Added On:  01/18/16
SQL Column:  ESTIMATION_PERIOD_CL
Java Field:  estimationPeriodCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Enumeration of possible values of estimation periods.
The values can be the following:
'D' - estimation period is daily;
'W' - estimation period is weekly;
'M' - estimation period is monthly;
'A' - estimation period is annually.
Added On:  10/16/15
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:  10/16/15
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.