Merchant Activity Statistics

Added On: 03/16/12

SQL Table: IAPP_MERCHANT_ACTIVITY_STATISTICS

Module: UniCore

Type: Entity Status: Active

Java Class: MerchantActivityStatistics

Represents merchant activity statistics.

Available Fields:

Access Fee Count
Cancel Credit Count
Cancel Refund Count
Chargeback Reversal Count
Create Date
Credit Agency Transaction Count
Credit Count
Effective Date
Email Agent Payment Count
Email Cancel Credit Count
Email Cancel Refund Count
Email Chargeback Count
Email Collections1 Count
Email Collections2 Count
Email Collections3 Count
Email Collections4 Count
Email Collections5 Count
Email Credit Count
Email Custom Count
Email Draft Payment Count
Email Hard Decline Count
Email Invoice Count
Email Invoice Notification Count
Email Late Fee Count
Email Notification1 Count
Email Notification2 Count
Email Notification3 Count
Email Portal Payment Count

Email Refund Count
Email Soft Decline Count
Email Statement Count
Email Total Count
Email Void Count
Email Welcome Count
Id
Invoice Count
Late Fee Count
Letter Chargeback Count
Letter Collections1 Count
Letter Collections2 Count
Letter Collections3 Count
Letter Collections4 Count
Letter Collections5 Count
Letter Custom Count
Letter Hard Decline Count
Letter Invoice Notification Count
Letter Notification1 Count
Letter Notification2 Count
Letter Notification3 Count
Letter Soft Decline Count
Letter Statement Count
Letter Total Count
Letter Welcome Count
Merchant Account Code
Payment Plan Count
Phase4 Payment Count

Phase4 Return Count
Reinstate Count
Sent Collections Count
Service Fee Count
Settlement Count
Skip Trace Count
Total Access Fee Amount
Total Cancel Credit Amount
Total Cancel Refund Amount
Total Cancelled Fixed Count
Total Cancelled Fixed Value Amount
Total Chargeback Reversal Amount
Total Created Fixed Count
Total Created Fixed Value Amount
Total Credit Amount
Total Invoice Amount
Total Late Fee Amount
Total Payment Plan Amount
Total Phase4 Payment Amount
Total Phase4 Return Amount
Total Sent Collections Amount
Total Service Fee Amount
Total Settlement Amount
Total Upgraded Fixed Count
Total Upgraded Fixed Value Amount
Total Void Payment Amount
Total Write Off Amount
Void Payment Count

Write Off Count

Access Fee Count

Added On: 03/16/12

SQL Column: ACCESS_FEE_COUNT

Java Field: accessFeeCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Cancel Credit Count

Added On: 03/16/12

SQL Column: CANCEL_CREDIT_COUNT

Java Field: cancelCreditCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Cancel Refund Count

Added On: 03/16/12

SQL Column: CANCEL_REFUND_COUNT

Java Field: cancelRefundCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Chargeback Reversal Count

Added On: 03/16/12

SQL Column: CHARGEBACK_REVERSAL_COUNT

Java Field: chargebackReversalCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Create Date

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

Credit Agency Transaction Count

Added On: 03/16/12

SQL Column: CREDIT_AGENCY_TRANSACTION_COUNT

Java Field: creditAgencyTransactionCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Credit Count

Added On: 03/16/12

SQL Column: CREDIT_COUNT

Java Field: creditCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Effective Date

Added On: 03/16/12

SQL Column: EFFECTIVE_DATE

Java Field: effectiveDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Email Agent Payment Count

Added On: 03/16/12

SQL Column: EMAIL_AGENT_PAYMENT_COUNT

Java Field: emailAgentPaymentCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Cancel Credit Count

Added On: 03/16/12

SQL Column: EMAIL_CANCEL_CREDIT_COUNT

Java Field: emailCancelCreditCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Cancel Refund Count

Added On: 03/16/12

SQL Column: EMAIL_CANCEL_REFUND_COUNT

Java Field: emailCancelRefundCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Chargeback Count

Added On: 03/16/12

SQL Column: EMAIL_CHARGEBACK_COUNT

Java Field: emailChargebackCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Collections1 Count

Added On: 03/16/12

SQL Column: EMAIL_COLLECTIONS1_COUNT

Java Field: emailCollections1Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Collections2 Count

Added On: 03/16/12

SQL Column: EMAIL_COLLECTIONS2_COUNT

Java Field: emailCollections2Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Collections3 Count

Added On: 03/16/12

SQL Column: EMAIL_COLLECTIONS3_COUNT

Java Field: emailCollections3Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Collections4 Count

Added On: 03/16/12

SQL Column: EMAIL_COLLECTIONS4_COUNT

Java Field: emailCollections4Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Collections5 Count

Added On: 03/16/12

