Paymentech UTF Auth Retail Transaction UML

Added On: 02/01/13

SQL Table: PAYMENTECH_UTF_AUTH_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: PaymentechUtfAuthRetailTransaction

Paymentech UTF specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, Paymentech UTF specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.

Available Fields:

Account Number
AI Application Identifier
AV Cardholder Street Address
AV Cardholder Zip Code
AV Extended Cardholder Street Address
Charge Transaction FK
Client Number
Cr Card Authentication Results Code Request
Cr Card Authentication Results Code Response
Dl Download Flag
DUKPT KSN
DUKPT PIN
Em Chip Card Data Length
em Chip Card Data Length Response
Em Chip Card Data Request
Em Chip Card Data Response
Entry Data Source
Exp Date
Host
IC Authorization Characteristics Indicator
IC MC Bank Net Date
IC MC Bank Net Reference Number
IC MC CVC Error Indicator
IC MC CVC Status Change
IC MC Magnetic Stripe Quality Indicator
IC MC Merchant Category Code
IC Visa Authorization Response Code
IC Visa AVS Response Code
IC Visa Commercial Card Type
IC Visa Merchant Category Code
IC Visa POS Entry Mode
IC Visa Total Authorization Amount
IC Visa Transaction Id
IC Visa Validation Code
Id
Industry Card Sequence Number
Industry Card Total Number
Industry Cash Out Indicator
Industry Charge Description
Industry Code
Industry Ecommerce Goods Indicator
Industry Electronic Commerce Indicator
Industry Employee Number
Industry Invoice Number

Industry Item Code
Industry Reference Code
Industry Server Number
Industry Tip Amount
Industry Type Indicator
Last Retrieval Reference Number
Market Specific Data Indicator
Merchant Account Code
Merchant Number
Misc Authorization Code
Misc Cash Back Amount
Misc EBT Type Code
Misc Retrieval Reference Number
Password
PIN Capability Code
Port
Ps Pan Sequence
Purchase Customer Reference Number
Purchase Destination Zip
Purchase Local Tax Flag
Purchase Sales Tax Amount
Request Token Data
Request Token Data Ext
Response Action Code
Response Address Verification Code
Response Authorization Error Code
Response Authorization Source
Response Authorizing Network Id
Response Batch Number
Response Beginning Balance
Response Card Type
Response Cash Available Balance
Response Cash Beginning Balance
Response Cash Ledger Balance
Response Fs Available Balance
Response Fs Ledger Balance
Response Message
Response Retrieval Reference Number
Response Surcharge Fee Amount
Response Trace Number
Retail Transaction Cycle FK
Sequence Number
System Indicator
Terminal Number

Tk Ac Cid Response Value
Tk At Transaction Identifier
Tk B 1 Current Balance Amount
Tk B 3 Previous Balance Amount
Tk B 4 Approved Amount
Tk B 5 Cash Out Amount
Tk B 6 Available Balance 1 Amount
Tk B 7 Available Balance 2 Amount
TK B6 Available Balance1 Currency Code
TK B7 Available Balance2 Currency Code
TK CB Credit Cash Back Over Amount
Tk Ck Forced Current Key Request
Tk Ck Mac Encryption Key
Tk Ck Pin Encryption Key
Tk Cm Visa Cvv Results Code
TK CV Response Value
TK DA Auth Amount
TK DA AVS Response Code
TK DA CID Response Code
TK DA PIN Capability Code
TK DA POS Entry Mode
TK DA Processing Code
TK DA System Trace Audit Number
TK DA Track Data Condition Code
Tk Dt Host Time
Tk Ek Encrypted Key Index
TK ER Failed Token Indicator
Tk Mc Mac
Tk Mu Submitted Transaction Identifier
TK PC Information Response Indicator
Tk PC Response Value
Tk Pd Authorizer Pos Data Code
TK Q8 Authorization Type Code
TK Q8 Authorized Amount
TK Q8 Card Type
TK RN POS Retrieval Reference Number
TK VB CAVV Response Data
TK VC Visa Card Level Results Code
Tk Vs Spend Qualified Results Code
Track Data
Transaction Amount
Transaction Code
Transaction Sequence Flag
Ts Transaction Sequence Counter

User ID

Account Number

Added On: 04/16/15

SQL Column:

Java Field: accountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

The identifier of the merchant within the system of the company serving as the business reference. Normally, a unique value, that is used to locate the information about the merchant within the system of the business reference.

AI Application Identifier

Added On: 04/16/15

SQL Column: AI_APPLICATION_IDENTIFIER

Java Field: aiApplicationIdentifier

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

AV Cardholder Street Address

Added On: 02/01/13

SQL Column: AV_CARDHOLDER_STREET_ADDRESS

Java Field: avCardholderStreetAddress

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

AV Cardholder Zip Code

Added On: 02/01/13

SQL Column: AV_CARDHOLDER_ZIP_CODE

Java Field: avCardholderZipCode

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

AV Extended Cardholder Street Address

Added On: 02/01/13

SQL Column: AV_EXTENDED_CARDHOLDER_STREET_ADDRESS

Java Field: avExtendedCardholderStreetAddress

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Charge Transaction FK

Added On: 02/01/13

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.

Client Number

Added On: 02/01/13

SQL Column: CLIENT_NUMBER

Java Field: clientNumber

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Cr Card Authentication Results Code Request

Added On: 04/16/15

SQL Column: CR_CARD_AUTHENTICATION_RESULTS_CODE_REQUEST

Java Field: crCardAuthenticationResultsCodeRequest

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Cr Card Authentication Results Code Response

Added On: 04/16/15

SQL Column: CR_CARD_AUTHENTICATION_RESULTS_CODE_RESPONSE

Java Field: crCardAuthenticationResultsCodeResponse

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Dl Download Flag

Added On: 04/16/15

SQL Column: DL_DOWNLOAD_FLAG

Java Field: dlDownloadFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

DUKPT KSN

Added On: 07/14/16

SQL Column:

Java Field: dukptKsn

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

DUKPT PIN

Added On: 04/16/15

SQL Column:

Java Field: dukptPin

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Em Chip Card Data Length

Added On: 04/16/15

SQL Column:

Java Field: emChipCardDataLength

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

em Chip Card Data Length Response

Added On: 04/16/15

SQL Column:

Java Field: emChipCardDataLengthResponse

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Em Chip Card Data Request

Added On: 04/16/15

SQL Column:

Java Field: emChipCardDataRequest

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Em Chip Card Data Response

Added On: 04/16/15

SQL Column:

Java Field: emChipCardDataResponse

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Entry Data Source

Added On: 02/01/13

SQL Column: ENTRY_DATA_SOURCE

Java Field: entryDataSource

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Exp Date

Added On: 04/16/15

SQL Column:

Java Field: expDate

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Expiration date of a credit card.

Host

Added On: 08/18/17

SQL Column: HOST

Java Field: host

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes: Transient

Provider's host

IC Authorization Characteristics Indicator

Added On: 02/01/13

SQL Column: IC_AUTHORIZATION_CHARACTERISTICS_INDICATOR

Java Field: icAuthorizationCharacteristicsIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

IC MC Bank Net Date

Added On: 02/01/13

SQL Column: IC_MC_BANK_NET_DATE

Java Field: icMcBankNetDate

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

IC MC Bank Net Reference Number

Added On: 02/01/13

SQL Column: IC_MC_BANK_NET_REFERENCE_NUMBER

Java Field: icMcBankNetReferenceNumber

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

IC MC CVC Error Indicator

Added On: 02/01/13

SQL Column: IC_MC_CVC_ERROR_INDICATOR

Java Field: icMcCvcErrorIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

IC MC CVC Status Change

Added On: 02/01/13

SQL Column: IC_MC_CVC_STATUS_CHANGE

Java Field: icMcCvcStatusChange

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

IC MC Magnetic Stripe Quality Indicator

Added On: 02/01/13

SQL Column: IC_MC_MAGNETIC_STRIPE_QUALITY_INDICATOR

Java Field: icMcMagneticStripeQualityIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

IC MC Merchant Category Code

Added On: 02/01/13

SQL Column: IC_MC_MERCHANT_CATEGORY_CODE

Java Field: icMcMerchantCategoryCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

IC Visa Authorization Response Code

Added On: 02/01/13

SQL Column: IC_VISA_AUTHORIZATION_RESPONSE_CODE

Java Field: icVisaAuthorizationResponseCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

IC Visa AVS Response Code

Added On: 02/01/13

SQL Column: IC_VISA_AVS_RESPONSE_CODE

Java Field: icVisaAvsResponseCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

IC Visa Commercial Card Type

Added On: 02/01/13

SQL Column: IC_VISA_COMMERCIAL_CARD_TYPE

Java Field: icVisaCommercialCardType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

IC Visa Merchant Category Code

Added On: 02/01/13

SQL Column: IC_VISA_MERCHANT_CATEGORY_CODE

Java Field: icVisaMerchantCategoryCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

IC Visa POS Entry Mode

Added On: 02/01/13

SQL Column: IC_VISA_POS_ENTRY_MODE

Java Field: icVisaPosEntryMode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

IC Visa Total Authorization Amount

Added On: 02/01/13

SQL Column: IC_VISA_TOTAL_AUTHORIZATION_AMOUNT

Java Field: icVisaTotalAuthorizationAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

IC Visa Transaction Id

Added On: 02/01/13

SQL Column: IC_VISA_TRANSACTION_ID

Java Field: icVisaTransactionId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

IC Visa Validation Code

Added On: 02/01/13

SQL Column: IC_VISA_VALIDATION_CODE

Java Field: icVisaValidationCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Added On: 02/01/13

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.

Industry Card Sequence Number

Added On: 02/01/13

SQL Column: INDUSTRY_CARD_SEQUENCE_NUMBER

Java Field: industryCardSequenceNumber

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Industry Card Total Number

Added On: 02/01/13

SQL Column: INDUSTRY_CARD_TOTAL_NUMBER

Java Field: industryCardTotalNumber

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Industry Cash Out Indicator

Added On: 02/01/13

SQL Column: INDUSTRY_CASH_OUT_INDICATOR

Java Field: industryCashOutIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Industry Charge Description

Added On: 02/01/13

SQL Column: INDUSTRY_CHARGE_DESCRIPTION

Java Field: industryChargeDescription

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Industry Code

Added On: 02/01/13

SQL Column: INDUSTRY_CODE

Java Field: industryCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Industry Ecommerce Goods Indicator

Added On: 02/01/13

SQL Column: INDUSTRY_ECOMMERCE_GOODS_INDICATOR

Java Field: industryEcommerceGoodsIndicator

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Industry Electronic Commerce Indicator

Added On: 02/01/13

SQL Column: INDUSTRY_ELECTRONIC_COMMERCE_INDICATOR

Java Field: industryElectronicCommerceIndicator

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Industry Employee Number

Added On: 02/01/13

SQL Column: INDUSTRY_EMPLOYEE_NUMBER

Java Field: industryEmployeeNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Industry Invoice Number

Added On: 02/01/13

SQL Column: INDUSTRY_INVOICE_NUMBER

Java Field: industryInvoiceNumber

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Industry Item Code

Added On: 02/01/13

SQL Column: INDUSTRY_ITEM_CODE

Java Field: industryItemCode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Industry Reference Code

Added On: 02/01/13

SQL Column: INDUSTRY_REFERENCE_CODE

Java Field: industryReferenceCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Industry Server Number

Added On: 02/01/13

SQL Column: INDUSTRY_SERVER_NUMBER

Java Field: industryServerNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Industry Tip Amount

Added On: 02/01/13

SQL Column: INDUSTRY_TIP_AMOUNT

Java Field: industryTipAmount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Industry Type Indicator

Added On: 02/01/13

SQL Column: INDUSTRY_TYPE_INDICATOR

Java Field: industryTypeIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Last Retrieval Reference Number

Added On: 02/01/13

SQL Column: LAST_RETRIEVAL_REFERENCE_NUMBER

Java Field: lastRetrievalReferenceNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Market Specific Data Indicator

Added On: 02/01/13

SQL Column: MARKET_SPECIFIC_DATA_INDICATOR

Java Field: marketSpecificDataIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Merchant Account Code

Added On: 02/01/13

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 Number

Added On: 02/01/13

SQL Column: MERCHANT_NUMBER

Java Field: merchantNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Misc Authorization Code

Added On: 02/01/13

SQL Column: MISC_AUTHORIZATION_CODE

Java Field: miscAuthorizationCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Misc Cash Back Amount

Added On: 02/01/13

SQL Column: MISC_CASH_BACK_AMOUNT

Java Field: miscCashBackAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Misc EBT Type Code

Added On: 02/01/13

SQL Column: MISC_EBT_TYPE_CODE

Java Field: miscEbtTypeCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Misc Retrieval Reference Number

Added On: 02/01/13

SQL Column: MISC_RETRIEVAL_REFERENCE_NUMBER

Java Field: miscRetrievalReferenceNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Password

Added On: 04/16/15

SQL Column:

Java Field: password

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

PIN Capability Code

Added On: 02/01/13

SQL Column: PIN_CAPABILITY_CODE

Java Field: pinCapabilityCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Port

Added On: 08/18/17

SQL Column: PORT

Java Field: port

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes: Transient

Ps Pan Sequence

Added On: 04/16/15

SQL Column: PS_PAN_SEQUENCE

Java Field: psPanSequence

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Purchase Customer Reference Number

Added On: 02/01/13

SQL Column: PURCHASE_CUSTOMER_REFERENCE_NUMBER

Java Field: purchaseCustomerReferenceNumber

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Purchase Destination Zip

Added On: 02/01/13

SQL Column: PURCHASE_DESTINATION_ZIP

Java Field: purchaseDestinationZip

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Purchase Local Tax Flag

Added On: 02/01/13

SQL Column: PURCHASE_LOCAL_TAX_FLAG

Java Field: purchaseLocalTaxFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Purchase Sales Tax Amount

Added On: 02/01/13

SQL Column: PURCHASE_SALES_TAX_AMOUNT

Java Field: purchaseSalesTaxAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Request Token Data

Added On: 02/01/13

SQL Column: REQUEST_TOKEN_DATA

Java Field: requestTokenData

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes: Transient

Request Token Data Ext

Added On: 04/16/15

SQL Column:

Java Field: requestTokenDataExt

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Response Action Code

Added On: 02/01/13

SQL Column: RESPONSE_ACTION_CODE

Java Field: responseActionCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Response Address Verification Code

Added On: 02/01/13

SQL Column: RESPONSE_ADDRESS_VERIFICATION_CODE

Java Field: responseAddressVerificationCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Response Authorization Error Code

Added On: 02/01/13

SQL Column: RESPONSE_AUTHORIZATION_ERROR_CODE

Java Field: responseAuthorizationErrorCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Response Authorization Source

Added On: 02/01/13

SQL Column: RESPONSE_AUTHORIZATION_SOURCE

Java Field: responseAuthorizationSource

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Response Authorizing Network Id

Added On: 02/01/13

SQL Column: RESPONSE_AUTHORIZING_NETWORK_ID

Java Field: responseAuthorizingNetworkId

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Response Batch Number

Added On: 02/01/13

SQL Column: RESPONSE_BATCH_NUMBER

Java Field: responseBatchNumber

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Response Beginning Balance

Added On: 02/01/13

SQL Column: RESPONSE_BEGINNING_BALANCE

Java Field: responseBeginningBalance

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Response Card Type

Added On: 02/01/13

SQL Column: RESPONSE_CARD_TYPE

Java Field: responseCardType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Response Cash Available Balance

Added On: 02/01/13

SQL Column: RESPONSE_CASH_AVAILABLE_BALANCE

Java Field: responseCashAvailableBalance

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Response Cash Beginning Balance

Added On: 02/01/13

SQL Column: RESPONSE_CASH_BEGINNING_BALANCE

Java Field: responseCashBeginningBalance

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Response Cash Ledger Balance

Added On: 02/01/13

SQL Column: RESPONSE_CASH_LEDGER_BALANCE

Java Field: responseCashLedgerBalance

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Response Fs Available Balance

Added On: 02/01/13

SQL Column: RESPONSE_FS_AVAILABLE_BALANCE

Java Field: responseFsAvailableBalance

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Response Fs Ledger Balance

Added On: 02/01/13

SQL Column: RESPONSE_FS_LEDGER_BALANCE

Java Field: responseFsLedgerBalance

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Response Message

Added On: 02/01/13

SQL Column: RESPONSE_MESSAGE

Java Field: responseMessage

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Response Retrieval Reference Number

Added On: 02/01/13

SQL Column: RESPONSE_RETRIEVAL_REFERENCE_NUMBER

Java Field: responseRetrievalReferenceNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Response Surcharge Fee Amount

Added On: 02/01/13

SQL Column: RESPONSE_SURCHARGE_FEE_AMOUNT

Java Field: responseSurchargeFeeAmount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Response Trace Number

Added On: 02/01/13

SQL Column: RESPONSE_TRACE_NUMBER

Java Field: responseTraceNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Retail Transaction Cycle FK

Added On: 02/01/13

SQL Column: RETAIL_TRANSACTION_CYCLE_FK

Java Field: retailTransactionCycle

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Retail Transaction Cycle

Attributes:

Reference to the entity that represents a group of real-time transactions which must be settled together.

Sequence Number

Added On: 02/01/13

SQL Column: SEQUENCE_NUMBER

Java Field: sequenceNumber

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

System Indicator

Added On: 02/01/13

SQL Column: SYSTEM_INDICATOR

Java Field: systemIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Terminal Number

Added On: 02/01/13

SQL Column: TERMINAL_NUMBER

Java Field: terminalNumber

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Tk Ac Cid Response Value

Added On: 02/01/13

SQL Column: TK_AC_CID_RESPONSE_VALUE

Java Field: tkAcCidResponseValue

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Tk At Transaction Identifier

Added On: 02/01/13

SQL Column: TK_AT_TRANSACTION_IDENTIFIER

Java Field: tkAtTransactionIdentifier

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Tk B 1 Current Balance Amount

Added On: 02/01/13

SQL Column: TK_B1_CURRENT_BALANCE_AMOUNT

Java Field: tkB1CurrentBalanceAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Tk B 3 Previous Balance Amount

Added On: 02/01/13

SQL Column: TK_B3_PREVIOUS_BALANCE_AMOUNT

Java Field: tkB3PreviousBalanceAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Tk B 4 Approved Amount

Added On: 02/04/13

SQL Column: TK_B4_APPROVED_AMOUNT

Java Field: tkB4ApprovedAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Tk B 5 Cash Out Amount

Added On: 02/01/13

SQL Column: TK_B5_CASH_OUT_AMOUNT

Java Field: tkB5CashOutAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Tk B 6 Available Balance 1 Amount

Added On: 02/01/13

SQL Column: TK_B6_AVAILABLE_BALANCE1_AMOUNT

Java Field: tkB6AvailableBalance1Amount

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

Tk B 7 Available Balance 2 Amount

Added On: 02/01/13

SQL Column: TK_B7_AVAILABLE_BALANCE2_AMOUNT

Java Field: tkB7AvailableBalance2Amount

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

TK B6 Available Balance1 Currency Code

Added On: 02/01/13

SQL Column: TK_B6_AVAILABLE_BALANCE1_CURRENCY_CODE

Java Field: tkB6AvailableBalance1CurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

TK B7 Available Balance2 Currency Code

Added On: 02/01/13

SQL Column: TK_B7_AVAILABLE_BALANCE2_CURRENCY_CODE

Java Field: tkB7AvailableBalance2CurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

TK CB Credit Cash Back Over Amount

Added On: 02/01/13

SQL Column: TK_CB_CREDIT_CASH_BACK_OVER_AMOUNT

Java Field: tkCbCreditCashBackOverAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Tk Ck Forced Current Key Request

Added On: 08/18/17

SQL Column: TK_CK_FORCED_CURRENT_KEY_REQUEST

Java Field: tkCkForcedCurrentKeyRequest

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Tk Ck Mac Encryption Key

Added On: 08/18/17

SQL Column: TK_CK_MAC_ENCRYPTION_KEY

Java Field: tkCkMacEncryptionKey

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes: Transient

Tk Ck Pin Encryption Key

Added On: 08/18/17

SQL Column: TK_CK_PIN_ENCRYPTION_KEY

Java Field: tkCkPinEncryptionKey

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes: Transient

Tk Cm Visa Cvv Results Code

Added On: 02/01/13

SQL Column: TK_CM_VISA_CVV_RESULTS_CODE

Java Field: tkCmVisaCvvResultsCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

TK CV Response Value

Added On: 02/01/13

SQL Column: TK_CV_RESPONSE_VALUE

Java Field: tkCvResponseValue

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

TK DA Auth Amount

Added On: 02/01/13

SQL Column: TK_DA_AUTH_AMOUNT

Java Field: tkDaAuthAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

TK DA AVS Response Code

Added On: 02/01/13

SQL Column: TK_DA_AVS_RESPONSE_CODE

Java Field: tkDaAvsResponseCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

TK DA CID Response Code

Added On: 02/01/13

SQL Column: TK_DA_CID_RESPONSE_CODE

Java Field: tkDaCidResponseCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

TK DA PIN Capability Code

Added On: 02/01/13

SQL Column: TK_DA_PIN_CAPABILITY_CODE

Java Field: tkDaPinCapabilityCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

TK DA POS Entry Mode

Added On: 02/01/13

SQL Column: TK_DA_POS_ENTRY_MODE

Java Field: tkDaPosEntryMode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

TK DA Processing Code

Added On: 02/01/13

SQL Column: TK_DA_PROCESSING_CODE

Java Field: tkDaProcessingCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

TK DA System Trace Audit Number

Added On: 02/01/13

SQL Column: TK_DA_SYSTEM_TRACE_AUDIT_NUMBER

Java Field: tkDaSystemTraceAuditNumber

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

TK DA Track Data Condition Code

Added On: 02/01/13

SQL Column: TK_DA_TRACK_DATA_CONDITION_CODE

Java Field: tkDaTrackDataConditionCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Tk Dt Host Time

Added On: 08/18/17

SQL Column: TK_DT_HOST_TIME

Java Field: tkDtHostTime

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

Tk Ek Encrypted Key Index

Added On: 08/18/17

SQL Column: TK_EK_ENCRYPTED_KEY_INDEX

Java Field: tkEkEncryptedKeyIndex

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

TK ER Failed Token Indicator

Added On: 02/01/13

SQL Column: TK_ER_FAILED_TOKEN_INDICATOR

Java Field: tkErFailedTokenIndicator

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Tk Mc Mac

Added On: 08/18/17

SQL Column: TK_MC_MAC

Java Field: tkMcMac

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes: Transient

Tk Mu Submitted Transaction Identifier

Added On: 06/06/18

SQL Column: TK_MU_SUBMITTED_TRANSACTION_IDENTIFIER

Java Field: tkMuSubmittedTransactionIdentifier

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

TK PC Information Response Indicator

Added On: 02/01/13

SQL Column: TK_PC_INFORMATION_RESPONSE_INDICATOR

Java Field: tkPcInformationResponseIndicator

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Tk PC Response Value

Added On: 02/01/13

SQL Column: TK_PC_RESPONSE_VALUE

Java Field: tkPcResponseValue

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Tk Pd Authorizer Pos Data Code

Added On: 02/01/13

SQL Column: TK_PD_AUTHORIZER_POS_DATA_CODE

Java Field: tkPdAuthorizerPosDataCode

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

TK Q8 Authorization Type Code

Added On: 02/01/13

SQL Column: TK_Q8_AUTHORIZATION_TYPE_CODE

Java Field: tkQ8AuthorizationTypeCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

TK Q8 Authorized Amount

Added On: 02/01/13

SQL Column: TK_Q8_AUTHORIZED_AMOUNT

Java Field: tkQ8AuthorizedAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

TK Q8 Card Type

Added On: 02/01/13

SQL Column: TK_Q8_CARD_TYPE

Java Field: tkQ8CardType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

TK RN POS Retrieval Reference Number

Added On: 02/01/13

SQL Column: TK_RN_POS_RETRIEVAL_REFERENCE_NUMBER

Java Field: tkRnPosRetrievalReferenceNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

TK VB CAVV Response Data

Added On: 02/01/13

SQL Column: TK_VB_CAVV_RESPONSE_DATA

Java Field: tkVbCavvResponseData

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

TK VC Visa Card Level Results Code

Added On: 02/01/13

SQL Column: TK_VC_VISA_CARD_LEVEL_RESULTS_CODE

Java Field: tkVcVisaCardLevelResultsCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Tk Vs Spend Qualified Results Code

Added On: 08/18/17

SQL Column: TK_VS_SPEND_QUALIFIED_RESULTS_CODE

Java Field: tkVsSpendQualifiedResultsCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Track Data

Added On: 04/16/15

SQL Column:

Java Field: trackData

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Transaction Amount

Added On: 02/01/13

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Transaction Code

Added On: 02/01/13

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Transaction Sequence Flag

Added On: 02/01/13

SQL Column: TRANSACTION_SEQUENCE_FLAG

Java Field: transactionSequenceFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Ts Transaction Sequence Counter

Added On: 04/16/15

SQL Column: TS_TRANSACTION_SEQUENCE_COUNTER

Java Field: tsTransactionSequenceCounter

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

User ID

Added On: 04/16/15

SQL Column:

Java Field: userId

Status: Active

SQL Type:

Java Type: String

Attributes: Transient