Client Transaction UML


Added On:  02/11/13 
SQL Table:  CLIENT_TRANSACTION 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  ClientTransaction 
Added On:  02/11/13
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  02/11/13
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:  02/11/13
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created
Added On:  02/11/13
SQL Column:  TRANSACTION_CL
Java Field:  transactionCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Enumeration of possible transaction processing modes available in the system.
Added On:  02/11/13
SQL Column:  SOURCE_CL
Java Field:  sourceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/11/13
SQL Column:  TRANSACTION_AMOUNT
Java Field:  transactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  PROCESSING_FEE_RATE
Java Field:  processingFeeRate
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  PROCESSING_FEE_AMOUNT
Java Field:  processingFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  PAYABLE_AMOUNT
Java Field:  payableAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  CLIENT_PAYOUT_RATE
Java Field:  clientPayoutRate
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  CLIENT_PAYOUT_AMOUNT
Java Field:  clientPayoutAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  COLLECTED_AMOUNT
Java Field:  collectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  PARTNER_PAYOUT_RATE
Java Field:  partnerPayoutRate
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  PARTNER_PAYOUT_AMOUNT
Java Field:  partnerPayoutAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  COMMISSIONABLE_AMOUNT
Java Field:  commissionableAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  AGENT_PAYOUT_RATE
Java Field:  agentPayoutRate
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  AGENT_PAYOUT_AMOUNT
Java Field:  agentPayoutAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  NET_AMOUNT
Java Field:  netAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  IS_VISIBLE_EXTERNALLY
Java Field:  isVisibleExternally
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: true
Added On:  02/11/13
SQL Column:  CLIENT_FEE_CODE
Java Field:  clientFeeCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  02/11/13
SQL Column:  CLIENT_STATEMENT_CODE
Java Field:  clientStatementCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  02/11/13
SQL Column:  PARTNER_STATEMENT_CODE
Java Field:  partnerStatementCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  02/11/13
SQL Column:  AGENT_STATEMENT_CODE
Java Field:  agentStatementCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  02/11/13
SQL Column:  COMPANY_STATEMENT_CODE
Java Field:  companyStatementCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  02/11/13
SQL Column:  PARTNER_CODE
Java Field:  partnerCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  NOTES
Java Field:  notes
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/11/13
SQL Column:  IS_CALCULATION_REQUIRED
Java Field:  isCalculationRequired
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Added On:  02/11/13
SQL Column:  ORIGINAL_TRANSACTION_FK
Java Field:  originalTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Client Transaction
Attributes:
Added On:  02/11/13
SQL Column:  CUSTOMER_ACCOUNT_FK
Java Field:  customerAccount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Customer Account
Attributes:
Added On:  02/11/13
SQL Column:  ACCOUNT_TRANSACTION_FK
Java Field:  accountTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Account Transaction
Attributes:
Reference to the entity that represents account transaction.