Added On:  03/21/18 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  RetailIso8583Profile 
                    
        
        
     
    
        
            
                
                    Encapsulates specific settings required for real-time transaction processing. Adds specific fields to the base fields of 
Billing Profile and 
Retail Profile.                 
 
         
     
        
        
                    
                        
                Added On:  02/22/13
                SQL Column:  ACQUIRER_INSTITUTION_ID
                Java Field:  acquirerInstitutionId
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A code that identifies the institution receiving the request. This ID is used when it is not possible to route a message using the Account Number field. When this field is included, it takes precedence over all account number fields for routing. 
                        
                     
                 
             
                    
                        
                Added On:  09/15/15
                SQL Column:  AGGREGATOR_MERCHANT_SUB_MERCHANT_ID
                Java Field:  aggregatorMerchantSubMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identification number of the sub-merchant for merchant's aggregator.
                        
                     
                 
             
                    
                        
                Added On:  10/22/13
                SQL Column:  AGGREGATOR_NAME
                Java Field:  aggregatorName
             
            
                Status:  Active
                SQL Type:  varchar(38)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  03/02/17
                SQL Column:  APPLICATION_HEADER
                Java Field:  applicationHeader
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Header element of the application.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  APPLICATION_ID
                Java Field:  applicationId
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Unique application identification number.
                        
                     
                 
             
                    
                        
                Added On:  01/27/13
                SQL Column:  APPLICATION_INFORMATION
                Java Field:  applicationInformation
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Short information about the application used for transaction.
                        
                     
                 
             
                    
                        
                Added On:  06/20/15
                SQL Column:  CAR_RENTAL_DATAWIRE_ID
                Java Field:  carRentalDatawireId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Datawire ID of the card rental.
                        
                     
                 
             
                    
                        
                Added On:  06/20/15
                SQL Column:  CAR_RENTAL_MERCHANT_CATEGORY_CODE
                Java Field:  carRentalMerchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A code that identifies the type of business or services conducted by the service establishment.
On a 0400 (Debit/EBT) reversal message, this field must match the original 0200 (Debit/EBT) request.
                        
                     
                 
             
                    
                        
                Added On:  06/20/15
                SQL Column:  CAR_RENTAL_MERCHANT_ID
                Java Field:  carRentalMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code assigned to a merchant location. Merchants must use the First Data-assigned Merchant ID. 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/27/17
                SQL Column:  CAR_RENTAL_MERCHANT_NUMBER
                Java Field:  carRentalMerchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
                        
                     
                 
             
                    
                        
                Added On:  06/20/15
                SQL Column:  CAR_RENTAL_TERMINAL_ID
                Java Field:  carRentalTerminalId
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code that identifies a merchant terminal. 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/05/12
                SQL Column:  CHARGE_DESCRIPTION
                Java Field:  chargeDescription
             
            
                Status:  Active
                SQL Type:  varchar(23)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Charge Descriptions are agreed upon by the client and American Express, at the time the Electronic Submission Addendum is completed.
                        
                     
                 
             
                    
                        
                Added On:  06/17/13
                SQL Column:  CHECK_DIGIT
                Java Field:  checkDigit
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The check digits is a validation character associated with the message authentication working key. The check digit is used to distinguish a MAC synch (31) reversal error from a MAC verification (30) reversal error when MAC authentication fails. 
                        
                     
                 
             
                    
                        
                Added On:  06/30/15
                SQL Column:  COUNTRY_CODE
                Java Field:  countryCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Country code of the merchant. 
