Elavon EISOP Capture Retail Transaction UML


Added On:  04/06/15 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  ElavonEisopCaptureRetailTransaction 
Represents capture/settlement transaction as it is defined in Elavon EISOP's realtime processing specification.
Available Fields:
Added On:  12/06/19
SQL Column:  ACCOUNTHOLDER_AUTHENTICATION_VALUE
Java Field:  accountholderAuthenticationValue
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes: Transient
Added On:  12/06/19
SQL Column:  ACCOUNTHOLDER_AUTHENTICATION_VALUE_COLLECTION_INDICATOR
Java Field:  accountholderAuthenticationValueCollectionIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  04/27/15
SQL Column:  AUTH_CHARACTERISTICS_IND
Java Field:  authCharacteristicsInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Required in order to qualify the transactions for Visa custom payment services rates.

If data is not present, spaces must be entered.
Added On:  04/27/15
SQL Column:  AUTHORISATION_CODE
Java Field:  authorisationCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The code of authorization.
If no authorization code is received, spaces must be entered.
Added On:  04/27/15
SQL Column:  AUTHORISATION_SOURCE
Java Field:  authorisationSource
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
00 = Off-line by terminal (no on-line auth);
01 = On-line to acquirer;
02 = Voice (referral);
10 = EMV-compliant, Offline by terminal chip approved;
11 = EMV-compliant, On-line to acquirer;
12 = EMV-compliant, Voice (referral).
Added On:  04/06/15
SQL Column:  AVS_RESULT
Java Field:  avsResult
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
AVS result code returned from the card issuer.

N = No Match
The match is not exact because the post code and/or the addresses do not match.

U = Unavailable Address
Information is unavailable or the Issuer does not support AVS. Acquirer has representment rights.

F = Exact Match
The match is exact; both the address and the post code matches. No representment rights.
Added On:  04/27/15
SQL Column:  BANK_NET_REF_DATE
Java Field:  bankNetRefDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Banknet reference date returned on the original authorization response.

For MasterCard transactions: MMDD.
Otherwise spaces must be entered.

Must be present in combination with the next two fields: 'Financial Network Code' and 'BankNet Reference'.
Added On:  04/27/15
SQL Column:  BANK_NET_REFERENCE
Java Field:  bankNetReference
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Banknet reference number that is returned on the original authorization response.

For MasterCard transactions.
Otherwise spaces must be entered.

Last two digits must be space filled.
Added On:  04/27/15
SQL Column:  
Java Field:  cardNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Card or bank account number of the client.
Added On:  04/27/15
SQL Column:  CARD_SCHEME_DATA_DATE_TIME
Java Field:  cardSchemeDataDateTime
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Only valid for UnionPay value received from UnionPay in the authorization response.

Format: MMDDHHMMSS
If data is not present, spaces must be entered.
Added On:  04/27/15
SQL Column:  CARD_SCHEME_DATA_SETTLEMENT_DATE
Java Field:  cardSchemeDataSettlementDate
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Only valid for UnionPay value received from UnionPay in the authorization response.

Format: Julian Day
If data is not present, spaces must be entered.
Added On:  04/27/15
SQL Column:  CASH_BACK_AMOUNT
Java Field:  cashBackAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Represents the amount of "cashback" operation which is not higher than the transaction-amount in the TDR.
Same currency as in the TDR is used.
Added On:  04/06/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:  03/17/16
SQL Column:  CONFIRMED_RESERVATION_INDICATOR
Java Field:  confirmedReservationIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates whether the room reservation is confirmed.
Added On:  04/06/15
SQL Column:  CVV_RESULT
Java Field:  cvvResult
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
The CVV2, CVC2, or CID result code.
Added On:  03/17/16
SQL Column:  DAILY_ROOM_RATE
Java Field:  dailyRoomRate
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Price of the booked room.
Added On:  03/17/16
SQL Column:  DATE_OF_CHECK_IN
Java Field:  dateOfCheckIn
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Date when the room check-in is set.
Added On:  03/17/16
SQL Column:  DATE_OF_CHECK_OUT
Java Field:  dateOfCheckOut
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Date when the room check-out is set.
Added On:  12/06/19
SQL Column:  DIRECTORY_SERVER_TRANSACTION_ID
Java Field:  directoryServerTransactionId
Status:  Active
SQL Type:  varchar(36)
Java Type:  String
Attributes:
Added On:  04/27/15
SQL Column:  DYNAMIC_MERCHANT_CITY
Java Field:  dynamicMerchantCity
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
DBA city for the dynamic merchant of the transaction (if payment facilitator processing is used).

Left justified with trailing spaces.
For non-dynamic merchant information submitters spaces must be entered.
Added On:  04/27/15
SQL Column:  DYNAMIC_MERCHANT_COUNTRY_CODE
Java Field:  dynamicMerchantCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
DBA country code of the dynamic merchant of the transaction (if payment facilitator processing is used).

