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 
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).
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.
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.
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.
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.
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.
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.
Added On:  03/16/12
SQL Column:  REF_SHIFT_CODE
Java Field:  refShiftCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
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.
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.
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.
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.
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.
Added On:  03/16/12
SQL Column:  PRE_CUSTOMER_ACCOUNT_AGE
Java Field:  preCustomerAccountAge
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  POST_CUSTOMER_ACCOUNT_AGE
Java Field:  postCustomerAccountAge
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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.
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.
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.
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.
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.
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.
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.
Added On:  09/15/16
SQL Column:  SOURCE_BALANCING_SUMMARY_FK
Java Field:  sourceBalancingSummaries
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Balancing Summary
Attributes:
Reference to the entity that represents balancing summary, including the source.
Added On:  09/22/16
SQL Column:  BALANCING_SUMMARIES
Java Field:  balancingSummaries
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Balancing Summary
Attributes:
Reference to the entity that represents balancing summary.