CC Vantiv Tandem Batch Transaction UML

Added On: 08/03/16

SQL Table: CC_VANTIV_TANDEM_BATCH_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: CcVantivTandemBatchTransaction

Entity that represents a batch transaction as it is defined in batch processing specification of Vantiv Tandem.

Available Fields:

Card Expiration Date
Cardholder Account Number
Cardholder ID Method
Cardholder Street Address
Cc Vantiv Tandem Batch
Charge Transaction FK
Currency Code
Draft Locator Number
First Payment
Id
Market Specific Data Indicator
Media Code
Merchant Account Code
Merchant Descriptor
Pos Entry Mode
Pos Environment Indicator
Response Address Verification Resp
Response Amex Card Capture Capability
Response Amex Card Data Input Capability
Response Amex Card Data Input Mode

Response Amex Card Data Output Capability
Response Amex Card Present
Response Amex Cardholder Authentication
Response Amex Cardholder Present
Response Amex Cardmember Authentication
Response Amex Cardmember Authentication Entity
Response Amex Operating Environment
Response Amex PIN Capture Capability
Response Amex Terminal Output Capability
Response Amex Transaction Identifier
Response Authorization Date
Response Authorization Number
Response Code
Response Discover Audit Trace
Response Discover Auth Date Time
Response Discover Network Reference ID
Response Discover POS Cond Code
Response Discover POS Entry Mode
Response Discover Processing Code
Response Discover Response

Response Discover Track Status
Response Mastercard BankNet Reference Number
Response Mastercard BankNet Settlement Date
Response Mastercard Retrieval Reference Number
Response Recurring Payment Advice Code
Response Visa Authorization Characteristics Indicator
Response Visa Card Level Results Code
Response Visa Code
Response Visa Retrieval Reference Number
Response Visa Total Authorized Amount
Response Visa Transaction ID
Response Visa Validation Code
Subsequent Transaction Reason Code
Transaction Amount
Transaction Date
Transaction Format Code
Transaction Identity
Transaction Type
Visa Transaction Id
ZIP Code

Card Expiration Date

Added On: 08/03/16

SQL Column:

Java Field: cardExpirationDate

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Expiration date of the card of the cardholder.

Cardholder Account Number

Added On: 08/03/16

SQL Column:

Java Field: cardholderAccountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Account number of the cardholder that applied the transaction.

Cardholder ID Method

Added On: 08/03/16

SQL Column: CARDHOLDER_ID_METHOD

Java Field: cardholderIdMethod

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Identifier of the cardholder assigned by a processor.

Cardholder Street Address

Added On: 08/03/16

SQL Column: CARDHOLDER_STREET_ADDRESS

Java Field: cardholderStreetAddress

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Street address of the cardholder.

Cc Vantiv Tandem Batch

Added On: 08/03/16

SQL Column: CC_VANTIV_TANDEM_BATCH_FK

Java Field: ccVantivTandemBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References CC Vantiv Tandem Batch

Attributes:

Reference to the entity that represents list of the provier charge transactions.

Charge Transaction FK

Added On: 08/03/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.

Currency Code

Added On: 10/12/16

SQL Column: CURRENCY_CODE

Java Field: currencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of the currency used in transaction.

Draft Locator Number

Added On: 08/03/16

SQL Column: DRAFT_LOCATOR_NUMBER

Java Field: draftLocatorNumber

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Code that is used to identify the draft locator.

First Payment

Added On: 08/03/16

SQL Column: FIRST_PAYMENT

Java Field: firstPayment

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates whether the first payment occurred.

Added On: 08/03/16

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.

Market Specific Data Indicator

Added On: 09/29/17

SQL Column: MARKET_SPECIFIC_DATA_INDICATOR

Java Field: marketSpecificDataIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Media Code

Added On: 10/12/16

SQL Column: MEDIA_CODE

Java Field: mediaCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Code of the media associated with the transaction.

Merchant Account Code

Added On: 08/03/16

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 Descriptor

Added On: 08/03/16

SQL Column: MERCHANT_DESCRIPTOR

Java Field: merchantDescriptor

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Dynamic description of a merchant that can be customized to simplify understanding of charge for a cardholder.

Pos Entry Mode

Added On: 03/20/18

SQL Column: POS_ENTRY_MODE

Java Field: posEntryMode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Pos Environment Indicator

Added On: 03/20/18

SQL Column: POS_ENVIRONMENT_INDICATOR

Java Field: posEnvironmentIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Response Address Verification Resp

Added On: 08/03/16

SQL Column: RESPONSE_ADDRESS_VERIFICATION_RESP

Java Field: responseAddressVerificationResp

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Contents of the address verification response message.

Response Amex Card Capture Capability

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_CARD_CAPTURE_CAPABILITY

Java Field: responseAmexCardCaptureCapability

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the Amex card capture response.

Response Amex Card Data Input Capability

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_CARD_DATA_INPUT_CAPABILITY

Java Field: responseAmexCardDataInputCapability

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the Amex card data input mode response.

Response Amex Card Data Input Mode

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_CARD_DATA_INPUT_MODE

Java Field: responseAmexCardDataInputMode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Contents of the Amex card data input mode response.

Response Amex Card Data Output Capability

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_CARD_DATA_OUTPUT_CAPABILITY

Java Field: responseAmexCardDataOutputCapability

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the Amex card data output mode response.

Response Amex Card Present

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_CARD_PRESENT

Java Field: responseAmexCardPresent

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the Amex card response.

Response Amex Cardholder Authentication

Added On: 08/05/16

SQL Column: RESPONSE_AMEX_CARDHOLDER_AUTHENTICATION

Java Field: responseAmexCardholderAuthentication

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Response received for Amex cardholder authentication request.

Response Amex Cardholder Present

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_CARDHOLDER_PRESENT

Java Field: responseAmexCardholderPresent

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the Amex cardholder response.

Response Amex Cardmember Authentication

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_CARDMEMBER_AUTHENTICATION

Java Field: responseAmexCardmemberAuthentication

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Response received on Amex cardmember authentication request.

Response Amex Cardmember Authentication Entity

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_CARDMEMBER_AUTHENTICATION_ENTITY

Java Field: responseAmexCardmemberAuthenticationEntity

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Response received on Amex cardmember authentication entity request.

Response Amex Operating Environment

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_OPERATING_ENVIRONMENT

Java Field: responseAmexOperatingEnvironment

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the Amex operating environment response.

Response Amex PIN Capture Capability

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_PIN_CAPTURE_CAPABILITY

Java Field: responseAmexPinCaptureCapability

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the Amex PIN capture response.

Response Amex Terminal Output Capability

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_TERMINAL_OUTPUT_CAPABILITY

Java Field: responseAmexTerminalOutputCapability

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the Amex terminal output mode response.

Response Amex Transaction Identifier

Added On: 08/03/16

SQL Column: RESPONSE_AMEX_TRANSACTION_IDENTIFIER

Java Field: responseAmexTransactionIdentifier

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Identifier of the Amex transaction response.

Response Authorization Date

Added On: 08/03/16

SQL Column: RESPONSE_AUTHORIZATION_DATE

Java Field: responseAuthorizationDate

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Date when authorization response was received.

Response Authorization Number

Added On: 08/03/16

SQL Column: RESPONSE_AUTHORIZATION_NUMBER

Java Field: responseAuthorizationNumber

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Number of the authorization response.

Response Code

Added On: 08/03/16

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Response code generated by the system.

Response Discover Audit Trace

Added On: 08/03/16

SQL Column: RESPONSE_DISCOVER_AUDIT_TRACE

Java Field: responseDiscoverAuditTrace

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Trace of the Discover audit response.

Response Discover Auth Date Time

Added On: 08/03/16

SQL Column: RESPONSE_DISCOVER_AUTH_DATE_TIME

Java Field: responseDiscoverAuthDateTime

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Time when the response with Discover authentication date was received.

Response Discover Network Reference ID

Added On: 08/03/16

SQL Column: RESPONSE_DISCOVER_NETWORK_REFERENCE_ID

Java Field: responseDiscoverNetworkReferenceId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Secondary identifier of the Discover network response.

Response Discover POS Cond Code

Added On: 08/03/16

SQL Column: RESPONSE_DISCOVER_POS_COND_CODE

Java Field: responseDiscoverPosCondCode

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

Code of the Discover POS response.

Response Discover POS Entry Mode

Added On: 08/03/16

SQL Column: RESPONSE_DISCOVER_POS_ENTRY_MODE

Java Field: responseDiscoverPosEntryMode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Mode of the Discover POS entry received in the response.

Response Discover Processing Code

Added On: 08/03/16

SQL Column: RESPONSE_DISCOVER_PROCESSING_CODE

Java Field: responseDiscoverProcessingCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Code of the Discover processing response.

Response Discover Response

Added On: 08/03/16

SQL Column: RESPONSE_DISCOVER_RESPONSE

Java Field: responseDiscoverResponse

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Code of the Discover response.

Response Discover Track Status

Added On: 08/03/16

SQL Column: RESPONSE_DISCOVER_TRACK_STATUS

Java Field: responseDiscoverTrackStatus

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Status of the Discover track received in the response.

Response Mastercard BankNet Reference Number

Added On: 08/03/16

SQL Column: RESPONSE_MASTERCARD_BANK_NET_REFERENCE_NUMBER

Java Field: responseMastercardBankNetReferenceNumber

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Secondary identifier of the Mastercard BankNet response.

Response Mastercard BankNet Settlement Date

Added On: 08/05/16

SQL Column: RESPONSE_MASTERCARD_BANK_NET_SETTLEMENT_DATE

Java Field: responseMastercardBankNetSettlementDate

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Date of the Mastercard BankNet settlement received in response.

Response Mastercard Retrieval Reference Number

Added On: 08/03/16

SQL Column: RESPONSE_MASTERCARD_RETRIEVAL_REFERENCE_NUMBER

Java Field: responseMastercardRetrievalReferenceNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Secondary identifier of the Mastercard retrieval response.

Response Recurring Payment Advice Code

Added On: 08/03/16

SQL Column: RESPONSE_RECURRING_PAYMENT_ADVICE_CODE

Java Field: responseRecurringPaymentAdviceCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the recurring payment response.

Response Visa Authorization Characteristics Indicator

Added On: 08/03/16

SQL Column: RESPONSE_VISA_AUTHORIZATION_CHARACTERISTICS_INDICATOR

Java Field: responseVisaAuthorizationCharacteristicsIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicator of the Visa authorization characteristics response message.

Response Visa Card Level Results Code

Added On: 08/03/16

SQL Column: RESPONSE_VISA_CARD_LEVEL_RESULTS_CODE

Java Field: responseVisaCardLevelResultsCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Code of the Visa card level results response.

Response Visa Code

Added On: 08/03/16

SQL Column: RESPONSE_VISA_CODE

Java Field: responseVisaCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Code of the Visa response.

Response Visa Retrieval Reference Number

Added On: 08/03/16

SQL Column: RESPONSE_VISA_RETRIEVAL_REFERENCE_NUMBER

Java Field: responseVisaRetrievalReferenceNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Secondary identifier of the Visa retrieval response.

Response Visa Total Authorized Amount

Added On: 08/03/16

SQL Column: RESPONSE_VISA_TOTAL_AUTHORIZED_AMOUNT

Java Field: responseVisaTotalAuthorizedAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Total amount received in Visa authorization response.

Response Visa Transaction ID

Added On: 08/03/16

SQL Column: RESPONSE_VISA_TRANSACTION_ID

Java Field: responseVisaTransactionId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Identifier of the Visa transaction response.

Response Visa Validation Code

Added On: 08/03/16

SQL Column: RESPONSE_VISA_VALIDATION_CODE

Java Field: responseVisaValidationCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Code of the Visa validation code.

Subsequent Transaction Reason Code

Added On: 03/20/18

SQL Column: SUBSEQUENT_TRANSACTION_REASON_CODE

Java Field: subsequentTransactionReasonCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Transaction Amount

Added On: 08/03/16

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Amount included in the transaction.

Transaction Date

Added On: 08/03/16

SQL Column: TRANSACTION_DATE

Java Field: transactionDate

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Date when transaction is processed.

Transaction Format Code

Added On: 10/12/16

SQL Column: TRANSACTION_FORMAT_CODE

Java Field: transactionFormatCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Code of the transaction format.

Transaction Identity

Added On: 04/12/19

SQL Column: TRANSACTION_IDENTITY

Java Field: transactionIdentity

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Transaction Type

Added On: 08/03/16

SQL Column: TRANSACTION_TYPE

Java Field: transactionType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Type of the transaction included in the batch.

Visa Transaction Id

Added On: 03/20/18

SQL Column: VISA_TRANSACTION_ID

Java Field: visaTransactionId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

ZIP Code

Added On: 08/03/16

SQL Column: ZIP_CODE

Java Field: zipCode

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

ZIP code of the cardholder's mailing address.