Needs to state 3 digit alpha-numeric country code.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  CUSTOMER_SERVICE_PHONE
                Java Field:  customerServicePhone
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Service phone of the customer used for discussing any processing issues.
                        
                     
                 
             
                    
                        
                Added On:  11/04/15
                SQL Column:  DPC_NUMBER
                Java Field:  dpcNumber
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Delivery point code assigned by a processor.
                        
                     
                 
             
                    
                        
                Added On:  08/26/15
                SQL Column:  DYNAMIC_MERCHANT_CITY
                Java Field:  dynamicMerchantCity
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic merchant city address.
                        
                     
                 
             
                    
                        
                Added On:  08/26/15
                SQL Column:  DYNAMIC_MERCHANT_COUNTRY
                Java Field:  dynamicMerchantCountry
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic merchant mailing country code.
                        
                     
                 
             
                    
                        
                Added On:  12/06/19
                SQL Column:  DYNAMIC_MERCHANT_EMAIL
                Java Field:  dynamicMerchantEmail
             
            
                Status:  Active
                SQL Type:  varchar(40)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/26/15
                SQL Column:  DYNAMIC_MERCHANT_NAME
                Java Field:  dynamicMerchantName
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/26/15
                SQL Column:  DYNAMIC_MERCHANT_STATE
                Java Field:  dynamicMerchantState
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic merchant mailing state code.
                        
                     
                 
             
                    
                        
                Added On:  08/26/15
                SQL Column:  DYNAMIC_MERCHANT_STREET
                Java Field:  dynamicMerchantStreet
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic merchant street address.
                        
                     
                 
             
                    
                        
                Added On:  12/06/19
                SQL Column:  DYNAMIC_MERCHANT_TAX_ID
                Java Field:  dynamicMerchantTaxId
             
            
                Status:  Active
                SQL Type:  varchar(14)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/26/15
                SQL Column:  DYNAMIC_MERCHANT_ZIP
                Java Field:  dynamicMerchantZip
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic merchant's mailing address ZIP or postal code.
                        
                     
                 
             
                    
                        
                Added On:  08/26/15
                SQL Column:  DYNAMIC_SUB_MERCHANT_ID
                Java Field:  dynamicSubMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(14)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dynamic sub-merchant identification number.
                        
                     
                 
             
                    
                        
                Added On:  12/06/19
                SQL Column:  DYNAMIC_SUB_MERCHANT_MCC
                Java Field:  dynamicSubMerchantMcc
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/12/17
                SQL Column:  ECOMM_URL
                Java Field:  ecommUrl
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Merchant's connection URL used for e-commerce transactions processing.
                        
                     
                 
             
                    
                        
                Added On:  02/17/17
                SQL Column:  ECOMMERCE_CHECK_DIGIT
                Java Field:  ecommerceCheckDigit
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Specific identifier of the ecommerce industry profile assigned by a processor.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  ECOMMERCE_DATAWIRE_ID
                Java Field:  ecommerceDatawireId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Datawire ID of the e-commerce.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  ECOMMERCE_MERCHANT_CATEGORY_CODE
                Java Field:  ecommerceMerchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A code that identifies the type of business or services conducted by the service establishment.
On a 0400 (Debit/EBT) reversal message, this field must match the original 0200 (Debit/EBT) request.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  ECOMMERCE_MERCHANT_ID
                Java Field:  ecommerceMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code assigned to a merchant location. Merchants must use the First Data-assigned Merchant ID. 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/27/17
                SQL Column:  ECOMMERCE_MERCHANT_NUMBER
                Java Field:  ecommerceMerchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  ECOMMERCE_TERMINAL_ID
                Java Field:  ecommerceTerminalId
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code that identifies a merchant terminal. 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:  04/29/15
                SQL Column:  EMAIL_ADDRESS
                Java Field:  emailAddress
             
            
                Status:  Active
                SQL Type:  varchar(160)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Email address of the provider.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  FILENAME
                Java Field:  filename
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  10/07/13
                SQL Column:  HEADER_MERCHANT_ID
                Java Field:  headerMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/05/12
                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:  08/28/15
                SQL Column:  KEY_ID
                Java Field:  keyId
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Key Serial Number.
Base Derivation Key ID (BDK ID) (If fewer than nine positions, pad on
LEFT with ‘F’s.)
                        
                     
                 
             
                    
                        
                Added On:  05/27/13
                SQL Column:  LANE_NUMBER
                Java Field:  laneNumber
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Terminal Lane Number.
MasterCard regulations mandate that each POS device have a unique terminal identifier. This value is forwarded to MasterCard as the terminal identifier.
                        
                     
                 
             
                    
                        
                Added On:  08/28/13
                SQL Column:  LODGING_DATAWIRE_ID
                Java Field:  lodgingDatawireId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/28/13
                SQL Column:  LODGING_MERCHANT_CATEGORY_CODE
                Java Field:  lodgingMerchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A code that identifies the type of business or services conducted by the service establishment.
