Vantiv Tandem Provisioning Transaction UML

Added On: 04/05/15

SQL Table: VANTIV_TANDEM_PROVISIONING_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: VantivTandemProvisioningTransaction

Entity that represents information about provisioning transaction processed by Vantiv Tandem.

Available Fields:

Aba
Alternate Mail Address1
Alternate Mail Address2
Alternate Mail City
Alternate Mail Extended ZIP
Alternate Mail State
Alternate Mail ZIP
Auto Close
Auto Close Time
Average Ticket Price
Background Verification Result Code
Card Type1
Card Type2
Card Type3
Card Type4
Card Type5
Card Type6
Contact Name
Contact Phone
Customer Service Phone
Customer Specific Merchant Level Id
Date Merchant Added
Dda
Discount Method1
Discount Method2
Discount Method3

Discount Method4
Discount Method5
Discount Method6
Discount Percentage1
Discount Percentage2
Discount Percentage3
Discount Percentage4
Discount Percentage5
Discount Percentage6
Environment
Equipment Code
Equipment Flag
External Account Number1
External Account Number2
External Account Number3
External Account Number4
External Account Number5
External Account Number6
Federal Tax Id
Id
MCC Code
Merchant Account Code
Merchant Name
Merchant Number
Provisioning Transaction FK
Sales Volume1

Sales Volume2
Sales Volume3
Sales Volume4
Sales Volume5
Sales Volume6
Status
Store Address2
Store City
Store Extended ZIP
Store Name
Store Number
Store Physical Address1
Store State
Store Time Zone
Store ZIP
Swipe Percentage
Terminal ID
Ticket Average1
Ticket Average2
Ticket Average3
Ticket Average4
Ticket Average5
Ticket Average6
Vantiv Tandem Provisioning File Batch FK
Voucher Flags
Web Site Url

Aba

Added On: 04/05/15

SQL Column: ABA

Java Field: aba

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Alternate Mail Address1

Added On: 04/05/15

SQL Column: ALTERNATE_MAIL_ADDRESS1

Java Field: alternateMailAddress1

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes:

The street alternative mailing address line one (in case if the main address is unavailable).

Alternate Mail Address2

Added On: 04/05/15

SQL Column: ALTERNATE_MAIL_ADDRESS2

Java Field: alternateMailAddress2

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes:

The street alternative mailing address line two (in case if the main address is unavailable).

Alternate Mail City

Added On: 04/05/15

SQL Column: ALTERNATE_MAIL_CITY

Java Field: alternateMailCity

Status: Active

SQL Type: varchar(28)

Java Type: String

Attributes:

The city alternative mailing address (in case if the main address is unavailable).

Alternate Mail Extended ZIP

Added On: 04/05/15

SQL Column: ALTERNATE_MAIL_EXTENDED_ZIP

Java Field: alternateMailExtendedZip

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

The extended ZIP/postal code of alternative mailing address (in case if the main address is unavailable).

Alternate Mail State

Added On: 04/05/15

SQL Column: ALTERNATE_MAIL_STATE

Java Field: alternateMailState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

The state code of alternative mailing address (in case if the main address is unavailable).

Alternate Mail ZIP

Added On: 04/05/15

SQL Column: ALTERNATE_MAIL_ZIP

Java Field: alternateMailZip

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

The ZIP/postal code of alternative mailing address (in case if the main address is unavailable).

Auto Close

Added On: 04/05/15

SQL Column: AUTO_CLOSE

Java Field: autoClose

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Auto Close Time

Added On: 04/05/15

SQL Column: AUTO_CLOSE_TIME

Java Field: autoCloseTime

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Average Ticket Price

Added On: 04/05/15

SQL Column: AVERAGE_TICKET_PRICE

Java Field: averageTicketPrice

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Background Verification Result Code

Added On: 07/17/15

SQL Column: BACKGROUND_VERIFICATION_RESULT_CODE

Java Field: backgroundVerificationResultCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

The result code of background verification.

Card Type1

Added On: 04/05/15

SQL Column: CARD_TYPE1

Java Field: cardType1

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Card Type2

Added On: 04/05/15

SQL Column: CARD_TYPE2

Java Field: cardType2

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Card Type3

Added On: 04/05/15

SQL Column: CARD_TYPE3

Java Field: cardType3

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Card Type4

Added On: 04/05/15

SQL Column: CARD_TYPE4

Java Field: cardType4

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Card Type5

Added On: 04/05/15

SQL Column: CARD_TYPE5

Java Field: cardType5

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Card Type6

