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.                
             
         
     
        
        
                    
                        
                Added On:  06/02/16
                SQL Column:  
                Java Field:  accountNumber
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
                
                    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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        Used to differentiate between debit (sale) and credit (refund) transactions as follows:
                         
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  TYPE_OF_INSTALLMENT
                Java Field:  typeOfInstallment
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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.