On a 0400 (Debit/EBT) reversal message, this field must match the original 0200 (Debit/EBT) request.
                        
                     
                 
             
                    
                        
                Added On:  08/28/13
                SQL Column:  LODGING_MERCHANT_ID
                Java Field:  lodgingMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code assigned to a merchant location. Merchants must use the First Data-assigned Merchant ID. 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/27/17
                SQL Column:  LODGING_MERCHANT_NUMBER
                Java Field:  lodgingMerchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
                        
                     
                 
             
                    
                        
                Added On:  08/28/13
                SQL Column:  LODGING_TERMINAL_ID
                Java Field:  lodgingTerminalId
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code that identifies a merchant terminal. 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/05/15
                SQL Column:  MC_ASSIGNED_ID
                Java Field:  mcAssignedId
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        An identifier assigned by MasterCard to identify a specific merchant who is registered with MasterCard for specific fees, special interchange treatment, or participation in select acceptance programs.
                        
                     
                 
             
                    
                        
                Added On:  12/21/16
                SQL Column:  MC_BIN
                Java Field:  mcBin
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        BIN accosiated with MasterCard cards.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MERCHANT_CITY
                Java Field:  merchantCity
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City associated with this merchant account.
                        
                     
                 
             
                    
                        
                Added On:  04/16/15
                SQL Column:  MERCHANT_COUNTRY_CODE
                Java Field:  merchantCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the country associated with this merchant account.
                        
                     
                 
             
                    
                        
                Added On:  10/22/13
                SQL Column:  MERCHANT_EMAIL
                Java Field:  merchantEmail
             
            
                Status:  Active
                SQL Type:  varchar(19)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/09/15
                SQL Column:  MERCHANT_FNS_NUMBER
                Java Field:  merchantFnsNumber
             
            
                Status:  Active
                SQL Type:  varchar(7)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Merchant Food and Nutrition Service Number.
FNS Number: A seven-digit merchant number issued by the US Department of Agriculture Food and Nutrition Service that is used in EBT Food Stamps. This number must authorize merchants who wish to accept food stamp.
Note: If not supplied, space-fill so number can be obtained from First Data Terminal Control file.
                        
                     
                 
             
                    
                        
                Added On:  04/29/15
                SQL Column:  MERCHANT_GROUP_IDENTIFIER
                Java Field:  merchantGroupIdentifier
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifier of the merchant group.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MERCHANT_NAME
                Java Field:  merchantName
             
            
                Status:  Active
                SQL Type:  varchar(19)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The DBA name of the merchant.
                        
                     
                 
             
                    
                        
                Added On:  08/27/15
                SQL Column:  MERCHANT_NAME_ABBREVIATION
                Java Field:  merchantNameAbbreviation
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Abbreviation of the merchant's full name.
                        
                     
                 
             
                    
                        
                Added On:  01/17/17
                SQL Column:  MERCHANT_NUMBER
                Java Field:  merchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifier of the merchant assigned by a processor.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MERCHANT_STATE
                Java Field:  merchantState
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        State code associated with this merchant account.
                        
                     
                 
             
                    
                        
                Added On:  10/21/13
                SQL Column:  MERCHANT_STREET
                Java Field:  merchantStreet
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Street address associated with this merchant account.
                        
                     
                 
             
                    
                        
                Added On:  04/02/14
                SQL Column:  MERCHANT_TAX_ID
                Java Field:  merchantTaxId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Tax identifier of the merchant.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MERCHANT_ZIP_CODE
                Java Field:  merchantZipCode
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ZIP/Postal code associated with this merchant account.
                        
                     
                 
             
                    
                        
                Added On:  02/17/17
                SQL Column:  MOTO_CHECK_DIGIT
                Java Field:  motoCheckDigit
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Specific identifier of the MOTO industry profile assigned by a processor.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MOTO_DATAWIRE_ID
                Java Field:  motoDatawireId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/05/12
                SQL Column:  MOTO_MERCHANT_CATEGORY_CODE
                Java Field:  motoMerchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A code that identifies the type of business or services conducted by the service establishment.
