Added On:  03/21/18 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  RetailTsysProfile 
                    
        
        
     
    
        
            
                
                    Encapsulates TSYS specific settings required for real-time transaction processing. Adds TSYS specific fields to the base fields of 
Billing Profile and 
Retail Profile.                
 
         
     
        
        
                    
                        
                Added On:  02/13/12
                SQL Column:  ACQUIRER_BIN
                Java Field:  acquirerBin
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains Visa assigned Bank Identification Number (BIN) issued by the merchant's member bank or processor. The Acquirer BIN identifies the member bank that signed the merchant using the POS application.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  AGENT_BANK_NUMBER
                Java Field:  agentBankNumber
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Assigned by the signing member or processor. The number identifies an institution which signs merchants as an agent of a member. The member uses this number to identify the agent within TSYS Acquiring Solutions’ system.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  AGENT_CHAIN_NUMBER
                Java Field:  agentChainNumber
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Assigned by the signing member or processor. The member uses this number to identify the merchant chain within the TSYS Acquiring Solutions’ system.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CITY_CODE
                Java Field:  cityCode
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code used to further identify the merchant location.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CONTACT_PHONE_NUMBER
                Java Field:  contactPhoneNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Phone number of the contact person
                        
                     
                 
             
                    
                        
                Added On:  03/12/20
                SQL Column:  DESCRIPTOR
                Java Field:  descriptor
             
            
                Status:  Active
                SQL Type:  varchar(21)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  03/12/20
                SQL Column:  DESCRIPTOR_PREFIX
                Java Field:  descriptorPrefix
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  DEVELOPER_ID
                Java Field:  developerId
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Provides a unique value to identify transactions originated by the Developer. This number is provided by TSYS Acquiring Solutions during certification.
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  ECOMMERCE_MERCHANT_CATEGORY_CODE
                Java Field:  ecommerceMerchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a number assigned by the signing member or processor to identify a merchant industry classification. This value is similar to the Standard Industry Code (SIC). 
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  ECOMMERCE_MERCHANT_NUMBER
                Java Field:  ecommerceMerchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a unique number, assigned by the signing merchant’s bank or processor. Used to identify the merchant within the TSYS Acquiring Solutions system. 
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  ECOMMERCE_TERMINAL_ID_NUMBER
                Java Field:  ecommerceTerminalIdNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a number assigned by the signing member, processor, or merchant to identify a unique terminal within a merchant location. 
                        
                     
                 
             
                    
                        
                Added On:  04/16/13
                SQL Column:  FCS_ID
                Java Field:  fcsId
             
            
                Status:  Active
                SQL Type:  varchar(7)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the Food and Consumer Identifier. The FCS ID identifies the Merchant as being certified and approved to accept Food Stamps.
