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

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.