Merchant Balance History UML

Added On: 10/02/12

SQL Table: IAPP_MERCHANT_BALANCE_HISTORY

Module: UniCore

Type: Entity Status: Active

Java Class: MerchantBalanceHistory

Represents available funds and transaction history of the merchant.

Available Fields:

Amount
Create Date
Funds Source CL

Id
Merchant Account Code
Merchant Account Group FK

Merchant Statement FK
Source Balance
Total Balance

Amount

Added On: 10/02/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.

Create Date

Added On: 10/02/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Funds Source CL

Added On: 10/02/12

SQL Column: FUNDS_SOURCE_CL

Java Field: fundsSourceCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Funds Source Classifier

Attributes:

Represents the type of funds source selected.

Added On: 10/02/12

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.

Merchant Account Code

Added On: 10/02/12

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.

Merchant Account Group FK

Added On: 10/02/12

SQL Column: MERCHANT_ACCOUNT_GROUP_FK

Java Field: merchantAccountGroup

Status: Active

SQL Type: bigint(20)

Java Type:

References Merchant Account Group

Attributes:

Reference to the entity that represents merchant account group information.

Merchant Statement FK

Added On: 10/02/12

SQL Column: MERCHANT_STATEMENT_FK

Java Field: merchantStatement

Status: Active

SQL Type: bigint(20)

Java Type:

References Statement

Attributes:

Reference to the entity that represents merchant statement information.

Source Balance

Added On: 01/21/13

SQL Column: SOURCE_BALANCE

Java Field: sourceBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Source balance of the merchant.

Total Balance

Added On: 01/21/13

SQL Column: TOTAL_BALANCE

Java Field: totalBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total balance of the merchant.