Added On: 04/05/15

SQL Column: CARD_TYPE6

Java Field: cardType6

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Contact Name

Added On: 04/05/15

SQL Column: CONTACT_NAME

Java Field: contactName

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Contact Phone

Added On: 04/05/15

SQL Column: CONTACT_PHONE

Java Field: contactPhone

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Customer service phone number that will appear on the cardholder's statement.

Customer Service Phone

Added On: 04/05/15

SQL Column: CUSTOMER_SERVICE_PHONE

Java Field: customerServicePhone

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Customer service phone number that will appear on the cardholder's statement.

Customer Specific Merchant Level Id

Added On: 09/12/18

SQL Column: CUSTOMER_SPECIFIC_MERCHANT_LEVEL_ID

Java Field: customerSpecificMerchantLevelId

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Date Merchant Added

Added On: 04/05/15

SQL Column: DATE_MERCHANT_ADDED

Java Field: dateMerchantAdded

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

The actual date when the merchant was added.

Dda

Added On: 04/05/15

SQL Column: DDA

Java Field: dda

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Discount Method1

Added On: 04/05/15

SQL Column: DISCOUNT_METHOD1

Java Field: discountMethod1

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Discount Method2

Added On: 04/05/15

SQL Column: DISCOUNT_METHOD2

Java Field: discountMethod2

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Discount Method3

Added On: 04/05/15

SQL Column: DISCOUNT_METHOD3

Java Field: discountMethod3

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Discount Method4

Added On: 04/05/15

SQL Column: DISCOUNT_METHOD4

Java Field: discountMethod4

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Discount Method5

Added On: 04/05/15

SQL Column: DISCOUNT_METHOD5

Java Field: discountMethod5

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Discount Method6

Added On: 04/05/15

SQL Column: DISCOUNT_METHOD6

Java Field: discountMethod6

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Discount Percentage1

Added On: 04/05/15

SQL Column: DISCOUNT_PERCENTAGE1

Java Field: discountPercentage1

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Discount Percentage2

Added On: 04/05/15

SQL Column: DISCOUNT_PERCENTAGE2

Java Field: discountPercentage2

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Discount Percentage3

Added On: 04/05/15

SQL Column: DISCOUNT_PERCENTAGE3

Java Field: discountPercentage3

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Discount Percentage4

Added On: 04/05/15

SQL Column: DISCOUNT_PERCENTAGE4

Java Field: discountPercentage4

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Discount Percentage5

Added On: 04/05/15

SQL Column: DISCOUNT_PERCENTAGE5

Java Field: discountPercentage5

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Discount Percentage6

Added On: 04/05/15

SQL Column: DISCOUNT_PERCENTAGE6

Java Field: discountPercentage6

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Environment

Added On: 04/05/15

SQL Column: ENVIRONMENT

Java Field: environment

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Equipment Code

Added On: 04/05/15

SQL Column: EQUIPMENT_CODE

Java Field: equipmentCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Equipment Flag

Added On: 04/05/15

SQL Column: EQUIPMENT_FLAG

Java Field: equipmentFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

External Account Number1

Added On: 04/05/15

SQL Column: EXTERNAL_ACCOUNT_NUMBER1

Java Field: externalAccountNumber1

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

External Account Number2

Added On: 04/05/15

SQL Column: EXTERNAL_ACCOUNT_NUMBER2

Java Field: externalAccountNumber2

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

External Account Number3

Added On: 04/05/15

SQL Column: EXTERNAL_ACCOUNT_NUMBER3

Java Field: externalAccountNumber3

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

External Account Number4

Added On: 04/05/15

SQL Column: EXTERNAL_ACCOUNT_NUMBER4

Java Field: externalAccountNumber4

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

External Account Number5

Added On: 04/05/15

SQL Column: EXTERNAL_ACCOUNT_NUMBER5

Java Field: externalAccountNumber5

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

External Account Number6

Added On: 04/05/15

SQL Column: EXTERNAL_ACCOUNT_NUMBER6

Java Field: externalAccountNumber6

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

Federal Tax Id

Added On: 04/05/15

SQL Column: FEDERAL_TAX_ID

Java Field: federalTaxId

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Added On: 04/05/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.

MCC Code

Added On: 04/05/15

SQL Column: MCC_CODE

Java Field: mccCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

MCC (merchant category code) Code of the merchant.

Merchant Account Code

Added On: 04/05/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.

Merchant Name

Added On: 04/05/15

SQL Column: MERCHANT_NAME

Java Field: merchantName

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

