Retail First Data Rapid Connect Profile


Parent:    Retail Profile
Added On:  03/21/18 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  RetailFirstDataRapidConnectProfile 
Encapsulates First Data Rapid Connect specific settings required for real-time transaction processing. Adds First Data Rapid Connect specific fields to the base fields of Billing Profile and Retail Profile.
Added On:  09/23/14
SQL Column:  ALTERNATE_MERCHANT_ID
Java Field:  alternateMerchantId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Alternate ID assigned by FirstData Prepaid Closed Loop.
For additional information, please contact account representative.
Added On:  11/10/14
SQL Column:  APPLICATION_ID
Java Field:  applicationId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
ID of the application used for the transaction processing.
Added On:  06/27/16
SQL Column:  CAR_RENTAL_DATAWIRE_ID
Java Field:  carRentalDatawireId
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Identifier that represents the original source document reference number associated with car rental industry of the merchant.
Added On:  06/23/15
SQL Column:  CAR_RENTAL_MERCHANT_CATEGORY_CODE
Java Field:  carRentalMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Code used to classify a car rental industry of the merchant.
Added On:  06/27/16
SQL Column:  CAR_RENTAL_MERCHANT_ID
Java Field:  carRentalMerchantId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Unique ID of the merchant associated with eCommerce industry assigned by FirstData.
The Merchant ID does not conform to the standard definition of alphanumeric fields: it is right-justified and zero-filled on the left. On a 0100 VRU Authorization only, the Merchant ID can be the First Data internal number or a merchant external number. On a 0400 reversal message, this field must match the original 0100/0200 request.
Added On:  06/27/16
SQL Column:  CAR_RENTAL_MERCHANT_ID_SETTLEMENT
Java Field:  carRentalMerchantIdSettlement
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  06/27/16
SQL Column:  CAR_RENTAL_TERMINAL_ID
Java Field:  carRentalTerminalId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
ID of the terminal associated with lodging industry of the merchant.
A unique code must be assigned to each terminal/POS device (e.g., a register) in a merchant location. This code will be returned on the host response. In certain instances, the Terminal ID may be assigned by the merchant; in other instances, First Data assigns it. The Terminal ID does not conform to the standard definition of alphanumeric fields: it is right justified and zero-filled on the left. On a 0400 reversal message, this field must match the original 0100/0200 request
Added On:  11/10/14
SQL Column:  CHARGE_DESCRIPTION
Java Field:  chargeDescription
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
Description of the file agreed upon by the client and American Express, at the time the Electronic Submission Addendum is completed.
Added On:  09/23/14
SQL Column:  CUSTOMER_SERVICE_PHONE_NUMBER
Java Field:  customerServicePhoneNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Phone number used for resolving any processing issues.
Added On:  11/10/14
SQL Column:  DATAWIRE_ID
Java Field:  datawireId
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Identifier that represents the original source document reference number.
Added On:  08/10/16
SQL Column:  DYNAMIC_MERCHANT_ADDRESS
Java Field:  dynamicMerchantAddress
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Dynamic field that contains address of the merchant.
Added On:  08/10/16
SQL Column:  DYNAMIC_MERCHANT_CITY
Java Field:  dynamicMerchantCity
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Dynamic field that contains address city of the merchant.
Added On:  08/10/16
SQL Column:  DYNAMIC_MERCHANT_COUNTRY
Java Field:  dynamicMerchantCountry
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Dynamic field that contains address country code of the merchant.
Added On:  08/10/16
SQL Column:  DYNAMIC_MERCHANT_COUNTY
Java Field:  dynamicMerchantCounty
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Dynamic field that contains address county code of the merchant.
Added On:  08/10/16
SQL Column:  DYNAMIC_MERCHANT_NAME
Java Field:  dynamicMerchantName
Status:  Active
SQL Type:  varchar(38)
Java Type:  String
Attributes:
Dynamic field that contains name of the merchant.
Added On:  08/10/16
SQL Column:  DYNAMIC_MERCHANT_STATE
Java Field:  dynamicMerchantState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Dynamic field that contains address state code of the merchant.
Added On:  08/10/16
SQL Column:  DYNAMIC_MERCHANT_ZIP
Java Field:  dynamicMerchantZip
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Dynamic field that contains address ZIP/postal code of the merchant.
Added On:  09/23/14
SQL Column:  ECOMM_URL
Java Field:  ecommUrl
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
URL of the eCommerce site.
Added On:  06/27/16
SQL Column:  ECOMMERCE_DATAWIRE_ID
Java Field:  ecommerceDatawireId
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Identifier that represents the original source document reference number associated with eCommerce industry of the merchant.
Added On:  11/10/14
SQL Column:  ECOMMERCE_MERCHANT_CATEGORY_CODE
Java Field:  ecommerceMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Code used to classify an eCommerce business of the merchant.
Added On:  06/27/16
SQL Column:  ECOMMERCE_MERCHANT_ID
Java Field:  ecommerceMerchantId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Unique ID of the merchant associated with eCommerce industry.
The Merchant ID does not conform to the standard definition of alphanumeric fields: it is right-justified and zero-filled on the left. On a 0100 VRU Authorization only, the Merchant ID can be the First Data internal number or a merchant external number. On a 0400 reversal message, this field must match the original 0100/0200 request.
Added On:  06/27/16
SQL Column:  ECOMMERCE_MERCHANT_ID_SETTLEMENT
Java Field:  ecommerceMerchantIdSettlement
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  06/27/16
SQL Column:  ECOMMERCE_TERMINAL_ID
Java Field:  ecommerceTerminalId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
ID of the terminal associated with eCommerce industry of the merchant.
A unique code must be assigned to each terminal/POS device (e.g., a register) in a merchant location. This code will be returned on the host response. In certain instances, the Terminal ID may be assigned by the merchant; in other instances, First Data assigns it. The Terminal ID does not conform to the standard definition of alphanumeric fields: it is right justified and zero-filled on the left. On a 0400 reversal message, this field must match the original 0100/0200 request
Added On:  11/26/14
SQL Column:  FILENAME
Java Field:  filename
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the file that is downloaded.
Added On:  09/23/14
SQL Column:  GROUP_ID
Java Field:  groupId
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Unique ID assigned by FirstData to identify the group of merchants.
Added On:  01/28/15
SQL Column:  IS_TEST_MODE
Java Field:  isTestMode
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the test mode is active for the customer.
Added On:  06/27/16
SQL Column:  LODGING_DATAWIRE_ID
Java Field:  lodgingDatawireId
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Identifier that represents the original source document reference number associated with lodging industry of the merchant.
Added On:  06/23/15
SQL Column:  LODGING_MERCHANT_CATEGORY_CODE
Java Field:  lodgingMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Code used to classify a lodging industry of the merchant.
Added On:  06/27/16
SQL Column:  LODGING_MERCHANT_ID
Java Field:  lodgingMerchantId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Unique ID of the merchant associated with lodging industry.
The Merchant ID does not conform to the standard definition of alphanumeric fields: it is right-justified and zero-filled on the left. On a 0100 VRU Authorization only, the Merchant ID can be the First Data internal number or a merchant external number. On a 0400 reversal message, this field must match the original 0100/0200 request.
Added On:  06/27/16
SQL Column:  LODGING_MERCHANT_ID_SETTLEMENT
Java Field:  lodgingMerchantIdSettlement
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  06/27/16
SQL Column:  LODGING_TERMINAL_ID
Java Field:  lodgingTerminalId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
ID of the terminal associated with lodging industry of the merchant.
A unique code must be assigned to each terminal/POS device (e.g., a register) in a merchant location. This code will be returned on the host response. In certain instances, the Terminal ID may be assigned by the merchant; in other instances, First Data assigns it. The Terminal ID does not conform to the standard definition of alphanumeric fields: it is right justified and zero-filled on the left. On a 0400 reversal message, this field must match the original 0100/0200 request.
Added On:  11/10/14
SQL Column:  MERCHANT_CITY
Java Field:  merchantCity
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
City of the merchant mailing address applied on the FirstData merchant profile.
Added On:  05/12/16
SQL Column:  MERCHANT_COUNTRY_CODE
Java Field:  merchantCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code of the merchant mailing address.
Added On:  08/05/16
SQL Column:  MERCHANT_FNS_NUMBER
Java Field:  merchantFnsNumber
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Code received by a merchant from government that allows to accept EBT cards.
Added On:  09/23/14
SQL Column:  MERCHANT_ID
Java Field:  merchantId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Unique ID assigned by FirstData to identify merchant.
Added On:  11/10/14
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Merchant name used as a DBA (Doing Business As) name on the FirstData merchant file.
Added On:  11/10/14
SQL Column:  MERCHANT_STATE
Java Field:  merchantState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
State code of the merchant mailing address used on the FirstData merchant file.
Added On:  11/10/14
SQL Column:  MERCHANT_STREET
Java Field:  merchantStreet
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Street of the merchant mailing address applied on the FirstData merchant file.
Added On:  09/23/14
SQL Column:  MERCHANT_TAX_ID
Java Field:  merchantTaxId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Tax ID collected by a merchant for the transaction processing.
Added On:  11/10/14
SQL Column:  MERCHANT_ZIP_CODE
Java Field:  merchantZipCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP or postal code of the merchant mailing address used on the FirstData merchant file.
Added On:  06/27/16
SQL Column:  MOTO_DATAWIRE_ID
Java Field:  motoDatawireId
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Identifier that represents the original source document reference number associated with MOTO industry of the merchant.
Added On:  11/10/14
SQL Column:  MOTO_MERCHANT_CATEGORY_CODE
Java Field:  motoMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Code used to classify a MOTO industry of the merchant.
Added On:  06/27/16
SQL Column:  MOTO_MERCHANT_ID
Java Field:  motoMerchantId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Unique ID of the merchant associated with MOTO industry.
The Merchant ID does not conform to the standard definition of alphanumeric fields: it is right-justified and zero-filled on the left. On a 0100 VRU Authorization only, the Merchant ID can be the First Data internal number or a merchant external number. On a 0400 reversal message, this field must match the original 0100/0200 request.
Added On:  06/27/16
SQL Column:  MOTO_MERCHANT_ID_SETTLEMENT
Java Field:  motoMerchantIdSettlement
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  06/27/16
SQL Column:  MOTO_TERMINAL_ID
Java Field:  motoTerminalId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
ID of the terminal associated with MOTO industry of the merchant.
A unique code must be assigned to each terminal/POS device (e.g., a register) in a merchant location. This code will be returned on the host response. In certain instances, the Terminal ID may be assigned by the merchant; in other instances, First Data assigns it. The Terminal ID does not conform to the standard definition of alphanumeric fields: it is right justified and zero-filled on the left. On a 0400 reversal message, this field must match the original 0100/0200 request
Added On:  07/14/16
SQL Column:  PETROLEUM_DATAWIRE_ID
Java Field:  petroleumDatawireId
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Identifier that represents the original source document reference number associated with petroleum industry of the merchant.
Added On:  07/14/16
SQL Column:  PETROLEUM_MERCHANT_CATEGORY_CODE
Java Field:  petroleumMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Code used to classify a petroleum industry of the merchant.
Added On:  07/14/16
SQL Column:  PETROLEUM_MERCHANT_ID
Java Field:  petroleumMerchantId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Unique ID of the merchant associated with petroleum industry. The Merchant ID does not conform to the standard definition of alphanumeric fields: it is right-justified and zero-filled on the left. On a 0100 VRU Authorization only, the Merchant ID can be the First Data internal number or a merchant external number. On a 0400 reversal message, this field must match the original 0100/0200 request.
Added On:  07/14/16
SQL Column:  PETROLEUM_MERCHANT_ID_SETTLEMENT
Java Field:  petroleumMerchantIdSettlement
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  07/14/16
SQL Column:  PETROLEUM_TERMINAL_ID
Java Field:  petroleumTerminalId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
ID of the terminal associated with petroleum industry of the merchant.
A unique code must be assigned to each terminal/POS device (e.g., a register) in a merchant location. This code will be returned on the host response. In certain instances, the Terminal ID may be assigned by the merchant; in other instances, First Data assigns it. The Terminal ID does not conform to the standard definition of alphanumeric fields: it is right justified and zero-filled on the left. On a 0400 reversal message, this field must match the original 0100/0200 request.
Added On:  06/27/16
SQL Column:  RESTAURANT_DATAWIRE_ID
Java Field:  restaurantDatawireId
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Identifier that represents the original source document reference number associated with restaurant industry of the merchant.
Added On:  11/10/14
SQL Column:  RESTAURANT_MERCHANT_CATEGORY_CODE
Java Field:  restaurantMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Code used to classify a restaurant industry of the merchant.
Added On:  06/27/16
SQL Column:  RESTAURANT_MERCHANT_ID
Java Field:  restaurantMerchantId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Unique ID of the merchant associated with restaurant industry.
The Merchant ID does not conform to the standard definition of alphanumeric fields: it is right-justified and zero-filled on the left. On a 0100 VRU Authorization only, the Merchant ID can be the First Data internal number or a merchant external number. On a 0400 reversal message, this field must match the original 0100/0200 request.
Added On:  06/27/16
SQL Column:  RESTAURANT_MERCHANT_ID_SETTLEMENT
Java Field:  restaurantMerchantIdSettlement
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  06/27/16
SQL Column:  RESTAURANT_TERMINAL_ID
Java Field:  restaurantTerminalId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
ID of the terminal associated with restaurant industry of the merchant.
A unique code must be assigned to each terminal/POS device (e.g., a register) in a merchant location. This code will be returned on the host response. In certain instances, the Terminal ID may be assigned by the merchant; in other instances, First Data assigns it. The Terminal ID does not conform to the standard definition of alphanumeric fields: it is right justified and zero-filled on the left. On a 0400 reversal message, this field must match the original 0100/0200 request
Added On:  06/27/16
SQL Column:  RETAIL_DATAWIRE_ID
Java Field:  retailDatawireId
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Identifier that represents the original source document reference number associated with retail industry of the merchant.
Added On:  11/10/14
SQL Column:  RETAIL_MERCHANT_CATEGORY_CODE
Java Field:  retailMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Code used to classify a retail industry of the merchant.
Added On:  06/27/16
SQL Column:  RETAIL_MERCHANT_ID
Java Field:  retailMerchantId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Unique ID of the merchant associated with retail industry.
The Merchant ID does not conform to the standard definition of alphanumeric fields: it is right-justified and zero-filled on the left. On a 0100 VRU Authorization only, the Merchant ID can be the First Data internal number or a merchant external number. On a 0400 reversal message, this field must match the original 0100/0200 request.
Added On:  06/27/16
SQL Column:  RETAIL_MERCHANT_ID_SETTLEMENT
Java Field:  retailMerchantIdSettlement
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  06/27/16
SQL Column:  RETAIL_TERMINAL_ID
Java Field:  retailTerminalId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
ID of the terminal associated with retail industry of the merchant.
A unique code must be assigned to each terminal/POS device (e.g., a register) in a merchant location. This code will be returned on the host response. In certain instances, the Terminal ID may be assigned by the merchant; in other instances, First Data assigns it. The Terminal ID does not conform to the standard definition of alphanumeric fields: it is right justified and zero-filled on the left. On a 0400 reversal message, this field must match the original 0100/0200 request
Added On:  11/10/14
SQL Column:  SECURE_CODE
Java Field:  secureCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Additional security layer for online credit and debit card transactions.
Added On:  01/28/15
SQL Column:  SERVICE_ID
Java Field:  serviceId
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code that represents the specific ID of the product or service.
Added On:  09/23/14
SQL Column:  TERMINAL_ID
Java Field:  terminalId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Unique ID assigned by FirstData to identify the terminal.
Added On:  09/23/14
SQL Column:  TPP_ID
Java Field:  tppId
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Rapid Connect ID assigned by FirstData for a specific version of vendor/merchant software.