Numeric ISO 3166.
Space filled for non-dynamic merchant information submitters.
Added On:  04/27/15
SQL Column:  DYNAMIC_MERCHANT_DBA_NAME
Java Field:  dynamicMerchantDbaName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Allows a merchant to dynamically change the “Doing Business As” (DBA) 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.

Left justified with trailing spaces.
For non-dynamic merchant information submitters spaces must be entered.
Added On:  12/06/19
SQL Column:  DYNAMIC_MERCHANT_EMAIL_ADDRESS
Java Field:  dynamicMerchantEmailAddress
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  12/06/19
SQL Column:  DYNAMIC_MERCHANT_MCC_CODE
Java Field:  dynamicMerchantMccCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  12/06/19
SQL Column:  DYNAMIC_MERCHANT_PHONE_NUMBER
Java Field:  dynamicMerchantPhoneNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/03/15
SQL Column:  DYNAMIC_MERCHANT_STATE_CODE
Java Field:  dynamicMerchantStateCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Dynamic state code of the merchant.
Added On:  04/27/15
SQL Column:  DYNAMIC_MERCHANT_STREET_ADDRESS
Java Field:  dynamicMerchantStreetAddress
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
DBA street address of the dynamic merchant of the transaction (if payment facilitator processing is used).

Left justified with trailing spaces.
For non-dynamic merchant information submitters spaces must be entered.
Added On:  04/27/15
SQL Column:  DYNAMIC_MERCHANT_SUB_MERCHANT_ID
Java Field:  dynamicMerchantSubMerchantId
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Sub-merchant ID allocated by the payment facilitator for the dynamic merchant of the transaction (if payment facilitator processing is used).

Numeric ISO 3166.
Space filled for non-dynamic merchant information submitters.
Added On:  12/06/19
SQL Column:  DYNAMIC_MERCHANT_TAX_ID
Java Field:  dynamicMerchantTaxId
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Added On:  04/27/15
SQL Column:  DYNAMIC_MERCHANT_ZIP_CODE
Java Field:  dynamicMerchantZipCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
DBA ZIP code of the dynamic merchant of the transaction (if payment facilitator processing is used).