SQL Column: EMAIL_COLLECTIONS5_COUNT

Java Field: emailCollections5Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Credit Count

Added On: 03/16/12

SQL Column: EMAIL_CREDIT_COUNT

Java Field: emailCreditCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Custom Count

Added On: 03/16/12

SQL Column: EMAIL_CUSTOM_COUNT

Java Field: emailCustomCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Draft Payment Count

Added On: 03/16/12

SQL Column: EMAIL_DRAFT_PAYMENT_COUNT

Java Field: emailDraftPaymentCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Hard Decline Count

Added On: 03/16/12

SQL Column: EMAIL_HARD_DECLINE_COUNT

Java Field: emailHardDeclineCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Invoice Count

Added On: 03/16/12

SQL Column: EMAIL_INVOICE_COUNT

Java Field: emailInvoiceCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Invoice Notification Count

Added On: 03/16/12

SQL Column: EMAIL_INVOICE_NOTIFICATION_COUNT

Java Field: emailInvoiceNotificationCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Late Fee Count

Added On: 03/16/12

SQL Column: EMAIL_LATE_FEE_COUNT

Java Field: emailLateFeeCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Notification1 Count

Added On: 03/16/12

SQL Column: EMAIL_NOTIFICATION1_COUNT

Java Field: emailNotification1Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Notification2 Count

Added On: 03/16/12

SQL Column: EMAIL_NOTIFICATION2_COUNT

Java Field: emailNotification2Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Notification3 Count

Added On: 03/16/12

SQL Column: EMAIL_NOTIFICATION3_COUNT

Java Field: emailNotification3Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Portal Payment Count

Added On: 03/16/12

SQL Column: EMAIL_PORTAL_PAYMENT_COUNT

Java Field: emailPortalPaymentCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Refund Count

Added On: 03/16/12

SQL Column: EMAIL_REFUND_COUNT

Java Field: emailRefundCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Soft Decline Count

Added On: 03/16/12

SQL Column: EMAIL_SOFT_DECLINE_COUNT

Java Field: emailSoftDeclineCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Statement Count

Added On: 03/16/12

SQL Column: EMAIL_STATEMENT_COUNT

Java Field: emailStatementCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Total Count

Added On: 03/16/12

SQL Column: EMAIL_TOTAL_COUNT

Java Field: emailTotalCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Void Count

Added On: 03/16/12

SQL Column: EMAIL_VOID_COUNT

Java Field: emailVoidCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Email Welcome Count

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: 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.

Invoice Count

Added On: 03/16/12

SQL Column: INVOICE_COUNT

Java Field: invoiceCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Late Fee Count

Added On: 03/16/12

SQL Column: LATE_FEE_COUNT

Java Field: lateFeeCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Chargeback Count

Added On: 03/16/12

SQL Column: LETTER_CHARGEBACK_COUNT

Java Field: letterChargebackCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Collections1 Count

Added On: 03/16/12

SQL Column: LETTER_COLLECTIONS1_COUNT

Java Field: letterCollections1Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Collections2 Count

Added On: 03/16/12

SQL Column: LETTER_COLLECTIONS2_COUNT

Java Field: letterCollections2Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Collections3 Count

Added On: 03/16/12

SQL Column: LETTER_COLLECTIONS3_COUNT

Java Field: letterCollections3Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Collections4 Count

Added On: 03/16/12

SQL Column: LETTER_COLLECTIONS4_COUNT

Java Field: letterCollections4Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Collections5 Count

Added On: 03/16/12

SQL Column: LETTER_COLLECTIONS5_COUNT

Java Field: letterCollections5Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Custom Count

Added On: 03/16/12

SQL Column: LETTER_CUSTOM_COUNT

Java Field: letterCustomCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Hard Decline Count

Added On: 03/16/12

SQL Column: LETTER_HARD_DECLINE_COUNT

Java Field: letterHardDeclineCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Invoice Notification Count

Added On: 03/16/12

SQL Column: LETTER_INVOICE_NOTIFICATION_COUNT

Java Field: letterInvoiceNotificationCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Notification1 Count

Added On: 03/16/12

SQL Column: LETTER_NOTIFICATION1_COUNT

Java Field: letterNotification1Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Notification2 Count

Added On: 03/16/12

SQL Column: LETTER_NOTIFICATION2_COUNT

Java Field: letterNotification2Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Notification3 Count

Added On: 03/16/12

SQL Column: LETTER_NOTIFICATION3_COUNT

Java Field: letterNotification3Count

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Soft Decline Count

Added On: 03/16/12

SQL Column: LETTER_SOFT_DECLINE_COUNT

Java Field: letterSoftDeclineCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Statement Count

Added On: 03/16/12

SQL Column: LETTER_STATEMENT_COUNT

