Retail Elavon Profile


Parent:    Retail Profile
Added On:  03/21/18 
SQL Table:  RETAIL_ELAVON_PROFILE 
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
Attributes:
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
Attributes:
Customer service telephone number.
Added On:  08/08/13
SQL Column:  DESCRIPTOR
Java Field:  descriptor
Status:  Active
SQL Type:  varchar(21)
Java Type:  String
Attributes:
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
Attributes:
Abbreviated corporate name.
Added On:  10/16/12
SQL Column:  DESTINATION_NUMBER
Java Field:  destinationNumber
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
User assigned.
Added On:  01/22/20
SQL Column:  IS_FILE_RENAMING_REQUIRED
Java Field:  isFileRenamingRequired
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:true
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  06/02/16
SQL Column:  PROCESSOR_BUILDING_NUMBER
Java Field:  processorBuildingNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  05/25/18
SQL Column:  VAT_REGISTRATION_NUMBER
Java Field:  vatRegistrationNumber
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  08/20/12
SQL Column:  VENDOR_ID
Java Field:  vendorId
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
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
Attributes:
Enumeration of versions for Elavon.