The name assosiated with this merchant account.

Merchant Number

Added On: 04/05/15

SQL Column: MERCHANT_NUMBER

Java Field: merchantNumber

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Merchant number in the system.

Provisioning Transaction FK

Added On: 06/17/16

SQL Column: PROVISIONING_TRANSACTION_FK

Java Field: provisioningTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Provisioning Transaction

Attributes:

Reference to the entity that represents settings applied to Vantiv Tandem Provisioning transaction.

Sales Volume1

Added On: 04/05/15

SQL Column: SALES_VOLUME1

Java Field: salesVolume1

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Sales Volume2

Added On: 04/05/15

SQL Column: SALES_VOLUME2

Java Field: salesVolume2

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Sales Volume3

Added On: 04/05/15

SQL Column: SALES_VOLUME3

Java Field: salesVolume3

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Sales Volume4

Added On: 04/05/15

SQL Column: SALES_VOLUME4

Java Field: salesVolume4

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Sales Volume5

Added On: 04/05/15

SQL Column: SALES_VOLUME5

Java Field: salesVolume5

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Sales Volume6

Added On: 04/05/15

SQL Column: SALES_VOLUME6

Java Field: salesVolume6

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Status

Added On: 04/05/15

SQL Column: STATUS

Java Field: status

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Current status of the merchant.

Store Address2

Added On: 04/05/15

SQL Column: STORE_ADDRESS2

Java Field: storeAddress2

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes:

Street physical address of the store line two.

Store City

Added On: 04/05/15

SQL Column: STORE_CITY

Java Field: storeCity

Status: Active

SQL Type: varchar(28)

Java Type: String

Attributes:

City physical address of the store.

Store Extended ZIP

Added On: 04/05/15

SQL Column: STORE_EXTENDED_ZIP

Java Field: storeExtendedZip

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Extended ZIP/postal code of the store physical address.

Store Name

Added On: 04/05/15

SQL Column: STORE_NAME

Java Field: storeName

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

The name of the store.

Store Number

Added On: 04/05/15

SQL Column: STORE_NUMBER

Java Field: storeNumber

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Store Physical Address1

Added On: 04/05/15

SQL Column: STORE_PHYSICAL_ADDRESS1

Java Field: storePhysicalAddress1

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes:

Street physical address of the store line one.

Store State

Added On: 04/05/15

SQL Column: STORE_STATE

Java Field: storeState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

State code of physical address of the store.

Store Time Zone

Added On: 04/05/15

SQL Column: STORE_TIME_ZONE

Java Field: storeTimeZone

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

This field used to calculate the local time of the store within the Vantiv Tandem authorization system.

Store ZIP

Added On: 04/05/15

SQL Column: STORE_ZIP

Java Field: storeZip

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

ZIP/Postal code of physical address of the store.

Swipe Percentage

Added On: 04/05/15

SQL Column: SWIPE_PERCENTAGE

Java Field: swipePercentage

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Terminal ID

Added On: 04/05/15

SQL Column: TERMINAL_ID

Java Field: terminalId

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Identification number of the terminal. Provided by the processor.

Ticket Average1

Added On: 04/05/15

SQL Column: TICKET_AVERAGE1

Java Field: ticketAverage1

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

Ticket Average2

Added On: 04/05/15

SQL Column: TICKET_AVERAGE2

Java Field: ticketAverage2

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

Ticket Average3

Added On: 04/05/15

SQL Column: TICKET_AVERAGE3

Java Field: ticketAverage3

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

Ticket Average4

Added On: 04/05/15

SQL Column: TICKET_AVERAGE4

Java Field: ticketAverage4

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

Ticket Average5

Added On: 04/05/15

SQL Column: TICKET_AVERAGE5

Java Field: ticketAverage5

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

Ticket Average6

Added On: 04/05/15

SQL Column: TICKET_AVERAGE6

Java Field: ticketAverage6

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

Vantiv Tandem Provisioning File Batch FK

Added On: 06/17/16

SQL Column: VANTIV_TANDEM_PROVISIONING_FILE_BATCH_FK

Java Field: vantivTandemProvisioningFileBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Vantiv Tandem Provisioning File Batch

Attributes:

Reference to the entity that represents Vantiv Tandem provisioning transaction information.

Voucher Flags

Added On: 04/05/15

SQL Column: VOUCHER_FLAGS

Java Field: voucherFlags

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Web Site Url

Added On: 09/12/18

SQL Column: WEB_SITE_URL

Java Field: webSiteUrl

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes: