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
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).
Id
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:
Copyright © Constellation Payments. All Rights Reserved.
All Logos and Trademarks used or mentioned on this page are copyrighted property of their respective owners and are used for display purposes only.