Note: Cash benefits transactions do not use the Electronic Voucher Serial Number, FCS ID, and Voucher Approval Code fields; food stamp transactions must use the FCS ID. Electronic voucher transactions require Electronic Voucher Serial Number, FCS ID, and Voucher Approval Code fields.
                        
                     
                 
             
                    
                        
                Added On:  07/29/15
                SQL Column:  KEY_SET_IDENTIFIER
                Java Field:  keySetIdentifier
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Unique bank identification code used in processing direct debit transactions. Supplied to the POS device by a properly injected and certified TSYS Acquiring Solutions PIN Pad.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MERCHANT_ABA_NUMBER
                Java Field:  merchantAbaNumber
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies the merchant to a direct debit switch. Must be supplied for all direct debit request transactions except for the Interlink Debit Cancel (Transaction Code 95). This number is provided by the signing member or processor.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MERCHANT_CATEGORY
                Java Field:  merchantCategory
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Merchant category code assigned by the signing member or processor to identify a merchant industry classification. This value is similar to the Standard Industry Code (SIC).
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MERCHANT_CITY
                Java Field:  merchantCity
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the merchant location/city name provided by the signing member or processor. The name provided must correspond to the location/city name printed on the customer receipt.
                        
                     
                 
             
                    
                        
                Added On:  02/09/17
                SQL Column:  MERCHANT_COUNTRY_CODE
                Java Field:  merchantCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Country code of the address associated with the sub-merchant account.
                        
                     
                 
             
                    
                        
                Added On:  07/02/20
                SQL Column:  MERCHANT_EMAIL
                Java Field:  merchantEmail
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  MERCHANT_LOCATION_NUMBER
                Java Field:  merchantLocationNumber
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Provides additional information on the location of the merchant. Unless otherwise specified by the merchant’s bank or processor, it should be defaulted to 00001.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MERCHANT_NAME
                Java Field:  merchantName
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the merchant name provided by the signing member or processor. Must contain the same data used in the data capture batch.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MERCHANT_NUMBER
                Java Field:  merchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Assigned by the signing merchant’s bank or processor. Used to identify the merchant within the TSYS Acquiring Solutions system.
                        
                     
                 
             
                    
                        
                Added On:  06/25/20
                SQL Column:  MERCHANT_NUMBER_BACKEND
                Java Field:  merchantNumberBackend
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  MERCHANT_SETTLEMENT_AGENT_NUMBER
                Java Field:  merchantSettlementAgentNumber
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies the merchant settling agent. This number is provided by the signing member or processor.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MERCHANT_STATE
                Java Field:  merchantState
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the merchant State/Province Code provided by the signing member or processor. Must contain the same data used in the data capture batch.
                        
                     
                 
             
                    
                        
                Added On:  07/02/20
                SQL Column:  MERCHANT_STREET
                Java Field:  merchantStreet
             
            
                Status:  Active
                SQL Type:  varchar(38)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/09/17
                SQL Column:  MERCHANT_ZIP_CODE
                Java Field:  merchantZipCode
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ZIP/Postal code of the address associated with the sub-merchant account.
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  MOTO_MERCHANT_CATEGORY_CODE
                Java Field:  motoMerchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a number assigned by the signing member or processor to identify a merchant industry classification. This value is similar to the Standard Industry Code (SIC). 
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  MOTO_MERCHANT_NUMBER
                Java Field:  motoMerchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a unique number, assigned by the signing merchant’s bank or processor. Used to identify the merchant within the TSYS Acquiring Solutions system.
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  MOTO_TERMINAL_ID_NUMBER
                Java Field:  motoTerminalIdNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a number assigned by the signing member, processor, or merchant to identify a unique terminal within a merchant location. 
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  NETWORK_ID
                Java Field:  networkId
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a code that specifies the network to be used for transmission of the message and determines the program rules that apply to the transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/09/17
                SQL Column:  PAYMENT_FACILITATOR_ID_MASTER_CARD
                Java Field:  paymentFacilitatorIdMasterCard
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifier of the payment facilitator assigned by the processor.
                        
                     
                 
             
                    
                        
                Added On:  07/02/20
                SQL Column:  PAYMENT_FACILITATOR_ID_VISA
                Java Field:  paymentFacilitatorIdVisa
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/02/20
                SQL Column:  PAYMENT_SERVICE_PROVIDER_NAME
                Java Field:  paymentServiceProviderName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/30/17
                SQL Column:  PRESTIGIOUS_PROPERTY_INDICATOR_CL
                Java Field:  prestigiousPropertyIndicatorCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/20/12
                SQL Column:  PROCESSOR_CL
                Java Field:  processorCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Enumeration of possible TSYS processor types. 
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  RESTAURANT_MERCHANT_CATEGORY_CODE
                Java Field:  restaurantMerchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a number assigned by the signing member or processor to identify a merchant industry classification. This value is similar to the Standard Industry Code (SIC). 
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  RESTAURANT_MERCHANT_NUMBER
                Java Field:  restaurantMerchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a unique number, assigned by the signing merchant’s bank or processor. Used to identify the merchant within the TSYS Acquiring Solutions system. 
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  RESTAURANT_TERMINAL_ID_NUMBER
                Java Field:  restaurantTerminalIdNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a number assigned by the signing member, processor, or merchant to identify a unique terminal within a merchant location. 
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  RETAIL_MERCHANT_CATEGORY_CODE
                Java Field:  retailMerchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a number assigned by the signing member or processor to identify a merchant industry classification. This value is similar to the Standard Industry Code (SIC).
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  RETAIL_MERCHANT_NUMBER
                Java Field:  retailMerchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a unique number, assigned by the signing merchant’s bank or processor. Used to identify the merchant within the TSYS Acquiring Solutions system.
                        
                     
                 
             
                    
                        
                Added On:  11/20/12
                SQL Column:  RETAIL_TERMINAL_ID_NUMBER
                Java Field:  retailTerminalIdNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a number assigned by the signing member, processor, or merchant to identify a unique terminal within a merchant location. 
                        
                     
                 
             
                    
                        
                Added On:  07/02/20
                SQL Column:  SELLER_ID
                Java Field:  sellerId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  SHARING_GROUPS
                Java Field:  sharingGroups
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a listing of direct debit and EBT networks that a POS device can access. Provided by the signing member or processor. The values must correspond to one of the Visa assigned direct debit network types. This data is part of the TSYS Acquiring Solutions direct debit data.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  STORE_NUMBER
                Java Field:  storeNumber
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a number assigned by the signing member, processor, or merchant to identify a specific merchant store within the TSYS Acquiring Solutions’ system.
                        
                     
                 
             
                    
                        
                Added On:  02/09/17
                SQL Column:  SUB_MERCHANT_CITY
                Java Field:  subMerchantCity
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City of the address associated with the sub-merchant account.
                        
                     
                 
             
                    
                        
                Added On:  07/02/20
                SQL Column:  SUB_MERCHANT_COUNTRY_CODE
                Java Field:  subMerchantCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/09/17
                SQL Column:  SUB_MERCHANT_ID
                Java Field:  subMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifier of the sub-merchant account assigned by a processor.
                        
                     
                 
             
                    
                        
                Added On:  02/09/17
                SQL Column:  SUB_MERCHANT_STATE_PROVINCE_CODE
                Java Field:  subMerchantStateProvinceCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        State/Province code of the address associated with the sub-merchant account.
                        
                     
                 
             
                    
                        
                Added On:  07/02/20
                SQL Column:  SUB_MERCHANT_ZIP_CODE
                Java Field:  subMerchantZipCode
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  TERMINAL_ID_NUMBER
                Java Field:  terminalIdNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Assigned by the processor.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TERMINAL_NUMBER
                Java Field:  terminalNumber
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains a number assigned by the signing member, processor, or merchant to identify a unique terminal within a merchant location. 
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TIME_ZONE_CL
                Java Field:  timeZoneCl
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Used to calculate the local time within the TSYS Acquiring Solutions authorization system.
                        
                     
                 
             
                    
                        
                Added On:  02/04/22
                SQL Column:  TIME_ZONE_CODE
                Java Field:  timeZoneCode
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  03/27/12
                SQL Column:  VAT_REGISTRATION_NUMBER
                Java Field:  vatRegistrationNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Government assigned tax identification number of the merchant from whom the goods or services were purchased from.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  VERSION_ID
                Java Field:  versionId
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Version ID provides a unique value to identify the version of software. This number is provided by TSYS Acquiring Solutions during certification.