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.
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.
Added On:  11/07/17
SQL Column:  ADJUSTMENT_TOTAL_AMOUNT
Java Field:  adjustmentTotalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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.
Added On:  02/26/21
SQL Column:  APPROVAL_DATE
Java Field:  approvalDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
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.
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.
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.
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.
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.
Added On:  03/02/18
SQL Column:  FACILITATOR_PROCESSING_COST_AMOUNT
Java Field:  facilitatorProcessingCostAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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.
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.
Added On:  08/08/17
SQL Column:  MERCHANT_ACCOUNT_GROUP_FK
Java Field:  merchantAccountGroup
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Merchant Account Group reference
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.
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.
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.
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.
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.
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.
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.
Added On:  11/07/17
SQL Column:  RESELLER_FLAT_FEE_AMOUNT
Java Field:  resellerFlatFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/07/17
SQL Column:  RESELLER_PROCESSING_FEE_AMOUNT
Java Field:  resellerProcessingFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/07/17
SQL Column:  RESELLER_RECURRING_FEE_AMOUNT
Java Field:  resellerRecurringFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  08/31/16
SQL Column:  RESELLER_STATEMENT_DETAIL_FK
Java Field:  resellerStatementDetails
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents reseller commission details information.
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.
Added On:  03/16/12
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents current status of the reseller statement.
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.