Asset Transaction UML

Parent: Account Transaction

Added On: 03/16/12

SQL Table: ASSET_TRANSACTION

Module: UniBill

Type: Entity Status: Active

Java Class: AssetTransaction

Available Fields:

Aggregation Info
Allocation Detail
Attempt Count
Capture Info FK
Chargeback Transaction FK
Check Number
Fee Amount

Fee Claim Amount
Invoice Claim Amount
Is Account Delinquent
Is Captured
Is Draft Return
Is Prepayment
Is Refund

Masked Accessory
Masked Account Number
Previous Payment Date
Processed Date
Response Code
Response Date
Return Claim Amount

Transaction CL
Transaction Source CL

Aggregation Info

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.

Allocation Detail

Added On: 01/06/15

SQL Column: ALLOCATION_DETAIL

Java Field: allocationDetail

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Attempt Count

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.

Capture Info FK

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.

Chargeback Transaction FK

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.

Check Number

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.

Fee Amount

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.

Fee Claim Amount

Added On: 03/16/12

SQL Column: FEE_CLAIM_AMOUNT

Java Field: feeClaimAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Invoice Claim Amount

Added On: 03/16/12

SQL Column: INVOICE_CLAIM_AMOUNT

Java Field: invoiceClaimAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Is Account Delinquent

Added On: 03/16/12

SQL Column: IS_ACCOUNT_DELINQUENT

Java Field: isAccountDelinquent

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Captured

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.

Is Draft Return

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

Is Prepayment

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.

Is Refund

Added On: 08/27/15

SQL Column:

Java Field: isRefund

Status: Active

SQL Type:

Java Type: Boolean

Attributes: Transient, Default:false

Masked Accessory

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.

Masked Account Number

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.

Previous Payment Date

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.

Processed Date

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.

Response Code

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.

Response Date

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.

Return Claim Amount

Added On: 03/16/12

SQL Column: RETURN_CLAIM_AMOUNT

Java Field: returnClaimAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction CL

Added On: 03/16/12

SQL Column: TRANSACTION_CL

Java Field: transactionCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Asset Transaction Classifier

Attributes:

Enumeration of possible asset transaction processing modes available in the system.

Transaction Source CL

Added On: 03/16/12

SQL Column: TRANSACTION_SOURCE_CL

Java Field: transactionSourceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Transaction Source Classifier

Attributes:

Enumeration of possible sources of the transaction.