Elavon4 Auth Retail Transaction                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  10/17/12 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  Elavon4AuthRetailTransaction 
                    
        
        
     
    
        
        
                    
                        
                Added On:  09/09/16
                SQL Column:  ACCOUNT_BALANCE3
                Java Field:  accountBalance3
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Field used for account balance amount.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  ACCOUNT_BALANCE1
                Java Field:  accountBalance1
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For Credit and Debit cards, if present this value indicates the remaining balance for a pre-paid account. For EBT transactions, if present this value indicates the remaining Food Stamp balance. For Gift Card transactions, if present this value indicates the remaining Gift Card balance on the account. Refer to the specification of the provider for more information.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  ACCOUNT_BALANCE2
                Java Field:  accountBalance2
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For Credit and Debit cards, if present this value indicates the remaining Gift Card Balance on the account. 
For EBT transactions, if present this value indicates the remaining Cash Benefit balance. 
For Gift Card transactions, if present this value indicates the remaining Loyalty points on the account.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  ACCOUNT_DATA
                Java Field:  accountData
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        The value is used to submit the cardholder account data to Elavon for processing. Refer to the specification of the provider for more information.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  ACCOUNT_ENTRY_MODE
                Java Field:  accountEntryMode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to identify the method used to enter the Account Data for the transaction. Refer to the specification of the provider for more information.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  ACCOUNT_TYPE
                Java Field:  accountType
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to facilitate transaction routing on Elavon. 
0 = Default or primary account on file (In Canada this is only used for Flash Transactions) 
1 = Checking 
2 = Savings 
3 = Food Stamp 
4 = Cash Benefits                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  AMEX_CAPTURE_CODE
                Java Field:  amexCaptureCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This is the American Express Capture Code field and is returned during a credit card authorization response. It determines the capture option allowed for the American Express Card in the Split Dial environment, where the POS is accessing Amex directly for Authorization processing of Amex Cards. 
0 = Do not process 
1 = Allow authorizations but do not capture in Settlement file 
2 = Allow authorizations and capture in settlement file for processing                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  APPLICATION_ID
                Java Field:  applicationId
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field is used to indicate the type of POS device that is originating the transaction. These values are case sensitive and must be capitalized.  Sample: HZ0000GC.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  APPROVAL_CODE
                Java Field:  approvalCode
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field contains the Approval Code for an approved transaction. 
Note:  If the Response Code on the auth. is not equal to "AA" or “AP” the contents of this field are ignored.                        
                     
                 
             
                    
                        
                Added On:  02/16/16
                SQL Column:  ASSOCIATION_NAME
                Java Field:  associationName
             
            
                Status:  Active
                SQL Type:  varchar(38)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name of the assigned association.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  AUTHORIZATION_DATE
                Java Field:  authorizationDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is the date which the transaction was authorized. For offline transactions, this value should be set to the date when the transaction occurs.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  AUTHORIZATION_RESPONSE
                Java Field:  authorizationResponse
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field contains the 16 character response display message. This field is used by the POS device to display the authorization results.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  AUTHORIZATION_SOURCE
                Java Field:  authorizationSource
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the source for the authorization response.  The values in this response message are subject to additions.  
For On-Line transactions, the codes are supplied by the Issuer and are returned by Elavon in the response message for all on line approvals.
For Off-Line transactions, this is a one character field in the table below contains the Authorization Source code:
9 = No Authorization Source Code. This is used for non-authorized transactions, such as Credit Card Returns 
E = Off-Line Approval. This is used when the approval code is manually entered, such as  on a Referral or Force Transaction 
6 = Off-Line approval, POS generated the approval.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  AUTHORIZATION_TIME
                Java Field:  authorizationTime
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is the time which the transaction was authorized. For offline transactions, this value should be set to the time when the transaction occurs.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  AUTHORIZED_AMOUNT
                Java Field:  authorizedAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to identify the total authorized amount for the authorization request. If the Partial authorization flag is enabled, this amount may be less than the requested amount.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  AVS_RESPONSE
                Java Field:  avsResponse
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value contains the address verification response code returned in response message as a result of an AVS Request. It is also a required value for a terminal-based settlement, if returned in the authorization response. Refer to the specification of the provider for more information.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  CAPTURE_CODE
                Java Field:  captureCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field is used to indicate to the POS which transactions should be captured in the local Shadow file. 
0 = Do not Capture – Authorization Only 
1 = Capture Transaction in Shadow File (EDC) 
2 = Capture Transaction in Shadow File (EDC). This value is used for Debit Returns to indicate that the Debit Purchase is in the current batch.                          
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  CASHBACK_AMOUNT
                Java Field:  cashbackAmount
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field is used to indicate the cashback amount applied to the transaction. This amount should be included in the Transaction Amount field.                         
                     
                 
             
                    
                        
                Added On:  04/02/15
                SQL Column:  CAT_INDICATOR
                Java Field:  catIndicator
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the type of Cardholder Activated Terminal Indicator for this transaction. 
00 = Not a CAT Transaction 
01 = Limited Amount Terminal 
02 = Automated Dispensing Machine 
03 = Self-Service Terminal (AFD) 
04 = In-Flight Commerce 
05 = Internet 
06 = Transponder 
07 = Remote Indicator                          
                     
                 
             
                    
                        
                Added On:  11/19/14
                SQL Column:  CHARGE_TRANSACTION_FK
                Java Field:  chargeTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents real-time financial transaction.                        
                     
                 
             
                    
                        
                Added On:  01/21/15
                SQL Column:  CLINIC_OTHER_AMOUNT
                Java Field:  clinicOtherAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        This value is used to submit the amount of all Clinical or other qualified medical expenses contained within this purchase.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  CUSTOMER_CODE
                Java Field:  customerCode
             
            
                Status:  Active
                SQL Type:  varchar(51)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to identify the customer number for purchasing card transactions.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  CVV2_INDICATOR
                Java Field:  cvv2Indicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the presence of the CVV2 data on the Visa card.  For non-Visa Cards, the value of “Present” should be used when CVC2 or CID data is present, or “Bypassed” when not present. 
0 = Bypassed 
1 = Present 
2 = Illegible 
9 = Not Present                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  CVV2_RESPONSE
                Java Field:  cvv2Response
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value contains the Card verification response code returned in Authorization Response.  It is also a required value for a terminal-based settlement message, if returned in the authorization response. 
M = Match 
N = No match 
P = Not Processed 
S = Issuer indicates that CVV2 data should be present on the card, but the merchant has indicated that the CVV2 data is not present on the card (Visa Only) 
U = Issuer not certified or registered to process card verification.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  CVV2_VALUE
                Java Field:  cvv2Value
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is a three to four digit value that appears at the end of the printed PAN on the reserve side of the card. This value is used to verify a card’s authenticity for the purpose of preventing fraud in the mail order, telephone order (MO/TO) and card-not-present environments.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  DEBIT_EBT_NETWORK_ID
                Java Field:  debitEbtNetworkId
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the Debit Network that the transaction was routed through for authorization. It may also be used on the Debit Purchase and PINLess Purchase transaction to indicate the preferred Debit Network routing ID for authorization. Refer to the specification of the provider for more information.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  DEBIT_EBT_SETTLEMENT_DATE
                Java Field:  debitEbtSettlementDate
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is the debit switch settlement date in MMDD format.                         
                     
                 
             
                    
                        
                Added On:  01/21/15
                SQL Column:  DENTAL_AMOUNT
                Java Field:  dentalAmount
             
            
                Status:  Active
                SQL Type:  int(11)(12)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        This value is used to submit the amount of all Dental expenses contained within this purchase.                         
                     
                 
             
                    
                        
                Added On:  09/09/16
                SQL Column:  DEVICE_TYPE
                Java Field:  deviceType
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/23/16
                SQL Column:  DOCUMENTATION_VERSION
                Java Field:  documentationVersion
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Vestion of the corresponding documentation.                        
                     
                 
             
                    
                        
                Added On:  05/25/18
                SQL Column:  DYNAMIC_AUTH_TYPE_INDICATOR
                Java Field:  dynamicAuthTypeIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/31/15
                SQL Column:  DYNAMIC_CITY
                Java Field:  dynamicCity
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic city of the merchant.                        
                     
                 
             
                    
                        
                Added On:  07/31/15
                SQL Column:  DYNAMIC_COUNTRY_CODE
                Java Field:  dynamicCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic country code of the merchant.                        
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  DYNAMIC_DBA_NAME
                Java Field:  dynamicDbaName
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value allows the merchant to dynamically change the “Doing Business As” name on each transaction submitted to the host for authorization and settlement. The use of the dynamic DBA (dDBA) field is restricted by Elavon and requires prior approval to participate in the program.  Values that are sent in this field by merchants that are not approved for use of this field will be ignored by the host prior to authorization and the value currently “on file” with Elavon will be used.                         
                     
                 
             
                    
                        
                Added On:  05/25/18
                SQL Column:  DYNAMIC_EMAIL_ADDRESS
                Java Field:  dynamicEmailAddress
             
            
                Status:  Active
                SQL Type:  varchar(70)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  05/25/18
                SQL Column:  DYNAMIC_MCC
                Java Field:  dynamicMcc
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/31/15
                SQL Column:  DYNAMIC_PHONE_NUMBER
                Java Field:  dynamicPhoneNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic phone number of the merchant.                        
                     
                 
             
                    
                        
                Added On:  07/31/15
                SQL Column:  DYNAMIC_POSTAL_CODE
                Java Field:  dynamicPostalCode
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic ZIP (or postal) code of the merchant.                        
                     
                 
             
                    
                        
                Added On:  07/31/15
                SQL Column:  DYNAMIC_STATE
                Java Field:  dynamicState
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic state code of the merchant.                        
                     
                 
             
                    
                        
                Added On:  07/31/15
                SQL Column:  DYNAMIC_STREET_ADDRESS
                Java Field:  dynamicStreetAddress
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic street address of the merchant.                        
                     
                 
             
                    
                        
                Added On:  07/31/15
                SQL Column:  DYNAMIC_SUB_MERCHANT_ID
                Java Field:  dynamicSubMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic sub-merchant identification number of the merchant.                        
                     
                 
             
                    
                        
                Added On:  05/25/18
                SQL Column:  DYNAMIC_TAX_ID
                Java Field:  dynamicTaxId
             
            
                Status:  Active
                SQL Type:  varchar(14)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  05/25/18
                SQL Column:  ECI_SECURITY_LEVEL_INDICATOR
                Java Field:  eciSecurityLevelIndicator
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  10/17/12
                SQL Column:  ECOMMERCE_INDICATOR
                Java Field:  ecommerceIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This indicates the method used to capture the cardholder’s information for an eCommerce or Internet transaction. 
