Payout Statement UML


Added On:  02/11/13 
SQL Table:  IAPP_PAYOUT_STATEMENT 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  PayoutStatement 
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:
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:  BEGIN_DATE
Java Field:  beginDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Begin date of the period which this statistics record covers.
Added On:  02/11/13
SQL Column:  END_DATE
Java Field:  endDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  02/11/13
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:  02/11/13
SQL Column:  ADJUSTED_AMOUNT
Java Field:  adjustedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total amount on the statement after adjustments.
If adjusted amount is below the original amount, it means that:

1) the money has been withdrawn "manually", or
2) the balance in the previous statement was negative.

If adjusted amount is above the original one, it means that:

1) the money has been added manually, or
2) some former debt has been returned, or
3) the money from reserve has been returned.
Added On:  02/11/13
SQL Column:  REMITTED_AMOUNT
Java Field:  remittedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  BALANCE
Java Field:  balance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/11/13
SQL Column:  STATEMENT_CL
Java Field:  statementCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/11/13
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/11/13
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:  02/11/13
SQL Column:  REMITTER_CODE
Java Field:  remitterCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  02/11/13
SQL Column:  DEPOSIT_DATE
Java Field:  depositDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  02/11/13
SQL Column:  CLIENT_FEE_FK
Java Field:  clientFee
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Client Fee
Attributes:
Reference to the entity that represents client's fee information.
Added On:  02/11/13
SQL Column:  PARTNER_FK
Java Field:  partner
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References Reseller
Attributes:
Reference to the entity that represents information about the partner.
Added On:  02/11/13
SQL Column:  AGENT_FK
Java Field:  agent
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References User
Attributes:
Reference to the entity that represents information about agent.