Merchant Financial Statistics

Added On: 03/16/12

SQL Table: IAPP_MERCHANT_FINANCIAL_STATISTICS

Module: UniCore

Type: Entity Status: Active

Java Class: MerchantFinancialStatistics

Represents information about merchant financial statistics.

Available Fields:

Adjustment Date
Adjustment Note
Aggregate Transaction Code
Amount
Assessments Fee Amount4p
Attempt Count
Authorization Currency Code
Authorization Reconciliation Date
Create Date
Deposit Date
Entry CL
Fee Amount
Flat Fee Amount 4p
Funding Date
Id
Interchange Fee Amount4p
Interchange Flat Fee4p
Interchange Percentage Fee4p
Interchange Rate Name

Is Aggregate
Is AVS Enabled
Is Chargeback Transaction
Is Csc Enabled
Is Final Attempt
Is Interregional
Is Outside Submission
Is Prepaid
Is Submission Closed
Merchant Account Code
Merchant Account Group Code
Original Transaction Code
Payment CL
Peritem Fee Amount4p
Portfolio Code
Processing Cost Amount4p
Processing Fee Amount4p
Processing Fee Rate 4p
Processor Fee Amount4p

Processor Reconciliation Date
Provider Name
Provider Transaction Code
Rebill Attempt Count
Remittance Date
Request Date
Reseller Code
Response Date
Settlement Amount
Settlement Currency Code
Settlement Reconciliation Date
Split Merchant Account Code
Submission CL
Submission Code
Submission Date
Transaction CL
Transaction Code
Transaction Source CL
User Code

Adjustment Date

Added On: 06/09/15

SQL Column: ADJUSTMENT_DATE

Java Field: adjustmentDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the financial transaction is adjusted.

Adjustment Note

Added On: 06/09/15

SQL Column: ADJUSTMENT_NOTE

Java Field: adjustmentNote

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Any additional notes related to the adjustment of the transaction within the system.

Aggregate Transaction Code

Added On: 11/14/13

SQL Column: AGGREGATE_TRANSACTION_CODE

Java Field: aggregateTransactionCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the aggregate transaction.

Amount

Added On: 03/16/12

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The amount of the transaction. Supply the value in cents without a decimal point.

Assessments Fee Amount4p

Added On: 02/15/13

SQL Column: ASSESSMENTS_FEE_AMOUNT4P

Java Field: assessmentsFeeAmount4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The total of assessment fees charged by an association for processing/settlement of the transaction. When processing through Paymentech Stratus, this field contains fees that are applied to chargebacks.

Attempt Count

Added On: 03/16/12

SQL Column: ATTEMPT_COUNT

Java Field: attemptCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Number of attempts.

Authorization Currency Code

Added On: 08/04/13

SQL Column: AUTHORIZATION_CURRENCY_CODE

Java Field: authorizationCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of the currency used for authorization transaction.

Authorization Reconciliation Date

Added On: 04/17/13

SQL Column: AUTHORIZATION_RECONCILIATION_DATE

Java Field: authorizationReconciliationDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the authorization reconciliation for the merchant.

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.

Deposit Date

Added On: 03/16/12

SQL Column: DEPOSIT_DATE

Java Field: depositDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the deposit.

Entry CL

Added On: 01/27/13

SQL Column: ENTRY_CL

Java Field: entryCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Entry Classifier

Attributes:

Represents the type of selected credit card entering mode.

Fee Amount

Added On: 03/16/14

SQL Column: FEE_AMOUNT

Java Field: feeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of fee for the merchant (in dollars).

Flat Fee Amount 4p

Added On: 07/23/19

SQL Column: FLAT_FEE_AMOUNT_4P

Java Field: flatFeeAmount4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Flat fee charged to a transaction.

Funding Date

Added On: 04/02/12

SQL Column: FUNDING_DATE

Java Field: fundingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the funding.

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.

Interchange Fee Amount4p

Added On: 02/15/13

SQL Column: INTERCHANGE_FEE_AMOUNT4P

Java Field: interchangeFeeAmount4p

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

The column is calculated using the following formula:

Interchange Percentage Fee 4p + Interchange Flat Fee4p = Interchange Fee Amount4p

Interchange Flat Fee4p

Added On: 02/15/13

SQL Column: INTERCHANGE_FLAT_FEE4P

Java Field: interchangeFlatFee4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Flat fee charged to a transaction by an association for processing of the card.

Interchange Percentage Fee4p

Added On: 02/15/13

SQL Column: INTERCHANGE_PERCENTAGE_FEE4P

Java Field: interchangePercentageFee4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Percentage fee, charged of a total transaction amount by an association for processing of the card.

Interchange Rate Name

Added On: 02/15/13

SQL Column: INTERCHANGE_RATE_NAME

Java Field: interchangeRateName

Status: Active

SQL Type: varchar(82)

Java Type: String

Attributes:

The name of the interchange rate that this transaction is qualified.

Is Aggregate

Added On: 02/28/20

SQL Column: IS_AGGREGATE

Java Field: isAggregate

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Is AVS Enabled

Added On: 05/10/13

SQL Column: IS_AVS_ENABLED

Java Field: isAvsEnabled

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether AVS approvement is enabled.

Is Chargeback Transaction

Added On: 06/26/14

SQL Column: IS_CHARGEBACK_TRANSACTION

Java Field: isChargebackTransaction

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the type of financial transaction is chargeback.

Is Csc Enabled

Added On: 11/23/17

SQL Column: IS_CSC_ENABLED

Java Field: isCscEnabled

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Is Final Attempt

Added On: 03/16/12

SQL Column: IS_FINAL_ATTEMPT

