Reseller Statement UML

Added On: 03/16/12

SQL Table: IAPP_RESELLER_STATEMENT

Module: UniCore

Type: Entity Status: Active

Java Class: ResellerStatement

Reseller statement, compiled based on actual processing volumes and reseller fee details. It shows all the transactions processed for the given reseller during the specified time interval and all the fees deduced.

Available Fields:

Adjusted Amount
Adjustment Total Amount
Amount
Approval Date
Approver Code
Create Date
Due Date
Email Sent Date
End Date

Facilitator Processing Cost Amount
Flat Fee Total Amount
Id
Merchant Account Code
Merchant Account Group
Note
Processing Cost Total Amount
Processing Fee Total Amount
Recurring Fee Total Amount

Remitter Code
Reseller Commission FK
Reseller FK
Reseller Flat Fee Amount
Reseller Processing Fee Amount
Reseller Recurring Fee Amount
Reseller Statement Detail FK
Start Date
Status CL

Transaction Code

Adjusted Amount

Added On: 03/16/12

SQL Column: ADJUSTED_AMOUNT

Java Field: adjustedAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of the statement after adjustments.
If adjusted amount is below the original amount, it means that:
1) money has been withdrawn manually, or
2) balance in the previous statement was negative.
If adjusted amount is above the original one, it means that:
1) money has been added manually, or
2) some former debt has been returned, or
3) money from reserve has been returned.

Adjustment Total Amount

Added On: 11/07/17

SQL Column: ADJUSTMENT_TOTAL_AMOUNT

Java Field: adjustmentTotalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount

Added On: 03/16/12

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the statement.

Approval Date

Added On: 02/26/21

SQL Column: APPROVAL_DATE

Java Field: approvalDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Approver Code

Added On: 03/16/12

SQL Column: APPROVER_CODE

Java Field: approverCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

The user name (or code) of a person, who approved the statement.

Create Date

Added On: 03/16/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the reseller statement was created.

Due Date

Added On: 01/21/13

SQL Column: DUE_DATE

Java Field: dueDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Duration period of the statement.

Email Sent Date

Added On: 11/05/12

SQL Column: EMAIL_SENT_DATE

Java Field: emailSentDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

The date when the email notification was sent.

End Date

Added On: 03/16/12

SQL Column: END_DATE

Java Field: endDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date until which the submitted transactions should be included in the statement.

Facilitator Processing Cost Amount

Added On: 03/02/18

SQL Column: FACILITATOR_PROCESSING_COST_AMOUNT

Java Field: facilitatorProcessingCostAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Flat Fee Total Amount

Added On: 04/03/17

SQL Column: FLAT_FEE_TOTAL_AMOUNT

Java Field: flatFeeTotalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of flat fee shown on the reseller statement.

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.

Merchant Account Code

Added On: 03/16/12

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

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 Account Group

Added On: 08/08/17

SQL Column: MERCHANT_ACCOUNT_GROUP_FK

Java Field: merchantAccountGroup

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Merchant Account Group

Attributes:

Merchant Account Group reference

Note

Added On: 03/16/12

SQL Column: NOTE

Java Field: note

Status: Active

SQL Type: varchar(1024)

Java Type: String

Attributes:

Any additional information about the statement.

Processing Cost Total Amount

Added On: 04/03/17

SQL Column: PROCESSING_COST_TOTAL_AMOUNT

Java Field: processingCostTotalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of processing cost shown on the reseller statement.

Processing Fee Total Amount

Added On: 04/03/17

SQL Column: PROCESSING_FEE_TOTAL_AMOUNT

Java Field: processingFeeTotalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of processing fee shown on the reseller statement.

Recurring Fee Total Amount

Added On: 04/03/17

SQL Column: RECURRING_FEE_TOTAL_AMOUNT

Java Field: recurringFeeTotalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of recurring fee shown on the reseller statement.

Remitter Code

Added On: 03/16/12

SQL Column: REMITTER_CODE

Java Field: remitterCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

The user name (or code) of a person who remits the money under manual (non-automated) remittance.

Reseller Commission FK

Added On: 03/16/12

SQL Column: RESELLER_COMMISSION_FK

Java Field: resellerCommission

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Reseller Commission

Attributes:

Reference to the entity that represents the reseller comission information.

Reseller FK

Added On: 03/16/12

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.

Reseller Flat Fee Amount

Added On: 11/07/17

SQL Column: RESELLER_FLAT_FEE_AMOUNT

Java Field: resellerFlatFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Reseller Processing Fee Amount

Added On: 11/07/17

SQL Column: RESELLER_PROCESSING_FEE_AMOUNT

Java Field: resellerProcessingFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Reseller Recurring Fee Amount

Added On: 11/07/17

SQL Column: RESELLER_RECURRING_FEE_AMOUNT

Java Field: resellerRecurringFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Reseller Statement Detail FK

Added On: 08/31/16

SQL Column: RESELLER_STATEMENT_DETAIL_FK

Java Field: resellerStatementDetails

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Reseller Statement Detail

Attributes:

Reference to the entity that represents reseller commission details information.

Start Date

Added On: 03/16/12

SQL Column: START_DATE

Java Field: startDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date from which the submitted transactions should be included in the statement.

Status CL

Added On: 03/16/12

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Statement Status Classifier

Attributes:

Represents current status of the reseller statement.

Transaction Code

Added On: 03/16/12

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Code of the initial transaction.