Processing Deviation UML


Added On:  05/12/14 
SQL Table:  IAPP_PROCESSING_DEVIATION 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  ProcessingDeviation 
Represents the fields used for processing deviation statistics within a chosen period of time.
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.
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.
Added On:  05/12/14
SQL Column:  PORTFOLIO_CODE
Java Field:  portfolioCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the portfolio that the group belongs to.
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.
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.
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.
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.
Added On:  05/12/14
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents enumeration of possible statuses of a merchant or reseller statement.
The values can be the following:
'A' - the status is Approved;
'C' - the status is Cancelled;
'N' - the status is Pending;
'P' - the status is Posted;
'J' - the status is Adjusted.
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.
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.
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.
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.
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.
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.
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:  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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Added On:  05/12/14
SQL Column:  PROCESSING_STATISTICS_FK
Java Field:  processingStatistics
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents processing statistics information.
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.
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.
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.
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.