1 = Secure Electronic Commerce Transaction that includes the 3-D Secure Authentication value. (5) 
2 = Non-Authenticated Security Transaction from a 3-D Secure capable merchant, and merchant attempted to authorize using 3-D Secure. Transaction Does Not Include 3-D Secure authentication value. (6) 
3 = Non-Authenticated Security Transaction w/o Merchant Certificate i.e., Channel Encrypted (7) 
4 = Non-Authenticated Security Transaction at a SET Capable merchant (9) 
5 = Non-Secure Transaction (no encryption used) (8)                          
                     
                 
             
                    
                        
                Added On:  09/09/16
                SQL Column:  EMV_KEY_DATE
                Java Field:  emvKeyDate
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date when the EMV key was generated.                        
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  GIFT_LOYALTY_TRANSACTION_CODE
                Java Field:  giftLoyaltyTransactionCode
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This character is used by the POS to uniquely identify the transaction to the gift card host. This value is required for both Gift Card and Loyalty reversal transactions. 
A unique value assigned by the POS to identify the gift card transaction.                         
                     
                 
             
                    
                        
                Added On:  01/21/15
                SQL Column:  HEALTHCARE_AMOUNT
                Java Field:  healthcareAmount
             
            
                Status:  Active
                SQL Type:  int(11)(12)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        This value is used to submit the total amount of All qualified medical expenses (Over the counter, Dental, Prescription, Vision, and Clinical/Other amount) contained within this Auto-Substantiation purchase. The “Transit Amount” is not included in this calculation.                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_AED
                Java Field:  iccAed
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to identify the date after which the application expires (The Application Expiration Date).                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_AIP
                Java Field:  iccAip
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the capabilities of the card to support specific functions within the application (The Application Interchange Profile).                         
                     
                 
             
                    
                        
                Added On:  12/01/14
                SQL Column:  ICC_ARC
                Java Field:  iccArc
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is generated by the authorization authority for an approved transaction.                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_ARPC
                Java Field:  iccArpc
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value contains data sent to the chip card for online issuer authentication.                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_ATC
                Java Field:  iccAtc
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This is an incrementing counter value that is managed by the application in the chip card (The Application Transaction Counter).                        
                     
                 
             
                    
                        
                Added On:  03/12/15
                SQL Column:  ICC_ATC_RESPONSE
                Java Field:  iccAtcResponse
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This is an incrementing counter response value that is managed by the application in the chip card.                         
                     
                 
             
                    
                        
                Added On:  12/01/14
                SQL Column:  ICC_AUTHORIZED_AMOUNT
                Java Field:  iccAuthorizedAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the authorized amount of the transaction (excluding adjustments).                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_CID
                Java Field:  iccCid
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value indicates the type of cryptogram and the actions to be performed by the terminal (The Cryptogram Information Data).                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_CRYPTOGRAM
                Java Field:  iccCryptogram
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This cryptogram value is returned by the Chip (ICC) in response to a “Generate AC” command.                        
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_CSN
                Java Field:  iccCsn
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to differentiate chip cards using the same Primary Account Number (PAN).                         
                     
                 
             
                    
                        
                Added On:  03/12/15
                SQL Column:  ICC_CSN_RESPONSE
                Java Field:  iccCsnResponse
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This response value is used to differentiate chip cards using the same Primary Account Number (PAN).                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_CUSTOMER_EXCLUSIVE_DATA
                Java Field:  iccCustomerExclusiveData
             
            
                Status:  Active
                SQL Type:  varchar(64)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field is available for the Issuer’s discretionary use. The issuer is responsible for ensuring its use of the field complies with all applicable laws and its own privacy policy.                         
                     
                 
             
                    
                        
                Added On:  12/01/14
                SQL Column:  ICC_CVMR
                Java Field:  iccCvmr
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the results of the last CVM preformed. The Cardholder Verification Method Results (CVM) – EMV Tag 9F34.                         
                     
                 
             
                    
                        
                Added On:  08/23/16
                SQL Column:  ICC_DEDICATED_FILE_NAME
                Java Field:  iccDedicatedFileName
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ICC (International Chamber of Commerce) dedicated name of a file.                        
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_FORM_FACTOR_INDICATOR
                Java Field:  iccFormFactorIndicator
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field contains indicators about the attributes of the card holder’s device and the technology used for communication between the cardholder’s device and the acquiring POS Device.                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_IAD
                Java Field:  iccIad
             
            
                Status:  Active
                SQL Type:  varchar(64)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to send proprietary application data to the issuer in an online transaction.                         
                     
                 
             
                    
                        
                Added On:  01/19/15
                SQL Column:  ICC_ISR
                Java Field:  iccIsr
             
            
                Status:  Active
                SQL Type:  varchar(84)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to identify the results of the terminal script processing.                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_ISSUER_SCRIPT
                Java Field:  iccIssuerScript
             
            
                Status:  Active
                SQL Type:  varchar(256)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to return the Issuer specified script contained in EMV Tags 71 or 72 back to the POS in the authorization response message. Refer to the specidication of the provider for more information.                        
                     
                 
             
                    
                        
                Added On:  12/01/14
                SQL Column:  ICC_OTHER_AMOUNT
                Java Field:  iccOtherAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate a secondary “Cashback” amount associated with the transaction.                         
                     
                 
             
                    
                        
                Added On:  03/12/15
                SQL Column:  ICC_TCC
                Java Field:  iccTcc
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to identify the country code where the terminal is located.                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_TCP
                Java Field:  iccTcp
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value indicates the card data input, CVM, and security capabilities of the terminal.                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_TERMINAL_TYPE
                Java Field:  iccTerminalType
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the environment of the terminal, its communication capability, and its operational control.                        
                     
                 
             
                    
                        
                Added On:  05/13/16
                SQL Column:  ICC_THIRD_PARTY_DATA
                Java Field:  iccThirdPartyData
             
            
                Status:  Active
                SQL Type:  varchar(64)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Data assigned to ICC third party company.                        
                     
                 
             
                    
                        
                Added On:  12/01/14
                SQL Column:  ICC_TRANSACTION_CURRENCY
                Java Field:  iccTransactionCurrency
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the currency code of the transaction according to the ISO 4217 standard.                         
                     
                 
             
                    
                        
                Added On:  12/01/14
                SQL Column:  ICC_TT
                Java Field:  iccTt
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value indicates the type of financial transaction, represented by the first two digits of the ISO 8583 processing code.                        
                     
                 
             
                    
                        
                Added On:  12/01/14
                SQL Column:  ICC_TTD
                Java Field:  iccTtd
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the local data that the transaction was authorized (The Transaction Date).                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_TVR
                Java Field:  iccTvr
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value indicates the status of the different functions as seen from the terminal.                         
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  ICC_UNPREDICTABLE_NUMBER
                Java Field:  iccUnpredictableNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to provide variability and uniqueness to the generation of a cryptogram.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
                
                    Attributes:
                    Unique, Required, CreateOnly, ReadOnly                
                             
            
                
                    
                        
                        Identifier of the object used for references; auto-incremented integer value.                        
                     
                 
             
                    
                        
                Added On:  12/06/12
                SQL Column:  INSTALLMENT_COUNT
                Java Field:  installmentCount
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the total number of payments for an installment transaction. For example, if the consumer is making payment 1 of 12, then this value should be set to “12”.                         
                     
                 
             
                    
                        
                Added On:  12/06/12
                SQL Column:  INSTALLMENT_NUMBER
                Java Field:  installmentNumber
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the current payment number for an installment transaction. For example, if the consumer is making payment 1 of 12, then this value should be set to “1”.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  INVOICE_NUMBER
                Java Field:  invoiceNumber
             
            
                Status:  Active
                SQL Type:  varchar(75)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to include the POS’s local transaction invoice or order number. This is a required value for Mail Order and Ecommerce transactions.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  ISSUER_RESPONSE_CODE
                Java Field:  issuerResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is the original Issuer response as returned during the authorization attempt.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  KEY_POINTER
                Java Field:  keyPointer
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate which encryption methodology was used for US Debit transactions (POS to Elavon) and which key to use for the next transaction (Elavon to POS).
D = Single-DES DUKPT 
T = Triple-DES DUKPT 
P = PIN Less Debit Purchase                         
                     
                 
             
                    
                        
                Added On:  08/26/15
                SQL Column:  
                Java Field:  kns
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        This is the value returned by the PIN Pad device, which was used to encrypt the cardholder’s Personal Identification Number (PIN) using the Derived Unique Key Per Transaction (DUKPT) method.  It is a 10 byte composite field that is transmitted as 20 alphanumeric characters.                        
                     
                 
             
                    
                        
                Added On:  01/15/15
                SQL Column:  LINE_NUMBER
                Java Field:  lineNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field is used to allow a multi-lane retailer using interleaved processing to send up a unique value that will identify the lane where the transaction originated from.                        
                     
                 
             
                    
                        
                Added On:  01/18/16
                SQL Column:  
                Java Field:  macKey
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Key assigned to the merchant account code.                        
                     
                 
             
                    
                        
                Added On:  10/14/15
                SQL Column:  MAC_VALUE
                Java Field:  macValue
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Message Authentication Code (MAC) is used to verify that a Canadian Debit message transferred over a telecommunications network has not been altered. The MAC Value is optional on a Canadian Debit Reversal and must space filled if not utilized.                         
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  MEMBER_NAME
                Java Field:  memberName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Member name associated with the gift or loyalty card transaction, if available.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  MERCHANT_ACCOUNT_CODE
                Java Field:  merchantAccountCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Code of 
Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.                        
 
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  MERCHANT_REFERENCE_NBR
                Java Field:  merchantReferenceNbr
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value contains the merchant assigned reference number for this transaction. If this value is not present, then Elavon will generate this number for backend use.                           
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  MSDI
                Java Field:  msdi
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Market Specific Data Indicator value. 
0 = Returned if the data was not presented in authorization 
1 = Returned if the data passed the Hotel Edits (H) 
2 = Returned if the data failed Edits (N) 
3 = Healthcare / Auto-Substantiation (M) 
4 = Transit / Auto-Substantiation (T) 
5 = Returned if the data passed the Visa Aggregator edits (E) 
6 = Returned if the data passed the Auto Rental edits (A) 
7 = Returned if the data passed the Bill Payment edits (B) 
8 = Returned if the data passed the MasterCard Payment Gateway edits (G) 
9 = Business to Business Invoice Payments (J)                          
                     
                 
             
                    
                        
                Added On:  02/08/16
                SQL Column:  ORIGINAL_APPROVAL_CODE
                Java Field:  originalApprovalCode
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Approval code associated with the original transaction.                        
                     
                 
             
                    
                        
                Added On:  02/08/16
                SQL Column:  ORIGINAL_PS2000_DATA
                Java Field:  originalPs2000Data
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Record that contains specified data assigned by a processor.                        
                     
                 
             
                    
                        
                Added On:  02/08/16
                SQL Column:  ORIGINAL_RESPONSE_CODE
                Java Field:  originalResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Response code associated with the original transaction.                        
                     
                 
             
                    
                        
                Added On:  02/08/16
                SQL Column:  ORIGINAL_TRACE_NUMBER
                Java Field:  originalTraceNumber
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Trace number of the merchant from which the payment is applied.
                        
                     
                 
             
                    
                        
                Added On:  02/10/16
                SQL Column:  ORIGINAL_TRANSACTION_REFERENCE_NBR
                Java Field:  originalTransactionReferenceNbr
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Secondary identifier of the transaction which can be used to cross-reference records between UniPay and integrated systems. 
                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  PARTIAL_AUTH_INDICATOR
                Java Field:  partialAuthIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate if the POS is capable of performing partial authorizations. 
0 = Indicates that the POS is not capable of Partial Authorizations. 
1 = Indicates that the POS is capable of Partial Authorizations. 
2 = Indicates that the POS is capable of Partial Authorizations and is a Visa Aggregator.                        
                     
                 
             
                    
                        
                Added On:  08/26/15
                SQL Column:  
                Java Field:  pinBlock
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        The encrypted Personal Identification Number entered by Debit / EBT Cardholder as identification for Transaction. The encrypted PIN Block is returned from the PIN Pad Device.                         
                     
                 
             
                    
                        
                Added On:  01/20/15
                SQL Column:  PIN_ENTRY_CAPABILITY
                Java Field:  pinEntryCapability
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the capability of the terminal to capture a PIN. 
0 = Unknown 
1 = Can accept and pass an online PIN 
2 = Cannot accept and pass an online PIN 
8 = PIN Pad is not functional                         
                     
                 
             
                    
                        
                Added On:  01/18/16
                SQL Column:  
                Java Field:  pinWorkingKey
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Key assigned to the current PIN of the cardholder.                        
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  POINTS_ADDED
                Java Field:  pointsAdded
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the number of points added to an account an account.                         
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  POINTS_CANCELED
                Java Field:  pointsCanceled
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the number of points to cancel from an account.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  POS_ENTRY_CAPABILITY
                Java Field:  posEntryCapability
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to identify the account entry capabilities on the POS device originating the transaction. Refer to the specification of the provider for more information.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  POSTAL_ZIP_CODE
                Java Field:  postalZipCode
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the cardholder’s Postal or ZIP Code.                        
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  PRE_AUTH_REFERENCE_NUMBER
                Java Field:  preAuthReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This is a Gift Card value used to identify the original pre-authorization request. This value is required to submit the post-authorization completion transaction message.                         
                     
                 
             
                    
                        
                Added On:  01/21/15
                SQL Column:  PRESCRIPTION_AMOUNT
                Java Field:  prescriptionAmount
             
            
                Status:  Active
                SQL Type:  int(11)(12)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        This value is used to submit the amount of all prescription expenses contained within this purchase.                         
                     
                 
             
                    
                        
                Added On:  10/14/15
                SQL Column:  PROCESSING_CODE
                Java Field:  processingCode
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Processing code of the transaction.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  PS2000_DATA
                Java Field:  ps2000Data
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This data will be as received during the original authorization processing.  It will not be present for off line transactions. This is a “retain and return” value for terminal-based settlement messages. Refer to the specification of the provider for more information.                        
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  RECEIPT_MESSAGE
                Java Field:  receiptMessage
             
            
                Status:  Active
                SQL Type:  varchar(40)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field contains a custom message as retuned from the Gift Card host to be printed on the cardholder’s receipt.                         
                     
                 
             
                    
                        
                Added On:  12/06/12
                SQL Column:  RECURRING_PAYMENT_TYPE
                Java Field:  recurringPaymentType
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field is used to identify the type of recurring transaction that is being submitted for authorization. 
A Recurring Transaction is a transaction in which a cardholder allows a merchant to charge their card for recurring goods or services for a mutually agreed-upon payment amount (variable or set) and for a specified length of time. The merchant must obtain written permission to bill a cardholder on a recurring basis.  Subsequent permission must be obtained when the agreement is renewed.  
Recurring transactions have a defined billing cycle and are in effect as long as the contract between the merchant and the cardholder is in good standing.  Recurring payments include charges for Utilities, membership fees, subscriptions, insurance premiums, tuition, etc. 
An Installment Transaction is a transaction in which a cardholder allows a merchant permission to charge their card for a single purchase of goods or services on a pre-determined payment schedule.  The merchant must obtain permission to bill the cardholder in an arrangement in which a single purchase of goods/service is divided into two or more payments.  Subsequent permission must be obtained when the agreement is modified.  
Installment transactions have a defined transaction amount, billing cycle, and a total number of payments, which equal the full amount for the original agreed upon purchase.  Installment payments include charges for loan payments, car purchase, furniture stores, etc. 
A Carne Bill Payment Transaction is a Brazilian transaction in which a cardholder enters into an agreement and signs a contract with the Merchant to make regular monthly payments using a domestic Brazilian Debit Card for a current purchase.  The cardholder then agrees to return to the store each month and present a domestic Brazilian Debit Card to make a payment according to the terms of the contract.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  REFERENCE_NUMBER
                Java Field:  referenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is a reference number assigned by Elavon and returned in the authorization response message.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  REQUEST
                Java Field:  request
             
            
                Status:  Active
                SQL Type:  varchar(40)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  10/17/12
                SQL Column:  RESPONSE_CODE
                Java Field:  responseCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is a 2 character code indicating the authorization response status. An approval is always indicated with an ‘AA’ or ‘AP’ code, all other codes indicate a non-approval. 
