Client Transaction UML

Added On: 02/11/13

SQL Table: CLIENT_TRANSACTION

Module: UniBill

Type: Entity Status: Active

Java Class: ClientTransaction

Available Fields:

Account Transaction FK
Agent Payout Amount
Agent Payout Rate
Agent Statement Code
Client Fee Code
Client Payout Amount
Client Payout Rate
Client Statement Code
Collected Amount
Commissionable Amount

Company Statement Code
Create Date
Customer Account FK
Id
Is Calculation Required
Is Visible Externally
Merchant Account Code
Net Amount
Notes
Original Transaction FK

Partner Code
Partner Payout Amount
Partner Payout Rate
Partner Statement Code
Payable Amount
Processing Fee Amount
Processing Fee Rate
Source CL
Transaction Amount
Transaction CL

Account Transaction FK

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.

Agent Payout Amount

Added On: 02/11/13

SQL Column: AGENT_PAYOUT_AMOUNT

Java Field: agentPayoutAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Agent Payout Rate

Added On: 02/11/13

SQL Column: AGENT_PAYOUT_RATE

Java Field: agentPayoutRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Agent Statement Code

Added On: 02/11/13

SQL Column: AGENT_STATEMENT_CODE

Java Field: agentStatementCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Client Fee Code

Added On: 02/11/13

SQL Column: CLIENT_FEE_CODE

Java Field: clientFeeCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Client Payout Amount

Added On: 02/11/13

SQL Column: CLIENT_PAYOUT_AMOUNT

Java Field: clientPayoutAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Client Payout Rate

Added On: 02/11/13

SQL Column: CLIENT_PAYOUT_RATE

Java Field: clientPayoutRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Client Statement Code

Added On: 02/11/13

SQL Column: CLIENT_STATEMENT_CODE

Java Field: clientStatementCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Collected Amount

Added On: 02/11/13

SQL Column: COLLECTED_AMOUNT

Java Field: collectedAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Commissionable Amount

Added On: 02/11/13

SQL Column: COMMISSIONABLE_AMOUNT

Java Field: commissionableAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Company Statement Code

Added On: 02/11/13

SQL Column: COMPANY_STATEMENT_CODE

Java Field: companyStatementCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Create Date

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

Customer Account FK

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: 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.

Is Calculation Required

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

Is Visible Externally

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

Merchant Account Code

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.

Net Amount

Added On: 02/11/13

SQL Column: NET_AMOUNT

Java Field: netAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Notes

Added On: 02/11/13

SQL Column: NOTES

Java Field: notes

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Original Transaction FK

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:

Partner Code

Added On: 02/11/13

SQL Column: PARTNER_CODE

Java Field: partnerCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Partner Payout Amount

Added On: 02/11/13

SQL Column: PARTNER_PAYOUT_AMOUNT

Java Field: partnerPayoutAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Partner Payout Rate

Added On: 02/11/13

SQL Column: PARTNER_PAYOUT_RATE

Java Field: partnerPayoutRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Partner Statement Code

Added On: 02/11/13

SQL Column: PARTNER_STATEMENT_CODE

Java Field: partnerStatementCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Payable Amount

Added On: 02/11/13

SQL Column: PAYABLE_AMOUNT

Java Field: payableAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Processing Fee Amount

Added On: 02/11/13

SQL Column: PROCESSING_FEE_AMOUNT

Java Field: processingFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Processing Fee Rate

Added On: 02/11/13

SQL Column: PROCESSING_FEE_RATE

Java Field: processingFeeRate

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Source CL

Added On: 02/11/13

SQL Column: SOURCE_CL

Java Field: sourceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Transaction Source Classifier

Attributes:

Transaction Amount

Added On: 02/11/13

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction CL

Added On: 02/11/13

SQL Column: TRANSACTION_CL

Java Field: transactionCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Client Transaction Classifier

Attributes:

Enumeration of possible transaction processing modes available in the system.