On a 0400 (Debit/EBT) reversal message, this field must match the original 0200 (Debit/EBT) request.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MOTO_MERCHANT_ID
                Java Field:  motoMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code assigned to a merchant location. Merchants must use the First Data-assigned Merchant ID. 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/27/17
                SQL Column:  MOTO_MERCHANT_NUMBER
                Java Field:  motoMerchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MOTO_TERMINAL_ID
                Java Field:  motoTerminalId
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code that identifies a merchant terminal. 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:  05/27/13
                SQL Column:  NETWORK_ROUTING
                Java Field:  networkRouting
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Zeros filled in the request message, debit Network ID will be included as response values.
                        
                     
                 
             
                    
                        
                Added On:  06/07/13
                SQL Column:  PASSWORD
                Java Field:  password
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Password associated with the appropriate username.
                        
                     
                 
             
                    
                        
                Added On:  02/17/17
                SQL Column:  PETROLEUM_CHECK_DIGIT
                Java Field:  petroleumCheckDigit
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Specific identifier of the pertoleum industry profile assigned by a processor.
                        
                     
                 
             
                    
                        
                Added On:  06/20/14
                SQL Column:  PETROLEUM_DATAWIRE_ID
                Java Field:  petroleumDatawireId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Datawire ID of the petroleum industry.
                        
                     
                 
             
                    
                        
                Added On:  06/20/14
                SQL Column:  PETROLEUM_MERCHANT_CATEGORY_CODE
                Java Field:  petroleumMerchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A code that identifies the type of business or services conducted by the service establishment.
On a 0400 (Debit/EBT) reversal message, this field must match the original 0200 (Debit/EBT) request.
                        
                     
                 
             
                    
                        
                Added On:  06/20/14
                SQL Column:  PETROLEUM_MERCHANT_ID
                Java Field:  petroleumMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code assigned to a merchant location. Merchants must use the First Data-assigned Merchant ID. 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/27/17
                SQL Column:  PETROLEUM_MERCHANT_NUMBER
                Java Field:  petroleumMerchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
                        
                     
                 
             
                    
                        
                Added On:  06/20/14
                SQL Column:  PETROLEUM_TERMINAL_ID
                Java Field:  petroleumTerminalId
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code that identifies a merchant terminal. 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:  03/21/13
                SQL Column:  PROCESS_MODE
                Java Field:  processMode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/29/15
                SQL Column:  PROCESSOR_BUILDING_NUMBER
                Java Field:  processorBuildingNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Building number of the processor's mailing address.
                        
                     
                 
             
                    
                        
                Added On:  04/29/15
                SQL Column:  PROCESSOR_CITY
                Java Field:  processorCity
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City of the processor's mailing address.
                        
                     
                 
             
                    
                        
                Added On:  09/15/14
                SQL Column:  PROCESSOR_CL
                Java Field:  processorCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Enumerates possible values of ISO8583 Profile.
                        
                     
                 
             
                    
                        
                Added On:  04/29/15
                SQL Column:  PROCESSOR_COUNTRY_CODE
                Java Field:  processorCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Country code of the processor's mailing address.
                        
                     
                 
             
                    
                        
                Added On:  04/29/15
                SQL Column:  PROCESSOR_ID
                Java Field:  processorId
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identification number of the processor.
                        
                     
                 
             
                    
                        
                Added On:  04/29/15
                SQL Column:  PROCESSOR_NAME
                Java Field:  processorName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name associated with the processor profile.
                        
                     
                 
             
                    
                        
                Added On:  04/29/15
                SQL Column:  PROCESSOR_PHONE_NUMBER
                Java Field:  processorPhoneNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Phone number of the processor for discussing any processing issues.
                        
                     
                 
             
                    
                        
                Added On:  04/29/15
                SQL Column:  PROCESSOR_STREET
                Java Field:  processorStreet
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Street of the processor's mailing address.
                        
                     
                 
             
                    
                        
                Added On:  04/29/15
                SQL Column:  PROCESSOR_ZIP_CODE
                Java Field:  processorZipCode
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ZIP/postal code of the processor's mailing address.
                        
                     
                 
             
                    
                        
                Added On:  02/17/17
                SQL Column:  RESTAURANT_CHECK_DIGIT
                Java Field:  restaurantCheckDigit
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Specific identifier of the restaurant industry profile assigned by a processor.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RESTAURANT_DATAWIRE_ID
                Java Field:  restaurantDatawireId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Datawire ID of the restaurant.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RESTAURANT_MERCHANT_CATEGORY_CODE
                Java Field:  restaurantMerchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A code that identifies the type of business or services conducted by the service establishment.
On a 0400 (Debit/EBT) reversal message, this field must match the original 0200 (Debit/EBT) request.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RESTAURANT_MERCHANT_ID
                Java Field:  restaurantMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code assigned to a merchant location. Merchants must use the First Data-assigned Merchant ID. 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/27/17
                SQL Column:  RESTAURANT_MERCHANT_NUMBER
                Java Field:  restaurantMerchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RESTAURANT_TERMINAL_ID
                Java Field:  restaurantTerminalId
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code that identifies a merchant terminal. 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:  02/17/17
                SQL Column:  RETAIL_CHECK_DIGIT
                Java Field:  retailCheckDigit
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Specific identifier of the retail industry profile assigned by a processor.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RETAIL_DATAWIRE_ID
                Java Field:  retailDatawireId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Datawire ID of the retail industry.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RETAIL_MERCHANT_CATEGORY_CODE
                Java Field:  retailMerchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A code that identifies the type of business or services conducted by the service establishment.
On a 0400 (Debit/EBT) reversal message, this field must match the original 0200 (Debit/EBT) request.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RETAIL_MERCHANT_ID
                Java Field:  retailMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code assigned to a merchant location. Merchants must use the First Data-assigned Merchant ID. 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/27/17
                SQL Column:  RETAIL_MERCHANT_NUMBER
                Java Field:  retailMerchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RETAIL_TERMINAL_ID
                Java Field:  retailTerminalId
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code that identifies a merchant terminal. 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/05/12
                SQL Column:  SECURE_CODE
                Java Field:  secureCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/05/12
                SQL Column:  SERVICE_ID
                Java Field:  serviceId
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Digital number that represents the specific code of the product/service.
                        
                     
                 
             
                    
                        
                Added On:  05/13/13
                SQL Column:  TERMINAL_TYPE
                Java Field:  terminalType
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of the terminal used for the transaction.
                        
                     
                 
             
                    
                        
                Added On:  01/04/16
                SQL Column:  TOKEN_REQUESTOR_ID
                Java Field:  tokenRequestorId
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identification number of the token requestor.
                        
                     
                 
             
                    
                        
                Added On:  08/28/15
                SQL Column:  TOKEN_TYPE
                Java Field:  tokenType
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/20/12
                SQL Column:  TPP_ID
                Java Field:  tppId
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Third Party Processor ID - The TPP ID is mandatory on all Authorization requests submitted by Third Parties who have been issued one by First Data. If you were assigned a Third Party Processor ID, you are required to send this additional format record.
If you were not assigned a Third Party Processor ID, this record should not be sent.
                        
                     
                 
             
                    
                        
                Added On:  12/25/15
                SQL Column:  TRANS_ARMOR_KEY_ID
                Java Field:  transArmorKeyId
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identification number of the key in TransArmor. 
                        
                     
                 
             
                    
                        
                Added On:  12/25/15
                SQL Column:  TRANS_ARMOR_TOKEN_TYPE
                Java Field:  transArmorTokenType
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of the token for TransArmor.
                        
                     
                 
             
                    
                        
                Added On:  01/17/17
                SQL Column:  USE_LEGACY_FILE_HEADER
                Java Field:  useLegacyFileHeader
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        File header that contains Transaction Code, PSP Name, File Creation Date, File Reference, File Identification and Test/Prod Identifier.
                        
                     
                 
             
                    
                        
                Added On:  06/07/13
                SQL Column:  USER_NAME
                Java Field:  userName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name of the user in the system.
                        
                     
                 
             
                    
                        
                Added On:  12/21/16
                SQL Column:  VISA_BIN
                Java Field:  visaBin
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        BIN accosiated with Visa cards.
                        
                     
                 
             
                    
                        
                Added On:  11/12/15
                SQL Column:  VISA_MERCHANT_VERIFICATION_VALUE
                Java Field:  visaMerchantVerificationValue
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        An identifier assigned by Visa to identify a merchant who is registered with Visa for specific fees, special interchange treatment, or participation in select acceptance programs.