Agent Commission UML


Added On:  03/16/12 
SQL Table:  AGENT_COMMISSION 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  AgentCommission 
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:  REF_CODE
Java Field:  refCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
See Reference Code definition for additional information.
Added On:  03/16/12
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created
Added On:  03/16/12
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:  03/16/12
SQL Column:  COLLECTOR_ACCOUNT_CODE
Java Field:  collectorAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The account code of the collector.
Added On:  03/16/12
SQL Column:  CREATOR_CODE
Java Field:  creatorCode
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/16/12
SQL Column:  AGENT_CODE
Java Field:  agentCode
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/16/12
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.
Added On:  03/16/12
SQL Column:  COMMISSION_CL
Java Field:  commissionCl
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/16/12
SQL Column:  NOTE
Java Field:  note
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/16/12
SQL Column:  PAYMENT_OPTION_FK
Java Field:  paymentOption
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Payment Option
Attributes:
Added On:  03/16/12
SQL Column:  CUSTOMER_ACCOUNT_FK
Java Field:  customerAccount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Customer Account
Attributes:
Added On:  03/16/12
SQL Column:  TARGET_FK
Java Field:  target
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Asset Transaction
Attributes:
Added On:  03/16/12
SQL Column:  SOURCE_FK
Java Field:  source
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Revenue Transaction
Attributes:
Added On:  03/16/12
SQL Column:  ADJUSTMENT_AGENT_COMMISSION_FK
Java Field:  adjustmentAgentCommission
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Agent Commission
Attributes:
Reference to the entity that represents adjustment agent comission information.