Merchant Fee Detail UML


Added On:  03/16/12 
SQL Table:  IAPP_MERCHANT_FEE_DETAIL 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  MerchantFeeDetail 
Represents definition of a specific line item of the fee structure. Contains detailed information about merchant fees.
Available Fields:
Buy Rate Variable1
Added On:  03/16/12
SQL Column:  BUY_RATE_VARIABLE1
Java Field:  buyRateVariable1
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
A place-holder for a variable field (actual buy rate value) used in the calculation formula.
Buy Rate Variable2
Added On:  03/16/12
SQL Column:  BUY_RATE_VARIABLE2
Java Field:  buyRateVariable2
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
A place-holder for a variable field (actual buy rate value) used in the calculation formula.
Caption
Added On:  03/16/12
SQL Column:  CAPTION
Java Field:  caption
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
A caption intended to visually display the formula, which is used to deduce the fee from the line item.
Caption Var0
Added On:  03/16/12
SQL Column:  CAPTION_VAR0
Java Field:  captionVar0
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.
Caption Var1
Added On:  03/16/12
SQL Column:  CAPTION_VAR1
Java Field:  captionVar1
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.
Caption Var2
Added On:  03/16/12
SQL Column:  CAPTION_VAR2
Java Field:  captionVar2
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.
Caption Var3
Added On:  03/16/12
SQL Column:  CAPTION_VAR3
Java Field:  captionVar3
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.
Charge Date
Added On:  10/02/13
SQL Column:  CHARGE_DATE
Java Field:  chargeDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
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: Transient
Delay Period
Added On:  10/02/13
SQL Column:  DELAY_PERIOD
Java Field:  delayPeriod
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Description
Added On:  03/16/12
SQL Column:  DESCRIPTION
Java Field:  description
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Description of the line item in the fee structure.
Fee Frequency CL
Added On:  03/16/12
SQL Column:  FEE_FREQUENCY_CL
Java Field:  feeFrequencyCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
References Merchant Fee Frequency Classifier
Attributes:
Enumerates possible frequencies that can be used to apply merchant fees.
Fee Funding Policy CL
Added On:  01/29/15
SQL Column:  FEE_FUNDING_POLICY_CL
Java Field:  feeFundingPolicyCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References Fee Funding Policy Classifier
Attributes:
Fee Schema Detail FK
Added On:  08/31/16
SQL Column:  FEE_SCHEMA_DETAIL_FK
Java Field:  feeSchemaDetail
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Fee Schema Detail
Attributes:
Reference to the entity that represents fee schema detail information.
Fee Variable1
Added On:  03/16/12
SQL Column:  FEE_VARIABLE1
Java Field:  feeVariable1
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
A place-holder for a variable field (actual value of the fee) used in the calculation formula.
Fee Variable2
Added On:  03/16/12
SQL Column:  FEE_VARIABLE2
Java Field:  feeVariable2
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Formula
Added On:  03/16/12
SQL Column:  FORMULA
Java Field:  formula
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
A mathematical expression to calculate/deduce the amount for the line item, based on statistical variables (financial statistics).
GL Account FK
Added On:  08/31/16
SQL Column:  GL_ACCOUNT_FK
Java Field:  glAccount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References GL Account
Attributes:
Reference to the entity that represents GL account information.
Id
Added On:  03/16/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Required
Identifier of the object used for references; auto-incremented integer value.
Is Commissionable
Added On:  03/16/12
SQL Column:  IS_COMMISSIONABLE
Java Field:  isCommissionable
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether commission can be taken from the line item.
Is Submission Based
Added On:  03/16/12
SQL Column:  IS_SUBMISSION_BASED
Java Field:  isSubmissionBased
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:true
When set to FALSE, indicates whether this particular item is a result of chargebacks or ACH transactions. When set to TRUE, indicates that the item results from submitter-initiated transcations.
Is Variable1 Percent
Added On:  03/16/12
SQL Column:  IS_VARIABLE1_PERCENT
Java Field:  isVariable1Percent
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether Variable 1 is expressed as percentage of transaction amount (in contrast to specific cash amount).
Is Variable2 Percent
Added On:  03/16/12
SQL Column:  IS_VARIABLE2_PERCENT
Java Field:  isVariable2Percent
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Position
Added On:  01/21/13
SQL Column:  POSITION
Java Field:  position
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Position of the fee detail in the merchant fee table. The field allows to define the fee detail position in the list of fee details manually.
Remittance Source CL
Added On:  03/16/12
SQL Column:  REMITTANCE_SOURCE_CL
Java Field:  remittanceSourceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References Remittance Source Classifier
Attributes:
Enumeration of possible banking accounts the money for specific line item is taken from. See Remittance source.
Statement Detail Group FK
Added On:  08/31/16
SQL Column:  STATEMENT_DETAIL_GROUP_FK
Java Field:  statementDetailGroup
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Statement Detail Group
Attributes:
Reference to the entity that represents statement detail group information.
Stereotype
Added On:  01/27/13
SQL Column:  STEREOTYPE
Java Field:  stereotype
Status:  Active
SQL Type:  varchar(70)
Java Type:  String
Attributes:
Conceptual name of the merchant fee detail item that identifies its functional purpose and allows to match differently named items with the same functional purpose across different merchant fees.
Submission CL
Added On:  01/21/13
SQL Column:  SUBMISSION_CL
Java Field:  submissionCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References Submission Classifier
Attributes:
Enumeration of possible submission types for the given detail (indicates, which submission type the detail belongs to).
Transaction CL
Added On:  01/21/13
SQL Column:  TRANSACTION_CL
Java Field:  transactionCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
References Transaction Classifier
Attributes:
Enumeration of possible types of transaction, that the fee detail deals with.
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.