Merchant Remittance Statistics

Added On: 02/26/21

SQL Table: IAPP_MERCHANT_REMITTANCE_STATISTICS

Module: UniCore

Type: Entity Status: Active

Java Class: MerchantRemittanceStatistics

Available Fields:

Chargebacks Amount
Chargebacks Count
Create Date
Id
Merchant Account Code
Merchant Account Group Code
Merchant Balance Amount
Merchant Fee Adjustments Amount
Merchant Fees Amount
Merchant Fees Balance Amount
Merchant Processing Cost Adjustments Amount

Merchant Processing Cost Amount
Payments Amount
Payments Count
Portfolio Code
Pricing Cl
Processor Cost Amount
Processor Identity List
Processor Name List
Reconciliation Days
Refunds Amount
Refunds Count

Reseller Balance Amount
Reseller Code
Reseller Commissions Amount
Reseller Fees Amount
Reseller Processing Cost Adjustments Amount
Reseller Processing Cost Amount
Returns Amount
Returns Count
Reversals Amount
Reversals Count
Statement Approve Date

Statement End Date
Statement Month

Chargebacks Amount

Added On: 02/26/21

SQL Column: CHARGEBACKS_AMOUNT

Java Field: chargebacksAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Chargebacks Count

Added On: 02/26/21

SQL Column: CHARGEBACKS_COUNT

Java Field: chargebacksCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Create Date

Added On: 02/26/21

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created.

Added On: 02/26/21

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes:

Identifier of the object used for references; auto-incremented integer value.

Merchant Account Code

Added On: 02/26/21

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Code of Merchant Account to which instance of this object is attributed to.\n\nDepending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.\n\nThe 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: 02/26/21

SQL Column: MERCHANT_ACCOUNT_GROUP_CODE

Java Field: merchantAccountGroupCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Merchant Balance Amount

Added On: 02/26/21

SQL Column: MERCHANT_BALANCE_AMOUNT

Java Field: merchantBalanceAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Merchant Fee Adjustments Amount

Added On: 02/26/21

SQL Column: MERCHANT_FEE_ADJUSTMENTS_AMOUNT

Java Field: merchantFeeAdjustmentsAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant Fees Amount

Added On: 02/26/21

SQL Column: MERCHANT_FEES_AMOUNT

Java Field: merchantFeesAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant Fees Balance Amount

Added On: 02/26/21

SQL Column: MERCHANT_FEES_BALANCE_AMOUNT

Java Field: merchantFeesBalanceAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant Processing Cost Adjustments Amount

Added On: 02/26/21

SQL Column: MERCHANT_PROCESSING_COST_ADJUSTMENTS_AMOUNT

Java Field: merchantProcessingCostAdjustmentsAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant Processing Cost Amount

Added On: 02/26/21

SQL Column: MERCHANT_PROCESSING_COST_AMOUNT

Java Field: merchantProcessingCostAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Payments Amount

Added On: 02/26/21

SQL Column: PAYMENTS_AMOUNT

Java Field: paymentsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Payments Count

Added On: 02/26/21

SQL Column: PAYMENTS_COUNT

Java Field: paymentsCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Portfolio Code

Added On: 02/26/21

SQL Column: PORTFOLIO_CODE

Java Field: portfolioCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Pricing Cl

Added On: 02/26/21

SQL Column: PRICING_CL

Java Field: pricingCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Pricing Classifier

Attributes:

Processor Cost Amount

Added On: 02/26/21

SQL Column: PROCESSOR_COST_AMOUNT

Java Field: processorCostAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Processor Identity List

Added On: 02/26/21

SQL Column: PROCESSOR_IDENTITY_LIST

Java Field: processorIdentityList

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Processor Name List

Added On: 02/26/21

SQL Column: PROCESSOR_NAME_LIST

Java Field: processorNameList

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Reconciliation Days

Added On: 02/26/21

SQL Column: RECONCILIATION_DAYS

Java Field: reconciliationDays

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Refunds Amount

Added On: 02/26/21

SQL Column: REFUNDS_AMOUNT

Java Field: refundsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Refunds Count

Added On: 02/26/21

SQL Column: REFUNDS_COUNT

Java Field: refundsCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Reseller Balance Amount

Added On: 02/26/21

SQL Column: RESELLER_BALANCE_AMOUNT

Java Field: resellerBalanceAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reseller Code

Added On: 02/26/21

SQL Column: RESELLER_CODE

Java Field: resellerCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Reseller Commissions Amount

Added On: 02/26/21

SQL Column: RESELLER_COMMISSIONS_AMOUNT

Java Field: resellerCommissionsAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Reseller Fees Amount

Added On: 02/26/21

SQL Column: RESELLER_FEES_AMOUNT

Java Field: resellerFeesAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Reseller Processing Cost Adjustments Amount

Added On: 02/26/21

SQL Column: RESELLER_PROCESSING_COST_ADJUSTMENTS_AMOUNT

Java Field: resellerProcessingCostAdjustmentsAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Reseller Processing Cost Amount

Added On: 02/26/21

SQL Column: RESELLER_PROCESSING_COST_AMOUNT

Java Field: resellerProcessingCostAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Returns Amount

Added On: 02/26/21

SQL Column: RETURNS_AMOUNT

Java Field: returnsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Returns Count

Added On: 02/26/21

SQL Column: RETURNS_COUNT

Java Field: returnsCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Reversals Amount

Added On: 02/26/21

SQL Column: REVERSALS_AMOUNT

Java Field: reversalsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reversals Count

Added On: 02/26/21

SQL Column: REVERSALS_COUNT

Java Field: reversalsCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Statement Approve Date

Added On: 02/26/21

SQL Column: STATEMENT_APPROVE_DATE

Java Field: statementApproveDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Statement End Date

Added On: 02/26/21

SQL Column: STATEMENT_END_DATE

Java Field: statementEndDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Statement Month

Added On: 02/26/21

SQL Column: STATEMENT_MONTH

Java Field: statementMonth

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: