Merchant Processing Statistics Fee Detail UML

Added On: 02/15/23

SQL Table: MERCHANT_PROCESSING_STATISTICS_FEE_DETAIL

Module: UniCore

Type: Entity Status: Active

Java Class: MerchantProcessingStatisticsFeeDetail

Available Fields:

Authorization Amount
Buy Rate
Buy Rate Amount
Commissionable Rate
Commissions Amount
Commissions Rate

Description
Fee
Fee Amount
Id
Merchant Account Code
Remittance Source Cl

Settlement Amount
Statement Detail Group
Stereotype
Tax Amount
Tax Rate
Tax Rate Value

Transaction Cl
Transaction Count

Authorization Amount

Added On: 02/15/23

SQL Column: AUTHORIZATION_AMOUNT

Java Field: authorizationAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Buy Rate

Added On: 02/15/23

SQL Column: BUY_RATE

Java Field: buyRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Buy Rate Amount

Added On: 02/15/23

SQL Column: BUY_RATE_AMOUNT

Java Field: buyRateAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Commissionable Rate

Added On: 02/15/23

SQL Column: COMMISSIONABLE_RATE

Java Field: commissionableRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Commissions Amount

Added On: 02/15/23

SQL Column: COMMISSIONS_AMOUNT

Java Field: commissionsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Commissions Rate

Added On: 02/15/23

SQL Column: COMMISSIONS_RATE

Java Field: commissionsRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Description

Added On: 02/15/23

SQL Column: DESCRIPTION

Java Field: description

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Fee

Added On: 02/15/23

SQL Column: FEE

Java Field: fee

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Fee Amount

Added On: 02/15/23

SQL Column: FEE_AMOUNT

Java Field: feeAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Added On: 02/15/23

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes:

Merchant Account Code

Added On: 02/15/23

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Remittance Source Cl

Added On: 02/15/23

SQL Column: REMITTANCE_SOURCE_CL

Java Field: remittanceSourceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Remittance Source Classifier

Attributes:

Settlement Amount

Added On: 02/15/23

SQL Column: SETTLEMENT_AMOUNT

Java Field: settlementAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Statement Detail Group

Added On: 02/15/23

SQL Column: STATEMENT_DETAIL_GROUP_FK

Java Field: statementDetailGroup

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Statement Detail Group

Attributes:

Stereotype

Added On: 02/15/23

SQL Column: STEREOTYPE

Java Field: stereotype

Status: Active

SQL Type: varchar(70)

Java Type: String

Attributes:

Tax Amount

Added On: 11/22/23

SQL Column: TAX_AMOUNT

Java Field: taxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount (in cents) of the tax.

Tax Rate

Added On: 11/22/23

SQL Column: TAX_RATE_FK

Java Field: taxRate

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Tax Rate

Attributes:

A copy of the value from the TaxRate table at the moment of statistics record creation.

Tax Rate Value

Added On: 11/22/23

SQL Column: TAX_RATE_VALUE

Java Field: taxRateValue

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction Cl

Added On: 02/15/23

SQL Column: TRANSACTION_CL

Java Field: transactionCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Transaction Classifier

Attributes:

Transaction Count

Added On: 02/15/23

SQL Column: TRANSACTION_COUNT

Java Field: transactionCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: