Evo Auth Retail Transaction UML


Added On:  12/28/15 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  EvoAuthRetailTransaction 
EVO Snap specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, EVO Snap specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Available Fields:
Added On:  12/29/15
SQL Column:  ACCOUNT_TYPE
Java Field:  accountType
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Type of the account.
Added On:  12/29/15
SQL Column:  ACTUAL_RESULT
Java Field:  actualResult
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Specifies the actual result of AVS from the service provider.
Added On:  12/29/15
SQL Column:  ADDRESS_RESULT
Java Field:  addressResult
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Specifies the result of AVS as it pertains to address matching.
Added On:  12/29/15
SQL Column:  ADVICE_RESPONSE
Java Field:  adviceResponse
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Specifies the reason for issuer decline of recurring payment transactions.
Added On:  12/29/15
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Amount of the transaction.
Added On:  12/29/15
SQL Column:  APPLICATION_PROFILE_ID
Java Field:  applicationProfileId
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Token representing the PTLS Socket ID unique to each Service Key and configuration data combination.
Added On:  12/29/15
SQL Column:  APPROVAL_CODE
Java Field:  approvalCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Approval code for this authorization.
Added On:  01/11/16
SQL Column:  AUTHORIZATION_SERVER_URL
Java Field:  authorizationServerUrl
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
UR address of the authorization server.
Added On:  12/29/15
SQL Column:  BASE_AMOUNT
Java Field:  baseAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Base amount of the transaction, not including freight, handling, and tax amounts.
Added On:  01/11/16
SQL Column:  BATCH_AMOUNT
Java Field:  batchAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Amount of batch transaction.
Added On:  12/29/15
SQL Column:  BATCH_ID
Java Field:  batchId
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Batch identifier.
Added On:  12/29/15
SQL Column:  BILL_PAYMENT
Java Field:  billPayment
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Indicates that the transaction is one in a set of recurring or installment transactions.
Added On:  12/29/15
SQL Column:  BUSINESS_NAME
Java Field:  businessName
Status:  Active
SQL Type:  varchar(38)
Java Type:  String
Attributes:
Business name of the merchant.
Added On:  12/29/15
SQL Column:  CAPTURE_AMOUNT
Java Field:  captureAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Amount of capture transaction.
Added On:  12/29/15
SQL Column:  CAPTURE_STATE
Java Field:  captureState
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
State of capture transaction.
Added On:  12/29/15
SQL Column:  CARD_LEVEL
Java Field:  cardLevel
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Code returned by the card association that indicates the type of card used by the customer.
Added On:  12/29/15
SQL Column:  CARD_TYPE
Java Field:  cardType
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
The card type used on the transaction.
Added On:  12/29/15
SQL Column:  CARDHOLDER_NAME
Java Field:  cardholderName
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Cardholder name embossed on the front of the card. Conditional, required if specified in AVSData.
Added On:  12/29/15
SQL Column:  CARDHOLDER_NAME_RESULT
Java Field:  cardholderNameResult
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Specifies the result of AVS as it pertains to cardholder name matching.
Added On:  12/29/15
SQL Column:  CASH_BACK_AMOUNT
Java Field:  cashBackAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Specifies a cash back amount for PIN Debit transactions.
Added On:  01/11/16
SQL Column:  CASH_BACK_TOTALS_COUNT
Java Field:  cashBackTotalsCount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The sum of all PIN Debit transaction cash back amounts included in the batch.
Added On:  01/11/16
SQL Column:  CASH_BACK_TOTALS_NET_AMOUNT
Java Field:  cashBackTotalsNetAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The sum of all PIN Debit transaction cash back net amounts included in the batch.
Added On:  12/29/15
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.
Added On:  12/29/15
SQL Column:  CHARGE_TYPE
Java Field:  chargeType
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Indicates the type of charge. In most retail environments this value is set to “RetailOther”, but if other enumerations are applicable they should be used.
Added On:  12/29/15
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City address of the cardholder used in AVS verification.
Added On:  12/29/15
SQL Column:  CITY_RESULT
Java Field:  cityResult
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Specifies the result of AVS as it pertains to city matching.
Added On:  12/29/15
SQL Column:  COMMERCIAL_CARD_RESPONSE
Java Field:  commercialCardResponse
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
Indicates the status of the card with respect to its ability to utilize purchase card data. When the card is a Business, Corporate, or Purchase card, providing purchase card data can result in improved interchange rates.
Added On:  12/29/15
SQL Column:  COMPANY_NAME
Java Field:  companyName
Status:  Active
SQL Type:  varchar(38)
Java Type:  String
Attributes:
Name of the company.
Added On:  12/29/15
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code of the cardholder used for AVS verification.
Added On:  12/29/15
SQL Column:  COUNTRY_RESULT
Java Field:  countryResult
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Specifies the result of AVS as it pertains to country matching.
Added On:  12/29/15
SQL Column:  CURRENCY_CODE
Java Field:  currencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Currency code as defined by the International Standards Organization (ISO).
Added On:  12/29/15
SQL Column:  CURRENT_INSTALLMENT_NUMBER
Java Field:  currentInstallmentNumber
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Current installment number.
Added On:  12/29/15
SQL Column:  CUSTOMER_PRESENT
Java Field:  customerPresent
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Presence of cardholder relative to the transaction point of service.
Added On:  12/29/15
SQL Column:  CUSTOMER_SERVICE_INTERNET
Java Field:  customerServiceInternet
Status:  Active
SQL Type:  varchar(64)
Java Type:  String
Attributes:
Service web URL or email address of the customer used for discussing any processing issues.
Added On:  12/29/15
SQL Column:  CUSTOMER_SERVICE_PHONE
Java Field:  customerServicePhone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Phone number used to discuss any processing issues.
Added On:  06/14/16
SQL Column:  
Java Field:  cvData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  12/29/15
SQL Column:  CV_DATA_PROVIDED
Java Field:  cvDataProvided
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Indicates whether or not CV data provided.
Added On:  12/29/15
SQL Column:  CV_RESULT
Java Field:  cvResult
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Response code returned by the card issuer indicating the result of Card Verification (CVV2/CVC2/CID).
Added On:  12/29/15
SQL Column:  DESCRIPTION
Java Field:  description
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Short description of the order.
Added On:  12/29/15
SQL Column:  DOWNGRADE_CODE
Java Field:  downgradeCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Downgrade reason.
Added On:  12/29/15
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email address of the merchant.
Added On:  12/29/15
SQL Column:  EMPLOYEE_ID
Java Field:  employeeId
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Clerk/cashier identifier.
Added On:  01/11/16
SQL Column:  
Java Field:  emvDataResponse
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
EMV data response.
Added On:  12/29/15
SQL Column:  ENTRY_MODE
Java Field:  entryMode
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
Indicates how the cardholder data was retrieved. When authorizing with stored card data, either locally or with PaymentAccountDataToken, indicates that the card data was manually collected (keyed or one of its variants).
Added On:  01/11/16
SQL Column:  ERROR_CODE
Java Field:  errorCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Code of the occured error.
Added On:  01/11/16
SQL Column:  ERROR_STRING
Java Field:  errorString
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Text message explaining the occured error.
Added On:  01/11/16
SQL Column:  ERROR_TYPE
Java Field:  errorType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Type of the occured error.
Added On:  01/18/16
SQL Column:  EXISTING_DEBT
Java Field:  existingDebt
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Amount of existing debt on the credit card.
Added On:  12/29/15
SQL Column:  
Java Field:  expire
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiration date of the credit card.
Added On:  12/29/15
SQL Column:  FEE_AMOUNT
Java Field:  feeAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Specifies the fee amount associated with an authorization, such as convenience fees.
Added On:  12/29/15
SQL Column:  FINAL_BALANCE
Java Field:  finalBalance
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The account balance after the transaction.
Added On:  12/29/15
SQL Column:  FIRST
Java Field:  first
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
First name of the customer.
Added On:  01/11/16
SQL Column:  FORCE_POST_CODE
Java Field:  forcePostCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Force post code information.
Added On:  01/11/16
SQL Column:  HOST_MESSAGE_ID
Java Field:  hostMessageId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
ID of the host message.
Added On:  12/28/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.
Added On:  12/29/15
SQL Column:  IDENTITY_TOKEN
Java Field:  identityToken
Status:  Active
SQL Type:  varchar(3260)
Java Type:  String
Attributes: Transient
Signed authentication tokens provided to merchants or other transaction originators to prevent the unauthorized use of an application.
Added On:  12/29/15
SQL Column:  INDUSTRY_TYPE
Java Field:  industryType
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
The industry type of the transaction(s).
Added On:  12/29/15
SQL Column:  INVOICE_NUMBER
Java Field:  invoiceNumber
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Informational field used to track invoice/receipt number.
Added On:  12/29/15
SQL Column:  IS_ACKNOWLEDGED
Java Field:  isAcknowledged
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Indicates if the transaction has been acknowledged by the client application.
Added On:  12/29/15
SQL Column:  IS_TAX_EXEMPT
Java Field:  isTaxExempt
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
Indicates tax exempt status of the transaction.
Added On:  12/29/15
SQL Column:  
Java Field:  keySerialNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Serial number of the key.
Added On:  12/29/15
SQL Column:  LANE_ID
Java Field:  laneId
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Identifies the cashier location at which the transaction occurred.
Added On:  12/29/15
SQL Column:  LAST
Java Field:  last
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Last name of the customer.
Added On:  01/11/16
SQL Column:  LAST_PAN_DIGITS
Java Field:  lastPanDigits
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Last PAN digits.
Added On:  01/11/16
SQL Column:  LEVEL3_ADDED
Java Field:  level3Added
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Level 3 added.
Added On:  12/29/15
SQL Column:  MASKED_PAN
Java Field:  maskedPan
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
The cardholder’s PAN in masked format.
Added On:  12/28/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.
Added On:  01/04/16
SQL Column:  MERCHANT_PROFILE_ID
Java Field:  merchantProfileId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Unique identifer for the merchant profile.
Added On:  01/11/16
SQL Column:  MESSAGE_AUTHENTICATION_CODE
Java Field:  messageAuthenticationCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Authentication code of the message.
Added On:  12/29/15
SQL Column:  NAME
Java Field:  name
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the merchant.
Added On:  01/11/16
SQL Column:  NET_TOTALS_COUNT
Java Field:  netTotalsCount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total count of transactions for the entire batch independent of transaction class.
Added On:  01/11/16
SQL Column:  NET_TOTALS_NET_AMOUNT
Java Field:  netTotalsNetAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total net amount of transactions for the entire batch independent of transaction class.
Added On:  12/29/15
SQL Column:  ORDER_ID
Java Field:  orderId
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
The order ID generated by CWS. This value is often used by service providers for transaction correlation.
Added On:  12/29/15
SQL Column:  ORDER_NUMBER
Java Field:  orderNumber
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Order number as assigned by the merchant.
Added On:  02/16/16
SQL Column:  ORDER_NUMBER_LEVEL2
Java Field:  orderNumberLevel2
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Order number.
Added On:  12/29/15
SQL Column:  ORIGINATOR_TRANSACTION_ID
Java Field:  originatorTransactionId
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
ID of the original transaction.
Added On:  12/29/15
SQL Column:  
Java Field:  pan
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
PAN code of the credit card.
Added On:  12/29/15
SQL Column:  PAYMENT_ACCOUNT_DATA_TOKEN
Java Field:  paymentAccountDataToken
Status:  Active
SQL Type:  varchar(73)
Java Type:  String
Attributes:
Token specified by a tokenization (offsite payment account data storage) service provider, used to retrieve securely stored payment account data.
Added On:  01/11/16
SQL Column:  PAYMENT_AUTHORIZATION_REQUEST
Java Field:  paymentAuthorizationRequest
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Payment authorization request.
Added On:  12/29/15
SQL Column:  PHONE
Java Field:  phone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Local telephone number of the cardholder used in AVS verification.
Added On:  12/29/15
SQL Column:  PHONE_RESULT
Java Field:  phoneResult
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Specifies the result of AVS as it pertains to phone matching.
Added On:  12/29/15
SQL Column:  
Java Field:  pin
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
PIN code of the credit card.
Added On:  12/29/15
SQL Column:  PIN_DEBIT_REASON
Java Field:  pinDebitReason
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Specifies the reason for the undo. Conditional, required for PIN Debit transactions.
Added On:  01/11/16
SQL Column:  PIN_DEBIT_RETURN_TOTALS_COUNT
Java Field:  pinDebitReturnTotalsCount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total count of PIN Debit returns.
Added On:  01/11/16
SQL Column:  PIN_DEBIT_RETURN_TOTALS_NET_AMOUNT
Java Field:  pinDebitReturnTotalsNetAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total net amount of PIN Debit returns.
Added On:  01/11/16
SQL Column:  PIN_DEBIT_SALE_TOTALS_COUNT
Java Field:  pinDebitSaleTotalsCount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total count of PIN Debit sales.
Added On:  01/11/16
SQL Column:  PIN_DEBIT_SALE_TOTALS_NET_AMOUNT
Java Field:  pinDebitSaleTotalsNetAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total net amount of PIN Debit sales.
Added On:  12/29/15
SQL Column:  POSTAL_CODE
Java Field:  postalCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP (or postal) code of the cardholder used in AVS verification.
Added On:  12/29/15
SQL Column:  POSTAL_CODE_RESULT
Java Field:  postalCodeResult
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Specifies the result of AVS as it pertains to postal code matching.
Added On:  12/29/15
SQL Column:  PREPAID_CARD
Java Field:  prepaidCard
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Specifies whether or not the card is a prepaid card. The identification of prepaid cards is at the discretion of the payment brand or issuer.
Added On:  01/11/16
SQL Column:  PROCESSED_AS3_D
Java Field:  processedAs3D
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Processed as 3D transaction.
Added On:  12/29/15
SQL Column:  REFERENCE
Java Field:  reference
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Specifies user or customer reference data echoed from the request.
Added On:  12/29/15
SQL Column:  REFERENCE_RESULT
Java Field:  referenceResult
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Result of the reference checking.
Added On:  12/30/15
SQL Column:  REQUEST_TYPE
Java Field:  requestType
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Type of the request.
Added On:  12/29/15
SQL Column:  RESPONSE_AMOUNT
Java Field:  responseAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Amount of the transaction specified in the response.
Added On:  12/29/15
SQL Column:  RESPONSE_DATE
Java Field:  responseDate
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Date of the actual response.
Added On:  12/29/15
SQL Column:  RESPONSE_STATUS
Java Field:  responseStatus
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Status of the response.
Added On:  12/29/15
SQL Column:  RESPONSE_STATUS_CODE
Java Field:  responseStatusCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Status code of the response.
Added On:  12/29/15
SQL Column:  RESPONSE_STATUS_MESSAGE
Java Field:  responseStatusMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Message explaining the response.
Added On:  12/29/15
SQL Column:  RESPONSE_TIME
Java Field:  responseTime
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Time for the response from the processor.
Added On:  12/29/15
SQL Column:  RESPONSE_TIME_ZONE
Java Field:  responseTimeZone
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Time zone response information.
Added On:  12/29/15
SQL Column:  RESUBMIT
Java Field:  resubmit
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Specifies whether resubmission is supported for PIN Debit transactions.
Added On:  12/29/15
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents a group of real-time transactions which must be settled together.
Added On:  12/29/15
SQL Column:  RETRIEVAL_REFERENCE_NUMBER
Java Field:  retrievalReferenceNumber
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Retrieval reference number generated by the processor used for settlement and reversals. If present in the response, this same data element and value must be provided during settlement of any subsequent authorization linked to this transaction.
Added On:  12/29/15
SQL Column:  RETURN_AMOUNT
Java Field:  returnAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Amount of the return transaction.
Added On:  01/11/16
SQL Column:  RETURN_TOTALS_COUNT
Java Field:  returnTotalsCount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total count of returns for the entire batch independent of transaction class.
Added On:  01/11/16
SQL Column:  RETURN_TOTALS_NET_AMOUNT
Java Field:  returnTotalsNetAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total net amount of returns for the entire batch independent of transaction class.
Added On:  12/29/15
SQL Column:  RETURNED_ACI
Java Field:  returnedAci
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Provides information concerning the status of a transaction’s CPS qualification.
Added On:  01/11/16
SQL Column:  SALE_TOTALS_COUNT
Java Field:  saleTotalsCount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total count of sales for the entire batch independent of transaction class.
Added On:  01/11/16
SQL Column:  SALE_TOTALS_NET_AMOUNT
Java Field:  saleTotalsNetAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total net amount of sales for the entire batch independent of transaction class.
Added On:  12/29/15
SQL Column:  SERVICE_ID
Java Field:  serviceId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
The ID of the service the transaction should process against.
Added On:  12/29/15
SQL Column:  SERVICE_TRANSACTION_ID
Java Field:  serviceTransactionId
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Transaction identifier assigned by the service provider. May be useful for identifying the transaction when contacting the service provider offline.
Added On:  12/29/15
SQL Column:  SETTLEMENT_DATE
Java Field:  settlementDate
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Settlement date.
Added On:  12/29/15
SQL Column:  SHIP_DATE
Java Field:  shipDate
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Date of goods shipment.
Added On:  12/29/15
SQL Column:  SIGNATURE_CAPTURED
Java Field:  signatureCaptured
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Specifies whether the cardholder provided a signature for the transaction.
Added On:  12/29/15
SQL Column:  STATE_PROVINCE
Java Field:  stateProvince
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State or province address of the cardholder used in AVS verification.
Added On:  12/29/15
SQL Column:  STATE_RESULT
Java Field:  stateResult
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Specifies the result of AVS as it pertains to state matching.
Added On:  12/29/15
SQL Column:  STREET1
Java Field:  street1
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Street address (line 1) of the client.
Added On:  12/29/15
SQL Column:  TAX_AMOUNT
Java Field:  taxAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Amount of tax.
Added On:  12/29/15
SQL Column:  TAX_EXEMPT_NUMBER
Java Field:  taxExemptNumber
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Number of the tax extempt.
Added On:  01/11/16
SQL Column:  TERMINAL_ID
Java Field:  terminalId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Transaction device identifier. Often referred to as Terminal Number or Terminal
ID (TID).
Added On:  12/29/15
SQL Column:  TIP_AMOUNT
Java Field:  tipAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Positive amount added to the total as a tip.
Added On:  12/29/15
SQL Column:  
Java Field:  tokenData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Contains actual data for token. VPAS or UCAF value must be in its original base64 encoded form.
Added On:  12/29/15
SQL Column:  
Java Field:  tokenIndicator
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Specifies VPAS, UCAF, or SET certificate S/N. Conditional, required for Electronic Commerce transactions using VPAS, UCAF, or SET w/certificate.
Added On:  01/11/16
SQL Column:  TOKEN_INFORMATION
Java Field:  tokenInformation
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Token information.
Added On:  12/29/15
SQL Column:  TOTAL_NUMBER_OF_INSTALLMENTS
Java Field:  totalNumberOfInstallments
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Total number of installments.
Added On:  12/29/15
SQL Column:  
Java Field:  track2Data
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
The actual data read from the magnetic stripe on a card. Application should strip Start and End Sentinels, LRC, and Track separators.
Added On:  01/11/16
SQL Column:  TRANSACTION_CODE
Java Field:  transactionCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Specifies if a transaction should override the Evo duplicate charge check.

Either ‘NotSet’ or ‘Override’
Added On:  12/29/15
SQL Column:  TRANSACTION_DATE_TIME
Java Field:  transactionDateTime
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
The local date and time of the transaction as calculated by the merchant and printed on the customer receipt. This field should contain a timezone offset representing the timezone in which the transaction is taking place.

Format: YYYY-MM-DDTHH:MM:SS±offset.
Added On:  12/29/15
SQL Column:  TRANSACTION_ID
Java Field:  transactionId
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
The ID of the transaction.
Added On:  12/29/15
SQL Column:  TRANSACTION_STATE
Java Field:  transactionState
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
Current status of the transaction.
Added On:  01/11/16
SQL Column:  TRANSMISSION_NUMBER
Java Field:  transmissionNumber
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Transmission number.
Added On:  01/11/16
SQL Column:  VOID_TOTALS_COUNT
Java Field:  voidTotalsCount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total count of voids for the entire batch independent of transaction class.
Added On:  01/11/16
SQL Column:  VOID_TOTALS_NET_AMOUNT
Java Field:  voidTotalsNetAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Total net amount of voids for the entire batch independent of transaction class.
Added On:  12/29/15
SQL Column:  
Java Field:  xid
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Transaction identifier in its original, base64 encoded form for Electronic Commerce transactions w/VPAS.