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.                
             
         
     
        
        
                    
                        
                Added On:  12/06/19
                SQL Column:  ACCOUNTHOLDER_AUTHENTICATION_VALUE
                Java Field:  accountholderAuthenticationValue
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  12/06/19
                SQL Column:  ACCOUNTHOLDER_AUTHENTICATION_VALUE_COLLECTION_INDICATOR
                Java Field:  accountholderAuthenticationValueCollectionIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/27/15
                SQL Column:  AUTH_CHARACTERISTICS_IND
                Java Field:  authCharacteristicsInd
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  04/27/15
                SQL Column:  DYNAMIC_MERCHANT_CITY
                Java Field:  dynamicMerchantCity
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  12/06/19
                SQL Column:  DYNAMIC_MERCHANT_MCC_CODE
                Java Field:  dynamicMerchantMccCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  12/06/19
                SQL Column:  DYNAMIC_MERCHANT_PHONE_NUMBER
                Java Field:  dynamicMerchantPhoneNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/03/15
                SQL Column:  DYNAMIC_MERCHANT_STATE_CODE
                Java Field:  dynamicMerchantStateCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  04/27/15
                SQL Column:  DYNAMIC_MERCHANT_ZIP_CODE
                Java Field:  dynamicMerchantZipCode
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  04/27/15
                SQL Column:  
                Java Field:  expiryDate
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
                
                    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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  12/06/19
                SQL Column:  MOBILE_POS_INDICATOR
                Java Field:  mobilePosIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/27/15
                SQL Column:  MOTO_ECOMMERCE_AUTHENTICATION_INDICATOR
                Java Field:  motoEcommerceAuthenticationIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  06/14/16
                SQL Column:  NETWORK_REFERENCE_IDENTIFICATION_NUMBER
                Java Field:  networkReferenceIdentificationNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  12/06/19
                SQL Column:  POS_TERMINAL_CAPABILITY
                Java Field:  posTerminalCapability
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/14/16
                SQL Column:  PRODUCT_ID
                Java Field:  productId
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  12/16/15
                SQL Column:  TRACK_DATA_CONDITION_CODE
                Java Field:  trackDataConditionCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  04/06/15
                SQL Column:  TRANSACTION_REFERENCE
                Java Field:  transactionReference
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  04/27/15
                SQL Column:  VALIDATION_CODE
                Java Field:  validationCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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.