Elavon4 Auth Retail Transaction UML


Added On:  10/17/12 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  Elavon4AuthRetailTransaction 
Elavon4 specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, Elavon4 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:  09/09/16
SQL Column:  ACCOUNT_BALANCE3
Java Field:  accountBalance3
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Field used for account balance amount.
Added On:  10/17/12
SQL Column:  ACCOUNT_BALANCE1
Java Field:  accountBalance1
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
For Credit and Debit cards, if present this value indicates the remaining balance for a pre-paid account. For EBT transactions, if present this value indicates the remaining Food Stamp balance. For Gift Card transactions, if present this value indicates the remaining Gift Card balance on the account. Refer to the specification of the provider for more information.
Added On:  10/17/12
SQL Column:  ACCOUNT_BALANCE2
Java Field:  accountBalance2
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
For Credit and Debit cards, if present this value indicates the remaining Gift Card Balance on the account.
For EBT transactions, if present this value indicates the remaining Cash Benefit balance.
For Gift Card transactions, if present this value indicates the remaining Loyalty points on the account.
Added On:  10/17/12
SQL Column:  ACCOUNT_DATA
Java Field:  accountData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
The value is used to submit the cardholder account data to Elavon for processing. Refer to the specification of the provider for more information.
Added On:  10/17/12
SQL Column:  ACCOUNT_ENTRY_MODE
Java Field:  accountEntryMode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value is used to identify the method used to enter the Account Data for the transaction. Refer to the specification of the provider for more information.
Added On:  10/17/12
SQL Column:  ACCOUNT_TYPE
Java Field:  accountType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This value is used to facilitate transaction routing on Elavon.

0 = Default or primary account on file (In Canada this is only used for Flash Transactions)
1 = Checking
2 = Savings
3 = Food Stamp
4 = Cash Benefits
Added On:  10/17/12
SQL Column:  AMEX_CAPTURE_CODE
Java Field:  amexCaptureCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This is the American Express Capture Code field and is returned during a credit card authorization response. It determines the capture option allowed for the American Express Card in the Split Dial environment, where the POS is accessing Amex directly for Authorization processing of Amex Cards.

0 = Do not process
1 = Allow authorizations but do not capture in Settlement file
2 = Allow authorizations and capture in settlement file for processing
Added On:  10/17/12
SQL Column:  APPLICATION_ID
Java Field:  applicationId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
This field is used to indicate the type of POS device that is originating the transaction. These values are case sensitive and must be capitalized. Sample: HZ0000GC.
Added On:  10/17/12
SQL Column:  APPROVAL_CODE
Java Field:  approvalCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
This field contains the Approval Code for an approved transaction.

Note: If the Response Code on the auth. is not equal to "AA" or “AP” the contents of this field are ignored.
Added On:  02/16/16
SQL Column:  ASSOCIATION_NAME
Java Field:  associationName
Status:  Active
SQL Type:  varchar(38)
Java Type:  String
Attributes:
Name of the assigned association.
Added On:  10/17/12
SQL Column:  AUTHORIZATION_DATE
Java Field:  authorizationDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
This value is the date which the transaction was authorized. For offline transactions, this value should be set to the date when the transaction occurs.
Added On:  10/17/12
SQL Column:  AUTHORIZATION_RESPONSE
Java Field:  authorizationResponse
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
This field contains the 16 character response display message. This field is used by the POS device to display the authorization results.
Added On:  10/17/12
SQL Column:  AUTHORIZATION_SOURCE
Java Field:  authorizationSource
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This value is used to indicate the source for the authorization response. The values in this response message are subject to additions.

For On-Line transactions, the codes are supplied by the Issuer and are returned by Elavon in the response message for all on line approvals.

For Off-Line transactions, this is a one character field in the table below contains the Authorization Source code:

9 = No Authorization Source Code. This is used for non-authorized transactions, such as Credit Card Returns
E = Off-Line Approval. This is used when the approval code is manually entered, such as on a Referral or Force Transaction
6 = Off-Line approval, POS generated the approval.
Added On:  10/17/12
SQL Column:  AUTHORIZATION_TIME
Java Field:  authorizationTime
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
This value is the time which the transaction was authorized. For offline transactions, this value should be set to the time when the transaction occurs.
Added On:  10/17/12
SQL Column:  AUTHORIZED_AMOUNT
Java Field:  authorizedAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
This value is used to identify the total authorized amount for the authorization request. If the Partial authorization flag is enabled, this amount may be less than the requested amount.
Added On:  10/17/12
SQL Column:  AVS_RESPONSE
Java Field:  avsResponse
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This value contains the address verification response code returned in response message as a result of an AVS Request. It is also a required value for a terminal-based settlement, if returned in the authorization response. Refer to the specification of the provider for more information.
Added On:  10/17/12
SQL Column:  CAPTURE_CODE
Java Field:  captureCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This field is used to indicate to the POS which transactions should be captured in the local Shadow file.

0 = Do not Capture – Authorization Only
1 = Capture Transaction in Shadow File (EDC)
2 = Capture Transaction in Shadow File (EDC). This value is used for Debit Returns to indicate that the Debit Purchase is in the current batch.
Added On:  03/21/13
SQL Column:  CASHBACK_AMOUNT
Java Field:  cashbackAmount
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes: Pattern:/8/
This field is used to indicate the cashback amount applied to the transaction. This amount should be included in the Transaction Amount field.
Added On:  04/02/15
SQL Column:  CAT_INDICATOR
Java Field:  catIndicator
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value is used to indicate 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
Added On:  11/19/14
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:  01/21/15
SQL Column:  CLINIC_OTHER_AMOUNT
Java Field:  clinicOtherAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
This value is used to submit the amount of all Clinical or other qualified medical expenses contained within this purchase.
Added On:  10/17/12
SQL Column:  CUSTOMER_CODE
Java Field:  customerCode
Status:  Active
SQL Type:  varchar(51)
Java Type:  String
Attributes:
This value is used to identify the customer number for purchasing card transactions.
Added On:  10/17/12
SQL Column:  CVV2_INDICATOR
Java Field:  cvv2Indicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This value is used to indicate the presence of the CVV2 data on the Visa card. For non-Visa Cards, the value of “Present” should be used when CVC2 or CID data is present, or “Bypassed” when not present.

0 = Bypassed
1 = Present
2 = Illegible
9 = Not Present
Added On:  10/17/12
SQL Column:  CVV2_RESPONSE
Java Field:  cvv2Response
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This value contains the Card verification response code returned in Authorization Response. It is also a required value for a terminal-based settlement message, if returned in the authorization response.

M = Match
N = No match
P = Not Processed
S = Issuer indicates that CVV2 data should be present on the card, but the merchant has indicated that the CVV2 data is not present on the card (Visa Only)
U = Issuer not certified or registered to process card verification.
Added On:  10/17/12
SQL Column:  CVV2_VALUE
Java Field:  cvv2Value
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
This value is a three to four digit value that appears at the end of the printed PAN on the reserve side of the card. This value is used to verify a card’s authenticity for the purpose of preventing fraud in the mail order, telephone order (MO/TO) and card-not-present environments.
Added On:  10/17/12
SQL Column:  DEBIT_EBT_NETWORK_ID
Java Field:  debitEbtNetworkId
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value is used to indicate the Debit Network that the transaction was routed through for authorization. It may also be used on the Debit Purchase and PINLess Purchase transaction to indicate the preferred Debit Network routing ID for authorization. Refer to the specification of the provider for more information.
Added On:  10/17/12
SQL Column:  DEBIT_EBT_SETTLEMENT_DATE
Java Field:  debitEbtSettlementDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
This value is the debit switch settlement date in MMDD format.
Added On:  01/21/15
SQL Column:  DENTAL_AMOUNT
Java Field:  dentalAmount
Status:  Active
SQL Type:  int(11)(12)
Java Type:  Integer
Attributes:
This value is used to submit the amount of all Dental expenses contained within this purchase.
Added On:  09/09/16
SQL Column:  DEVICE_TYPE
Java Field:  deviceType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Code of the device type.
Added On:  08/23/16
SQL Column:  DOCUMENTATION_VERSION
Java Field:  documentationVersion
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Vestion of the corresponding documentation.
Added On:  05/25/18
SQL Column:  DYNAMIC_AUTH_TYPE_INDICATOR
Java Field:  dynamicAuthTypeIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/31/15
SQL Column:  DYNAMIC_CITY
Java Field:  dynamicCity
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Dynamic city of the merchant.
Added On:  07/31/15
SQL Column:  DYNAMIC_COUNTRY_CODE
Java Field:  dynamicCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Dynamic country code of the merchant.
Added On:  03/21/13
SQL Column:  DYNAMIC_DBA_NAME
Java Field:  dynamicDbaName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
This value allows the merchant to dynamically change the “Doing Business As” name on each transaction submitted to the host for authorization and settlement. The use of the dynamic DBA (dDBA) field is restricted by Elavon and requires prior approval to participate in the program. Values that are sent in this field by merchants that are not approved for use of this field will be ignored by the host prior to authorization and the value currently “on file” with Elavon will be used.
Added On:  05/25/18
SQL Column:  DYNAMIC_EMAIL_ADDRESS
Java Field:  dynamicEmailAddress
Status:  Active
SQL Type:  varchar(70)
Java Type:  String
Attributes:
Added On:  05/25/18
SQL Column:  DYNAMIC_MCC
Java Field:  dynamicMcc
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  07/31/15
SQL Column:  DYNAMIC_PHONE_NUMBER
Java Field:  dynamicPhoneNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Dynamic phone number of the merchant.
Added On:  07/31/15
SQL Column:  DYNAMIC_POSTAL_CODE
Java Field:  dynamicPostalCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Dynamic ZIP (or postal) code of the merchant.
Added On:  07/31/15
SQL Column:  DYNAMIC_STATE
Java Field:  dynamicState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Dynamic state code of the merchant.
Added On:  07/31/15
SQL Column:  DYNAMIC_STREET_ADDRESS
Java Field:  dynamicStreetAddress
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Dynamic street address of the merchant.
Added On:  07/31/15
SQL Column:  DYNAMIC_SUB_MERCHANT_ID
Java Field:  dynamicSubMerchantId
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Dynamic sub-merchant identification number of the merchant.
Added On:  05/25/18
SQL Column:  DYNAMIC_TAX_ID
Java Field:  dynamicTaxId
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Added On:  05/25/18
SQL Column:  ECI_SECURITY_LEVEL_INDICATOR
Java Field:  eciSecurityLevelIndicator
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  10/17/12
SQL Column:  ECOMMERCE_INDICATOR
Java Field:  ecommerceIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This indicates the method used to capture the cardholder’s information for an eCommerce or Internet transaction.

1 = Secure Electronic Commerce Transaction that includes the 3-D Secure Authentication value. (5)
2 = Non-Authenticated Security Transaction from a 3-D Secure capable merchant, and merchant attempted to authorize using 3-D Secure. Transaction Does Not Include 3-D Secure authentication value. (6)
3 = Non-Authenticated Security Transaction w/o Merchant Certificate i.e., Channel Encrypted (7)
4 = Non-Authenticated Security Transaction at a SET Capable merchant (9)
5 = Non-Secure Transaction (no encryption used) (8)
Added On:  09/09/16
SQL Column:  EMV_KEY_DATE
Java Field:  emvKeyDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Date when the EMV key was generated.
Added On:  03/21/13
SQL Column:  GIFT_LOYALTY_TRANSACTION_CODE
Java Field:  giftLoyaltyTransactionCode
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
This character is used by the POS to uniquely identify the transaction to the gift card host. This value is required for both Gift Card and Loyalty reversal transactions.

A unique value assigned by the POS to identify the gift card transaction.
Added On:  01/21/15
SQL Column:  HEALTHCARE_AMOUNT
Java Field:  healthcareAmount
Status:  Active
SQL Type:  int(11)(12)
Java Type:  Integer
Attributes:
This value is used to submit the total amount of All qualified medical expenses (Over the counter, Dental, Prescription, Vision, and Clinical/Other amount) contained within this Auto-Substantiation purchase. The “Transit Amount” is not included in this calculation.
Added On:  01/15/15
SQL Column:  ICC_AED
Java Field:  iccAed
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
This value is used to identify the date after which the application expires (The Application Expiration Date).
Added On:  01/15/15
SQL Column:  ICC_AIP
Java Field:  iccAip
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
This value is used to indicate the capabilities of the card to support specific functions within the application (The Application Interchange Profile).
Added On:  12/01/14
SQL Column:  ICC_ARC
Java Field:  iccArc
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value is generated by the authorization authority for an approved transaction.
Added On:  01/15/15
SQL Column:  ICC_ARPC
Java Field:  iccArpc
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
This value contains data sent to the chip card for online issuer authentication.
Added On:  01/15/15
SQL Column:  ICC_ATC
Java Field:  iccAtc
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
This is an incrementing counter value that is managed by the application in the chip card (The Application Transaction Counter).
Added On:  03/12/15
SQL Column:  ICC_ATC_RESPONSE
Java Field:  iccAtcResponse
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
This is an incrementing counter response value that is managed by the application in the chip card.
Added On:  12/01/14
SQL Column:  ICC_AUTHORIZED_AMOUNT
Java Field:  iccAuthorizedAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
This value is used to indicate the authorized amount of the transaction (excluding adjustments).
Added On:  01/15/15
SQL Column:  ICC_CID
Java Field:  iccCid
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value indicates the type of cryptogram and the actions to be performed by the terminal (The Cryptogram Information Data).
Added On:  01/15/15
SQL Column:  ICC_CRYPTOGRAM
Java Field:  iccCryptogram
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
This cryptogram value is returned by the Chip (ICC) in response to a “Generate AC” command.
Added On:  01/15/15
SQL Column:  ICC_CSN
Java Field:  iccCsn
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value is used to differentiate chip cards using the same Primary Account Number (PAN).
Added On:  03/12/15
SQL Column:  ICC_CSN_RESPONSE
Java Field:  iccCsnResponse
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This response value is used to differentiate chip cards using the same Primary Account Number (PAN).
Added On:  01/15/15
SQL Column:  ICC_CUSTOMER_EXCLUSIVE_DATA
Java Field:  iccCustomerExclusiveData
Status:  Active
SQL Type:  varchar(64)
Java Type:  String
Attributes:
This field is available for the Issuer’s discretionary use. The issuer is responsible for ensuring its use of the field complies with all applicable laws and its own privacy policy.
Added On:  12/01/14
SQL Column:  ICC_CVMR
Java Field:  iccCvmr
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
This value is used to indicate the results of the last CVM preformed. The Cardholder Verification Method Results (CVM) – EMV Tag 9F34.
Added On:  08/23/16
SQL Column:  ICC_DEDICATED_FILE_NAME
Java Field:  iccDedicatedFileName
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
ICC (International Chamber of Commerce) dedicated name of a file.
Added On:  01/15/15
SQL Column:  ICC_FORM_FACTOR_INDICATOR
Java Field:  iccFormFactorIndicator
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
This field contains indicators about the attributes of the card holder’s device and the technology used for communication between the cardholder’s device and the acquiring POS Device.
Added On:  01/15/15
SQL Column:  ICC_IAD
Java Field:  iccIad
Status:  Active
SQL Type:  varchar(64)
Java Type:  String
Attributes:
This value is used to send proprietary application data to the issuer in an online transaction.
Added On:  01/19/15
SQL Column:  ICC_ISR
Java Field:  iccIsr
Status:  Active
SQL Type:  varchar(84)
Java Type:  String
Attributes:
This value is used to identify the results of the terminal script processing.
Added On:  01/15/15
SQL Column:  ICC_ISSUER_SCRIPT
Java Field:  iccIssuerScript
Status:  Active
SQL Type:  varchar(256)
Java Type:  String
Attributes:
This value is used to return the Issuer specified script contained in EMV Tags 71 or 72 back to the POS in the authorization response message. Refer to the specidication of the provider for more information.
Added On:  12/01/14
SQL Column:  ICC_OTHER_AMOUNT
Java Field:  iccOtherAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
This value is used to indicate a secondary “Cashback” amount associated with the transaction.
Added On:  03/12/15
SQL Column:  ICC_TCC
Java Field:  iccTcc
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
This value is used to identify the country code where the terminal is located.
Added On:  01/15/15
SQL Column:  ICC_TCP
Java Field:  iccTcp
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
This value indicates the card data input, CVM, and security capabilities of the terminal.
Added On:  01/15/15
SQL Column:  ICC_TERMINAL_TYPE
Java Field:  iccTerminalType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value is used to indicate the environment of the terminal, its communication capability, and its operational control.
Added On:  05/13/16
SQL Column:  ICC_THIRD_PARTY_DATA
Java Field:  iccThirdPartyData
Status:  Active
SQL Type:  varchar(64)
Java Type:  String
Attributes:
Data assigned to ICC third party company.
Added On:  12/01/14
SQL Column:  ICC_TRANSACTION_CURRENCY
Java Field:  iccTransactionCurrency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
This value is used to indicate the currency code of the transaction according to the ISO 4217 standard.
Added On:  12/01/14
SQL Column:  ICC_TT
Java Field:  iccTt
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value indicates the type of financial transaction, represented by the first two digits of the ISO 8583 processing code.
Added On:  12/01/14
SQL Column:  ICC_TTD
Java Field:  iccTtd
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
This value is used to indicate the local data that the transaction was authorized (The Transaction Date).
Added On:  01/15/15
SQL Column:  ICC_TVR
Java Field:  iccTvr
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
This value indicates the status of the different functions as seen from the terminal.
Added On:  01/15/15
SQL Column:  ICC_UNPREDICTABLE_NUMBER
Java Field:  iccUnpredictableNumber
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
This value is used to provide variability and uniqueness to the generation of a cryptogram.
Added On:  10/17/12
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/06/12
SQL Column:  INSTALLMENT_COUNT
Java Field:  installmentCount
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value is used to indicate the total number of payments for an installment transaction. For example, if the consumer is making payment 1 of 12, then this value should be set to “12”.
Added On:  12/06/12
SQL Column:  INSTALLMENT_NUMBER
Java Field:  installmentNumber
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value is used to indicate the current payment number for an installment transaction. For example, if the consumer is making payment 1 of 12, then this value should be set to “1”.
Added On:  10/17/12
SQL Column:  INVOICE_NUMBER
Java Field:  invoiceNumber
Status:  Active
SQL Type:  varchar(75)
Java Type:  String
Attributes:
This value is used to include the POS’s local transaction invoice or order number. This is a required value for Mail Order and Ecommerce transactions.
Added On:  10/17/12
SQL Column:  ISSUER_RESPONSE_CODE
Java Field:  issuerResponseCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
This value is the original Issuer response as returned during the authorization attempt.
Added On:  10/17/12
SQL Column:  KEY_POINTER
Java Field:  keyPointer
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This value is used to indicate which encryption methodology was used for US Debit transactions (POS to Elavon) and which key to use for the next transaction (Elavon to POS).

D = Single-DES DUKPT
T = Triple-DES DUKPT
P = PIN Less Debit Purchase
Added On:  08/26/15
SQL Column:  
Java Field:  kns
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
This is the value returned by the PIN Pad device, which was used to encrypt the cardholder’s Personal Identification Number (PIN) using the Derived Unique Key Per Transaction (DUKPT) method. It is a 10 byte composite field that is transmitted as 20 alphanumeric characters.
Added On:  01/15/15
SQL Column:  LINE_NUMBER
Java Field:  lineNumber
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
This field is used to allow a multi-lane retailer using interleaved processing to send up a unique value that will identify the lane where the transaction originated from.
Added On:  01/18/16
SQL Column:  
Java Field:  macKey
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Key assigned to the merchant account code.
Added On:  10/14/15
SQL Column:  MAC_VALUE
Java Field:  macValue
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes: Transient
The Message Authentication Code (MAC) is used to verify that a Canadian Debit message transferred over a telecommunications network has not been altered. The MAC Value is optional on a Canadian Debit Reversal and must space filled if not utilized.
Added On:  03/21/13
SQL Column:  MEMBER_NAME
Java Field:  memberName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
The Member name associated with the gift or loyalty card transaction, if available.
Added On:  10/17/12
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:  10/17/12
SQL Column:  MERCHANT_REFERENCE_NBR
Java Field:  merchantReferenceNbr
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
This value contains the merchant assigned reference number for this transaction. If this value is not present, then Elavon will generate this number for backend use.
Added On:  10/17/12
SQL Column:  MSDI
Java Field:  msdi
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
The Market Specific Data Indicator value.

0 = Returned if the data was not presented in authorization
1 = Returned if the data passed the Hotel Edits (H)
2 = Returned if the data failed Edits (N)
3 = Healthcare / Auto-Substantiation (M)
4 = Transit / Auto-Substantiation (T)
5 = Returned if the data passed the Visa Aggregator edits (E)
6 = Returned if the data passed the Auto Rental edits (A)
7 = Returned if the data passed the Bill Payment edits (B)
8 = Returned if the data passed the MasterCard Payment Gateway edits (G)
9 = Business to Business Invoice Payments (J)
Added On:  02/08/16
SQL Column:  ORIGINAL_APPROVAL_CODE
Java Field:  originalApprovalCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Approval code associated with the original transaction.
Added On:  02/08/16
SQL Column:  ORIGINAL_PS2000_DATA
Java Field:  originalPs2000Data
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Record that contains specified data assigned by a processor.
Added On:  02/08/16
SQL Column:  ORIGINAL_RESPONSE_CODE
Java Field:  originalResponseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Response code associated with the original transaction.
Added On:  02/08/16
SQL Column:  ORIGINAL_TRACE_NUMBER
Java Field:  originalTraceNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Trace number of the merchant from which the payment is applied.
Added On:  02/10/16
SQL Column:  ORIGINAL_TRANSACTION_REFERENCE_NBR
Java Field:  originalTransactionReferenceNbr
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Secondary identifier of the transaction which can be used to cross-reference records between UniPay and integrated systems.
Added On:  10/17/12
SQL Column:  PARTIAL_AUTH_INDICATOR
Java Field:  partialAuthIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This value is used to indicate if the POS is capable of performing partial authorizations.

0 = Indicates that the POS is not capable of Partial Authorizations.
1 = Indicates that the POS is capable of Partial Authorizations.
2 = Indicates that the POS is capable of Partial Authorizations and is a Visa Aggregator.
Added On:  08/26/15
SQL Column:  
Java Field:  pinBlock
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
The encrypted Personal Identification Number entered by Debit / EBT Cardholder as identification for Transaction. The encrypted PIN Block is returned from the PIN Pad Device.
Added On:  01/20/15
SQL Column:  PIN_ENTRY_CAPABILITY
Java Field:  pinEntryCapability
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This value is used to indicate the capability of the terminal to capture a PIN.

0 = Unknown
1 = Can accept and pass an online PIN
2 = Cannot accept and pass an online PIN
8 = PIN Pad is not functional
Added On:  01/18/16
SQL Column:  
Java Field:  pinWorkingKey
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Key assigned to the current PIN of the cardholder.
Added On:  03/21/13
SQL Column:  POINTS_ADDED
Java Field:  pointsAdded
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
This value is used to indicate the number of points added to an account an account.
Added On:  03/21/13
SQL Column:  POINTS_CANCELED
Java Field:  pointsCanceled
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
This value is used to indicate the number of points to cancel from an account.
Added On:  10/17/12
SQL Column:  POS_ENTRY_CAPABILITY
Java Field:  posEntryCapability
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value is used to identify the account entry capabilities on the POS device originating the transaction. Refer to the specification of the provider for more information.
Added On:  10/17/12
SQL Column:  POSTAL_ZIP_CODE
Java Field:  postalZipCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
This value is used to indicate the cardholder’s Postal or ZIP Code.
Added On:  03/21/13
SQL Column:  PRE_AUTH_REFERENCE_NUMBER
Java Field:  preAuthReferenceNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
This is a Gift Card value used to identify the original pre-authorization request. This value is required to submit the post-authorization completion transaction message.
Added On:  01/21/15
SQL Column:  PRESCRIPTION_AMOUNT
Java Field:  prescriptionAmount
Status:  Active
SQL Type:  int(11)(12)
Java Type:  Integer
Attributes:
This value is used to submit the amount of all prescription expenses contained within this purchase.
Added On:  10/14/15
SQL Column:  PROCESSING_CODE
Java Field:  processingCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Processing code of the transaction.
Added On:  10/17/12
SQL Column:  PS2000_DATA
Java Field:  ps2000Data
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
This data will be as received during the original authorization processing. It will not be present for off line transactions. This is a “retain and return” value for terminal-based settlement messages. Refer to the specification of the provider for more information.
Added On:  03/21/13
SQL Column:  RECEIPT_MESSAGE
Java Field:  receiptMessage
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
This field contains a custom message as retuned from the Gift Card host to be printed on the cardholder’s receipt.
Added On:  12/06/12
SQL Column:  RECURRING_PAYMENT_TYPE
Java Field:  recurringPaymentType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This field is used to identify the type of recurring transaction that is being submitted for authorization.

  • A Recurring Transaction is a transaction in which a cardholder allows a merchant to charge their card for recurring goods or services for a mutually agreed-upon payment amount (variable or set) and for a specified length of time. The merchant must obtain written permission to bill a cardholder on a recurring basis. Subsequent permission must be obtained when the agreement is renewed.

  • Recurring transactions have a defined billing cycle and are in effect as long as the contract between the merchant and the cardholder is in good standing. Recurring payments include charges for Utilities, membership fees, subscriptions, insurance premiums, tuition, etc.
  • An Installment Transaction is a transaction in which a cardholder allows a merchant permission to charge their card for a single purchase of goods or services on a pre-determined payment schedule. The merchant must obtain permission to bill the cardholder in an arrangement in which a single purchase of goods/service is divided into two or more payments. Subsequent permission must be obtained when the agreement is modified.

  • Installment transactions have a defined transaction amount, billing cycle, and a total number of payments, which equal the full amount for the original agreed upon purchase. Installment payments include charges for loan payments, car purchase, furniture stores, etc.
  • A Carne Bill Payment Transaction is a Brazilian transaction in which a cardholder enters into an agreement and signs a contract with the Merchant to make regular monthly payments using a domestic Brazilian Debit Card for a current purchase. The cardholder then agrees to return to the store each month and present a domestic Brazilian Debit Card to make a payment according to the terms of the contract.
  • Added On:  10/17/12
    SQL Column:  REFERENCE_NUMBER
    Java Field:  referenceNumber
    Status:  Active
    SQL Type:  varchar(8)
    Java Type:  String
    Attributes:
    This value is a reference number assigned by Elavon and returned in the authorization response message.
    Added On:  10/17/12
    SQL Column:  REQUEST
    Java Field:  request
    Status:  Active
    SQL Type:  varchar(40)
    Java Type:  String
    Attributes:
    Type of request.
    Added On:  10/17/12
    SQL Column:  RESPONSE_CODE
    Java Field:  responseCode
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    This value is a 2 character code indicating the authorization response status. An approval is always indicated with an ‘AA’ or ‘AP’ code, all other codes indicate a non-approval.

    AA = Approved Transaction (Authorizations and Reversals)
    AP = Approved Transaction for a Partial Amount
    NC = Decline (Pick Up Card)
    ND = Decline (Hard or Soft)
    NF = Decline (Record Not Found)
    NR = Decline (Referral Message)
    N7 = Decline (For CVV2 Only)
    NL = Decline (Loyalty/Gift Error)
    00-99 = Decline (Additional Gift Card Declined)
    Added On:  10/17/12
    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:  10/14/15
    SQL Column:  RETRIEVAL_REFERENCE_NUMBER
    Java Field:  retrievalReferenceNumber
    Status:  Active
    SQL Type:  varchar(12)
    Java Type:  String
    Attributes:
    Retrieval reference number of the merchant.
    Added On:  10/17/12
    SQL Column:  SALES_TAX
    Java Field:  salesTax
    Status:  Active
    SQL Type:  int(11)
    Java Type:  Integer
    Attributes:
    This is the actual sales tax amount applied to this transaction. Consumer or Merchant tax exempt transactions can enter a single zero to properly reflect a tax exempt transaction.
    Added On:  10/17/12
    SQL Column:  SHIPPING_DATE
    Java Field:  shippingDate
    Status:  Active
    SQL Type:  varchar(8)
    Java Type:  String
    Attributes:
    The value is the date that the consumer’s goods were shipped. This value is the “Transaction Date” for direct marketing and ecommerce transactions.

    Shipping Date in MMDDYYYY format.
    Added On:  06/06/16
    SQL Column:  SPEND_QUALIFIER
    Java Field:  spendQualifier
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Added On:  05/25/18
    SQL Column:  STORED_CREDENTIAL_INDICATOR
    Java Field:  storedCredentialIndicator
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Added On:  10/17/12
    SQL Column:  STREET_ADDRESS
    Java Field:  streetAddress
    Status:  Active
    SQL Type:  varchar(20)
    Java Type:  String
    Attributes:
    This value is used to identify the cardholder’s street address.
    Added On:  10/17/12
    SQL Column:  SURCHARGE_AMOUNT
    Java Field:  surchargeAmount
    Status:  Active
    SQL Type:  int(11)
    Java Type:  Integer
    Attributes:
    This field is used to indicate the amount of the surcharge applied to the transaction. This amount should be included in the Transaction Amount field.
    Added On:  10/14/15
    SQL Column:  SYSTEM_TRACE_AUDIT_NBR
    Java Field:  systemTraceAuditNbr
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    System trace audit number.
    Added On:  03/21/13
    SQL Column:  TENDER_TYPE
    Java Field:  tenderType
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    The value is used to identify the payment method use to activate or reload a gift card.

    0 = Cash
    1 = Credit Card
    2 = Debit Card
    3 = Check
    9 = Unknown
    Added On:  10/17/12
    SQL Column:  TERMINAL_ID
    Java Field:  terminalId
    Status:  Active
    SQL Type:  varchar(22)
    Java Type:  String
    Attributes:
    The terminal identification number is used to uniquely identify the Merchant and their financial institution to Elavon. The Terminal ID consists of two parts and is assigned by Elavon for each POS device.
    Added On:  04/02/15
    SQL Column:  TERMINAL_TYPE
    Java Field:  terminalType
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    This value is used to indicate the environment of the terminal, its communication capability, and its operational control.
    Added On:  08/26/15
    SQL Column:  
    Java Field:  threeDSecureValue
    Status:  Active
    SQL Type:  
    Java Type:  String
    Attributes: Transient
    Value of the 3-D secure verification of the transaction.
    Added On:  10/17/12
    SQL Column:  TRACE_NUMBER
    Java Field:  traceNumber
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    This value is used as a message reference number identify the transaction request and is returned in all authorization response messages. It is sent to the host on reversal and void messages when applicable.
    Added On:  10/17/12
    SQL Column:  TRANSACTION_AMOUNT
    Java Field:  transactionAmount
    Status:  Active
    SQL Type:  int(11)
    Java Type:  Integer
    Attributes:
    This is the actual amount of the transaction. The maximum transaction amounts supported are currently $9,999,999.99 for Visa and MasterCard, and $99,999.99 all others card associations.

    For Terminal-Based Settlement messages, this value will contain the total amount of the transaction in the Merchant’s currency, including any Tips (for restaurant transactions).
    For Canadian Debit Authorization Response messages, this field is zero filled and right justified to 12 characters.
    Added On:  10/17/12
    SQL Column:  TRANSACTION_CODE
    Java Field:  transactionCode
    Status:  Active
    SQL Type:  varchar(25)
    Java Type:  String
    Attributes:
    This value is used to uniquely identify the type of transaction that is being submitted to Elavon. Refer to the specification of the provider for more information.
    Added On:  10/17/12
    SQL Column:  TRANSACTION_REFERENCE_NBR
    Java Field:  transactionReferenceNbr
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    The Transaction Reference Number is returned in the authorization response message and is used on void and reversal transactions, when available. This number is assigned by Elavon.
    Added On:  12/06/12
    SQL Column:  UCAF_INDICATOR
    Java Field:  ucafIndicator
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    This value identifies the means in which the transaction was processed between the cardholder and the merchant for a SecureCode authentication transaction.

    0 = UCAF data collection is not supported by the Merchant
    1 = UCAF data collection is supported by merchant but not populated
    2 = UCAF data collection is supported by merchant, and UCAF data must be present
    Added On:  01/21/15
    SQL Column:  VISION_AMOUNT
    Java Field:  visionAmount
    Status:  Active
    SQL Type:  int(11)(12)
    Java Type:  Integer
    Attributes:
    This value is used to submit the amount of all optical/vision expenses contained within this purchase.
    Added On:  09/03/14
    SQL Column:  VOUCHER_CLEAR_NBR
    Java Field:  voucherClearNbr
    Status:  Active
    SQL Type:  varchar(15)
    Java Type:  String
    Attributes:
    The Voucher Number from an EBT sales slip, used for Voucher Clear Food Stamp transactions.
    The 15 digit Voucher Clear Number from the Merchant’s EBT Food Stamp sales slip.