Convenience Fee UML

Added On: 09/21/15

SQL Table: CONVENIENCE_FEE

Module: UniCharge

Type: Entity Status: Active

Java Class: ConvenienceFee

The enumeration of rules according to which convenience fee is charged on merchant’s transactions.

Available Fields:

Account Processing Policy
Amount Level1
Amount Level2
Amount Level3
Amount Level4
Amount Level5

Id
Is Active
Merchant Account Profile FK
Percentage Level1
Percentage Level2
Percentage Level3

Percentage Level4
Percentage Level5
Processing Cost CL
Threshold Level1
Threshold Level2
Threshold Level3

Threshold Level4

Account Processing Policy

Added On: 09/21/15

SQL Column: ACCOUNT_PROCESSING_POLICY

Java Field: accountProcessingPolicy

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Type of the card that is charged with convenience fee.
The values can be the following:
'V' - Visa
'M' - MasterCard
'X' – American Express
'D' – Discover/Diner's
'A' – Direct debit

Amount Level1

Added On: 09/21/15

SQL Column: AMOUNT_LEVEL1

Java Field: amountLevel1

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Convenience fee represented as fixed amount that is charged to transactions that fall into the first range of transaction amount (for example, from $0 to $15).

Amount Level2

Added On: 09/21/15

SQL Column: AMOUNT_LEVEL2

Java Field: amountLevel2

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Convenience fee represented as fixed amount that is charged on transactions that fall into the second range of transaction amount (for example, from $15 to $50).

Amount Level3

Added On: 06/10/16

SQL Column: AMOUNT_LEVEL3

Java Field: amountLevel3

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Convenience fee represented as fixed amount that is charged on transactions that fall into the third range of transaction amount (for example, from $50 to $80).

Amount Level4

Added On: 09/21/15

SQL Column: AMOUNT_LEVEL4

Java Field: amountLevel4

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Convenience fee represented as fixed amount that is charged on transactions that fall into the fourth range of transaction amount (for example, from $80 to $100).

Amount Level5

Added On: 09/21/15

SQL Column: AMOUNT_LEVEL5

Java Field: amountLevel5

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Convenience fee represented as fixed amount that is charged on transactions that fall into the fifth range of transaction amount (for example, from $100 and more).

Added On: 09/21/15

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.

Is Active

Added On: 07/26/19

SQL Column: IS_ACTIVE

Java Field: isActive

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Merchant Account Profile FK

Added On: 09/21/15

SQL Column: MERCHANT_ACCOUNT_PROFILE_FK

Java Field: merchantAccountProfile

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Merchant Account Profile

Attributes:

Reference to the entity that represents merchant account profile.

Percentage Level1

Added On: 09/21/15

SQL Column: PERCENTAGE_LEVEL1

Java Field: percentageLevel1

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Convenience fee represented as a transaction’s percentage that is charged on transactions that fall into the first range of transaction amount (for example, from $0 to $15).

Percentage Level2

Added On: 09/21/15

SQL Column: PERCENTAGE_LEVEL2

Java Field: percentageLevel2

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Convenience fee represented as a transaction’s percentage that is charged on transactions that fall into the second range of transaction amount (for example, from $15 to $50).

Percentage Level3

Added On: 06/10/16

SQL Column: PERCENTAGE_LEVEL3

Java Field: percentageLevel3

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Convenience fee represented as a transaction’s percentage that is charged on transactions that fall into the third range of transaction amount (for example, from $50 to $80).

Percentage Level4

Added On: 09/21/15

SQL Column: PERCENTAGE_LEVEL4

Java Field: percentageLevel4

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Convenience fee represented as a transaction’s percentage that is charged on transactions that fall into the fourth range of transaction amount (for example, from $80 to $100).

Percentage Level5

Added On: 09/21/15

SQL Column: PERCENTAGE_LEVEL5

Java Field: percentageLevel5

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Convenience fee represented as a transaction’s percentage that is charged on transactions that fall into the fifth range of transaction amount (for example, from $100 and more).

Processing Cost CL

Added On: 09/21/15

SQL Column: PROCESSING_COST_CL

Java Field: processingCostCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Processing Cost Classifier

Attributes:

Indicates whether processing cost is included or not.
The values can be the following:
'G' - Indicates that processing cost is not included
'N' - Indicates that processing cost is included

Threshold Level1

Added On: 09/21/15

SQL Column: THRESHOLD_LEVEL1

Java Field: thresholdLevel1

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Threshold Level2

Added On: 09/24/15

SQL Column: THRESHOLD_LEVEL2

Java Field: thresholdLevel2

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Threshold Level3

Added On: 09/21/15

SQL Column: THRESHOLD_LEVEL3

Java Field: thresholdLevel3

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Threshold Level4

Added On: 09/21/15

SQL Column: THRESHOLD_LEVEL4

Java Field: thresholdLevel4

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: