Elavon4 Global Capture Retail Transaction UML


Added On:  06/02/16 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  Elavon4GlobalCaptureRetailTransaction 
Represents capture/settlement transaction as it is defined in Elavon4 Global's realtime processing specification.
Available Fields:
Added On:  06/02/16
SQL Column:  
Java Field:  accountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Contains the credit card account number which identifies the customer. The account number is left justified with trailing spaces. Visa’s authorization network record returns the cardholder account number in field 2. The cardholder account number must contain 13, 16 or 19 digits with the last digit being a mod-10 check digit.
Added On:  06/02/16
SQL Column:  ACI
Java Field:  aci
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
ACI (Authorization Characteristics Indicator) is applicable to Visa transactions only. ACI is a code assigned by the Visa authorization system to reflect the authorization characteristics. This field was formerly known as the Payment Service Indicator.
Added On:  06/02/16
SQL Column:  APPLICATION_EXPIRATION_DATE
Java Field:  applicationExpirationDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Chip transaction field – Tag 5F24 – captures the expiration date which is imbedded within the chip.
Added On:  06/02/16
SQL Column:  APPLICATION_INTERCHANGE_PROFILE
Java Field:  applicationInterchangeProfile
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Chip transaction field – Tag 82 – provides a series of indicators that reflect the specific functions supported by the chip card account.
Added On:  06/02/16
SQL Column:  APPLICATION_REQUEST_CRYPTOGRAM
Java Field:  applicationRequestCryptogram
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F26 – contains chip information passed from the chip to the terminal to validate the chip. This information must be captured and passed in the settlement.
Added On:  06/02/16
SQL Column:  APPLICATION_TRANSACTION_COUNTER
Java Field:  applicationTransactionCounter
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F36 – contains the count (the counter increments by 1 each time a transaction is initiated) of the transactions performed within the application.
Added On:  06/02/16
SQL Column:  APPROVAL_CODE
Java Field:  approvalCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The approval code is a series of alpha/numeric characters assigned by the credit card company to validate approval of a transaction. This field is also known as the authorization code. If no value is entered, zeroes or spaces are accepted; however, in order to qualify for Association incentive rates, the authorization code from the authorization response record must be moved to this field.
Added On:  06/02/16
SQL Column:  AUTHORIZATION_CURRENCY_CODE
Java Field:  authorizationCurrencyCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Chip transaction field – Tag 5F2A – contains the currency code the transaction was authorized in.
Added On:  06/02/16
SQL Column:  AUTHORIZATION_DATE
Java Field:  authorizationDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Chip transaction field – contains the date transaction was authorized on.
Added On:  06/02/16
SQL Column:  AUTHORIZATION_RESPONSE_CODE
Java Field:  authorizationResponseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Applicable to Visa transactions only –authorization response code is a code that is returned by Visa in the authorization response message (usually 00) indicating approval of a transaction. This field may be spaces if a value is not transferred from the Visa authorization response record field 39.
Added On:  06/02/16
SQL Column:  AUTHORIZATION_SOURCE
Java Field:  authorizationSource
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Contains the source of the authorization.
Added On:  06/02/16
SQL Column:  AUTHORIZED_AMOUNT
Java Field:  authorizedAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
If Multi-Currency or DCC transaction, the authorized amount field should contain the amount which was authorized and must equal the cardholder amount.

If NOT Multi-Currency or DCC transaction, the authorized amount should contain the amount which was authorized and must equal transaction amount keeping in mind the below scenario for U.S. processing.

The authorized amount field must contain the total amount authorized for all transactions approved simultaneously with a single approval code. This field is required to qualify for Association incentive rates. This field may be space-filled if the authorized amount is not available.

If the merchant participates in surcharging, the authorized amount will also include the surcharge amount if one is assessed.