Java Field: isFinalAttempt

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Indicates whether the attempt is final.

Is Interregional

Added On: 02/15/13

SQL Column: IS_INTERREGIONAL

Java Field: isInterregional

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the merchant transaction is interregional.

Is Outside Submission

Added On: 03/16/12

SQL Column: IS_OUTSIDE_SUBMISSION

Java Field: isOutsideSubmission

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Indicates whether the submission is outside.

Is Prepaid

Added On: 02/15/13

SQL Column: IS_PREPAID

Java Field: isPrepaid

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the transaction is prepaid.

Is Submission Closed

Added On: 03/16/12

SQL Column: IS_SUBMISSION_CLOSED

Java Field: isSubmissionClosed

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Indicates whether the submission is closed.

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.

Merchant Account Group Code

Added On: 03/16/12

SQL Column: MERCHANT_ACCOUNT_GROUP_CODE

Java Field: merchantAccountGroupCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the corresponding merchant account group.

Original Transaction Code

Added On: 09/08/17

SQL Column: ORIGINAL_TRANSACTION_CODE

Java Field: originalTransactionCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Payment CL

Added On: 03/16/12

SQL Column: PAYMENT_CL

Java Field: paymentCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Payment Classifier

Attributes:

Represents the selected type of payment (asset transactions).

Peritem Fee Amount4p

Added On: 02/15/13

SQL Column: PERITEM_FEE_AMOUNT4P

Java Field: peritemFeeAmount4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Flat fee charged to the transaction by the third party processor (gateway owner) for processing of the transaction.

Portfolio Code

Added On: 12/16/15

SQL Column: PORTFOLIO_CODE

Java Field: portfolioCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Code of the portfolio, associated with this record.

Processing Cost Amount4p

Added On: 02/15/13

SQL Column: PROCESSING_COST_AMOUNT4P

Java Field: processingCostAmount4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The column is calculated using the following formula:

Interchange Fee Amount4p + Processor Fee Amount4p + Assessments Fee Amount4p = Processing Cost Amount4p

Processing Fee Amount4p

Added On: 02/15/13

SQL Column: PROCESSING_FEE_AMOUNT4P

Java Field: processingFeeAmount4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Surcharge that is charged as a percentage of the transaction total by the third party processor (gateway owner) for processing of the transaction.

Processing Fee Rate 4p

Added On: 07/23/19

SQL Column: PROCESSING_FEE_RATE_4P

Java Field: processingFeeRate4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Surcharge percentage rate that is charged to the transaction total by the third party processor (gateway owner) for processing of the transaction.

Processor Fee Amount4p

Added On: 02/15/13

SQL Column: PROCESSOR_FEE_AMOUNT4P

Java Field: processorFeeAmount4p

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Flat fee charged by the processor for processing of a transaction.

Processor Reconciliation Date

Added On: 09/08/17

SQL Column: PROCESSOR_RECONCILIATION_DATE

Java Field: processorReconciliationDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Provider Name

Added On: 03/16/12

SQL Column: PROVIDER_NAME

Java Field: providerName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Name of the provider.

Provider Transaction Code

Added On: 03/19/15

SQL Column: PROVIDER_TRANSACTION_CODE

Java Field: providerTransactionCode

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Transaction code of the provider.

Rebill Attempt Count

Added On: 03/01/13

SQL Column: REBILL_ATTEMPT_COUNT

Java Field: rebillAttemptCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Number (count) of attemts of rebill operation.

Remittance Date

Added On: 03/16/12

SQL Column: REMITTANCE_DATE

Java Field: remittanceDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the remittance.

Request Date

Added On: 03/16/12

SQL Column: REQUEST_DATE

Java Field: requestDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the request.

Reseller Code

Added On: 12/06/17

SQL Column: RESELLER_CODE

Java Field: resellerCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Response Date

Added On: 03/16/12

SQL Column: RESPONSE_DATE

Java Field: responseDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the response.

Settlement Amount

Added On: 08/04/13

SQL Column: SETTLEMENT_AMOUNT

Java Field: settlementAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The amount required for the transaction to be settled.

Settlement Currency Code

Added On: 08/04/13

SQL Column: SETTLEMENT_CURRENCY_CODE

Java Field: settlementCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of the currency used for settlement transaction.

Settlement Reconciliation Date

Added On: 03/02/13

SQL Column: SETTLEMENT_RECONCILIATION_DATE

Java Field: settlementReconciliationDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the settlement reconciliation for the merchant.

Split Merchant Account Code

Added On: 04/28/17

SQL Column: SPLIT_MERCHANT_ACCOUNT_CODE

Java Field: splitMerchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Submission CL

Added On: 03/16/12

SQL Column: SUBMISSION_CL

Java Field: submissionCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Submission Classifier

Attributes:

Represents the type of submission selected.

Submission Code

Added On: 03/16/12

SQL Column: SUBMISSION_CODE

Java Field: submissionCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the submission.

Submission Date

Added On: 03/16/12

SQL Column: SUBMISSION_DATE

Java Field: submissionDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the submission.

Transaction CL

Added On: 03/16/12

SQL Column: TRANSACTION_CL

Java Field: transactionCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Transaction Classifier

Attributes:

Represents the type of asset transaction.

Transaction Code

Added On: 03/16/12

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

The unique code of the financial transaction.

Transaction Source CL

Added On: 03/16/12

SQL Column: TRANSACTION_SOURCE_CL

Java Field: transactionSourceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Transaction Source Classifier

Attributes:

Represents the type of transaction source.

User Code

Added On: 06/09/15

SQL Column: USER_CODE

Java Field: userCode

Status: Active

SQL Type: varchar(150)

Java Type: String

Attributes:

Code of the user in the system.