Java Field: letterStatementCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Total Count

Added On: 03/16/12

SQL Column: LETTER_TOTAL_COUNT

Java Field: letterTotalCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Letter Welcome Count

Added On: 03/16/12

SQL Column: LETTER_WELCOME_COUNT

Java Field: letterWelcomeCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant Account Code

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.

Payment Plan Count

Added On: 03/16/12

SQL Column: PAYMENT_PLAN_COUNT

Java Field: paymentPlanCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Phase4 Payment Count

Added On: 03/16/12

SQL Column: PHASE4_PAYMENT_COUNT

Java Field: phase4PaymentCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Phase4 Return Count

Added On: 03/16/12

SQL Column: PHASE4_RETURN_COUNT

Java Field: phase4ReturnCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Reinstate Count

Added On: 03/16/12

SQL Column: REINSTATE_COUNT

Java Field: reinstateCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Sent Collections Count

Added On: 03/16/12

SQL Column: SENT_COLLECTIONS_COUNT

Java Field: sentCollectionsCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Service Fee Count

Added On: 03/16/12

SQL Column: SERVICE_FEE_COUNT

Java Field: serviceFeeCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Settlement Count

Added On: 03/16/12

SQL Column: SETTLEMENT_COUNT

Java Field: settlementCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Skip Trace Count

Added On: 03/16/12

SQL Column: SKIP_TRACE_COUNT

Java Field: skipTraceCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Access Fee Amount

Added On: 03/16/12

SQL Column: TOTAL_ACCESS_FEE_AMOUNT

Java Field: totalAccessFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Cancel Credit Amount

Added On: 03/16/12

SQL Column: TOTAL_CANCEL_CREDIT_AMOUNT

Java Field: totalCancelCreditAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Cancel Refund Amount

Added On: 03/16/12

SQL Column: TOTAL_CANCEL_REFUND_AMOUNT

Java Field: totalCancelRefundAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Cancelled Fixed Count

Added On: 03/16/12

SQL Column: TOTAL_CANCELLED_FIXED_COUNT

Java Field: totalCancelledFixedCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Cancelled Fixed Value Amount

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:

Total Chargeback Reversal Amount

Added On: 03/16/12

SQL Column: TOTAL_CHARGEBACK_REVERSAL_AMOUNT

Java Field: totalChargebackReversalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Created Fixed Count

Added On: 03/16/12

SQL Column: TOTAL_CREATED_FIXED_COUNT

Java Field: totalCreatedFixedCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Created Fixed Value Amount

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:

Total Credit Amount

Added On: 03/16/12

SQL Column: TOTAL_CREDIT_AMOUNT

Java Field: totalCreditAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Invoice Amount

Added On: 03/16/12

SQL Column: TOTAL_INVOICE_AMOUNT

Java Field: totalInvoiceAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Late Fee Amount

Added On: 03/16/12

SQL Column: TOTAL_LATE_FEE_AMOUNT

Java Field: totalLateFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Payment Plan Amount

Added On: 03/16/12

SQL Column: TOTAL_PAYMENT_PLAN_AMOUNT

Java Field: totalPaymentPlanAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Phase4 Payment Amount

Added On: 03/16/12

SQL Column: TOTAL_PHASE4_PAYMENT_AMOUNT

Java Field: totalPhase4PaymentAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Phase4 Return Amount

Added On: 03/16/12

SQL Column: TOTAL_PHASE4_RETURN_AMOUNT

Java Field: totalPhase4ReturnAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Sent Collections Amount

Added On: 03/16/12

SQL Column: TOTAL_SENT_COLLECTIONS_AMOUNT

Java Field: totalSentCollectionsAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Service Fee Amount

Added On: 03/16/12

SQL Column: TOTAL_SERVICE_FEE_AMOUNT

Java Field: totalServiceFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Settlement Amount

Added On: 03/16/12

SQL Column: TOTAL_SETTLEMENT_AMOUNT

Java Field: totalSettlementAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Upgraded Fixed Count

Added On: 03/16/12

SQL Column: TOTAL_UPGRADED_FIXED_COUNT

Java Field: totalUpgradedFixedCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Upgraded Fixed Value Amount

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:

Total Void Payment Amount

Added On: 03/16/12

SQL Column: TOTAL_VOID_PAYMENT_AMOUNT

Java Field: totalVoidPaymentAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Write Off Amount

Added On: 03/16/12

SQL Column: TOTAL_WRITE_OFF_AMOUNT

Java Field: totalWriteOffAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Void Payment Count

Added On: 03/16/12

SQL Column: VOID_PAYMENT_COUNT

Java Field: voidPaymentCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Write Off Count

Added On: 03/16/12

SQL Column: WRITE_OFF_COUNT

Java Field: writeOffCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: