Master Reseller Statement UML

Added On: 04/03/17

SQL Table: IAPP_MASTER_RESELLER_STATEMENT

Module: UniCore

Type: Entity Status: Active

Java Class: MasterResellerStatement

Entity that represents information included in master reseller statement.

Available Fields:

Adjusted Amount
Amount
Approver Code
Basis CL
Create Date
Deposit Date
Due Date
Email Sent Date

End Date
Id
Merchant Account Code
Merchant Fee MIN Amount
Merchant Fee Policy
Note
Remitter Code
Reseller Deposit Date

Reseller FK
Start Date
Status CL
Total Adjustment Total Amount
Total Facilitator Processing Cost Amount
Total Flat Fee Total Amount
Total Processing Cost Total Amount
Total Processing Fee Total Amount

Total Recurring Fee Total Amount
Transaction Code

Adjusted Amount

Added On: 04/03/17

SQL Column: ADJUSTED_AMOUNT

Java Field: adjustedAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount represented in the master reseller statement after the applied adjustment.

Amount

Added On: 04/03/17

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount represented in the master reseller statement.

Approver Code

Added On: 04/03/17

SQL Column: APPROVER_CODE

Java Field: approverCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the user that approved the master reseller statement.

Basis CL

Added On: 04/03/17

SQL Column: BASIS_CL

Java Field: basisCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Merchant Fee Basis Classifier

Attributes:

Reference to the entity that represents possible ways of calculation of the merchant fee minimum amount.

Create Date

Added On: 04/03/17

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the master reseller statement was created.

Deposit Date

Added On: 08/29/17

SQL Column: DEPOSIT_DATE

Java Field: depositDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when transactions were deposited.

Due Date

Added On: 04/03/17

SQL Column: DUE_DATE

Java Field: dueDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the reseller statement calculation occurred.

Email Sent Date

Added On: 04/03/17

SQL Column: EMAIL_SENT_DATE

Java Field: emailSentDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the master reseller statement was sent via email.

End Date

Added On: 08/29/17

SQL Column: END_DATE

Java Field: endDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Added On: 04/03/17

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required

Identifier of the object used for references; auto-incremented integer value.

Merchant Account Code

Added On: 04/03/17

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Code of Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.

The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.

Merchant Fee MIN Amount

Added On: 04/03/17

SQL Column: MERCHANT_FEE_MIN_AMOUNT

Java Field: merchantFeeMinAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Minimum amount set for the merchant fee applied to the reseller's merchants.

Merchant Fee Policy

Added On: 04/03/17

SQL Column: MERCHANT_FEE_POLICY

Java Field: merchantFeePolicy

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes: Default:---

Defines to which type of fee minimun fee amount for merchant of the reseller is applied. Values can be the following: P - processing fee, F - flat fee, R - recurring fee.

Note

Added On: 04/03/17

SQL Column: NOTE

Java Field: note

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Any additional information about the statement.

Remitter Code

Added On: 04/03/17

SQL Column: REMITTER_CODE

Java Field: remitterCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the remitter associated with the master reseller statement.

Reseller Deposit Date

Added On: 11/23/17

SQL Column: RESELLER_DEPOSIT_DATE

Java Field: resellerDepositDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Reseller FK

Added On: 04/03/17

SQL Column: RESELLER_FK

Java Field: reseller

Status: Active

SQL Type: int(11)

Java Type: Integer

References Reseller

Attributes:

Reference to the entity that represents information about the reseller that the master statement is associated with.

Start Date

Added On: 09/01/17

SQL Column: START_DATE

Java Field: startDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Status CL

Added On: 04/03/17

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Statement Status Classifier

Attributes:

Reference to the entity that enumerates possible statuses of the master reseller statement.

Total Adjustment Total Amount

Added On: 06/28/17

SQL Column: TOTAL_ADJUSTMENT_TOTAL_AMOUNT

Java Field: totalAdjustmentTotalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of the adjustments in a master reseller statement.

Total Facilitator Processing Cost Amount

Added On: 03/02/18

SQL Column: TOTAL_FACILITATOR_PROCESSING_COST_AMOUNT

Java Field: totalFacilitatorProcessingCostAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total Flat Fee Total Amount

Added On: 04/03/17

SQL Column: TOTAL_FLAT_FEE_TOTAL_AMOUNT

Java Field: totalFlatFeeTotalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of flat fee shown on the master reseller statement.

Total Processing Cost Total Amount

Added On: 04/03/17

SQL Column: TOTAL_PROCESSING_COST_TOTAL_AMOUNT

Java Field: totalProcessingCostTotalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of processing cost shown on the master reseller statement.

Total Processing Fee Total Amount

Added On: 04/03/17

SQL Column: TOTAL_PROCESSING_FEE_TOTAL_AMOUNT

Java Field: totalProcessingFeeTotalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of processing fee shown on the master reseller statement.

Total Recurring Fee Total Amount

Added On: 04/03/17

SQL Column: TOTAL_RECURRING_FEE_TOTAL_AMOUNT

Java Field: totalRecurringFeeTotalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of recurring fee shown on the master reseller statement.

Transaction Code

Added On: 04/03/17

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the remittance transaction; generated automatically by the gateway.