Account Update Transaction UML

Added On: 02/13/12

SQL Table: ACCOUNT_UPDATE_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: AccountUpdateTransaction

Entity that represents account update transaction information.

Available Fields:

Account Update Subscription Transaction FK
Action CL
Bank Info FK
Billing Profile Type
Charge Transaction FK
Create Date
Customer Account Code
Customer Account Internal Code
Id
Merchant Account Code
Original Account CL

Original Bank Info Code
Original BIN Encoded
Original Card Exp Date
Original Card Number
Original Card Number Last4
Original Card Number Masked
Original Token Code
Request Type
Response Code
Response Date
Response Message

Token
Transaction Code
Transaction Internal Code
Updated Account CL
Updated Bank Info Code
Updated BIN Encoded
Updated Card Exp Date
Updated Card Number
Updated Card Number Last4
Updated Token
Updated Token Code

Account Update Subscription Transaction FK

Added On: 09/16/15

SQL Column: ACCOUNT_UPDATE_SUBSCRIPTION_TRANSACTION_FK

Java Field: accountUpdateSubscriptionTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Account Update Subscription Transaction

Attributes:

Reference to the entity that represents account update subscription transaction.

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 actions.

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.

Billing Profile Type

Added On: 12/26/14

SQL Column: BILLING_PROFILE_TYPE

Java Field: billingProfileType

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Type of the billing profile of the customer.

Charge Transaction FK

Added On: 06/06/16

SQL Column: CHARGE_TRANSACTION_FK

Java Field: chargeTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Charge Transaction

Attributes:

Reference to the entity that represents real-time financial transaction.

Create Date

Added On: 12/28/12

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/25/15

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Account code associated with the customer within the system.

Customer Account Internal Code

Added On: 09/25/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.

Added On: 02/13/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required

Identifier of the object used for references; auto-incremented integer value.

Merchant Account Code

Added On: 02/13/12

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.

Original Account CL

Added On: 02/13/12

SQL Column: ORIGINAL_ACCOUNT_CL

Java Field: originalAccountCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Account Classifier

Attributes:

Represents the type of account based on the application usage.

Original Bank Info Code

Added On: 02/13/12

SQL Column: ORIGINAL_BANK_INFO_CODE

Java Field: originalBankInfoCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Original bank info code.

Original BIN Encoded

Added On: 02/13/12

SQL Column: ORIGINAL_BIN_ENCODED

Java Field: originalBinEncoded

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes: Encoded

Original encoded BIN.

Original Card Exp Date

Added On: 02/13/12

SQL Column: ORIGINAL_CARD_EXP_DATE

Java Field: originalCardExpDate

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Actual expiration date of the card.

Original Card Number

Added On: 02/13/12

SQL Column: ORIGINAL_CARD_NUMBER

Java Field: originalCardNumber

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Credit card number.

Original Card Number Last4

Added On: 02/13/12

SQL Column: ORIGINAL_CARD_NUMBER_LAST4

Java Field: originalCardNumberLast4

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Last 4 digits of the actual account number.

Original Card Number Masked

Added On: 11/14/14

SQL Column: ORIGINAL_CARD_NUMBER_MASKED

Java Field: originalCardNumberMasked

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

For credit card transaction, the value is card’s account number (MMYY); for ACH/eCheck transaction, the value is bank account’s number. Shows only first digit of the card number and last three or four digits.

Original Token Code

Added On: 02/13/12

SQL Column: ORIGINAL_TOKEN_CODE

Java Field: originalTokenCode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Token value replacing account number.

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: 02/13/12

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Gateway generated response code.

Response Date

Added On: 06/11/15

SQL Column: RESPONSE_DATE

Java Field: responseDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of the response.

Response Message

Added On: 02/13/12

SQL Column: RESPONSE_MESSAGE

Java Field: responseMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Gateway generated response message.

Token

Added On: 10/23/15

SQL Column: TOKEN

Java Field: token

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Token value replacing account number.

Transaction Code

Added On: 02/13/12

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Value identifying this transaction in submitter’s system.

Transaction Internal Code

Added On: 09/25/15

SQL Column: TRANSACTION_INTERNAL_CODE

Java Field: transactionInternalCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Internal code of the transaction.

Updated Account CL

Added On: 02/13/12

SQL Column: UPDATED_ACCOUNT_CL

Java Field: updatedAccountCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Account Classifier

Attributes:

Represents the type of updated account.

Updated Bank Info Code

Added On: 02/13/12

SQL Column: UPDATED_BANK_INFO_CODE

Java Field: updatedBankInfoCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Updated bank info code.

Updated BIN Encoded

Added On: 02/13/12

SQL Column: UPDATED_BIN_ENCODED

Java Field: updatedBinEncoded

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes: Encoded

Updated encoded BIN.

Updated Card Exp Date

Added On: 02/13/12

SQL Column: UPDATED_CARD_EXP_DATE

Java Field: updatedCardExpDate

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Updated expiration date or routing number - if provided by account updater / Fed Reserve.

Updated Card Number

Added On: 02/13/12

SQL Column: UPDATED_CARD_NUMBER

Java Field: updatedCardNumber

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Updated account number - if provided by account updater.

Updated Card Number Last4

Added On: 02/13/12

SQL Column: UPDATED_CARD_NUMBER_LAST4

Java Field: updatedCardNumberLast4

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Last four digits of the updated card number.

Updated Token

Added On: 11/03/16

SQL Column: UPDATED_TOKEN

Java Field: updatedToken

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

New token value that is used for replacing account number.

Updated Token Code

Added On: 02/13/12

SQL Column: UPDATED_TOKEN_CODE

Java Field: updatedTokenCode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Updated token generated due to account information change provided by account updater or Fed Reserve.