Merchant Statement Extended Fee Detail

Added On:  11/07/18 

SQL Table:  MERCHANT_STATEMENT_EXTENDED_FEE_DETAIL 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  MerchantStatementExtendedFeeDetail 

Available Fields:

• Caption
• Id
• Merchant Account Code
• Per Item
• Percentage Rate P 4

• Position
• Remittance Source Cl
• Statement Code
• Stereotype
• Submission Cl

• Submission Code
• Tax Amount
• Total Amount
• Transaction Amount
• Transaction Count

Caption

Added On:  11/06/18

SQL Column:  CAPTION

Java Field:  caption

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Id

Added On:  11/06/18

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

Merchant Account Code

Added On:  11/06/18

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Per Item

Added On:  11/06/18

SQL Column:  PER_ITEM

Java Field:  perItem

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Percentage Rate P 4

Added On:  11/06/18

SQL Column:  PERCENTAGE_RATE_P4

Java Field:  percentageRateP4

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Position

Added On:  11/06/18

SQL Column:  POSITION

Java Field:  position

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Remittance Source Cl

Added On:  02/27/20

SQL Column:  REMITTANCE_SOURCE_CL

Java Field:  remittanceSourceCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Remittance Source Classifier

Attributes:

Statement Code

Added On:  11/06/18

SQL Column:  STATEMENT_CODE

Java Field:  statementCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Stereotype

Added On:  11/06/18

SQL Column:  STEREOTYPE

Java Field:  stereotype

Status:  Active

SQL Type:  varchar(70)

Java Type:  String

Attributes:

Submission Cl

Added On:  11/06/18

SQL Column:  SUBMISSION_CL

Java Field:  submissionCl

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

References Submission Classifier

Attributes:

Submission Code

Added On:  11/06/18

SQL Column:  SUBMISSION_CODE

Java Field:  submissionCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Tax Amount

Added On:  02/08/24

SQL Column:  TAX_AMOUNT

Java Field:  taxAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Amount (in cents) of the tax.

Total Amount

Added On:  11/06/18

SQL Column:  TOTAL_AMOUNT

Java Field:  totalAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Transaction Amount

Added On:  11/06/18

SQL Column:  TRANSACTION_AMOUNT

Java Field:  transactionAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Transaction Count

Added On:  11/06/18

SQL Column:  TRANSACTION_COUNT

Java Field:  transactionCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes: