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.
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.
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.
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).
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.
Added On:  03/16/12
SQL Column:  FEE_VARIABLE2
Java Field:  feeVariable2
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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.
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.
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).
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
Added On:  03/16/12
SQL Column:  FEE_FREQUENCY_CL
Java Field:  feeFrequencyCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Enumerates possible frequencies that can be used to apply merchant fees.
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.
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.
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.
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.
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.
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.
Added On:  03/16/12
SQL Column:  REMITTANCE_SOURCE_CL
Java Field:  remittanceSourceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Enumeration of possible banking accounts the money for specific line item is taken from. See Remittance source.
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.
Added On:  01/21/13
SQL Column:  SUBMISSION_CL
Java Field:  submissionCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Enumeration of possible submission types for the given detail (indicates, which submission type the detail belongs to).
Added On:  01/21/13
SQL Column:  TRANSACTION_CL
Java Field:  transactionCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Enumeration of possible types of transaction, that the fee detail deals with.
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.
Added On:  01/27/13
SQL Column:  STEREOTYPE
Java Field:  stereotype
Status:  Active
SQL Type:  varchar(60)
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.
Added On:  10/02/13
SQL Column:  DELAY_PERIOD
Java Field:  delayPeriod
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  10/02/13
SQL Column:  CHARGE_DATE
Java Field:  chargeDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/29/15
SQL Column:  FEE_FUNDING_POLICY_CL
Java Field:  feeFundingPolicyCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  08/31/16
SQL Column:  STATEMENT_DETAIL_GROUP_FK
Java Field:  statementDetailGroup
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents statement detail group information.
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.
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.