Added On:  03/21/18 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  RetailElavonProfile 
                    
        
        
     
    
        
            
                
                    Encapsulates Elavon specific settings required for real-time transaction processing. Adds Elavon specific fields to the base fields of 
Billing Profile and 
Retail Profile.
                
 
         
     
        
        
                    
                        
                Added On:  08/20/12
                SQL Column:  BANK_NBR
                Java Field:  bankNbr
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This six digit fixed length value is assigned by Elavon.                        
                     
                 
             
                    
                        
                Added On:  10/16/12
                SQL Column:  CUSTOMER_SERVICE_NUMBER
                Java Field:  customerServiceNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Customer service telephone number.                        
                     
                 
             
                    
                        
                Added On:  08/08/13
                SQL Column:  DESCRIPTOR
                Java Field:  descriptor
             
            
                Status:  Active
                SQL Type:  varchar(21)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Catalogue name/product type/installment information.                        
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  DESCRIPTOR_PREFIX
                Java Field:  descriptorPrefix
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Abbreviated corporate name.                        
                     
                 
             
                    
                        
                Added On:  10/16/12
                SQL Column:  DESTINATION_NUMBER
                Java Field:  destinationNumber
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Country Code of the destination address.                        
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  ECOMMERCE_MCC
                Java Field:  ecommerceMcc
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Ecommerce MCC (merchant category code).
Note: The Associations have assigned specific Merchant Category Codes (MCC) for merchants according to the operating regulations. If this field is not filled by the merchant, Elavon will insert the appropriate Merchant Category Code from its accounting system.                         
                     
                 
             
                    
                        
                Added On:  02/04/13
                SQL Column:  ECOMMERCE_MERCHANT_ID
                Java Field:  ecommerceMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Ecommerce merchant identification number. Provided by the processor.                        
                     
                 
             
                    
                        
                Added On:  06/06/16
                SQL Column:  ECOMMERCE_POINT_OF_SALE_NAME
                Java Field:  ecommercePointOfSaleName
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the name of the travel agent or ticketing location where the transaction took place.                         
                     
                 
             
                    
                        
                Added On:  08/20/12
                SQL Column:  ECOMMERCE_TERMINAL_NBR
                Java Field:  ecommerceTerminalNbr
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This sixteen digit fixed length value is assigned by Elavon. 
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:  10/12/15
                SQL Column:  EMAIL_ADDRESS
                Java Field:  emailAddress
             
            
                Status:  Active
                SQL Type:  varchar(160)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Email address of the merchant.                        
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  FILE_IDENTIFICATION
                Java Field:  fileIdentification
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains an identification code assigned by Elavon. The identification code can be up to 6 positions in length. If less than six positions are assigned, the remaining positions in this field should be space filled.                         
                     
                 
             
                    
                        
                Added On:  01/06/15
                SQL Column:  INSTITUTION_NAME
                Java Field:  institutionName
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/22/20
                SQL Column:  IS_FILE_RENAMING_REQUIRED
                Java Field:  isFileRenamingRequired
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
            
                    
                        
                Added On:  03/11/13
                SQL Column:  IS_TEST_MODE
                Java Field:  isTestMode
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates that this transaction should be processed in test mode, when it is handled by the processor.                        
                     
                 
             
                    
                        
                Added On:  03/21/13
                SQL Column:  KEY_POINTER_CL
                Java Field:  keyPointerCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Enumeration of key pointer values for Elavon.                        
                     
                 
             
                    
                        
                Added On:  10/16/12
                SQL Column:  MERCHANT_CITY
                Java Field:  merchantCity
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City of the mailing address for the merchant.                        
                     
                 
             
                    
                        
                Added On:  10/16/12
                SQL Column:  MERCHANT_COUNTRY_CODE
                Java Field:  merchantCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Country code of the mailing address for the merchant.                        
                     
                 
             
                    
                        
                Added On:  10/16/12
                SQL Column:  MERCHANT_DBA_NAME
                Java Field:  merchantDbaName
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Merchant DBA override data.
This value contains the “Doing Business As” name override data from the merchant. If this value is not present, then Elavon will use the DBA name on file.                        
                     
                 
             
                    
                        
                Added On:  10/16/12
                SQL Column:  MERCHANT_STATE
                Java Field:  merchantState
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        State of the mailing address for the merchant.                        
                     
                 
             
                    
                        
                Added On:  04/24/13
                SQL Column:  MERCHANT_STREET_ADDRESS
                Java Field:  merchantStreetAddress
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Street of the mailing address for the merchant.                        
                     
                 
             
                    
                        
                Added On:  10/16/12
                SQL Column:  MERCHANT_ZIP_CODE
                Java Field:  merchantZipCode
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Postal code (ZIP code) of the mailing address for the merchant.                        
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  MOTO_MCC
                Java Field:  motoMcc
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        MOTO MCC (merchant category code).
Note: The Associations have assigned specific Merchant Category Codes (MCC) for merchants according to the operating regulations. If this field is not filled by the merchant, Elavon will insert the appropriate Merchant Category Code from its accounting system.                         
                     
                 
             
                    
                        
                Added On:  02/04/13
                SQL Column:  MOTO_MERCHANT_ID
                Java Field:  motoMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        MOTO merchant identification number. Provided by the processor.                        
                     
                 
             
                    
                        
                Added On:  06/06/16
                SQL Column:  MOTO_POINT_OF_SALE_NAME
                Java Field:  motoPointOfSaleName
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the name of the travel agent or ticketing location where the transaction took place.                         
                     
                 
             
                    
                        
                Added On:  08/20/12
                SQL Column:  MOTO_TERMINAL_NBR
                Java Field:  motoTerminalNbr
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This sixteen digit fixed length value is assigned by Elavon.
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:  05/25/18
                SQL Column:  PAYMENT_FACILITATOR_ID
                Java Field:  paymentFacilitatorId
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/02/16
                SQL Column:  PROCESSOR_BUILDING_NUMBER
                Java Field:  processorBuildingNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the building number for the processing center.                        
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  PROCESSOR_CITY
                Java Field:  processorCity
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the city for the processing center.                        
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  PROCESSOR_COUNTRY_CODE
                Java Field:  processorCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the country for the processing center.                         
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  PROCESSOR_ID
                Java Field:  processorId
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the identifier for the processor (users can populate this field with their company details).                         
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  PROCESSOR_NAME
                Java Field:  processorName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the name for the merchant’s processor.                         
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  PROCESSOR_PHONE_NUMBER
                Java Field:  processorPhoneNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the phone number for the processing center.                        
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  PROCESSOR_STREET_NAME
                Java Field:  processorStreetName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the street name for the processing center.                        
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  PROCESSOR_ZIP_CODE
                Java Field:  processorZipCode
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the ZIP (or postal) code for the processing center.
                        
                     
                 
             
                    
                        
                Added On:  08/20/12
                SQL Column:  REG_KEY
                Java Field:  regKey
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Required in all Scripts sent to the Elavon Host for processing and will be sent as a HTTP Header Field in the Post request. 
Notes: The Registration Key should be sent as an HTTP Header field.  
The NOVA_PORTAL_FAKE_KEY is only used to send transactions to the Elavon development host and cannot be used to send traffic to production hosts. A production Registration Key will be assigned by the Certification Department after certification is complete and is 20 characters long.                        
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  RESTAURANT_MCC
                Java Field:  restaurantMcc
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Restaurant MCC (merchant category code).
Note: The Associations have assigned specific Merchant Category Codes (MCC) for merchants according to the operating regulations. If this field is not filled by the merchant, Elavon will insert the appropriate Merchant Category Code from its accounting system.                         
                     
                 
             
                    
                        
                Added On:  02/04/13
                SQL Column:  RESTAURANT_MERCHANT_ID
                Java Field:  restaurantMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Restaurant merchant identification number. Provided by the processor.                        
                     
                 
             
                    
                        
                Added On:  06/06/16
                SQL Column:  RESTAURANT_POINT_OF_SALE_NAME
                Java Field:  restaurantPointOfSaleName
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the name of the travel agent or ticketing location where the transaction took place.                         
                     
                 
             
                    
                        
                Added On:  01/14/13
                SQL Column:  RESTAURANT_TERMINAL_NBR
                Java Field:  restaurantTerminalNbr
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This variable length value is assigned by Elavon and has a minimum length of 1 and a maximum length of 16.
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:  06/02/16
                SQL Column:  RETAIL_MCC
                Java Field:  retailMcc
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Retail MCC (merchant category code).
Note: The Associations have assigned specific Merchant Category Codes (MCC) for merchants according to the operating regulations. If this field is not filled by the merchant, Elavon will insert the appropriate Merchant Category Code from its accounting system.                         
                     
                 
             
                    
                        
                Added On:  02/04/13
                SQL Column:  RETAIL_MERCHANT_ID
                Java Field:  retailMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Retail merchant identification number. Provided by the processor.                        
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  RETAIL_POINT_OF_SALE_NAME
                Java Field:  retailPointOfSaleName
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the name of the travel agent or ticketing location where the transaction took place.                         
                     
                 
             
                    
                        
                Added On:  08/20/12
                SQL Column:  RETAIL_TERMINAL_NBR
                Java Field:  retailTerminalNbr
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This sixteen digit fixed length value is assigned by Elavon.
Identifies a processing device associated to a Point of Sale division. This is not a required Format Indicator for retail transactions, but should be provided if possible to meet association rules and qualify for the best interchange rates.                        
                     
                 
             
                    
                        
                Added On:  06/02/16
                SQL Column:  SE_NUMBER
                Java Field:  seNumber
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the Service Establishment number and will contain either the Specific SE number assigned to the merchant (i.e. Discover SE, AMEX SE) or the HIMMS2-merchant number if the transaction is being processed on the international platform. This number is assigned to a merchant by Elavon and identifies the merchants profile and the settlement currency requirements. It should be noted that for each settlement currency required there will be a unique SE number assigned. This format does not support AMEX transactions from T&E merchants, for example airlines, hotels, and car rentals.                         
                     
                 
             
                    
                        
                Added On:  10/12/15
                SQL Column:  SUB_MERCHANT_ID
                Java Field:  subMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identification number of the submerchant.                        
                     
                 
             
                    
                        
                Added On:  05/25/18
                SQL Column:  SUB_MERCHANT_TAX_ID
                Java Field:  subMerchantTaxId
             
            
                Status:  Active
                SQL Type:  varchar(14)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  05/25/18
                SQL Column:  VAT_REGISTRATION_NUMBER
                Java Field:  vatRegistrationNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/20/12
                SQL Column:  VENDOR_ID
                Java Field:  vendorId
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is assigned by the Vendor Certification Department of ELAVON.
This number is an alphanumeric value and should be capitalized. All Vendor Certification Device Types are value of "Z".                        
                     
                 
             
                    
                        
                Added On:  10/16/12
                SQL Column:  VERSION_CL
                Java Field:  versionCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Enumeration of versions for Elavon.