Example for the airline industry: If four tickets for $400 each are authorized simultaneously, the authorized amount for all four transactions will be $1,600.
Added On:  06/02/16
SQL Column:  AVS_RESPONSE_CODE
Java Field:  avsResponseCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
When a credit card company’s Address Verification Service (AVS) is utilized, this field will contain the code used by the credit card company to respond to the address verification request. This field may be spaces if a value is not transferred from the authorization response record.
Added On:  06/02/16
SQL Column:  BANKNET_DATE
Java Field:  banknetDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
MasterCard transactions only – the Banknet date is the date the transaction was authorized through Banknet. The format of this field is MMDD. This field is required to qualify for MasterCard incentive rates.
Added On:  06/02/16
SQL Column:  BANKNET_REFERENCE_NUMBER
Java Field:  banknetReferenceNumber
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
MasterCard transactions only – assigned by MasterCard to each authorization message. The Banknet Reference Number contains the financial network code, a unique identifying number and the identification for the MIP that generated it. This field is required to qualify for MasterCard incentive rates.
Added On:  06/02/16
SQL Column:  CARD_SEQUENCE_NUMBER
Java Field:  cardSequenceNumber
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Chip transaction field – contains the number assigned to a specific card when two or more cards are associated with a single account number.
Added On:  06/06/16
SQL Column:  CARD_TYPE_IDENTIFIER
Java Field:  cardTypeIdentifier
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Contains and identifier which indicates the type of card used.
Added On:  06/02/16
SQL Column:  CARDHOLDER_ID_METHOD
Java Field:  cardholderIdMethod
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
The cardholder ID method indicates how the cardholder was identified. This field is required to qualify for Visa/MasterCard incentive rates.
Added On:  06/02/16
SQL Column:  CASH_BACK_AMOUNT
Java Field:  cashBackAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Contains the amount of cash back given to the cardholder at the time of the transaction. This amount cannot be higher than the transaction amount.
Added On:  06/02/16
SQL Column:  CASH_BACK_AMOUNT_EMV
Java Field:  cashBackAmountEmv
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Contains the amount of cash back given to the cardholder at the time of the EMV transaction. This amount cannot be higher than the transaction amount.
Added On:  06/02/16
SQL Column:  CAT_CODE
Java Field:  catCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
The cardholder activated terminal level indicator indicates the transaction took place at a self-service terminal used for transactions in an unattended POS situation. Values in this field will vary depending on association and environment.

NOTE: If the CAT code field is not applicable to the transaction type the field must contain a space
Added On:  06/02/16
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:  06/02/16
SQL Column:  CHIP_CONDITION_CODE
Java Field:  chipConditionCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Chip transaction field, Visa only – contains a value indicating what the condition the transaction occurred in. In certain situations the transaction failed chip validation and falls back to magnetic stripe processing.
Added On:  06/02/16
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Used for transaction level processing (MPS2 & 3 international platforms) and contains the country code where the transaction originated from. The value in this field is NOT used for batch level processing (MPS1 US and Canadian platform).
Added On:  06/02/16
SQL Column:  CRYPTOGRAM_INFORMATION_DATA
Java Field:  cryptogramInformationData
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F27 – indicates the type of cryptogram and the actions to be performed by the authorization system.
Added On:  06/02/16
SQL Column:  CRYPTOGRAM_TRANSACTION_TYPE
Java Field:  cryptogramTransactionType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Chip transaction field – Tag 9C – indicates the type of financial transaction.
Added On:  06/02/16
SQL Column:  CURRENCY_INDICATOR_CODE
Java Field:  currencyIndicatorCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
A three character code which indicates the currency represented in the transaction. This field may be zeros however, is required to match the authorized response record to qualify for Visa Customer Payment
Services (CPS) incentive rates. The Visa authorization system places this information in field 49.
Added On:  06/02/16
SQL Column:  CVM_RESULTS
Java Field:  cvmResults
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F34 – contains the result of the cardholder verification procedure.
Added On:  06/02/16
SQL Column:  CVV2_RESULTS_CODE
Java Field:  cvv2ResultsCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
CVV2 verification result field.
Added On:  06/02/16
SQL Column:  DE22_POINT_OF_SERVICE_DATA_CODE
Java Field:  de22PointOfServiceDataCode
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Contains information from the point of sale and is primarily used for MasterCard transactions.
For All other card brand transactions this field should be space filled.

MasterCard transactions only – DE22 Point of Service Data Code is a series of codes that identify terminal capability, terminal environment and point of interaction security data. It identifies special conditions that are present at the time a transaction occurred at the point of interaction. The information in DE22 must be passed unchanged from auth to clearing. DE22 contains 12 sub fields as described below.
Added On:  06/06/16
SQL Column:  DEBIT_NETWORK_ID
Java Field:  debitNetworkId
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Contains the network identifier for PIN based Debit cards.
Added On:  06/06/16
SQL Column:  DEBIT_SETTLEMENT_DATE
Java Field:  debitSettlementDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Contains the switch settlement date for PIN based Debit cards in MMDD format.
Added On:  06/02/16
SQL Column:  DEDICATED_FILE_NAME
Java Field:  dedicatedFileName
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Chip transaction field – contains the card application identification code for the card application from ISO 7816-5, selected by the terminal.
Added On:  06/02/16
SQL Column:  DEVICE_TYPE
Java Field:  deviceType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Chip transaction field – contains information indicating the type of the device used at the terminal for contactless transactions and is primarily used for MasterCard transactions. For all other card brand transactions this field should be space filled.
Added On:  06/02/16
SQL Column:  ECI_OR_MOTO_INDICATOR
Java Field:  eciOrMotoIndicator
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Electronic Commerce Indicator (ECI) = A VisaNet code that identifies a transaction that is conducted over the Internet or other network using a cardholder access device.
Mail Order Telephone Order (MOTO) = The purchase of goods or services where the cardholder is not present at the point of sale; the purchase is a result of a mail order, telephone order, fax order and so forth.
Added On:  06/02/16
SQL Column:  ELAVON4_GLOBAL_RETAIL_FILE_BATCH_FK
Java Field:  elavon4GlobalRetailFileBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity atht represents Elavon4 Global retail file batch information.
Added On:  06/02/16
SQL Column:  
Java Field:  expirationDate
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Contains the month and year (MMYY) after which the credit card account number is no longer valid. If the expiration date is not available, this field may be zero filled.
Added On:  06/02/16
SQL Column:  FORM_FACTOR
Java Field:  formFactor
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F6E – the form factor indicator defines the type of consumer device used to conduct the transaction. The field is conditional, however if information is passed it must be carried throughout the transaction (auth and settle).
Added On:  06/02/16
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:  06/02/16
SQL Column:  INTERFACE_DEVICE_SERIAL_NO
Java Field:  interfaceDeviceSerialNo
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Serial number of device interface.
Added On:  06/02/16
SQL Column:  ISSUER_APPLICATION_DATA
Java Field:  issuerApplicationData
Status:  Active
SQL Type:  varchar(64)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F10 – contains information the issuer wants to pass to the chip. The field is conditional, however if information is passed it must be carried throughout the transaction (auth and settle).
Added On:  06/02/16
SQL Column:  ISSUER_SCRIPT_RESULTS_PART1
Java Field:  issuerScriptResultsPart1
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Issuer Script Results Part 1.
Added On:  06/02/16
SQL Column:  ISSUER_SCRIPT_RESULTS_PART2
Java Field:  issuerScriptResultsPart2
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
Issuer Script Results Part 2.
Added On:  06/02/16
SQL Column:  MCC
Java Field:  mcc
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
The Associations have assigned specific Merchant Category Codes (MCC) for merchants according to the operating regulations. If this field is not filled by the merchant, Elavon will insert the appropriate Merchant Category Code from its accounting system.
Added On:  06/02/16
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:  06/02/16
SQL Column:  MERCHANT_DBA_NAME
Java Field:  merchantDbaName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Contains the merchants 'doing business as' (DBA) name.
Added On:  06/02/16
SQL Column:  NETWORK_REFERENCE_ID
Java Field:  networkReferenceId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Discover transactions only – contains a unique ID assigned by Discover Network at the time of the authorization response.
Added On:  06/02/16
SQL Column:  NUMBER_OF_INSTALLMENTS
Java Field:  numberOfInstallments
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Installment transaction field – contains the amount a customer put down as a deposit on a transaction.
Added On:  06/02/16
SQL Column:  POINT_OF_SALE_NAME
Java Field:  pointOfSaleName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Contains the name of the travel agent or ticketing location where the transaction took place.
Added On:  06/02/16
SQL Column:  POS_ENTRY_MODE
Java Field:  posEntryMode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Required to qualify for Visa/MasterCard/Discover incentive rates. It occupies positions 1-2 of field 22 on the Visa authorization system. Refer to the specification of the processor for detailed information.
Added On:  06/02/16
SQL Column:  POS_TERMINAL_CAPABILITY
Java Field:  posTerminalCapability
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates the capability of the terminal.
Added On:  06/02/16
SQL Column:  PRODUCT_ID
Java Field:  productId
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Applicable to Visa transactions only - assigned to U.S. and Canada regions identifying the type of card being used (the product). This value is passed in the authorization response message in field 62.23 Card Level Results if authorized through an MDEX. If transaction is authorized through another means, check with the authorization vendor to understand where the product id will be passed. The value received in this field must be passed in the settlement record, unchanged. This field is required to qualify for Visa incentive rates.
Added On:  06/06/16
SQL Column:  PURCHASE_ID_FORMAT
Java Field:  purchaseIdFormat
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
The purchase ID format indicates the format of additional identifying information for purchases, such as order number or invoice number, etc.
Added On:  06/06/16
SQL Column:  PURCHASE_IDENTIFIER
Java Field:  purchaseIdentifier
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
The purchase identifier is used to send information identifying the purchase to the issuer and cardholder. It indicates the type of identifying information (order number, invoice number, hotel folio number, car rental agreement number, text description, etc.).
Added On:  06/02/16
SQL Column:  REFERENCE_CODE
Java Field:  referenceCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Populated by the merchant for their use to assist with finding original documents, and for chargebacks. Elavon will include the reference code data on copy retrieval requests or chargeback forms.
Added On:  06/02/16
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:  06/08/16
SQL Column:  RETRIEVAL_REFERENCE_NUMBER
Java Field:  retrievalReferenceNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Retrieval reference number.
Added On:  06/06/16
SQL Column:  SALES_TAX_AMOUNT
Java Field:  salesTaxAmount
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Contains the amount of sales tax on the transaction. This field is required for certain interchange incentive rates.
Added On:  06/06/16
SQL Column:  SALES_TAX_INDICATOR
Java Field:  salesTaxIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Contains a sales tax indicator relating to the transaction. This field is required for certain interchange incentive rates.
Added On:  06/06/16
SQL Column:  SPEND_QUALIFIED_INDICATOR
Java Field:  spendQualifiedIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Visa only – contains a value which identifies if a transaction meets Visa’s spend requirement defined by the Visa region. This field should be populated as a straight pass thru from authorization to clearing/settlement. The Spend Qualified Indicator is located in field 62.25 of the authorization response record.
Added On:  06/02/16
SQL Column:  STATE_PROVINCE_CODE
Java Field:  stateProvinceCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Contains the two digit abbreviation for the state (if US) or province (if Canada) for the transaction.
Added On:  06/02/16
SQL Column:  SYSTEM_TRACE_AUDIT_NUMBER
Java Field:  systemTraceAuditNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Discover transactions only – This value is assigned by the Merchant to assist in identifying a specific card transaction. The STAN remains unchanged for the life of the card transaction. The STAN in the settlement record should match what was submitted in the Authorization Request.
Added On:  06/02/16
SQL Column:  TERMINAL_APPLICATION_VERSION_NO
Java Field:  terminalApplicationVersionNo
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Chip transaction field – contains the EMV Version of the Terminal.
Added On:  06/02/16
SQL Column:  TERMINAL_CAPABILITIES_PROFILE
Java Field:  terminalCapabilitiesProfile
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F33 – indicates the card input data, the Cardholder Verification Method and the security capabilities that are supported by the terminal.
Added On:  06/02/16
SQL Column:  TERMINAL_COUNTRY_CODE
Java Field:  terminalCountryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F1A – contains the country code of the country where the terminal is located.
Added On:  06/06/16
SQL Column:  TERMINAL_ID
Java Field:  terminalId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Contains the terminal serial number or means of identifying the terminal for merchant locations with multiple terminals.
Added On:  06/02/16
SQL Column:  TERMINAL_TRANSMISSION_DATE
Java Field:  terminalTransmissionDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Chip transaction field – Tag 9A – contains the terminal transmission date from the Chip reader, format YYMMDD where YY indicates the year, MM indicates the month, and DD indicates the day.
Added On:  06/02/16
SQL Column:  TERMINAL_TYPE
Java Field:  terminalType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F35 – contains the terminal type which indicates the environment of the terminal, its communications capability, and its operational control.
Added On:  06/02/16
SQL Column:  TERMINAL_VERIFICATION_RESULTS
Java Field:  terminalVerificationResults
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Chip transaction field – Tag 95 – contains a series of indicators from the terminal perspective. The terminal records the results of offline and online processing by setting a series of indicators in this field.
Added On:  06/02/16
SQL Column:  TOTAL_INSTALLMENT_AMOUNT
Java Field:  totalInstallmentAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Installment transaction field – contains the total installment amount.
Added On:  06/02/16
SQL Column:  TRACK_DATA_CONDITION_CODE
Java Field:  trackDataConditionCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Discover transactions only – The track data condition code field identifies the condition of the Track Data submitted in the authorization request. This field is required for association incentive interchange rates.
Added On:  06/02/16
SQL Column:  TRANSACTION_AMOUNT
Java Field:  transactionAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
If the merchant is utilizing Dynamic Currency Conversion (DCC), the transaction amount field contains the amount of the transaction in the transaction currency before DCC is applied.

For all other types of transactions (i.e., all transactions except DCC), the transaction amount field contains the amount of the transaction in the local currency. This is the transaction amount that will be processed by Elavon to the Card associations.

The transaction amount is a required field. 2 decimals are implied for US and Canadian transactions.

The transaction amount must include the surcharge amount if one is assessed.
Added On:  06/02/16
SQL Column:  TRANSACTION_CATEGORY_CODE
Java Field:  transactionCategoryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F53 – indicates the type of transaction being performed.
Added On:  06/02/16
SQL Column:  TRANSACTION_CURRENCY_CODE
Java Field:  transactionCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Contains the numeric value for the currency code for the transaction.
Added On:  06/02/16
SQL Column:  TRANSACTION_DATE
Java Field:  transactionDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The date of sale or refund in the format YYMMDD where YY denotes the year, MM denotes the month, and DD denotes the day.
Added On:  06/02/16
SQL Column:  TRANSACTION_IDENTIFIER
Java Field:  transactionIdentifier
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Visa and Amex transactions – this field must include an identifier provided in the authorization message to facilitate linking of authorization and settlement records. This field is required for Visa incentive interchange rates. All other card brands – this field should be space filled.
Added On:  06/02/16
SQL Column:  TRANSACTION_REFERENCE_ROC
Java Field:  transactionReferenceRoc
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Contains the merchant transaction reference information. This information is also referred to as the Record of Charge (ROC). The information in this field will be used to investigate any transaction level inquiries. This field is a user defined optional field. ROC information is at a transaction level and is returned to the merchant in the EPA file.
Added On:  06/02/16
SQL Column:  TRANSACTION_SEQUENCE_COUNTER
Java Field:  transactionSequenceCounter
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F41 – contains the sequence number assigned to the transaction. The transaction sequence counter is a counter maintained by the terminal that is incremented by one for each transaction.
Added On:  06/02/16
SQL Column:  TRANSACTION_TIME
Java Field:  transactionTime
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Contains the local transaction time in the format HHMMSS where H indicates the hour, M indicates the minute, and S indicates the seconds. The local transaction time is in the time zone the merchant is located in.
Added On:  06/02/16
SQL Column:  TRANSACTION_TYPE_IDENTIFIER
Java Field:  transactionTypeIdentifier
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Used to differentiate between debit (sale) and credit (refund) transactions as follows:
  • 05 = Sale
  • 06 = Refund
Added On:  06/02/16
SQL Column:  TYPE_OF_INSTALLMENT
Java Field:  typeOfInstallment
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Installment transaction field – contains a value indicating the type of installment, issuer or acquirer.
Added On:  06/02/16
SQL Column:  UCAF_COLLECTION_INDICATOR
Java Field:  ucafCollectionIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
MasterCard transactions only – the UCAF Collection Indicator is present on Secure Code e-commerce transactions only indicating the type of participation.
Added On:  06/02/16
SQL Column:  UNPREDICTABLE_NUMBER
Java Field:  unpredictableNumber
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Chip transaction field – Tag 9F37 – this field contains the number used in the generation of the cryptogram for chip transactions. It provides variability and uniqueness to the cryptogram.
Added On:  06/02/16
SQL Column:  VALIDATION_CODE
Java Field:  validationCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Visa transactions only – validation code is a unique value that Visa includes as part of the authorization response for CPS transactions to ensure that key authorization fields are preserved in the clearing record.