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.

Available Fields:

Card Type Amex
Card Type Direct Debit
Card Type Discover
Card Type Mastercard
Card Type Other
Card Type Visa

Entry Mode Ecommerce
Entry Mode Mail
Entry Mode Other
Entry Mode Phone
Entry Mode Retail
Entry Mode Tradeshow

Estimated AVG Transaction Amount
Estimated Direct Debit Transaction Volume
Estimated Max Transaction Amount
Estimated Payment Card Transaction Volume
Estimated Transaction Volume
Estimation Period CL

Id
Merchant Account Code

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.

Merchant Account Code

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.

Estimation Period CL

Added On: 01/18/16

SQL Column: ESTIMATION_PERIOD_CL

Java Field: estimationPeriodCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Time Period Classifier

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.

Estimated AVG Transaction Amount

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.

Estimated Max 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.

Estimated Transaction Volume

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.

Card Type Direct Debit

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.

Entry Mode Other

Added On: 05/10/16

SQL Column: ENTRY_MODE_OTHER

Java Field: entryModeOther

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Entry Mode Retail

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.

Entry Mode Ecommerce

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.

Entry Mode Mail

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.

Entry Mode Phone

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.

Entry Mode Tradeshow

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.

Card Type Mastercard

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.

Card Type Visa

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.

Card Type Amex

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.

Card Type Discover

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.

Card Type Other

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.

Estimated Payment Card Transaction Volume

Added On: 07/08/26

SQL Column: ESTIMATED_PAYMENT_CARD_TRANSACTION_VOLUME

Java Field: estimatedPaymentCardTransactionVolume

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Pattern:

Estimated payment card transaction volume.

Estimated Direct Debit Transaction Volume

Added On: 07/08/26

SQL Column: ESTIMATED_DIRECT_DEBIT_TRANSACTION_VOLUME

Java Field: estimatedDirectDebitTransactionVolume

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Pattern:

Estimated direct debit transaction volume.