Account Update Transaction UML


Added On:  02/13/12 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  AccountUpdateTransaction 
Entity that represents account update transaction information.
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, CreateOnly
Identifier of the object used for references; auto-incremented integer value.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Added On:  09/16/15
SQL Column:  ACTION_CL
Java Field:  actionCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the selected type of account update actions.
Added On:  09/16/15
SQL Column:  ACCOUNT_UPDATE_SUBSCRIPTION_TRANSACTION_FK
Java Field:  accountUpdateSubscriptionTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents account update subscription transaction.
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.
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:  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.
Added On:  10/22/15
SQL Column:  
Java Field:  requestType
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Type of the request.
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.
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.
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.
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.