Wells Fargo Provisioning Transaction UML

Added On: 09/09/19

SQL Table: WELLS_FARGO_PROVISIONING_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: WellsFargoProvisioningTransaction

Available Fields:

Acc Dep Del In Future
Account Close Reason
Account No
Account Status
Agent Id
Amex Industry Type
Average Tkt
B 2b Percent
Bill To City
Bill To Contact F Name
Bill To Contact L Name
Bill To Contact Title
Bill To Country
Bill To Email Address
Bill To Phone Number
Bill To State
Bill To Street
Bill To Zip
Business Operates From Type
Business Type
Chain Id
Chain Volume
Comments

Compass Did
Corporate Id
Create Date
Currency Code
Cust Service Phone
Customer Sign Date
Data Wire Did
Dba City
Dba Contact F Name
Dba Contact L Name
Dba Contact Title
Dba Country
Dba Email Address
Dba Name
Dba Phone Number
Dba State
Dba Street
Dba Zip
Dda 3
Dda 3 Aba
Dda 3 Account Type
Fed Tax Id
Id

International Postal Code
Irs Filing Nm
Legal Name
Maximum Tkt
Mc Auth Integrity
Mcc Code
Merchant Account Code
Nashville Merchant Number
Outlet Volume
Percent Keyed
Product Service Description
Provisioning Transaction
Registration Id
Registration Type
Response File File Store Code
Seasonal Ind
Serial No
Ship To Days
State Incorporated
Status Code
Terminal Number
Tin Type
Trans Source Percent Internet

Web Site Address
Wells Fargo Provisioning File Batch

Acc Dep Del In Future

Added On: 09/09/19

SQL Column: ACC_DEP_DEL_IN_FUTURE

Java Field: accDepDelInFuture

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Account Close Reason

Added On: 09/09/19

SQL Column: ACCOUNT_CLOSE_REASON

Java Field: accountCloseReason

Status: Active

SQL Type: varchar(49)

Java Type: String

Attributes:

Account No

Added On: 09/09/19

SQL Column: ACCOUNT_NO

Java Field: accountNo

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Account Status

Added On: 09/09/19

SQL Column: ACCOUNT_STATUS

Java Field: accountStatus

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Agent Id

Added On: 09/09/19

SQL Column: AGENT_ID

Java Field: agentId

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Amex Industry Type

Added On: 09/09/19

SQL Column: AMEX_INDUSTRY_TYPE

Java Field: amexIndustryType

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Average Tkt

Added On: 09/09/19

SQL Column: AVERAGE_TKT

Java Field: averageTkt

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

B 2b Percent

Added On: 09/09/19

SQL Column: B2B_PERCENT

Java Field: b2bPercent

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bill To City

Added On: 09/09/19

SQL Column: BILL_TO_CITY

Java Field: billToCity

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

Bill To Contact F Name

Added On: 09/09/19

SQL Column: BILL_TO_CONTACT_F_NAME

Java Field: billToContactFName

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Bill To Contact L Name

Added On: 09/09/19

SQL Column: BILL_TO_CONTACT_L_NAME

Java Field: billToContactLName

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Bill To Contact Title

Added On: 09/09/19

SQL Column: BILL_TO_CONTACT_TITLE

Java Field: billToContactTitle

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bill To Country

Added On: 09/09/19

SQL Column: BILL_TO_COUNTRY

Java Field: billToCountry

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Bill To Email Address

Added On: 09/09/19

SQL Column: BILL_TO_EMAIL_ADDRESS

Java Field: billToEmailAddress

Status: Active

SQL Type: varchar(70)

Java Type: String

Attributes:

Bill To Phone Number

Added On: 09/09/19

SQL Column: BILL_TO_PHONE_NUMBER

Java Field: billToPhoneNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Bill To State

Added On: 09/09/19

SQL Column: BILL_TO_STATE

Java Field: billToState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Bill To Street

Added On: 09/09/19

SQL Column: BILL_TO_STREET

Java Field: billToStreet

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Bill To Zip

Added On: 09/09/19

SQL Column: BILL_TO_ZIP

Java Field: billToZip

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Business Operates From Type

Added On: 09/09/19

SQL Column: BUSINESS_OPERATES_FROM_TYPE

Java Field: businessOperatesFromType

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Business Type

Added On: 09/09/19

SQL Column: BUSINESS_TYPE

Java Field: businessType

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Chain Id

Added On: 09/09/19

SQL Column: CHAIN_ID

Java Field: chainId

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Chain Volume

Added On: 09/09/19

SQL Column: CHAIN_VOLUME

Java Field: chainVolume

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Comments

Added On: 09/09/19

SQL Column: COMMENTS

Java Field: comments

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Compass Did

Added On: 09/09/19

SQL Column: COMPASS_DID

Java Field: compassDid

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Corporate Id

Added On: 09/09/19

SQL Column: CORPORATE_ID

Java Field: corporateId

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Create Date

Added On: 09/09/19

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Currency Code

Added On: 09/09/19

SQL Column: CURRENCY_CODE

Java Field: currencyCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Cust Service Phone

Added On: 09/09/19

SQL Column: CUST_SERVICE_PHONE

Java Field: custServicePhone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Customer Sign Date

Added On: 09/09/19

SQL Column: CUSTOMER_SIGN_DATE

Java Field: customerSignDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Data Wire Did

Added On: 09/09/19

SQL Column: DATA_WIRE_DID

Java Field: dataWireDid

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Dba City

Added On: 09/09/19

