Account Update Subscription Transaction UML

Added On: 09/16/15

SQL Table: ACCOUNT_UPDATE_SUBSCRIPTION_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: AccountUpdateSubscriptionTransaction

Entity that represents information included in account update subscription.

Available Fields:

Account Accessory
Account Accessory Updated
Account Number
Account Number Masked
Account Number Update Masked
Account Number Updated
Action CL
Bank Info FK

Create Date
Customer Account Code
Customer Account Internal Code
Data Hash
Duplicate Code
Id
Last Update Date
Merchant Account Code

Request Type
Response Code
Response Message
Status CL
Token
Token Code
Token Code Updated
Token Updated

Transaction Code
Transaction Internal Code

Account Accessory

Added On: 09/16/15

SQL Column: ACCOUNT_ACCESSORY

Java Field: accountAccessory

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

When transaction is associated with a credit card, the field contains card's expiration date. When transaction is associated with a bank account, the field contains account's routing number.

Account Accessory Updated

Added On: 09/16/15

SQL Column: ACCOUNT_ACCESSORY_UPDATED

Java Field: accountAccessoryUpdated

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Updated accessory (expiration date or routing number) for the payment option (credit card or bank account) used in this transaction. Updated information for credit cards comes from credit card account updater (a service provided by most Providers). Updated information for bank accounts comes from the Federal Reserve as notices within ACH returns.

Account Number

Added On: 09/16/15

SQL Column: ACCOUNT_NUMBER

Java Field: accountNumber

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Bank or account number of the customer.

Account Number Masked

Added On: 09/16/15

SQL Column: ACCOUNT_NUMBER_MASKED

Java Field: accountNumberMasked

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Masked account or bank number of the customer.

Account Number Update Masked

Added On: 09/16/15

SQL Column: ACCOUNT_NUMBER_UPDATE_MASKED

Java Field: accountNumberUpdateMasked

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Masked account number of the merchant.

Account Number Updated

Added On: 09/16/15

SQL Column: ACCOUNT_NUMBER_UPDATED

Java Field: accountNumberUpdated

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Updated account or bank number of the customer.

Action CL

Added On: 09/16/15

SQL Column: ACTION_CL

Java Field: actionCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Account Update Action Classifier

Attributes:

Represents the selected type of account update action.

Bank Info FK

Added On: 10/20/16

SQL Column: BANK_INFO_FK

Java Field: bankInfo

Status: Active

SQL Type: int(11)

Java Type: Integer

References Bank Info

Attributes:

Reference to the entity that represents information about the issuing bank.

Create Date

Added On: 09/16/15

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Customer Account Code

Added On: 09/16/15

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Account code of the custome in the system.

Customer Account Internal Code

Added On: 09/16/15

SQL Column: CUSTOMER_ACCOUNT_INTERNAL_CODE

Java Field: customerAccountInternalCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Internal code of the customer account within the system.

Data Hash

Added On: 09/24/15

SQL Column: DATA_HASH

Java Field: dataHash

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Hash assigned to Merchant Account Code, Customer Account Code.

Duplicate Code

Added On: 10/27/15

SQL Column: DUPLICATE_CODE

Java Field: duplicateCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Identifier of the transaction.

Added On: 09/16/15

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.

Last Update Date

Added On: 09/16/15

SQL Column: LAST_UPDATE_DATE

Java Field: lastUpdateDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

The date when the account was updated the last time.

Merchant Account Code

Added On: 09/16/15

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.

Request Type

Added On: 10/22/15

SQL Column: REQUEST_TYPE

Java Field: requestType

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Transient, Default:account-update

Type of the request.

Response Code

Added On: 09/16/15

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Gateway generated response code.

Response Message

Added On: 09/16/15

SQL Column: RESPONSE_MESSAGE

Java Field: responseMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Gateway generated response message.

Status CL

Added On: 09/16/15

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Transaction Status Classifier

Attributes:

Represents current status of the transaction.

Token

Added On: 09/16/15

SQL Column: TOKEN

Java Field: token

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Token value replacing account number.

Token Code

Added On: 09/16/15

SQL Column: TOKEN_CODE

Java Field: tokenCode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Token generated for the provided payment information. Always present when tokenization service is enabled.

Token Code Updated

Added On: 09/16/15

SQL Column: TOKEN_CODE_UPDATED

Java Field: tokenCodeUpdated

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Updated token, generated for the provided payment information. Always present when tokenization service is enabled.

Token Updated

Added On: 09/16/15

SQL Column: TOKEN_UPDATED

Java Field: tokenUpdated

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Updated token code.

Transaction Code

Added On: 09/16/15

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the initial transaction in the system.

Transaction Internal Code

Added On: 09/16/15

SQL Column: TRANSACTION_INTERNAL_CODE

Java Field: transactionInternalCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Internal code of the transaction within the system.