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.
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.
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
Added On:  09/21/15
SQL Column:  PROCESSING_COST_CL
Java Field:  processingCostCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
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
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).
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).
Added On:  09/21/15
SQL Column:  THRESHOLD_LEVEL1
Java Field:  thresholdLevel1
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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).
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).
Added On:  09/21/15
SQL Column:  THRESHOLD_LEVEL3
Java Field:  thresholdLevel3
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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).
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).
Added On:  09/21/15
SQL Column:  THRESHOLD_LEVEL4
Java Field:  thresholdLevel4
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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:  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).
Added On:  09/21/15
SQL Column:  MERCHANT_ACCOUNT_PROFILE_FK
Java Field:  merchantAccountProfile
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents merchant account profile.
Added On:  09/24/15
SQL Column:  THRESHOLD_LEVEL2
Java Field:  thresholdLevel2
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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).
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).