Wells Fargo Account Verification Transaction UML

Added On: 02/10/21

SQL Table: WELLS_FARGO_ACCOUNT_VERIFICATION_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: WellsFargoAccountVerificationTransaction

Available Fields:

Added Or Closed Date
Additional Status Code
Amount
Api Key
Bank Account Number
Bank Routing Number
Charge Transaction
Client Reference
Client Request Id
Decision
Early Warning Secondary Id

Error Code
Error Description
Error Field Name
Fcra Dispute Code
Gateway Entity Id
Id
Last Return Date
Last Return Reason Code
Last Update Date
Merchant Account Code
Number Of Returns

Previous Status Code
Primary Status Code
Scored Account Reason Code 1
Scored Account Reason Code 2
Scored Account Reason Code 3
Scored Account Reason Code 4
Scored Account Reason Code 5
Secondary Status Code
Transaction Channel
Transaction Datetime
Validation Channel

Validation Type

Added Or Closed Date

Added On: 02/10/21

SQL Column: ADDED_OR_CLOSED_DATE

Java Field: addedOrClosedDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Additional Status Code

Added On: 02/10/21

SQL Column: ADDITIONAL_STATUS_CODE

Java Field: additionalStatusCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Amount

Added On: 09/03/21

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

Api Key

Added On: 02/10/21

SQL Column: API_KEY

Java Field: apiKey

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Transient

Bank Account Number

Added On: 02/10/21

SQL Column: BANK_ACCOUNT_NUMBER

Java Field: bankAccountNumber

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Transient

Bank Routing Number

Added On: 02/10/21

SQL Column: BANK_ROUTING_NUMBER

Java Field: bankRoutingNumber

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Transient

Charge Transaction

Added On: 02/10/21

SQL Column: CHARGE_TRANSACTION_FK

Java Field: chargeTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Charge Transaction

Attributes:

Client Reference

Added On: 02/10/21

SQL Column: CLIENT_REFERENCE

Java Field: clientReference

Status: Active

SQL Type: varchar(36)

Java Type: String

Attributes:

Client Request Id

Added On: 02/10/21

SQL Column: CLIENT_REQUEST_ID

Java Field: clientRequestId

Status: Active

SQL Type: varchar(36)

Java Type: String

Attributes:

Decision

Added On: 09/03/21

SQL Column: DECISION

Java Field: decision

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Early Warning Secondary Id

Added On: 09/03/21

SQL Column: EARLY_WARNING_SECONDARY_ID

Java Field: earlyWarningSecondaryId

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Error Code

Added On: 02/10/21

SQL Column: ERROR_CODE

Java Field: errorCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Error Description

Added On: 02/10/21

SQL Column: ERROR_DESCRIPTION

Java Field: errorDescription

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Error Field Name

Added On: 02/10/21

SQL Column: ERROR_FIELD_NAME

Java Field: errorFieldName

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Fcra Dispute Code

Added On: 02/10/21

SQL Column: FCRA_DISPUTE_CODE

Java Field: fcraDisputeCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Gateway Entity Id

Added On: 02/10/21

SQL Column: GATEWAY_ENTITY_ID

Java Field: gatewayEntityId

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes:

Added On: 02/10/21

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 Return Date

Added On: 02/10/21

SQL Column: LAST_RETURN_DATE

Java Field: lastReturnDate

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Last Return Reason Code

Added On: 02/10/21

SQL Column: LAST_RETURN_REASON_CODE

Java Field: lastReturnReasonCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Last Update Date

Added On: 02/10/21

SQL Column: LAST_UPDATE_DATE

Java Field: lastUpdateDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Merchant Account Code

Added On: 02/10/21

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Code of Merchant Account to which instance of this object is attributed to.\n\nDepending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.\n\nThe field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.

Number Of Returns

Added On: 02/10/21

SQL Column: NUMBER_OF_RETURNS

Java Field: numberOfReturns

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Previous Status Code

Added On: 02/10/21

SQL Column: PREVIOUS_STATUS_CODE

Java Field: previousStatusCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Primary Status Code

Added On: 02/10/21

SQL Column: PRIMARY_STATUS_CODE

Java Field: primaryStatusCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Scored Account Reason Code 1

Added On: 02/10/21

SQL Column: SCORED_ACCOUNT_REASON_CODE1

Java Field: scoredAccountReasonCode1

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Scored Account Reason Code 2

Added On: 02/10/21

SQL Column: SCORED_ACCOUNT_REASON_CODE2

Java Field: scoredAccountReasonCode2

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Scored Account Reason Code 3

Added On: 02/10/21

SQL Column: SCORED_ACCOUNT_REASON_CODE3

Java Field: scoredAccountReasonCode3

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Scored Account Reason Code 4

Added On: 02/10/21

SQL Column: SCORED_ACCOUNT_REASON_CODE4

Java Field: scoredAccountReasonCode4

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Scored Account Reason Code 5

Added On: 02/10/21

SQL Column: SCORED_ACCOUNT_REASON_CODE5

Java Field: scoredAccountReasonCode5

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Secondary Status Code

Added On: 02/10/21

SQL Column: SECONDARY_STATUS_CODE

Java Field: secondaryStatusCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Transaction Channel

Added On: 09/03/21

SQL Column: TRANSACTION_CHANNEL

Java Field: transactionChannel

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Transaction Datetime

Added On: 02/10/21

SQL Column: TRANSACTION_DATETIME

Java Field: transactionDatetime

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Validation Channel

Added On: 02/10/21

SQL Column: VALIDATION_CHANNEL

Java Field: validationChannel

Status: Active

SQL Type: varchar(36)

Java Type: String

Attributes:

Validation Type

Added On: 02/10/21

SQL Column: VALIDATION_TYPE

Java Field: validationType

Status: Active

SQL Type: varchar(28)

Java Type: String

Attributes: