Retail ISO8583 Profile


Parent:    Retail Profile
Added On:  03/21/18 
SQL Table:  RETAIL_ISO8583_PROFILE 
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.
Available Fields:
Added On:  11/05/12
SQL Column:  SECURE_CODE
Java Field:  secureCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Unique secure code.
Added On:  11/05/12
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
The DBA name of the merchant.
Added On:  11/05/12
SQL Column:  MERCHANT_CITY
Java Field:  merchantCity
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
City associated with this merchant account.
Added On:  11/05/12
SQL Column:  MERCHANT_STATE
Java Field:  merchantState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State code associated with this merchant account.
Added On:  11/05/12
SQL Column:  MERCHANT_ZIP_CODE
Java Field:  merchantZipCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP/Postal code associated with this merchant account.
Added On:  11/05/12
SQL Column:  CUSTOMER_SERVICE_PHONE
Java Field:  customerServicePhone
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Service phone of the customer used for discussing any processing issues.
Added On:  11/05/12
SQL Column:  CHARGE_DESCRIPTION
Java Field:  chargeDescription
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
The Charge Descriptions are agreed upon by the client and American Express, at the time the Electronic Submission Addendum is completed.
Added On:  11/05/12
SQL Column:  FILENAME
Java Field:  filename
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the file.
Added On:  11/05/12
SQL Column:  RETAIL_MERCHANT_CATEGORY_CODE
Java Field:  retailMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
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
Attributes:
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:  11/05/12
SQL Column:  RETAIL_TERMINAL_ID
Java Field:  retailTerminalId
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
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:  RETAIL_DATAWIRE_ID
Java Field:  retailDatawireId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Datawire ID of the retail industry.
Added On:  11/05/12
SQL Column:  MOTO_MERCHANT_CATEGORY_CODE
Java Field:  motoMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
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
Attributes:
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:  11/05/12
SQL Column:  MOTO_TERMINAL_ID
Java Field:  motoTerminalId
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
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:  MOTO_DATAWIRE_ID
Java Field:  motoDatawireId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Datawire ID of the MOTO.
Added On:  11/05/12
SQL Column:  ECOMMERCE_MERCHANT_CATEGORY_CODE
Java Field:  ecommerceMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
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
Attributes:
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:  11/05/12
SQL Column:  ECOMMERCE_TERMINAL_ID
Java Field:  ecommerceTerminalId
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
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:  ECOMMERCE_DATAWIRE_ID
Java Field:  ecommerceDatawireId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Datawire ID of the e-commerce.
Added On:  11/05/12
SQL Column:  RESTAURANT_MERCHANT_CATEGORY_CODE
Java Field:  restaurantMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
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
Attributes:
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:  11/05/12
SQL Column:  RESTAURANT_TERMINAL_ID
Java Field:  restaurantTerminalId
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
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:  RESTAURANT_DATAWIRE_ID
Java Field:  restaurantDatawireId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Datawire ID of the restaurant.
Added On:  11/05/12
SQL Column:  SERVICE_ID
Java Field:  serviceId
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Digital number that represents the specific code of the product/service.
Added On:  11/05/12
SQL Column:  APPLICATION_ID
Java Field:  applicationId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Unique application identification number.
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:  11/20/12
SQL Column:  TPP_ID
Java Field:  tppId
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
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:  01/27/13
SQL Column:  APPLICATION_INFORMATION
Java Field:  applicationInformation
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Short information about the application used for transaction.
Added On:  02/22/13
SQL Column:  ACQUIRER_INSTITUTION_ID
Java Field:  acquirerInstitutionId
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
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:  03/21/13
SQL Column:  PROCESS_MODE
Java Field:  processMode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Mode of the processing.
Added On:  05/13/13
SQL Column:  TERMINAL_TYPE
Java Field:  terminalType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Type of the terminal used for the transaction.
Added On:  05/27/13
SQL Column:  NETWORK_ROUTING
Java Field:  networkRouting
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Zeros filled in the request message, debit Network ID will be included as response values.
Added On:  05/27/13
SQL Column:  LANE_NUMBER
Java Field:  laneNumber
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
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:  06/07/13
SQL Column:  USER_NAME
Java Field:  userName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the user in the system.
Added On:  06/07/13
SQL Column:  PASSWORD
Java Field:  password
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Password associated with the appropriate username.
Added On:  06/17/13
SQL Column:  CHECK_DIGIT
Java Field:  checkDigit
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
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:  08/28/13
SQL Column:  LODGING_MERCHANT_CATEGORY_CODE
Java Field:  lodgingMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
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
Attributes:
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:  08/28/13
SQL Column:  LODGING_TERMINAL_ID
Java Field:  lodgingTerminalId
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
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:  08/28/13
SQL Column:  LODGING_DATAWIRE_ID
Java Field:  lodgingDatawireId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Datawire ID of lodging.
Added On:  10/07/13
SQL Column:  HEADER_MERCHANT_ID
Java Field:  headerMerchantId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Header Merchant ID.
Added On:  10/21/13
SQL Column:  MERCHANT_STREET
Java Field:  merchantStreet
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Street address 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
Attributes:
Merchant Email
Added On:  10/22/13
SQL Column:  AGGREGATOR_NAME
Java Field:  aggregatorName
Status:  Active
SQL Type:  varchar(38)
Java Type:  String
Attributes:
Aggregator Name
Added On:  04/02/14
SQL Column:  MERCHANT_TAX_ID
Java Field:  merchantTaxId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Tax identifier of the merchant.
Added On:  06/20/14
SQL Column:  PETROLEUM_MERCHANT_CATEGORY_CODE
Java Field:  petroleumMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
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
Attributes:
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:  06/20/14
SQL Column:  PETROLEUM_TERMINAL_ID
Java Field:  petroleumTerminalId
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
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:  06/20/14
SQL Column:  PETROLEUM_DATAWIRE_ID
Java Field:  petroleumDatawireId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Datawire ID of the petroleum industry.
Added On:  09/15/14
SQL Column:  PROCESSOR_CL
Java Field:  processorCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Enumerates possible values of ISO8583 Profile.
Added On:  01/09/15
SQL Column:  MERCHANT_FNS_NUMBER
Java Field:  merchantFnsNumber
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
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/16/15
SQL Column:  MERCHANT_COUNTRY_CODE
Java Field:  merchantCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Code of the country associated with this merchant account.
Added On:  04/29/15
SQL Column:  PROCESSOR_ID
Java Field:  processorId
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
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
Attributes:
Name associated with the processor profile.
Added On:  04/29/15
SQL Column:  PROCESSOR_BUILDING_NUMBER
Java Field:  processorBuildingNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Building number of the processor's mailing address.
Added On:  04/29/15
SQL Column:  PROCESSOR_STREET
Java Field:  processorStreet
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Street 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
Attributes:
City of the processor's mailing address.
Added On:  04/29/15
SQL Column:  PROCESSOR_COUNTRY_CODE
Java Field:  processorCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code 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
Attributes:
ZIP/postal code of the processor's mailing address.
Added On:  04/29/15
SQL Column:  PROCESSOR_PHONE_NUMBER
Java Field:  processorPhoneNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Phone number of the processor for discussing any processing issues.
Added On:  04/29/15
SQL Column:  EMAIL_ADDRESS
Java Field:  emailAddress
Status:  Active
SQL Type:  varchar(160)
Java Type:  String
Attributes:
Email address of the provider.
Added On:  04/29/15
SQL Column:  MERCHANT_GROUP_IDENTIFIER
Java Field:  merchantGroupIdentifier
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Identifier of the merchant group.
Added On:  06/20/15
SQL Column:  CAR_RENTAL_DATAWIRE_ID
Java Field:  carRentalDatawireId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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:  06/20/15
SQL Column:  CAR_RENTAL_TERMINAL_ID
Java Field:  carRentalTerminalId
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
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:  06/30/15
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code of the merchant.
Needs to state 3 digit alpha-numeric country code.
Added On:  08/26/15
SQL Column:  DYNAMIC_MERCHANT_NAME
Java Field:  dynamicMerchantName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Dynamic merchant name.
Added On:  08/26/15
SQL Column:  DYNAMIC_MERCHANT_CITY
Java Field:  dynamicMerchantCity
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Dynamic merchant city address.
Added On:  08/26/15
SQL Column:  DYNAMIC_MERCHANT_STREET
Java Field:  dynamicMerchantStreet
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Dynamic merchant street address.
Added On:  08/26/15
SQL Column:  DYNAMIC_MERCHANT_ZIP
Java Field:  dynamicMerchantZip
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Dynamic merchant's mailing address ZIP or postal code.
Added On:  08/26/15
SQL Column:  DYNAMIC_MERCHANT_STATE
Java Field:  dynamicMerchantState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Dynamic merchant mailing state code.
Added On:  08/26/15
SQL Column:  DYNAMIC_MERCHANT_COUNTRY
Java Field:  dynamicMerchantCountry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Dynamic merchant mailing country code.
Added On:  08/26/15
SQL Column:  DYNAMIC_SUB_MERCHANT_ID
Java Field:  dynamicSubMerchantId
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Dynamic sub-merchant identification number.
Added On:  08/27/15
SQL Column:  MERCHANT_NAME_ABBREVIATION
Java Field:  merchantNameAbbreviation
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Abbreviation of the merchant's full name.
Added On:  08/28/15
SQL Column:  KEY_ID
Java Field:  keyId
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Key Serial Number.

Base Derivation Key ID (BDK ID) (If fewer than nine positions, pad on
LEFT with ‘F’s.)
Added On:  08/28/15
SQL Column:  TOKEN_TYPE
Java Field:  tokenType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Type of the token code.
Added On:  09/15/15
SQL Column:  AGGREGATOR_MERCHANT_SUB_MERCHANT_ID
Java Field:  aggregatorMerchantSubMerchantId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Identification number of the sub-merchant for merchant's aggregator.
Added On:  11/04/15
SQL Column:  DPC_NUMBER
Java Field:  dpcNumber
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Delivery point code assigned by a processor.
Added On:  11/05/15
SQL Column:  MC_ASSIGNED_ID
Java Field:  mcAssignedId
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
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:  11/12/15
SQL Column:  VISA_MERCHANT_VERIFICATION_VALUE
Java Field:  visaMerchantVerificationValue
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
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.
Added On:  12/25/15
SQL Column:  TRANS_ARMOR_KEY_ID
Java Field:  transArmorKeyId
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
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
Attributes:
Type of the token for TransArmor.
Added On:  01/04/16
SQL Column:  TOKEN_REQUESTOR_ID
Java Field:  tokenRequestorId
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Identification number of the token requestor.
Added On:  12/21/16
SQL Column:  VISA_BIN
Java Field:  visaBin
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
BIN accosiated with Visa cards.
Added On:  12/21/16
SQL Column:  MC_BIN
Java Field:  mcBin
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
BIN accosiated with MasterCard cards.
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:  01/17/17
SQL Column:  MERCHANT_NUMBER
Java Field:  merchantNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Identifier of the merchant assigned by a processor.
Added On:  02/17/17
SQL Column:  RETAIL_CHECK_DIGIT
Java Field:  retailCheckDigit
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Specific identifier of the retail industry profile assigned by a processor.
Added On:  02/17/17
SQL Column:  MOTO_CHECK_DIGIT
Java Field:  motoCheckDigit
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Specific identifier of the MOTO industry profile assigned by a processor.
Added On:  02/17/17
SQL Column:  ECOMMERCE_CHECK_DIGIT
Java Field:  ecommerceCheckDigit
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Specific identifier of the ecommerce industry profile assigned by a processor.
Added On:  02/17/17
SQL Column:  RESTAURANT_CHECK_DIGIT
Java Field:  restaurantCheckDigit
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Specific identifier of the restaurant industry profile assigned by a processor.
Added On:  02/17/17
SQL Column:  PETROLEUM_CHECK_DIGIT
Java Field:  petroleumCheckDigit
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Specific identifier of the pertoleum industry profile assigned by a processor.
Added On:  03/02/17
SQL Column:  APPLICATION_HEADER
Java Field:  applicationHeader
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Header element of the application.
Added On:  07/27/17
SQL Column:  RETAIL_MERCHANT_NUMBER
Java Field:  retailMerchantNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
Added On:  07/27/17
SQL Column:  MOTO_MERCHANT_NUMBER
Java Field:  motoMerchantNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
Added On:  07/27/17
SQL Column:  ECOMMERCE_MERCHANT_NUMBER
Java Field:  ecommerceMerchantNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
Added On:  07/27/17
SQL Column:  RESTAURANT_MERCHANT_NUMBER
Java Field:  restaurantMerchantNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
Added On:  07/27/17
SQL Column:  LODGING_MERCHANT_NUMBER
Java Field:  lodgingMerchantNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
Added On:  07/27/17
SQL Column:  PETROLEUM_MERCHANT_NUMBER
Java Field:  petroleumMerchantNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
Added On:  07/27/17
SQL Column:  CAR_RENTAL_MERCHANT_NUMBER
Java Field:  carRentalMerchantNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Settlement 80 byte Merchant number. (Used in FirstData OmniPay)
Added On:  07/12/17
SQL Column:  ECOMM_URL
Java Field:  ecommUrl
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Merchant's connection URL used for e-commerce transactions processing.