AA = Approved Transaction (Authorizations and Reversals) 
AP = Approved Transaction for a Partial Amount 
NC = Decline (Pick Up Card) 
ND = Decline (Hard or Soft) 
NF = Decline (Record Not Found) 
NR = Decline (Referral Message) 
N7 = Decline (For CVV2 Only) 
NL = Decline (Loyalty/Gift  Error) 
00-99 = Decline (Additional Gift Card Declined)                          
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
                Java Field:  retailTransactionCycle
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents a group of real-time transactions which must be settled together.                        
                     
                 
             
                    
                        
                Added On:  10/14/15
                SQL Column:  RETRIEVAL_REFERENCE_NUMBER
                Java Field:  retrievalReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Retrieval reference number of the merchant.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  SALES_TAX
                Java Field:  salesTax
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        This is the actual sales tax amount applied to this transaction. Consumer or Merchant tax exempt transactions can enter a single zero to properly reflect a tax exempt transaction.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  SHIPPING_DATE
                Java Field:  shippingDate
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The value is the date that the consumer’s goods were shipped. This value is the “Transaction Date” for direct marketing and ecommerce transactions.  
Shipping Date in MMDDYYYY format.                         
                     
                 
             
                    
                        
                Added On:  06/06/16
                SQL Column:  SPEND_QUALIFIER
                Java Field:  spendQualifier
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  05/25/18
                SQL Column:  STORED_CREDENTIAL_INDICATOR
                Java Field:  storedCredentialIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  10/17/12
                SQL Column:  STREET_ADDRESS
                Java Field:  streetAddress
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to identify the cardholder’s street address.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  SURCHARGE_AMOUNT
                Java Field:  surchargeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        This field is used to indicate the amount of the surcharge applied to the transaction. This amount should be included in the Transaction Amount field.                         
                     
                 
             
                    
                        
                Added On:  10/14/15
                SQL Column:  SYSTEM_TRACE_AUDIT_NBR
                Java Field:  systemTraceAuditNbr
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        System trace audit number.                        
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  TENDER_TYPE
                Java Field:  tenderType
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The value is used to identify the payment method use to activate or reload a gift card.  
0 = Cash 
1 = Credit Card 
2 = Debit Card 
3 = Check 
9 = Unknown                          
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  TERMINAL_ID
                Java Field:  terminalId
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The terminal identification number is used to uniquely identify the Merchant and their financial institution to Elavon. The Terminal ID consists of two parts and is assigned by Elavon for each POS device.                         
                     
                 
             
                    
                        
                Added On:  04/02/15
                SQL Column:  TERMINAL_TYPE
                Java Field:  terminalType
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the environment of the terminal, its communication capability, and its operational control.                         
                     
                 
             
                    
                        
                Added On:  08/26/15
                SQL Column:  
                Java Field:  threeDSecureValue
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Value of the 3-D secure verification of the transaction.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  TRACE_NUMBER
                Java Field:  traceNumber
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used as a message reference number identify the transaction request and is returned in all authorization response messages. It is sent to the host on reversal and void messages when applicable.                         
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  TRANSACTION_AMOUNT
                Java Field:  transactionAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        This is the actual amount of the transaction. The maximum transaction amounts supported are currently $9,999,999.99 for Visa and MasterCard, and $99,999.99 all others card associations. 
For Terminal-Based Settlement messages, this value will contain the total amount of the transaction in the Merchant’s currency, including any Tips (for restaurant transactions). 
For Canadian Debit Authorization Response messages, this field is zero filled and right justified to 12 characters.                          
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  TRANSACTION_CODE
                Java Field:  transactionCode
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to uniquely identify the type of transaction that is being submitted to Elavon. Refer to the specification of the provider for more information.                        
                     
                 
             
                    
                        
                Added On:  10/17/12
                SQL Column:  TRANSACTION_REFERENCE_NBR
                Java Field:  transactionReferenceNbr
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Transaction Reference Number is returned in the authorization response message and is used on void and reversal transactions, when available. This number is assigned by Elavon.                        
                     
                 
             
                    
                        
                Added On:  12/06/12
                SQL Column:  UCAF_INDICATOR
                Java Field:  ucafIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value identifies the means in which the transaction was processed between the cardholder and the merchant for a SecureCode authentication transaction. 
0 = UCAF data collection is not supported by the Merchant 
1 = UCAF data collection is supported by merchant but not populated 
2 = UCAF data collection is supported by merchant, and UCAF data must be present                         
                     
                 
             
                    
                        
                Added On:  01/21/15
                SQL Column:  VISION_AMOUNT
                Java Field:  visionAmount
             
            
                Status:  Active
                SQL Type:  int(11)(12)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        This value is used to submit the amount of all optical/vision expenses contained within this purchase.                         
                     
                 
             
                    
                        
                Added On:  09/03/14
                SQL Column:  VOUCHER_CLEAR_NBR
                Java Field:  voucherClearNbr
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Voucher Number from an EBT sales slip, used for Voucher Clear Food Stamp transactions.
The 15 digit Voucher Clear Number from the Merchant’s EBT Food Stamp sales slip.