Merchant Account Payment Statistics


Added On:  03/16/12 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  MerchantAccountPaymentStatistics 
Represents merchant account payment statistics.
Available Fields:
Added On:  03/16/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Required
Identifier of the object used for references; auto-incremented integer value.
Added On:  03/16/12
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created
Added On:  03/16/12
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:  03/16/12
SQL Column:  EFFECTIVE_DATE
Java Field:  effectiveDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  03/16/12
SQL Column:  TRANSACTION_SOURCE_CL
Java Field:  transactionSourceCl
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Represents current (or selected) type of transaction source.
Added On:  03/16/12
SQL Column:  VISA_PAYMENT_COUNT
Java Field:  visaPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VISA_PAYMENT_AMOUNT
Java Field:  visaPaymentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VISA_REFUND_COUNT
Java Field:  visaRefundCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VISA_REFUND_AMOUNT
Java Field:  visaRefundAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VISA_DECLINE_COUNT
Java Field:  visaDeclineCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VISA_DECLINE_AMOUNT
Java Field:  visaDeclineAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VISA_CHARGEBACK_COUNT
Java Field:  visaChargebackCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VISA_CHARGEBACK_AMOUNT
Java Field:  visaChargebackAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VISA_REVERSAL_COUNT
Java Field:  visaReversalCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VISA_REVERSAL_AMOUNT
Java Field:  visaReversalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  MASTER_CARD_PAYMENT_COUNT
Java Field:  masterCardPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  MASTER_CARD_PAYMENT_AMOUNT
Java Field:  masterCardPaymentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  MASTER_CARD_REFUND_COUNT
Java Field:  masterCardRefundCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  MASTER_CARD_REFUND_AMOUNT
Java Field:  masterCardRefundAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  MASTER_CARD_DECLINE_COUNT
Java Field:  masterCardDeclineCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  MASTER_CARD_DECLINE_AMOUNT
Java Field:  masterCardDeclineAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  MASTER_CARD_CHARGEBACK_COUNT
Java Field:  masterCardChargebackCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  MASTER_CARD_CHARGEBACK_AMOUNT
Java Field:  masterCardChargebackAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  MASTER_CARD_REVERSAL_COUNT
Java Field:  masterCardReversalCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  MASTER_CARD_REVERSAL_AMOUNT
Java Field:  masterCardReversalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  AMEX_PAYMENT_COUNT
Java Field:  amexPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  AMEX_PAYMENT_AMOUNT
Java Field:  amexPaymentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  AMEX_REFUND_COUNT
Java Field:  amexRefundCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Refund count of the transaction made by American Express credit card.
Added On:  03/16/12
SQL Column:  AMEX_REFUND_AMOUNT
Java Field:  amexRefundAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Refund amount of the transaction made by American Express credit card.
Added On:  03/16/12
SQL Column:  AMEX_DECLINE_COUNT
Java Field:  amexDeclineCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  AMEX_DECLINE_AMOUNT
Java Field:  amexDeclineAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  AMEX_CHARGEBACK_COUNT
Java Field:  amexChargebackCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  AMEX_CHARGEBACK_AMOUNT
Java Field:  amexChargebackAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  AMEX_REVERSAL_COUNT
Java Field:  amexReversalCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  AMEX_REVERSAL_AMOUNT
Java Field:  amexReversalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DISCOVER_PAYMENT_COUNT
Java Field:  discoverPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DISCOVER_PAYMENT_AMOUNT
Java Field:  discoverPaymentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DISCOVER_REFUND_COUNT
Java Field:  discoverRefundCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DISCOVER_REFUND_AMOUNT
Java Field:  discoverRefundAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DISCOVER_DECLINE_COUNT
Java Field:  discoverDeclineCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DISCOVER_DECLINE_AMOUNT
Java Field:  discoverDeclineAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DISCOVER_CHARGEBACK_COUNT
Java Field:  discoverChargebackCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DISCOVER_CHARGEBACK_AMOUNT
Java Field:  discoverChargebackAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DISCOVER_REVERSAL_COUNT
Java Field:  discoverReversalCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DISCOVER_REVERSAL_AMOUNT
Java Field:  discoverReversalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DINNERS_PAYMENT_COUNT
Java Field:  dinnersPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DINNERS_PAYMENT_AMOUNT
Java Field:  dinnersPaymentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DINNERS_REFUND_COUNT
Java Field:  dinnersRefundCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DINNERS_REFUND_AMOUNT
Java Field:  dinnersRefundAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DINNERS_DECLINE_COUNT
Java Field:  dinnersDeclineCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DINNERS_DECLINE_AMOUNT
Java Field:  dinnersDeclineAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DINNERS_CHARGEBACK_COUNT
Java Field:  dinnersChargebackCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DINNERS_CHARGEBACK_AMOUNT
Java Field:  dinnersChargebackAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DINNERS_REVERSAL_COUNT
Java Field:  dinnersReversalCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  DINNERS_REVERSAL_AMOUNT
Java Field:  dinnersReversalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EFT_PAYMENT_COUNT
Java Field:  eftPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EFT_PAYMENT_AMOUNT
Java Field:  eftPaymentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EFT_REFUND_COUNT
Java Field:  eftRefundCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EFT_REFUND_AMOUNT
Java Field:  eftRefundAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EFT_DECLINE_COUNT
Java Field:  eftDeclineCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EFT_DECLINE_AMOUNT
Java Field:  eftDeclineAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EFT_REVERSAL_COUNT
Java Field:  eftReversalCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EFT_REVERSAL_AMOUNT
Java Field:  eftReversalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  OTHER_PAYMENT_COUNT
Java Field:  otherPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  OTHER_PAYMENT_AMOUNT
Java Field:  otherPaymentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  OTHER_REFUND_COUNT
Java Field:  otherRefundCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  OTHER_REFUND_AMOUNT
Java Field:  otherRefundAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  RECLEAR_COUNT
Java Field:  reclearCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  REBILL_PAYMENT_COUNT
Java Field:  rebillPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  REBILL_PAYMENT_AMOUNT
Java Field:  rebillPaymentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  REBILL_REFUND_COUNT
Java Field:  rebillRefundCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  REBILL_REFUND_AMOUNT
Java Field:  rebillRefundAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  REBILL_DECLINE_COUNT
Java Field:  rebillDeclineCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  REBILL_DECLINE_AMOUNT
Java Field:  rebillDeclineAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VOID_COUNT
Java Field:  voidCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VOID_AMOUNT
Java Field:  voidAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: