Account Transaction UML

Parent: Account Activity

Children: Asset Transaction Revenue Transaction

Added On: 03/16/12

SQL Table: ACCOUNT_TRANSACTION

Module: UniBill

Type: Entity Status: Active

Java Class: AccountTransaction

Available Fields:

Adjustment Transaction FK
Amount
Balance
Balancing Group
Client Host
Due Date
Fee Amount
Franchise Fee Code

Historical Balance
Invoice List
Is Collections Transaction
Is Visible Externally
Late Fee
Note
Payment Plan FK
Post Customer Account Age

Poster Code
Pre Customer Account Age
Ref Creator Code
Ref Seller Code
Ref Shift Code
Ref Terminal Code
Return Fee
Tax Amount

Transaction Origin Code

Adjustment Transaction FK

Added On: 03/16/12

SQL Column: ADJUSTMENT_TRANSACTION_FK

Java Field: adjustmentTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Account Transaction

Attributes:

Reference to the entity that represents account transaction.

Amount

Added On: 03/16/12

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the transaction in cents (without a decimal point).

Balance

Added On: 03/16/12

SQL Column: BALANCE

Java Field: balance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Remaining balance of the transaction.

Balancing Group

Added On: 03/16/12

SQL Column: BALANCING_GROUP

Java Field: balancingGroup

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Balance group the transaction belongs to.

Client Host

Added On: 10/07/14

SQL Column: CLIENT_HOST

Java Field: clientHost

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Host address of the client.

Due Date

Added On: 03/16/12

SQL Column: DUE_DATE

Java Field: dueDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the transaction becomes effective.

Fee Amount

Added On: 05/13/23

SQL Column: FEE_AMOUNT

Java Field: feeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Franchise Fee Code

Added On: 05/13/23

SQL Column: FRANCHISE_FEE_CODE

Java Field: franchiseFeeCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Historical Balance

Added On: 03/16/12

SQL Column: HISTORICAL_BALANCE

Java Field: historicalBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Outstanding balance resulting historically from this transaction.

Invoice List

Added On: 03/04/24

SQL Column: INVOICE_LIST

Java Field: invoiceList

Status: Active

SQL Type: varchar(250)

Java Type: String

Attributes:

Pattern:

List of invoice references that are expected to be covered by this transaction.

Is Collections Transaction

Added On: 03/16/12

SQL Column: IS_COLLECTIONS_TRANSACTION

Java Field: isCollectionsTransaction

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the transaction is included in collections.

Is Visible Externally

Added On: 03/16/12

SQL Column: IS_VISIBLE_EXTERNALLY

Java Field: isVisibleExternally

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Indicates whether the transaction is visible on external sources.

Late Fee

Added On: 03/16/12

SQL Column: LATE_FEE

Java Field: lateFee

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the late fee.

Note

Added On: 03/16/12

SQL Column: NOTE

Java Field: note

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Description of the transaction.

Payment Plan FK

Added On: 03/16/12

SQL Column: PAYMENT_PLAN_FK

Java Field: paymentPlan

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Payment Plan

Attributes:

Reference to the entity that represents payment plan of the account.

Post Customer Account Age

Added On: 03/16/12

SQL Column: POST_CUSTOMER_ACCOUNT_AGE

Java Field: postCustomerAccountAge

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Poster Code

Added On: 03/16/12

SQL Column: POSTER_CODE

Java Field: posterCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the person that posted the transaction.

Pre Customer Account Age

Added On: 03/16/12

SQL Column: PRE_CUSTOMER_ACCOUNT_AGE

Java Field: preCustomerAccountAge

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Ref Creator Code

Added On: 03/16/12

SQL Column: REF_CREATOR_CODE

Java Field: refCreatorCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the user that created the account transaction.

Ref Seller Code

Added On: 03/16/12

SQL Column: REF_SELLER_CODE

Java Field: refSellerCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the seller assigned to the transaction.

Ref Shift Code

Added On: 03/16/12

SQL Column: REF_SHIFT_CODE

Java Field: refShiftCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Ref Terminal Code

Added On: 03/16/12

SQL Column: REF_TERMINAL_CODE

Java Field: refTerminalCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the terminal that processes the transaction.

Return Fee

Added On: 03/16/12

SQL Column: RETURN_FEE

Java Field: returnFee

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the return fee.

Tax Amount

Added On: 03/16/12

SQL Column: TAX_AMOUNT

Java Field: taxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the tax for the transaction.

Transaction Origin Code

Added On: 10/10/14

SQL Column: TRANSACTION_ORIGIN_CODE

Java Field: transactionOriginCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Origin code of the transaction.