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 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 Amount

Added On:  05/13/24

SQL Column:  COMMISSIONABLE_AMOUNT

Java Field:  commissionableAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

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:

Id

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: