Asset Transaction UML


Parent:    Account Transaction
Added On:  03/16/12 
SQL Table:  ASSET_TRANSACTION 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  AssetTransaction 
Added On:  03/16/12
SQL Column:  MASKED_ACCOUNT_NUMBER
Java Field:  maskedAccountNumber
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Masked account number of the sutomer.
Added On:  03/16/12
SQL Column:  MASKED_ACCESSORY
Java Field:  maskedAccessory
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Masked expiration date of the credit card or routing number of the bank account.
Added On:  03/16/12
SQL Column:  TRANSACTION_CL
Java Field:  transactionCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Enumeration of possible asset transaction processing modes available in the system.
Added On:  03/16/12
SQL Column:  IS_PREPAYMENT
Java Field:  isPrepayment
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the transaction is prepayed.
Added On:  03/16/12
SQL Column:  IS_CAPTURED
Java Field:  isCaptured
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Indicates whether the transaction is captured.
Added On:  03/16/12
SQL Column:  PREVIOUS_PAYMENT_DATE
Java Field:  previousPaymentDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the previous payment.
Added On:  03/16/12
SQL Column:  AGGREGATION_INFO
Java Field:  aggregationInfo
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes:
Transaction aggregation information.
Added On:  03/16/12
SQL Column:  FEE_CLAIM_AMOUNT
Java Field:  feeClaimAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  INVOICE_CLAIM_AMOUNT
Java Field:  invoiceClaimAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  RETURN_CLAIM_AMOUNT
Java Field:  returnClaimAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  TRANSACTION_SOURCE_CL
Java Field:  transactionSourceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Enumeration of possible sources of the transaction.
Added On:  03/16/12
SQL Column:  IS_ACCOUNT_DELINQUENT
Java Field:  isAccountDelinquent
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Added On:  03/16/12
SQL Column:  PROCESSED_DATE
Java Field:  processedDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the transaction was processed.
Added On:  03/16/12
SQL Column:  ATTEMPT_COUNT
Java Field:  attemptCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Number of attempts.
Added On:  03/16/12
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Gateway generated response code.
Added On:  03/16/12
SQL Column:  RESPONSE_DATE
Java Field:  responseDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the gateway response.
Added On:  03/16/12
SQL Column:  CAPTURE_INFO_FK
Java Field:  captureInfo
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Capture Info
Attributes:
Reference to the entity that represents capture information.
Added On:  03/16/12
SQL Column:  CHARGEBACK_TRANSACTION_FK
Java Field:  chargebackTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Asset Transaction
Attributes:
Reference to a chargeback transaction representing either initial chargeback (for credit cards) or ACH return (for bank accounts). If not chargeback/return came in, the field is not set. The field is primarily used to quickly identify transactions that have chargebacks/returns.
Added On:  10/09/12
SQL Column:  CHECK_NUMBER
Java Field:  checkNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Number of the customer's check.
Added On:  02/11/13
SQL Column:  FEE_AMOUNT
Java Field:  feeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of the fee included in the transaction.
Added On:  06/20/14
SQL Column:  IS_DRAFT_RETURN
Java Field:  isDraftReturn
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Added On:  01/06/15
SQL Column:  ALLOCATION_DETAIL
Java Field:  allocationDetail
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  08/27/15
SQL Column:  
Java Field:  isRefund
Status:  Active
SQL Type:  
Java Type:  Boolean
Attributes: Transient, Default: false