Master Reseller Statement Detail UML


Added On:  04/03/17 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  MasterResellerStatementDetail 
Entity that represents detailed 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 that is shown on the master reseller statement.
Added On:  04/03/17
SQL Column:  ACTIVITY_DATE
Java Field:  activityDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the transactions were processed and subsequently included in the master reseller statement.
Added On:  04/03/17
SQL Column:  CREATOR_CODE
Java Field:  creatorCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Code of the master reseller statement creator that generated the statement. Default value is System.
Added On:  04/03/17
SQL Column:  DESCRIPTION
Java Field:  description
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Additional information shown on the master reseller statement.
Added On:  04/03/17
SQL Column:  IS_VISIBLE_EXTERNALLY
Java Field:  isVisibleExternally
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:true
Indicates whether certain information included in the master reseller statement should be visible when being printed.
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 master reseller statement.
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 master 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 master reseller 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 master reseller statement.
Added On:  04/03/17
SQL Column:  RESELLER_STATEMENT_FK
Java Field:  resellerStatement
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Reseller Statement
Attributes:
Reference to the entity that represents associated reseller statement.
Added On:  06/28/17
SQL Column:  ADJUSTMENT_TOTAL_AMOUNT
Java Field:  adjustmentTotalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total amount of the adjustments in a reseller statement.
Added On:  06/28/17
SQL Column:  MERCHANT_REQUIRED_AMOUNT
Java Field:  merchantRequiredAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Gateway fees minimum amount that should be collected from a merchant.
Added On:  06/28/17
SQL Column:  MERCHANT_COLLECTED_AMOUNT
Java Field:  merchantCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Gateway fees amount collected from a merchant. If the amount is less than minimum fee set for the merchant, the rest of the amount is eliminated from reseller commissions.
Added On:  06/26/17
SQL Column:  MERCHANT_REQUIRED_AMOUNT
Java Field:  merchantRequiredAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Gateway fees minimum amount that should be collected from a merchant.
Added On:  06/26/17
SQL Column:  MERCHANT_COLLECTED_AMOUNT
Java Field:  merchantCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Gateway fees amount collected from a merchant. If the amount is less than minimum fee set for the merchant, the rest of the amount is eliminated from reseller commissions.