Processing Statistics

Added On: 05/12/14

SQL Table: IAPP_PROCESSING_STATISTICS

Module: UniCore

Type: Entity Status: Active

Java Class: ProcessingStatistics

Represents the fields used for processing statistics within a chosen period of time.

Available Fields:

Account Verifications Count
Activity Date
AVG Processing Frequency
AVG Transaction Amount
AVG Transaction Count
AVG Transaction Volume
Chargebacks Rate
Create Date
Credits Count
Declines Rate

Duplicate Amount Transaction Count
Duplicate Card Transaction Count
Duplicate Transaction Count
Even Amount Transaction Count
Id
Inactive Days Count
Is Active
Keyed Transactions Rate
Low Ticket Transaction Count
Merchant Account Code

Merchant Account Profile Code
Non Present Transactions Rate
Off Hours Transaction Count
Period CL
Portfolio Code
Refunds Count
Reseller Code
Returns Rate
Swiped Transactions Rate
Transaction Amount

Transaction Count
Transaction Volume

Account Verifications Count

Added On: 05/12/14

SQL Column: ACCOUNT_VERIFICATIONS_COUNT

Java Field: accountVerificationsCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Number of account verifications within the period.

Activity Date

Added On: 05/12/14

SQL Column: ACTIVITY_DATE

Java Field: activityDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the last processing activity of the corresponding merchant.

AVG Processing Frequency

Added On: 05/12/14

SQL Column: AVG_PROCESSING_FREQUENCY

Java Field: avgProcessingFrequency

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Average frequency of the transaction processing.

AVG Transaction Amount

Added On: 05/12/14

SQL Column: AVG_TRANSACTION_AMOUNT

Java Field: avgTransactionAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Average amount processed within the transactions.

AVG Transaction Count

Added On: 05/12/14

SQL Column: AVG_TRANSACTION_COUNT

Java Field: avgTransactionCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Average count of the transactions within the period.

AVG Transaction Volume

Added On: 05/12/14

SQL Column: AVG_TRANSACTION_VOLUME

Java Field: avgTransactionVolume

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Average volume processed within the transactions.

Chargebacks Rate

Added On: 05/12/14

SQL Column: CHARGEBACKS_RATE

Java Field: chargebacksRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Rate of the chargebacks amount within the period.

Create Date

Added On: 08/02/16

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created.

Credits Count

Added On: 05/12/14

SQL Column: CREDITS_COUNT

Java Field: creditsCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of credit transactions within the period.

Declines Rate

Added On: 05/12/14

SQL Column: DECLINES_RATE

Java Field: declinesRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Rate of declines amount within the period.

Duplicate Amount Transaction Count

Added On: 05/12/14

SQL Column: DUPLICATE_AMOUNT_TRANSACTION_COUNT

Java Field: duplicateAmountTransactionCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of transactions with duplicate amount within the period.

Duplicate Card Transaction Count

Added On: 05/12/14

SQL Column: DUPLICATE_CARD_TRANSACTION_COUNT

Java Field: duplicateCardTransactionCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of duplicate credit card transactions within the period.

Duplicate Transaction Count

Added On: 05/12/14

SQL Column: DUPLICATE_TRANSACTION_COUNT

Java Field: duplicateTransactionCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of duplicate transactions within the period.

Even Amount Transaction Count

Added On: 05/12/14

SQL Column: EVEN_AMOUNT_TRANSACTION_COUNT

Java Field: evenAmountTransactionCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the transactions with even amount.

Added On: 05/12/14

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.

Inactive Days Count

Added On: 06/05/14

SQL Column: INACTIVE_DAYS_COUNT

Java Field: inactiveDaysCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of inactive processing days.

Is Active

Added On: 05/16/14

SQL Column: IS_ACTIVE

Java Field: isActive

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Indicates whether the record is active within the system.

Keyed Transactions Rate

Added On: 05/12/14

SQL Column: KEYED_TRANSACTIONS_RATE

Java Field: keyedTransactionsRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the keyed transactions within the period.

Low Ticket Transaction Count

Added On: 05/12/14

SQL Column: LOW_TICKET_TRANSACTION_COUNT

Java Field: lowTicketTransactionCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of low ticket transactions within the period.

Merchant Account Code

Added On: 05/12/14

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.

Merchant Account Profile Code

Added On: 05/12/14

SQL Column: MERCHANT_ACCOUNT_PROFILE_CODE

Java Field: merchantAccountProfileCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of merchant account profile to which instance of this object is attributed to.

Non Present Transactions Rate

Added On: 05/12/14

SQL Column: NON_PRESENT_TRANSACTIONS_RATE

Java Field: nonPresentTransactionsRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Rate of card not present transactions within the period.

Off Hours Transaction Count

Added On: 06/05/14

SQL Column: OFF_HOURS_TRANSACTION_COUNT

Java Field: offHoursTransactionCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the processed off hours transactions.

Period CL

Added On: 05/12/14

SQL Column: PERIOD_CL

Java Field: periodCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Period Classifier

Attributes:

Period that is used for deviations statistics.
The values can be the following:
'D' - daily period is used;
'M' - monthly period is used.

Portfolio Code

Added On: 05/12/14

SQL Column: PORTFOLIO_CODE

Java Field: portfolioCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Portfolio that this group belongs to.

Refunds Count

Added On: 05/12/14

SQL Column: REFUNDS_COUNT

Java Field: refundsCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of refunds within the period.

Reseller Code

Added On: 05/12/14

SQL Column: RESELLER_CODE

Java Field: resellerCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Code of the reseller that the group is assigned to.

Returns Rate

Added On: 05/12/14

SQL Column: RETURNS_RATE

Java Field: returnsRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Rate of the returns amount within the period.

Swiped Transactions Rate

Added On: 05/12/14

SQL Column: SWIPED_TRANSACTIONS_RATE

Java Field: swipedTransactionsRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Rate of the swipe transactions within the period.

Transaction Amount

Added On: 08/31/16

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the processed transactions.

Transaction Count

Added On: 05/12/14

SQL Column: TRANSACTION_COUNT

Java Field: transactionCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the transactions.

Transaction Volume

Added On: 05/12/14

SQL Column: TRANSACTION_VOLUME

Java Field: transactionVolume

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Volume of the transactions.