Merchant Statement Statistics

Added On: 12/25/13

SQL Table: IAPP_MERCHANT_STATEMENT_STATISTICS

Module: UniCore

Type: Entity Status: Active

Java Class: MerchantStatementStatistics

Available Fields:

Advances Amount
Advances Count
Chargebacks Reserve Balance
Chargebacks Reserve Rate
Chargebacks Reserve Required Amount
Deactivate Date
Deductions Amount
Deductions Count
Flat Fees Amount
Id
Merchant Account Code
Merchant Account Group Code
Merchant Balance Writeoff Amount

Merchant Balance Writeoff Count
Merchant Fee Reimbursement Amount
Merchant Fee Reimbursement Count
Merchant Fee Writeoff Amount
Merchant Fee Writeoff Count
Net Balance
Period
Portfolio Code
Prev Balance
Processing Cost Amount
Processing Fees Amount
Processor Cost Amount
Recurring Fees Amount

Refunds Reserve Balance
Refunds Reserve Required Amount
Remittances Amount
Remittances Count
Reseller Commissions Amount
Returns Amount
Returns Balance
Returns Count
Returns Reserve Balance
Returns Reserve Rate
Returns Reserve Required Amount
Total Fees Amount
Withdrawals Amount

Withdrawals Count

Advances Amount

Added On: 03/16/14

SQL Column: ADVANCES_AMOUNT

Java Field: advancesAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Advances Count

Added On: 03/16/14

SQL Column: ADVANCES_COUNT

Java Field: advancesCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Chargebacks Reserve Balance

Added On: 12/25/13

SQL Column: CHARGEBACKS_RESERVE_BALANCE

Java Field: chargebacksReserveBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Chargebacks Reserve Rate

Added On: 12/25/13

SQL Column: CHARGEBACKS_RESERVE_RATE

Java Field: chargebacksReserveRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Chargebacks Reserve Required Amount

Added On: 12/25/13

SQL Column: CHARGEBACKS_RESERVE_REQUIRED_AMOUNT

Java Field: chargebacksReserveRequiredAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Deactivate Date

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.

Deductions Amount

Added On: 12/25/13

SQL Column: DEDUCTIONS_AMOUNT

Java Field: deductionsAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Deductions Count

Added On: 12/25/13

SQL Column: DEDUCTIONS_COUNT

Java Field: deductionsCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Flat Fees Amount

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

Merchant Account Code

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.

Merchant Account Group Code

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.

Merchant Balance Writeoff Amount

Added On: 01/02/14

SQL Column: MERCHANT_BALANCE_WRITEOFF_AMOUNT

Java Field: merchantBalanceWriteoffAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant Balance Writeoff Count

Added On: 01/02/14

SQL Column: MERCHANT_BALANCE_WRITEOFF_COUNT

Java Field: merchantBalanceWriteoffCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant Fee Reimbursement Amount

Added On: 01/02/14

SQL Column: MERCHANT_FEE_REIMBURSEMENT_AMOUNT

Java Field: merchantFeeReimbursementAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant Fee Reimbursement Count

Added On: 01/02/14

SQL Column: MERCHANT_FEE_REIMBURSEMENT_COUNT

Java Field: merchantFeeReimbursementCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant Fee Writeoff Amount

Added On: 01/02/14

SQL Column: MERCHANT_FEE_WRITEOFF_AMOUNT

Java Field: merchantFeeWriteoffAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant Fee Writeoff Count

Added On: 01/02/14

SQL Column: MERCHANT_FEE_WRITEOFF_COUNT

Java Field: merchantFeeWriteoffCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Net Balance

Added On: 12/25/13

SQL Column: NET_BALANCE

Java Field: netBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Period

Added On: 12/25/13

SQL Column: PERIOD

Java Field: period

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Portfolio Code

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.

Prev Balance

Added On: 06/24/14

SQL Column: PREV_BALANCE

Java Field: prevBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Processing Cost Amount

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.

Processing Fees Amount

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.

Processor Cost Amount

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.

Recurring Fees Amount

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.

Refunds Reserve Balance

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.

Refunds Reserve Required Amount

Added On: 12/25/13

SQL Column: REFUNDS_RESERVE_REQUIRED_AMOUNT

Java Field: refundsReserveRequiredAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Remittances Amount

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.

Remittances Count

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.

Reseller Commissions Amount

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.

Returns Amount

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.

Returns Balance

Added On: 12/25/13

SQL Column: RETURNS_BALANCE

Java Field: returnsBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Returns Count

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.

Returns Reserve Balance

Added On: 12/25/13

SQL Column: RETURNS_RESERVE_BALANCE

Java Field: returnsReserveBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Returns Reserve Rate

Added On: 12/25/13

SQL Column: RETURNS_RESERVE_RATE

Java Field: returnsReserveRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Returns Reserve Required Amount

Added On: 12/25/13

SQL Column: RETURNS_RESERVE_REQUIRED_AMOUNT

Java Field: returnsReserveRequiredAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Fees Amount

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.

Withdrawals Amount

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.

Withdrawals Count

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.