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
• Buy Rate Variable2
• Caption
• Caption Var0
• Caption Var1
• Caption Var2
• Caption Var3
• Charge Date
• Commissionable Rate

• Delay Period
• Description
• Fee Frequency CL
• Fee Funding Policy CL
• Fee Schema Detail FK
• Fee Variable1
• Fee Variable2
• Formula
• GL Account FK

• Id
• Is Commissionable
• Is Submission Based
• Is Variable1 Percent
• Is Variable2 Percent
• Position
• Remittance Source CL
• Statement Detail Group FK
• Stereotype

• Submission CL
• Transaction CL

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.

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.

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).

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:

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.

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

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.

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.

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.

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.

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.

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.

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.

Delay Period

Added On:  10/02/13

SQL Column:  DELAY_PERIOD

Java Field:  delayPeriod

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Charge Date

Added On:  10/02/13

SQL Column:  CHARGE_DATE

Java Field:  chargeDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

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:

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.

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.

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.

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

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.