Merchant Statement Statistics


Added On:  12/25/13 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  MerchantStatementStatistics 
Added On:  12/25/13
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:  12/25/13
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:  12/25/13
SQL Column:  MERCHANT_ACCOUNT_GROUP_CODE
Java Field:  merchantAccountGroupCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the group that merchant account belongs to.
Added On:  12/25/13
SQL Column:  PORTFOLIO_CODE
Java Field:  portfolioCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Portfolio that this group belongs to.
Added On:  12/25/13
SQL Column:  PERIOD
Java Field:  period
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  12/25/13
SQL Column:  NET_BALANCE
Java Field:  netBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  12/25/13
SQL Column:  RETURNS_BALANCE
Java Field:  returnsBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  12/25/13
SQL Column:  RECURRING_FEES_AMOUNT
Java Field:  recurringFeesAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money to be payed as recurring transaction fee.
Added On:  12/25/13
SQL Column:  PROCESSING_FEES_AMOUNT
Java Field:  processingFeesAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money to be payed as transaction processing fee.
Added On:  12/25/13
SQL Column:  PROCESSING_COST_AMOUNT
Java Field:  processingCostAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money to be payed as transaction processing cost.
Added On:  12/25/13
SQL Column:  FLAT_FEES_AMOUNT
Java Field:  flatFeesAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money to be payed as flat fee.
Added On:  12/25/13
SQL Column:  TOTAL_FEES_AMOUNT
Java Field:  totalFeesAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total amount of fees to be payed.
Added On:  12/25/13
SQL Column:  PROCESSOR_COST_AMOUNT
Java Field:  processorCostAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money to be payed as a processor cost.
Added On:  12/25/13
SQL Column:  RESELLER_COMMISSIONS_AMOUNT
Java Field:  resellerCommissionsAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money to be payed as reseller commissions.
Added On:  12/25/13
SQL Column:  REFUNDS_RESERVE_REQUIRED_AMOUNT
Java Field:  refundsReserveRequiredAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  12/25/13
SQL Column:  REFUNDS_RESERVE_BALANCE
Java Field:  refundsReserveBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Balance of reserves for processing refund transactions.
Added On:  12/25/13
SQL Column:  RETURNS_RESERVE_RATE
Java Field:  returnsReserveRate
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  12/25/13
SQL Column:  RETURNS_RESERVE_REQUIRED_AMOUNT
Java Field:  returnsReserveRequiredAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  12/25/13
SQL Column:  RETURNS_RESERVE_BALANCE
Java Field:  returnsReserveBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  12/25/13
SQL Column:  CHARGEBACKS_RESERVE_RATE
Java Field:  chargebacksReserveRate
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  12/25/13
SQL Column:  CHARGEBACKS_RESERVE_REQUIRED_AMOUNT
Java Field:  chargebacksReserveRequiredAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  12/25/13
SQL Column:  CHARGEBACKS_RESERVE_BALANCE
Java Field:  chargebacksReserveBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  12/25/13
SQL Column:  DEDUCTIONS_COUNT
Java Field:  deductionsCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  12/25/13
SQL Column:  DEDUCTIONS_AMOUNT
Java Field:  deductionsAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  12/25/13
SQL Column:  WITHDRAWALS_COUNT
Java Field:  withdrawalsCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total count (number) of withdrawals transactions.
Added On:  12/25/13
SQL Column:  WITHDRAWALS_AMOUNT
Java Field:  withdrawalsAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total amount of money of withdrawal transactions.
Added On:  12/30/13
SQL Column:  REMITTANCES_COUNT
Java Field:  remittancesCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total count (number) of remittance transactions.
Added On:  12/30/13
SQL Column:  REMITTANCES_AMOUNT
Java Field:  remittancesAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total amount of money of remittance transactions.
Added On:  01/02/14
SQL Column:  RETURNS_COUNT
Java Field:  returnsCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total count (number) of returns transactions.
Added On:  01/02/14
SQL Column:  RETURNS_AMOUNT
Java Field:  returnsAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total amount of money of returns transactions.
Added On:  01/02/14
SQL Column:  MERCHANT_FEE_REIMBURSEMENT_COUNT
Java Field:  merchantFeeReimbursementCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/02/14
SQL Column:  MERCHANT_FEE_REIMBURSEMENT_AMOUNT
Java Field:  merchantFeeReimbursementAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/02/14
SQL Column:  MERCHANT_FEE_WRITEOFF_COUNT
Java Field:  merchantFeeWriteoffCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/02/14
SQL Column:  MERCHANT_FEE_WRITEOFF_AMOUNT
Java Field:  merchantFeeWriteoffAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/02/14
SQL Column:  MERCHANT_BALANCE_WRITEOFF_COUNT
Java Field:  merchantBalanceWriteoffCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/02/14
SQL Column:  MERCHANT_BALANCE_WRITEOFF_AMOUNT
Java Field:  merchantBalanceWriteoffAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/02/14
SQL Column:  DEACTIVATE_DATE
Java Field:  deactivateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the account is (or will be) deactivated in the system.
Added On:  03/16/14
SQL Column:  ADVANCES_COUNT
Java Field:  advancesCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/14
SQL Column:  ADVANCES_AMOUNT
Java Field:  advancesAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  06/24/14
SQL Column:  PREV_BALANCE
Java Field:  prevBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: