Retail TSYS Profile


Parent:    Retail Profile
Added On:  03/21/18 
SQL Table:  RETAIL_TSYS_PROFILE 
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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(10)
Java Type:  String
Attributes:
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
Attributes:
Added On:  03/12/20
SQL Column:  DESCRIPTOR_PREFIX
Java Field:  descriptorPrefix
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  DEVELOPER_ID
Java Field:  developerId
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_LOCATION_NUMBER
Java Field:  merchantLocationNumber
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_SETTLEMENT_AGENT_NUMBER
Java Field:  merchantSettlementAgentNumber
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
Added On:  02/09/17
SQL Column:  MERCHANT_ZIP_CODE
Java Field:  merchantZipCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  07/02/20
SQL Column:  PAYMENT_SERVICE_PROVIDER_NAME
Java Field:  paymentServiceProviderName
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  08/30/17
SQL Column:  PRESTIGIOUS_PROPERTY_INDICATOR_CL
Java Field:  prestigiousPropertyIndicatorCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  11/20/12
SQL Column:  PROCESSOR_CL
Java Field:  processorCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  02/13/12
SQL Column:  SHARING_GROUPS
Java Field:  sharingGroups
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  02/09/17
SQL Column:  SUB_MERCHANT_ID
Java Field:  subMerchantId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
Added On:  02/13/12
SQL Column:  TERMINAL_ID_NUMBER
Java Field:  terminalIdNumber
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  03/27/12
SQL Column:  VAT_REGISTRATION_NUMBER
Java Field:  vatRegistrationNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
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
Attributes:
The Version ID provides a unique value to identify the version of software. This number is provided by TSYS Acquiring Solutions during certification.