Left justified with trailing spaces.
For non-dynamic merchant information submitters spaces must be entered.
Added On:  04/06/15
SQL Column:  ELAVON_EISOP_RETAIL_FILE_BATCH_FK
Java Field:  elavonEisopRetailFileBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents a group of Elavon EISOP Capture Retail Transaction objects that are settled together as a group within a single file.
Added On:  04/27/15
SQL Column:  
Java Field:  expiryDate
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Contains the card account number's expiration date. Used for key entered authorizations and terminal-based settlements only.
Added On:  04/27/15
SQL Column:  FINANCIAL_NETWORK_CODE
Java Field:  financialNetworkCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
For MasterCard transactions.
Otherwise spaces must be entered.
Added On:  03/17/16
SQL Column:  FOLIO_REFERENCE_NUMBER
Java Field:  folioReferenceNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Secondary identifier of the hotel folio that can be used to cross-reference records between UniPay and integrated systems.
Added On:  02/10/17
SQL Column:  FORM_FACTOR_INDICATOR
Java Field:  formFactorIndicator
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Indicator that is transmitted from the card to the terminal in the response of GET PROCESSING OPTIONS command for the sake of being forwarded to the issuer.
Added On:  04/27/15
SQL Column:  ICC_AMOUNT_OTHER
Java Field:  iccAmountOther
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Secondary amount of the transaction (e.g. cash amount) as provided by the terminal to the card.
Added On:  04/06/15
SQL Column:  ICC_APPLICATION_CRYPTOGRAM
Java Field:  iccApplicationCryptogram
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Returned by the chip (ICC) in response to a “Generate AC” command.
Added On:  04/06/15
SQL Column:  ICC_APPLICATION_INTERCHANGE_PROFILE
Java Field:  iccApplicationInterchangeProfile
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Used to indicate the capabilities of the card to support specific functions within the application.
Added On:  04/06/15
SQL Column:  ICC_APPLICATION_TRANSACTION_COUNTER
Java Field:  iccApplicationTransactionCounter
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Counter maintained by the application in the ICC, indicates the number of transactions processed by the card application.
Added On:  04/27/15
SQL Column:  ICC_CARD_SEQUENCE_NUMBER
Java Field:  iccCardSequenceNumber
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
A distinguishing number used to separate cards with the same PAN. If data is not present, spaces must be entered.
Added On:  04/06/15
SQL Column:  ICC_CRYPTOGRAM_INFORMATION_DATA
Java Field:  iccCryptogramInformationData
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Indicates the type of cryptogram and the actions to be performed by the authorization system.
Added On:  04/27/15
SQL Column:  ICC_CVM_RESULTS
Java Field:  iccCvmResults
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Result of last cardholder verification procedure performed.
Added On:  04/27/15
SQL Column:  ICC_DEDICATED_FILE_NAME
Java Field:  iccDedicatedFileName
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Contains the card application identification code for the card application from ISO 7816-5, selected by the terminal.
Added On:  04/27/15
SQL Column:  ICC_INTERFACE_DEVICE_SERIAL_NO
Java Field:  iccInterfaceDeviceSerialNo
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Unique and permanent serial number assigned to the IFD by the manufacturer.
Added On:  04/27/15
SQL Column:  ICC_ISSUER_APPLICATION_DATA
Java Field:  iccIssuerApplicationData
Status:  Active
SQL Type:  varchar(64)
Java Type:  String
Attributes:
Contains proprietary application data for transmission to the issuer in all transaction messages. Retrieved from the card.
Added On:  04/27/15
SQL Column:  ICC_ISSUER_SCRIPT_RESULTS_PART_I
Java Field:  iccIssuerScriptResultsPartI
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Identifies the results of the Issuer Script Execution.
Added On:  04/27/15
SQL Column:  ICC_ISSUER_SCRIPT_RESULTS_PART_I_I
Java Field:  iccIssuerScriptResultsPartII
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
Identifies the results of the Issuer Script Execution.
Added On:  04/27/15
SQL Column:  ICC_TERMINAL_APPLICATION_VERSION_NO
Java Field:  iccTerminalApplicationVersionNo
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Identifies the version number of updated application of the terminal.
Added On:  04/06/15
SQL Column:  ICC_TERMINAL_CAPABILITIES
Java Field:  iccTerminalCapabilities
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Indicates the card data input, CVM, and security capabilities of the terminal.
Added On:  04/27/15
SQL Column:  ICC_TERMINAL_COUNTRY_CODE
Java Field:  iccTerminalCountryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Indicates the country of the terminal, represented according to ISO 3166.
Added On:  04/27/15
SQL Column:  ICC_TERMINAL_TYPE
Java Field:  iccTerminalType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Indicates the environment of the terminal, its communications capability, and its operational control.
Added On:  04/27/15
SQL Column:  ICC_TERMINAL_VERIFICATION_RESULTS
Java Field:  iccTerminalVerificationResults
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Result of the different verification operations performed by the authorization system.
Added On:  04/27/15
SQL Column:  ICC_TRANSACTION_AMOUNT
Java Field:  iccTransactionAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Authorization amount of the transaction as provided by the terminal to the card.
Added On:  04/27/15
SQL Column:  ICC_TRANSACTION_CATEGORY_CODE
Java Field:  iccTransactionCategoryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Describes the environment of the TRX. Derived from MCC.
Added On:  04/27/15
SQL Column:  ICC_TRANSACTION_CURRENCY_CODE
Java Field:  iccTransactionCurrencyCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Indicates the currency code of the transaction according to ISO 4217.
Added On:  04/27/15
SQL Column:  ICC_TRANSACTION_DATE
Java Field:  iccTransactionDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The local date when the transaction was authorized.
Added On:  04/27/15
SQL Column:  ICC_TRANSACTION_SEQUENCE_COUNTER
Java Field:  iccTransactionSequenceCounter
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Counter maintained by the terminal that is incremented by one for each transaction.
Added On:  04/27/15
SQL Column:  ICC_TRANSACTION_TYPE
Java Field:  iccTransactionType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Indicates the type of financial transaction, representing the first two digits of ISO 8583:1987 processing code.
Added On:  04/27/15
SQL Column:  ICC_UNPREDICTABLE_NUMBER
Java Field:  iccUnpredictableNumber
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Value provided by the terminal to provide variability and uniqueness to the generation of the application.
Added On:  04/06/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:  04/06/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:  04/27/15
SQL Column:  MERCHANT_COUNTRY_CODE
Java Field:  merchantCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code where the merchant is located (NUMERIC ISO 3166).
Added On:  04/27/15
SQL Column:  MERCHANT_STATE
Java Field:  merchantState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Required where merchant country code is US/CA.
If country code = 840 or 124, than record ‘TAR’ is required.

Important: the state or province code should be consistent for all transactions in the batch. Refer to the specification of the processor for more information.
Added On:  12/06/19
SQL Column:  MOBILE_POS_ACCEPTANCE_DEVICE_INDICATOR
Java Field:  mobilePosAcceptanceDeviceIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  12/06/19
SQL Column:  MOBILE_POS_INDICATOR
Java Field:  mobilePosIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  04/27/15
SQL Column:  MOTO_ECOMMERCE_AUTHENTICATION_INDICATOR
Java Field:  motoEcommerceAuthenticationIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates the method used to capture the cardholder’s information for an MOTO/eCommerce or internet transaction.

If transaction source is equal to 02:
‘1’ - Mail-/Telephone Order
‘5’ - fully e-Commerce (*1)
‘6’ - attempt e-Commerce (*2)
‘7’ - Channel encrypted (*3)

If transaction source is not equal to ‘02’, spaces must be entered.
Added On:  03/17/16
SQL Column:  NAME_OF_GUEST
Java Field:  nameOfGuest
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Name of the guest.
Added On:  06/14/16
SQL Column:  NETWORK_REFERENCE_IDENTIFICATION_NUMBER
Java Field:  networkReferenceIdentificationNumber
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Secondary identifier of the network that can be used to cross-reference records between UniPay and integrated systems.
Added On:  03/17/16
SQL Column:  NUMBER_IN_PARTY
Java Field:  numberInParty
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Number of guests in a party.
Added On:  12/06/19
SQL Column:  PIN_CAPABILITY
Java Field:  pinCapability
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  12/06/19
SQL Column:  POS_TERMINAL_CAPABILITY
Java Field:  posTerminalCapability
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  06/14/16
SQL Column:  PRODUCT_ID
Java Field:  productId
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Specific identifier assigned by the processor.
Added On:  04/27/15
SQL Column:  RETRIEVAL_REFERENCE_NUMBER
Java Field:  retrievalReferenceNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
The retrieval reference number returned from the Canadian debit gateway during an authorization attempt. Also, used in a Canadian debit void transaction.

If data is not present, spaces must be entered.
Added On:  04/27/15
SQL Column:  SYSTEM_TRACE_AUDIT_NUMBER
Java Field:  systemTraceAuditNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Required for Discover processing in the US/CAN and UnionPay in all countries. Assigned by the merchant to assist in identifying a specific card transaction.

STAN remains unchanged for the entire life cycle of the card transaction.
STAN in the settlement record must match what was submitted in the authorization request.
If data is not present, spaces must be entered.
Added On:  12/06/19
SQL Column:  THREE_D_SECURE_VERSION_NUMBER
Java Field:  threeDSecureVersionNumber
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  12/16/15
SQL Column:  TRACK_DATA_CONDITION_CODE
Java Field:  trackDataConditionCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Condition code of the track data.
Added On:  04/06/15
SQL Column:  TRANSACTION_AMOUNT
Java Field:  transactionAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Authorization amount of the transaction as provided by the terminal to the card for cryptogram generation. The maximum transaction amounts supported are currently $9,999,999.99 for Visa and MasterCard, and $99,999.99 for all others card associations.
Added On:  04/06/15
SQL Column:  TRANSACTION_CURRENCY
Java Field:  transactionCurrency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
ISO currency code used in the Foreign Exchange Rate message. Taken from the terminal initialisation table or EMV chip card.
Added On:  04/06/15
SQL Column:  TRANSACTION_DATE
Java Field:  transactionDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
The actual date of the transaction.
Added On:  04/27/15
SQL Column:  TRANSACTION_IDENTIFIER
Java Field:  transactionIdentifier
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Transaction identifier that is returned on the original authorization response (returned in the authorization response message).

For Visa transactions, this field may include an identifier provided in the authorization message to facilitate linking of authorization and settlement records.

If data is not present, spaces must be entered.
Added On:  12/06/19
SQL Column:  TRANSACTION_INTEGRITY_CLASS
Java Field:  transactionIntegrityClass
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  04/06/15
SQL Column:  TRANSACTION_REFERENCE
Java Field:  transactionReference
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Used to identify the transaction reference on the account that the balance is being transferred to for the loyalty transfer transaction. Merchant transaction reference field/ ROC-Text-1 (Diners customer reference 1).
Added On:  04/27/15
SQL Column:  TRANSACTION_SOURCE
Java Field:  transactionSource
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The source of processing transaction.
Added On:  04/06/15
SQL Column:  TRANSACTION_TIME
Java Field:  transactionTime
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The actual time of the transaction.
Added On:  04/27/15
SQL Column:  TRANSACTION_TYPE
Java Field:  transactionType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Indicates the type of a transaction, representing the first two digits of ISO 8583:1987 processing code.
Added On:  12/06/19
SQL Column:  UNIQUE_TRANSACTION_RESPONSE_REFERENCE_NUMBER
Java Field:  uniqueTransactionResponseReferenceNumber
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Added On:  04/27/15
SQL Column:  VALIDATION_CODE
Java Field:  validationCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Validation code returned on the original authorization response.

For Visa transactions, this information is be provided to the merchant as part of the authorization message. May include a code to determine the accuracy of the authorization date contained in the clearing record.

If data is not present, spaces must be entered.