SQL Column: DBA_CITY

Java Field: dbaCity

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

Dba Contact F Name

Added On: 09/09/19

SQL Column: DBA_CONTACT_F_NAME

Java Field: dbaContactFName

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Dba Contact L Name

Added On: 09/09/19

SQL Column: DBA_CONTACT_L_NAME

Java Field: dbaContactLName

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Dba Contact Title

Added On: 09/09/19

SQL Column: DBA_CONTACT_TITLE

Java Field: dbaContactTitle

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Dba Country

Added On: 09/09/19

SQL Column: DBA_COUNTRY

Java Field: dbaCountry

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Dba Email Address

Added On: 09/09/19

SQL Column: DBA_EMAIL_ADDRESS

Java Field: dbaEmailAddress

Status: Active

SQL Type: varchar(70)

Java Type: String

Attributes:

Dba Name

Added On: 09/09/19

SQL Column: DBA_NAME

Java Field: dbaName

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Dba Phone Number

Added On: 09/09/19

SQL Column: DBA_PHONE_NUMBER

Java Field: dbaPhoneNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Dba State

Added On: 09/09/19

SQL Column: DBA_STATE

Java Field: dbaState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Dba Street

Added On: 09/09/19

SQL Column: DBA_STREET

Java Field: dbaStreet

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Dba Zip

Added On: 09/09/19

SQL Column: DBA_ZIP

Java Field: dbaZip

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Dda 3

Added On: 09/09/19

SQL Column: DDA3

Java Field: dda3

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes: Transient

Dda 3 Aba

Added On: 09/09/19

SQL Column: DDA3_ABA

Java Field: dda3Aba

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes: Transient

Dda 3 Account Type

Added On: 09/09/19

SQL Column: DDA3_ACCOUNT_TYPE

Java Field: dda3AccountType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Fed Tax Id

Added On: 09/09/19

SQL Column: FED_TAX_ID

Java Field: fedTaxId

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes: Transient

Added On: 09/17/19

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.

International Postal Code

Added On: 09/09/19

SQL Column: INTERNATIONAL_POSTAL_CODE

Java Field: internationalPostalCode

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Irs Filing Nm

Added On: 09/09/19

SQL Column: IRS_FILING_NM

Java Field: irsFilingNm

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Legal Name

Added On: 09/09/19

SQL Column: LEGAL_NAME

Java Field: legalName

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Maximum Tkt

Added On: 09/09/19

SQL Column: MAXIMUM_TKT

Java Field: maximumTkt

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Mc Auth Integrity

Added On: 09/09/19

SQL Column: MC_AUTH_INTEGRITY

Java Field: mcAuthIntegrity

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Mcc Code

Added On: 09/09/19

SQL Column: MCC_CODE

Java Field: mccCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Merchant Account Code

Added On: 09/17/19

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

Nashville Merchant Number

Added On: 09/09/19

SQL Column: NASHVILLE_MERCHANT_NUMBER

Java Field: nashvilleMerchantNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Outlet Volume

Added On: 09/09/19

SQL Column: OUTLET_VOLUME

Java Field: outletVolume

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Percent Keyed

Added On: 09/09/19

SQL Column: PERCENT_KEYED

Java Field: percentKeyed

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Product Service Description

Added On: 09/09/19

SQL Column: PRODUCT_SERVICE_DESCRIPTION

Java Field: productServiceDescription

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Provisioning Transaction

Added On: 09/09/19

SQL Column: PROVISIONING_TRANSACTION_FK

Java Field: provisioningTransaction

Status: Active

SQL Type: bigint(20)(10)

Java Type: Long

References Provisioning Transaction

Attributes:

Registration Id

Added On: 09/09/19

SQL Column: REGISTRATION_ID

Java Field: registrationId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Registration Type

Added On: 09/09/19

SQL Column: REGISTRATION_TYPE

Java Field: registrationType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Response File File Store Code

Added On: 09/09/19

SQL Column: RESPONSE_FILE_FILE_STORE_CODE

Java Field: responseFileFileStoreCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Seasonal Ind

Added On: 09/09/19

SQL Column: SEASONAL_IND

Java Field: seasonalInd

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Serial No

Added On: 09/09/19

SQL Column: SERIAL_NO

Java Field: serialNo

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Ship To Days

Added On: 09/09/19

SQL Column: SHIP_TO_DAYS

Java Field: shipToDays

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State Incorporated

Added On: 09/09/19

SQL Column: STATE_INCORPORATED

Java Field: stateIncorporated

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Status Code

Added On: 09/09/19

SQL Column: STATUS_CODE

Java Field: statusCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Terminal Number

Added On: 09/09/19

SQL Column: TERMINAL_NUMBER

Java Field: terminalNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Tin Type

Added On: 09/09/19

SQL Column: TIN_TYPE

Java Field: tinType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Trans Source Percent Internet

Added On: 09/09/19

SQL Column: TRANS_SOURCE_PERCENT_INTERNET

Java Field: transSourcePercentInternet

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Web Site Address

Added On: 09/09/19

SQL Column: WEB_SITE_ADDRESS

Java Field: webSiteAddress

Status: Active

SQL Type: varchar(70)

Java Type: String

Attributes:

Wells Fargo Provisioning File Batch

Added On: 09/09/19

SQL Column: WELLS_FARGO_PROVISIONING_FILE_BATCH_FK

Java Field: wellsFargoProvisioningFileBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Wells Fargo Provisioning File Batch

Attributes: