Master Reseller Statement UML


Added On:  04/03/17 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  MasterResellerStatement 
Entity that represents information included in master reseller statement.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Added On:  04/03/17
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that enumerates possible statuses of the master reseller statement.
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.
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.
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.
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.
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.
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.
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.
Added On:  04/03/17
SQL Column:  BASIS_CL
Java Field:  basisCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents possible ways of calculation of the merchant fee minimum 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.
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.
Added On:  08/29/17
SQL Column:  END_DATE
Java Field:  endDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
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.
Added On:  04/03/17
SQL Column:  MASTER_RESELLER_STATEMENT_DETAILS
Java Field:  masterResellerStatementDetails
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents detailed information about this master reseller statement.
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:
Added On:  11/23/17
SQL Column:  RESELLER_DEPOSIT_DATE
Java Field:  resellerDepositDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  09/01/17
SQL Column:  START_DATE
Java Field:  startDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes: