Merchant Activity Statistics


Added On:  03/16/12 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  MerchantActivityStatistics 
Represents merchant activity 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:  INVOICE_COUNT
Java Field:  invoiceCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_INVOICE_AMOUNT
Java Field:  totalInvoiceAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  CREDIT_COUNT
Java Field:  creditCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_CREDIT_AMOUNT
Java Field:  totalCreditAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  CANCEL_CREDIT_COUNT
Java Field:  cancelCreditCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_CANCEL_CREDIT_AMOUNT
Java Field:  totalCancelCreditAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  VOID_PAYMENT_COUNT
Java Field:  voidPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_VOID_PAYMENT_AMOUNT
Java Field:  totalVoidPaymentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  CANCEL_REFUND_COUNT
Java Field:  cancelRefundCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_CANCEL_REFUND_AMOUNT
Java Field:  totalCancelRefundAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  CHARGEBACK_REVERSAL_COUNT
Java Field:  chargebackReversalCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_CHARGEBACK_REVERSAL_AMOUNT
Java Field:  totalChargebackReversalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  SERVICE_FEE_COUNT
Java Field:  serviceFeeCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_SERVICE_FEE_AMOUNT
Java Field:  totalServiceFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LATE_FEE_COUNT
Java Field:  lateFeeCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_LATE_FEE_AMOUNT
Java Field:  totalLateFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  ACCESS_FEE_COUNT
Java Field:  accessFeeCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_ACCESS_FEE_AMOUNT
Java Field:  totalAccessFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  WRITE_OFF_COUNT
Java Field:  writeOffCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_WRITE_OFF_AMOUNT
Java Field:  totalWriteOffAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  SETTLEMENT_COUNT
Java Field:  settlementCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_SETTLEMENT_AMOUNT
Java Field:  totalSettlementAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  PAYMENT_PLAN_COUNT
Java Field:  paymentPlanCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_PAYMENT_PLAN_AMOUNT
Java Field:  totalPaymentPlanAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  SKIP_TRACE_COUNT
Java Field:  skipTraceCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  CREDIT_AGENCY_TRANSACTION_COUNT
Java Field:  creditAgencyTransactionCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_WELCOME_COUNT
Java Field:  letterWelcomeCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_SOFT_DECLINE_COUNT
Java Field:  letterSoftDeclineCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_HARD_DECLINE_COUNT
Java Field:  letterHardDeclineCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_CHARGEBACK_COUNT
Java Field:  letterChargebackCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_STATEMENT_COUNT
Java Field:  letterStatementCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_INVOICE_NOTIFICATION_COUNT
Java Field:  letterInvoiceNotificationCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_NOTIFICATION1_COUNT
Java Field:  letterNotification1Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_NOTIFICATION2_COUNT
Java Field:  letterNotification2Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_NOTIFICATION3_COUNT
Java Field:  letterNotification3Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_COLLECTIONS1_COUNT
Java Field:  letterCollections1Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_COLLECTIONS2_COUNT
Java Field:  letterCollections2Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_COLLECTIONS3_COUNT
Java Field:  letterCollections3Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_COLLECTIONS4_COUNT
Java Field:  letterCollections4Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_COLLECTIONS5_COUNT
Java Field:  letterCollections5Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_CUSTOM_COUNT
Java Field:  letterCustomCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  LETTER_TOTAL_COUNT
Java Field:  letterTotalCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_WELCOME_COUNT
Java Field:  emailWelcomeCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_SOFT_DECLINE_COUNT
Java Field:  emailSoftDeclineCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_HARD_DECLINE_COUNT
Java Field:  emailHardDeclineCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_CHARGEBACK_COUNT
Java Field:  emailChargebackCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_STATEMENT_COUNT
Java Field:  emailStatementCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_INVOICE_NOTIFICATION_COUNT
Java Field:  emailInvoiceNotificationCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_NOTIFICATION1_COUNT
Java Field:  emailNotification1Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_NOTIFICATION2_COUNT
Java Field:  emailNotification2Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_NOTIFICATION3_COUNT
Java Field:  emailNotification3Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_COLLECTIONS1_COUNT
Java Field:  emailCollections1Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_COLLECTIONS2_COUNT
Java Field:  emailCollections2Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_COLLECTIONS3_COUNT
Java Field:  emailCollections3Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_COLLECTIONS4_COUNT
Java Field:  emailCollections4Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_COLLECTIONS5_COUNT
Java Field:  emailCollections5Count
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_DRAFT_PAYMENT_COUNT
Java Field:  emailDraftPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_AGENT_PAYMENT_COUNT
Java Field:  emailAgentPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_PORTAL_PAYMENT_COUNT
Java Field:  emailPortalPaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_VOID_COUNT
Java Field:  emailVoidCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_REFUND_COUNT
Java Field:  emailRefundCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_INVOICE_COUNT
Java Field:  emailInvoiceCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_CREDIT_COUNT
Java Field:  emailCreditCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_CANCEL_CREDIT_COUNT
Java Field:  emailCancelCreditCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_CANCEL_REFUND_COUNT
Java Field:  emailCancelRefundCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_LATE_FEE_COUNT
Java Field:  emailLateFeeCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_CUSTOM_COUNT
Java Field:  emailCustomCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  EMAIL_TOTAL_COUNT
Java Field:  emailTotalCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  SENT_COLLECTIONS_COUNT
Java Field:  sentCollectionsCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_SENT_COLLECTIONS_AMOUNT
Java Field:  totalSentCollectionsAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  REINSTATE_COUNT
Java Field:  reinstateCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  PHASE4_PAYMENT_COUNT
Java Field:  phase4PaymentCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_PHASE4_PAYMENT_AMOUNT
Java Field:  totalPhase4PaymentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  PHASE4_RETURN_COUNT
Java Field:  phase4ReturnCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_PHASE4_RETURN_AMOUNT
Java Field:  totalPhase4ReturnAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_CANCELLED_FIXED_COUNT
Java Field:  totalCancelledFixedCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_CANCELLED_FIXED_VALUE_AMOUNT
Java Field:  totalCancelledFixedValueAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_CREATED_FIXED_COUNT
Java Field:  totalCreatedFixedCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_CREATED_FIXED_VALUE_AMOUNT
Java Field:  totalCreatedFixedValueAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_UPGRADED_FIXED_COUNT
Java Field:  totalUpgradedFixedCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TOTAL_UPGRADED_FIXED_VALUE_AMOUNT
Java Field:  totalUpgradedFixedValueAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: