Vantiv Tandem Processing Cost UML

Added On: 09/08/15

SQL Table: VANTIV_TANDEM_PROCESSING_COST

Module: UniCharge

Type: Entity Status: Active

Java Class: VantivTandemProcessingCost

Represents processing cost record as it is defined in Vantiv Tandem's processing cost specification.

Available Fields:

ACI
Address
Adjustment Action
Adjustment Amount
Adjustment Amount Sign
Adjustment Date Format
Adjustment Number
Adjustment Process
Adjustment Reason Code
Adjustment Reversal Amount
Adjustment Reversal Amount Sign
Adjustment Reversal Date
Adjustment Reversal Time
Adjustment Time Format
Adjustment Transaction Disposition
Adjustment Type
Authorization Code
Authorization Request Response Code
Authorization Source
Authorized Amount
AVS Response Code
Batch Number
Business Date
Call Type
Card Account Number
Card EMV Capability Flag
Card Owner Chain Code
Card Owner MID
Card Primary Account Number
Card Product Type
Card Type
Cardholder Acro
Cardholder Billing Amount
Cardholder Billing Currency Code
Cardholder Conversion Rate
Cardholder Currency Code
Cardholder I D Method
Cardholder ID
Cardholder Transaction Amount
CashBack Amount
CAT Indicator
CAVV Response
Charge Transaction
Check ABA Number
Check Serial Number
Check Type
Check Writer Date Of Birth

Check Writer ID Method
Check Writer Phone Number
Checking Account Number
Convenience Fee Amount
Conversion Rate
Cost Matching Status CL
Country Code
Currency Code
CVV2 Presence Code Indicator
CVV2 Response Code Indicator
DCC MCP Indicator
Denial Code
Draft Locator
EMV Offline Transaction Flag
EMV Transaction Flag
EMV Transaction Indicator
Error Code
Expiration Date
Franchise Card Transaction Flag
Franchise Program Type
From Account Type
Id
ID Number
ID State Code
Interchange Adjustment Amount
Interchange Adjustment Reason Code
Interchange Adjustment Sign
Interchange Amount
Interchange Amount Sign
Interchange Code
Magnetic Stripe
Mail Phone Indicator
Master Card Banknet Reference Number
Master Card Banknet Settlement Date
MCC Code
Merchant Account Code
Merchant Discretionary1
Merchant Discretionary2
Merchant Discretionary3
Merchant Reference Number
Network
Network Reference Number
Old Authorized Amount
On US Transaction
On US Transaction Flag
Origin Type
Original Amount

Original Amount Sign
Original Interchange Indicator
Original Transaction Date
Original Transaction Reference Number
Original Transaction Time
Originator
Originator Comments
PINless Ind
POS Condition Code
POS Entry Mode
Program Agent
Program Identifier
Raw Data
Receiver
Receiver Comments
Register Number
Remaining Balance
Remaining Balance Amount
Requested Authorization Amount
Requested Settled Amount
Retrieval Reference Number
RTC Settlement Type
Sales Person
SKU Number
Surcharge Amount
Terminal EMV Capability Flag
Terminal ID
Terminal Location
Terminal Number
Terminal Sequence Number
Token
Token ID
Transaction Amount
Transaction Date
Transaction Date Date
Transaction Disposition
Transaction Identity
Transaction Origin Flag
Transaction Sequence Number
Transaction Time
Transaction Type Code
Vantiv Tandem Processing Cost Batch FK
Visa Authorization Response Code
Visa Card Level Results
Visa Transaction ID
Visa Validation Code
Void Indicator

ACI

Added On: 09/08/15

SQL Column: ACI

Java Field: aci

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

A code used to request qualification in the Custom Payment Service (CPS) program as defined by Visa. Upon evaluation, the code may be changed in the response message if provided by Visa.

Address

Added On: 09/08/15

SQL Column: ADDRESS

Java Field: address

Status: Active

SQL Type: varchar(44)

Java Type: String

Attributes:

Adjustment Action

Added On: 09/08/15

SQL Column: ADJUSTMENT_ACTION

Java Field: adjustmentAction

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Adjustment Amount

Added On: 09/08/15

SQL Column: ADJUSTMENT_AMOUNT

Java Field: adjustmentAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount of the adjustment.

Adjustment Amount Sign

Added On: 09/08/15

SQL Column: ADJUSTMENT_AMOUNT_SIGN

Java Field: adjustmentAmountSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Adjustment Date Format

Added On: 09/08/15

SQL Column: ADJUSTMENT_DATE_FORMAT

Java Field: adjustmentDateFormat

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Date format used for the adjustment.

Adjustment Number

Added On: 09/08/15

SQL Column: ADJUSTMENT_NUMBER

Java Field: adjustmentNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Adjustment Process

Added On: 09/08/15

SQL Column: ADJUSTMENT_PROCESS

Java Field: adjustmentProcess

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Adjustment Reason Code

Added On: 09/08/15

SQL Column: ADJUSTMENT_REASON_CODE

Java Field: adjustmentReasonCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Reason code assigned to the adjustment that is generated within the system.

Adjustment Reversal Amount

Added On: 09/08/15

SQL Column: ADJUSTMENT_REVERSAL_AMOUNT

Java Field: adjustmentReversalAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount of the adjustment reversal.

Adjustment Reversal Amount Sign

Added On: 09/08/15

SQL Column: ADJUSTMENT_REVERSAL_AMOUNT_SIGN

Java Field: adjustmentReversalAmountSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Adjustment Reversal Date

Added On: 09/08/15

SQL Column: ADJUSTMENT_REVERSAL_DATE

Java Field: adjustmentReversalDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Date when the adjustment reversal occurred.

Adjustment Reversal Time

Added On: 09/08/15

SQL Column: ADJUSTMENT_REVERSAL_TIME

Java Field: adjustmentReversalTime

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Time when the adjustment reversal occurred.

Adjustment Time Format

Added On: 09/08/15

SQL Column: ADJUSTMENT_TIME_FORMAT

Java Field: adjustmentTimeFormat

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Time format used for the adjustment.

Adjustment Transaction Disposition

Added On: 09/08/15

SQL Column: ADJUSTMENT_TRANSACTION_DISPOSITION

Java Field: adjustmentTransactionDisposition

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Adjustment Type

Added On: 09/08/15

SQL Column: ADJUSTMENT_TYPE

Java Field: adjustmentType

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Type of the applied adjustment.

Authorization Code

Added On: 09/08/15

SQL Column: AUTHORIZATION_CODE

Java Field: authorizationCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Authorization code of the approved, original, authorized transaction.

Authorization Request Response Code

Added On: 09/08/15

SQL Column: AUTHORIZATION_REQUEST_RESPONSE_CODE

Java Field: authorizationRequestResponseCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Response code associated with an authorization request generated by the processor.

Authorization Source

Added On: 09/08/15

SQL Column: AUTHORIZATION_SOURCE

Java Field: authorizationSource

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Contains code indicating the source of the authorization code. The received code must be stored and resubmitted in the data capture settlement record.

Authorized Amount

Added On: 09/08/15

SQL Column: AUTHORIZED_AMOUNT

Java Field: authorizedAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

The total authorized amount for the authorization request. If the Partial authorization flag is enabled, this amount may be less than the requested amount.

AVS Response Code

Added On: 09/08/15

SQL Column: AVS_RESPONSE_CODE

Java Field: avsResponseCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Code indicating whether address verification was performed and the results.

Batch Number

Added On: 09/08/15

SQL Column: BATCH_NUMBER

Java Field: batchNumber

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Number of the associated batch files.

Business Date

Added On: 09/08/15

SQL Column: BUSINESS_DATE

Java Field: businessDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Processing date set in EMD file.

Call Type

Added On: 09/08/15

SQL Column: CALL_TYPE

Java Field: callType

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Indicator of how the call is performed.

Card Account Number

Added On: 09/08/15

SQL Column: CARD_ACCOUNT_NUMBER

Java Field: cardAccountNumber

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Card or account number of the cardholder.

Card EMV Capability Flag

Added On: 09/08/15

SQL Column: CARD_EMV_CAPABILITY_FLAG

Java Field: cardEmvCapabilityFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates that the card is EMV.

Card Owner Chain Code

Added On: 09/08/15

SQL Column: CARD_OWNER_CHAIN_CODE

Java Field: cardOwnerChainCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Identifier of the cardholder assigned by the processor.

Card Owner MID

Added On: 09/08/15

SQL Column: CARD_OWNER_MID

Java Field: cardOwnerMid

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Merchant ID of the cardholder.

Card Primary Account Number

Added On: 09/08/15

SQL Column: CARD_PRIMARY_ACCOUNT_NUMBER

Java Field: cardPrimaryAccountNumber

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Card Product Type

Added On: 09/08/15

SQL Column: CARD_PRODUCT_TYPE

Java Field: cardProductType

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Type of the MasterCard/Visa card.

Card Type

Added On: 09/08/15

SQL Column: CARD_TYPE

Java Field: cardType

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Type of the credit card used for the transaction.

Cardholder Acro

Added On: 09/08/15

SQL Column: CARDHOLDER_ACRO

Java Field: cardholderAcro

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Cardholder Billing Amount

Added On: 09/08/15

SQL Column: CARDHOLDER_BILLING_AMOUNT

Java Field: cardholderBillingAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Billing amount associated with a cardholder.

Cardholder Billing Currency Code

Added On: 09/08/15

SQL Column: CARDHOLDER_BILLING_CURRENCY_CODE

Java Field: cardholderBillingCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of the currency used for cardholder's billing.

Cardholder Conversion Rate

Added On: 09/08/15

SQL Column: CARDHOLDER_CONVERSION_RATE

Java Field: cardholderConversionRate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Cardholder Currency Code

Added On: 09/08/15

SQL Column: CARDHOLDER_CURRENCY_CODE

Java Field: cardholderCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

This value is the Cardholder’s currency code as represented by the Currency Code table in the specification of the processor. This is used on DCC transactions only.

Cardholder I D Method

Added On: 09/08/15

SQL Column: CARDHOLDER_I_D_METHOD

Java Field: cardholderIDMethod

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Cardholder ID

Added On: 09/08/15

SQL Column: CARDHOLDER_ID

Java Field: cardholderId

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

The unique identification number of the cardholder.

Cardholder Transaction Amount

Added On: 09/08/15

SQL Column: CARDHOLDER_TRANSACTION_AMOUNT

Java Field: cardholderTransactionAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Transaction amount processed.

CashBack Amount

Added On: 08/03/16

SQL Column: CASH_BACK_AMOUNT

Java Field: cashBackAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount of cashback.

CAT Indicator

Added On: 09/08/15

SQL Column: CAT_INDICATOR

Java Field: catIndicator

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Indicates the type of Cardholder Activated Terminal Indicator for this transaction.

00 = Not a CAT Transaction
01 = Limited Amount Terminal
02 = Automated Dispensing Machine
03 = Self-Service Terminal (AFD)
04 = In-Flight Commerce
05 = Internet
06 = Transponder
07 = Remote Indicator

CAVV Response

Added On: 09/08/15

SQL Column: CAVV_RESPONSE

Java Field: cavvResponse

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

CAV response generated by the processor.

Charge Transaction

Added On: 04/12/19

SQL Column: CHARGE_TRANSACTION_FK

Java Field: chargeTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Charge Transaction

Attributes:

Check ABA Number

Added On: 09/08/15

SQL Column: CHECK_ABA_NUMBER

Java Field: checkAbaNumber

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Check Serial Number

Added On: 09/08/15

SQL Column: CHECK_SERIAL_NUMBER

Java Field: checkSerialNumber

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Serial number of the check.

Check Type

Added On: 09/08/15

SQL Column: CHECK_TYPE

Java Field: checkType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Check Writer Date Of Birth

Added On: 09/08/15

SQL Column: CHECK_WRITER_DATE_OF_BIRTH

Java Field: checkWriterDateOfBirth

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Date of birth of the check issuer.

Check Writer ID Method

Added On: 09/08/15

SQL Column: CHECK_WRITER_ID_METHOD

Java Field: checkWriterIdMethod

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Check Writer Phone Number

Added On: 09/08/15

SQL Column: CHECK_WRITER_PHONE_NUMBER

Java Field: checkWriterPhoneNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Phone number of the check issuer.

Checking Account Number

Added On: 09/08/15

SQL Column: CHECKING_ACCOUNT_NUMBER

Java Field: checkingAccountNumber

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Convenience Fee Amount

Added On: 09/08/15

SQL Column: CONVENIENCE_FEE_AMOUNT

Java Field: convenienceFeeAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount of the convenience fee assigned to the transaction.

Conversion Rate

Added On: 09/08/15

SQL Column: CONVERSION_RATE

Java Field: conversionRate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Rate set for currency conversion.

Cost Matching Status CL

Added On: 02/13/17

SQL Column: COST_MATCHING_STATUS_CL

Java Field: costMatchingStatusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Cost Matching Status Classifier

Attributes:

Reference to the entity that represents enumeration of possible cost matching statuses.

Country Code

Added On: 09/08/15

SQL Column: COUNTRY_CODE

Java Field: countryCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of the country associated with POS.

Currency Code

Added On: 09/08/15

SQL Column: CURRENCY_CODE

Java Field: currencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of the currency used in the transaction.

CVV2 Presence Code Indicator

Added On: 09/08/15

SQL Column: CVV2_PRESENCE_CODE_INDICATOR

Java Field: cvv2PresenceCodeIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicated how CVV2 is provided.

CVV2 Response Code Indicator

Added On: 09/08/15

SQL Column: CVV2_RESPONSE_CODE_INDICATOR

Java Field: cvv2ResponseCodeIndicator

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Indicated how CVV2 was processed.

DCC MCP Indicator

Added On: 09/08/15

SQL Column: DCC_MCP_INDICATOR

Java Field: dccMcpIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Denial Code

Added On: 09/08/15

SQL Column: DENIAL_CODE

Java Field: denialCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Decline code generated by the processor.

Draft Locator

Added On: 07/26/16

SQL Column: DRAFT_LOCATOR

Java Field: draftLocator

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

EMV Offline Transaction Flag

Added On: 09/08/15

SQL Column: EMV_OFFLINE_TRANSACTION_FLAG

Java Field: emvOfflineTransactionFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates that the terminal processes offline EMV transactions.

EMV Transaction Flag

Added On: 09/08/15

SQL Column: EMV_TRANSACTION_FLAG

Java Field: emvTransactionFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates that the transaction is EMV.

EMV Transaction Indicator

Added On: 07/26/16

SQL Column: EMV_TRANSACTION_INDICATOR

Java Field: emvTransactionIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Error Code

Added On: 09/08/15

SQL Column: ERROR_CODE

Java Field: errorCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Error code generated by the system.

Expiration Date

Added On: 09/08/15

SQL Column: EXPIRATION_DATE

Java Field: expirationDate

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Expiration date of the card.

Franchise Card Transaction Flag

Added On: 09/08/15

SQL Column: FRANCHISE_CARD_TRANSACTION_FLAG

Java Field: franchiseCardTransactionFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates whether the transaction is submitted with a francise card.

Franchise Program Type

Added On: 09/08/15

SQL Column: FRANCHISE_PROGRAM_TYPE

Java Field: franchiseProgramType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

From Account Type

Added On: 09/08/15

SQL Column: FROM_ACCOUNT_TYPE

Java Field: fromAccountType

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

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

ID Number

Added On: 09/08/15

SQL Column: ID_NUMBER

Java Field: idNumber

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

ID State Code

Added On: 09/08/15

SQL Column: ID_STATE_CODE

Java Field: idStateCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Interchange Adjustment Amount

Added On: 09/08/15

SQL Column: INTERCHANGE_ADJUSTMENT_AMOUNT

Java Field: interchangeAdjustmentAmount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Amount of the interchange adjustment.

Interchange Adjustment Reason Code

Added On: 09/08/15

SQL Column: INTERCHANGE_ADJUSTMENT_REASON_CODE

Java Field: interchangeAdjustmentReasonCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Reason code associated with the interchange adjustment.

Interchange Adjustment Sign

Added On: 09/08/15

SQL Column: INTERCHANGE_ADJUSTMENT_SIGN

Java Field: interchangeAdjustmentSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Interchange Amount

Added On: 09/08/15

SQL Column: INTERCHANGE_AMOUNT

Java Field: interchangeAmount

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

Amount of an interchange assigned to the transaction.

Interchange Amount Sign

Added On: 09/08/15

SQL Column: INTERCHANGE_AMOUNT_SIGN

Java Field: interchangeAmountSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Interchange Code

Added On: 09/08/15

SQL Column: INTERCHANGE_CODE

Java Field: interchangeCode

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Code of an interchange assigned to the transaction.

Magnetic Stripe

Added On: 09/08/15

SQL Column: MAGNETIC_STRIPE

Java Field: magneticStripe

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Mail Phone Indicator

Added On: 09/08/15

SQL Column: MAIL_PHONE_INDICATOR

Java Field: mailPhoneIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates whether mail of phone is used as a primary contact.

Master Card Banknet Reference Number

Added On: 09/08/15

SQL Column: MASTER_CARD_BANKNET_REFERENCE_NUMBER

Java Field: masterCardBanknetReferenceNumber

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Identifier of the MasterCard transaction.

Master Card Banknet Settlement Date

Added On: 09/08/15

SQL Column: MASTER_CARD_BANKNET_SETTLEMENT_DATE

Java Field: masterCardBanknetSettlementDate

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Date when a MasterCard transaction is settled.

MCC Code

Added On: 09/08/15

SQL Column: MCC_CODE

Java Field: mccCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

MCC code of the merchant.

Merchant Account Code

Added On: 09/08/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 Discretionary1

Added On: 07/26/16

SQL Column: MERCHANT_DISCRETIONARY1

Java Field: merchantDiscretionary1

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Merchant Discretionary2

Added On: 07/26/16

SQL Column: MERCHANT_DISCRETIONARY2

Java Field: merchantDiscretionary2

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Merchant Discretionary3

Added On: 07/26/16

SQL Column: MERCHANT_DISCRETIONARY3

Java Field: merchantDiscretionary3

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Merchant Reference Number

Added On: 09/08/15

SQL Column: MERCHANT_REFERENCE_NUMBER

Java Field: merchantReferenceNumber

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Secondary identifier of the merchant that can be used to cross-reference records between UniPay and integrated systems.

Network

Added On: 09/08/15

SQL Column: NETWORK

Java Field: network

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Name of the network.

Network Reference Number

Added On: 09/08/15

SQL Column: NETWORK_REFERENCE_NUMBER

Java Field: networkReferenceNumber

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Secondary identifier of the network that can be used to cross-reference records between UniPay and integrated systems.

Old Authorized Amount

Added On: 09/08/15

SQL Column: OLD_AUTHORIZED_AMOUNT

Java Field: oldAuthorizedAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Previuosly authorized amount of the transaction.

On US Transaction

Added On: 09/08/15

SQL Column: ON_US_TRANSACTION

Java Field: onUsTransaction

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

On US Transaction Flag

Added On: 09/08/15

SQL Column: ON_US_TRANSACTION_FLAG

Java Field: onUsTransactionFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Origin Type

Added On: 09/08/15

SQL Column: ORIGIN_TYPE

Java Field: originType

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Type of the processor.

Original Amount

Added On: 09/08/15

SQL Column: ORIGINAL_AMOUNT

Java Field: originalAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Original Amount Sign

Added On: 09/08/15

SQL Column: ORIGINAL_AMOUNT_SIGN

Java Field: originalAmountSign

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Original Interchange Indicator

Added On: 09/08/15

SQL Column: ORIGINAL_INTERCHANGE_INDICATOR

Java Field: originalInterchangeIndicator

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Specific identifier assigned by the processor.

Original Transaction Date

Added On: 09/08/15

SQL Column: ORIGINAL_TRANSACTION_DATE

Java Field: originalTransactionDate

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Original Transaction Reference Number

Added On: 09/08/15

SQL Column: ORIGINAL_TRANSACTION_REFERENCE_NUMBER

Java Field: originalTransactionReferenceNumber

Status: Active

SQL Type: varchar(23)

Java Type: String

Attributes:

Identifier of the transaction.

Original Transaction Time

Added On: 09/08/15

SQL Column: ORIGINAL_TRANSACTION_TIME

Java Field: originalTransactionTime

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Originator

Added On: 09/08/15

SQL Column: ORIGINATOR

Java Field: originator

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Name of the transaction originator.

Originator Comments

Added On: 09/08/15

SQL Column: ORIGINATOR_COMMENTS

Java Field: originatorComments

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Additional information added by an originator.

PINless Ind

Added On: 07/26/16

SQL Column: PINLESS_IND

Java Field: pinlessInd

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates whether a PINless debit card is used.

POS Condition Code

Added On: 09/08/15

SQL Column: POS_CONDITION_CODE

Java Field: posConditionCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Identifier of the POS system condition.

POS Entry Mode

Added On: 09/08/15

SQL Column: POS_ENTRY_MODE

Java Field: posEntryMode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Entry mode of the card used in the POS system.

Program Agent

Added On: 09/08/15

SQL Column: PROGRAM_AGENT

Java Field: programAgent

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Program Identifier

Added On: 09/08/15

SQL Column: PROGRAM_IDENTIFIER

Java Field: programIdentifier

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Raw Data

Added On: 04/12/19

SQL Column: RAW_DATA

Java Field: rawData

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes: Transient

Receiver

Added On: 09/08/15

SQL Column: RECEIVER

Java Field: receiver

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Name of the transaction receiver.

Receiver Comments

Added On: 09/08/15

SQL Column: RECEIVER_COMMENTS

Java Field: receiverComments

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Additional information added by a receiver.

Added On: 09/08/15

SQL Column: REGISTER_NUMBER

Java Field: registerNumber

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Remaining Balance

Added On: 09/08/15

SQL Column: REMAINING_BALANCE

Java Field: remainingBalance

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Remaining Balance Amount

Added On: 09/08/15

SQL Column: REMAINING_BALANCE_AMOUNT

Java Field: remainingBalanceAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount of the remaining balance of the card.

Requested Authorization Amount

Added On: 07/26/16

SQL Column: REQUESTED_AUTHORIZATION_AMOUNT

Java Field: requestedAuthorizationAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount of the authorized transaction.

Requested Settled Amount

Added On: 07/26/16

SQL Column: REQUESTED_SETTLED_AMOUNT

Java Field: requestedSettledAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount of the settled transaction.

Retrieval Reference Number

Added On: 09/08/15

SQL Column: RETRIEVAL_REFERENCE_NUMBER

Java Field: retrievalReferenceNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Identifier of the transaction.

RTC Settlement Type

Added On: 09/08/15

SQL Column: RTC_SETTLEMENT_TYPE

Java Field: rtcSettlementType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Type of the RTC settlement.

Sales Person

Added On: 09/08/15

SQL Column: SALES_PERSON

Java Field: salesPerson

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Name of the sales person associated with the transaction.

SKU Number

Added On: 09/08/15

SQL Column: SKU_NUMBER

Java Field: skuNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

SKU number assigned by a processor.

Surcharge Amount

Added On: 07/26/16

SQL Column: SURCHARGE_AMOUNT

Java Field: surchargeAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Amount of the surcharge.

Terminal EMV Capability Flag

Added On: 09/08/15

SQL Column: TERMINAL_EMV_CAPABILITY_FLAG

Java Field: terminalEmvCapabilityFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates that the terminal accepts EMV transactions.

Terminal ID

Added On: 09/08/15

SQL Column: TERMINAL_ID

Java Field: terminalId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Identifier of the terminal assigned by the processor.

Terminal Location

Added On: 09/08/15

SQL Column: TERMINAL_LOCATION

Java Field: terminalLocation

Status: Active

SQL Type: varchar(44)

Java Type: String

Attributes:

Terminal Number

Added On: 09/08/15

SQL Column: TERMINAL_NUMBER

Java Field: terminalNumber

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Code of the terminal assigned within the system.

Terminal Sequence Number

Added On: 09/08/15

SQL Column: TERMINAL_SEQUENCE_NUMBER

Java Field: terminalSequenceNumber

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Sequence number of the terminal.

Token

Added On: 09/08/15

SQL Column: TOKEN

Java Field: token

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Token value replacing account number.

Token ID

Added On: 09/08/15

SQL Column: TOKEN_ID

Java Field: tokenId

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Identifier of the token.

Transaction Amount

Added On: 07/26/16

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount of the transaction.

Transaction Date

Added On: 09/08/15

SQL Column: TRANSACTION_DATE

Java Field: transactionDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Actual date of the transaction.

Transaction Date Date

Added On: 02/13/17

SQL Column: TRANSACTION_DATE_DATE

Java Field: transactionDateDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Transaction Disposition

Added On: 09/08/15

SQL Column: TRANSACTION_DISPOSITION

Java Field: transactionDisposition

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

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 Origin Flag

Added On: 09/08/15

SQL Column: TRANSACTION_ORIGIN_FLAG

Java Field: transactionOriginFlag

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Transaction Sequence Number

Added On: 07/26/16

SQL Column: TRANSACTION_SEQUENCE_NUMBER

Java Field: transactionSequenceNumber

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Transaction Time

Added On: 09/08/15

SQL Column: TRANSACTION_TIME

Java Field: transactionTime

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Actual time of the transaction.

Transaction Type Code

Added On: 09/08/15

SQL Column: TRANSACTION_TYPE_CODE

Java Field: transactionTypeCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Type of the transaction.

Vantiv Tandem Processing Cost Batch FK

Added On: 06/17/16

SQL Column: VANTIV_TANDEM_PROCESSING_COST_BATCH_FK

Java Field: vantivTandemProcessingCostBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Vantiv Tandem Processing Cost Batch

Attributes:

http://unidoc.unitedthinkers.com/help/field/b1fed2fb5cb81cb781eb5b6243ca844439a11a85a0f9dee79073b145f31e0ffdaf936fb654104c86a80f52d8e59fadbfb0ca5745cf65e6d5bd2cb7afcbebc927

Visa Authorization Response Code

Added On: 09/08/15

SQL Column: VISA_AUTHORIZATION_RESPONSE_CODE

Java Field: visaAuthorizationResponseCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Response code associated with a Visa authorization request generated by the processor.

Visa Card Level Results

Added On: 09/08/15

SQL Column: VISA_CARD_LEVEL_RESULTS

Java Field: visaCardLevelResults

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Result of the Visa card verification.

Visa Transaction ID

Added On: 09/08/15

SQL Column: VISA_TRANSACTION_ID

Java Field: visaTransactionId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Identifier of the Visa transaction.

Visa Validation Code

Added On: 09/08/15

SQL Column: VISA_VALIDATION_CODE

Java Field: visaValidationCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Validation code of the Visa transaction.

Void Indicator

Added On: 09/08/15

SQL Column: VOID_INDICATOR

Java Field: voidIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates whether the void is required.