Retail FirstData Compass Profile

Parent: Retail Profile

Added On: 02/13/12

SQL Table: RETAIL_FIRST_DATA_COMPASS_PROFILE

Module: UniCharge

Type: Entity Status: Active

Java Class: RetailFirstDataCompassProfile

Encapsulates FirstData Compass specific settings required for real-time transaction processing. Adds FirstData Compass specific fields to the base fields of Billing Profile and Retail Profile.

Available Fields:

Application ID
Auth Password
Auth Username
Customer Service Phone Number
Datawire ID
Descriptor
Descriptor Prefix
Division Number
Filename
Food And Consumer Number

Is Test Mode
Item Description
Merchant Category Code
Merchant City
Merchant Country Code
Merchant Email
Merchant ID
Merchant Location Id
Merchant Name
Merchant Postal Code

Merchant Region
Merchant Street
PID
PID Password
Retail First Data Compass Profile Cl
Service ID
SID
SID Password
Terminal ID
TPP ID

Application ID

Added On: 02/13/12

SQL Column: APPLICATION_ID

Java Field: applicationId

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Assigned by the processor.

Auth Password

Added On: 02/18/22

SQL Column: AUTH_PASSWORD

Java Field: authPassword

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Auth Username

Added On: 02/18/22

SQL Column: AUTH_USERNAME

Java Field: authUsername

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Customer Service Phone Number

Added On: 02/13/12

SQL Column: CUSTOMER_SERVICE_PHONE_NUMBER

Java Field: customerServicePhoneNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Customer service phone number that will appear on the cardholder’s statement. If left blank, this will default to the merchant city field at the division level

Datawire ID

Added On: 02/13/12

SQL Column: DATAWIRE_ID

Java Field: datawireId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Assigned by the processor.

Descriptor

Added On: 02/17/15

SQL Column: DESCRIPTOR

Java Field: descriptor

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

Catalogue name/product type/installment information.

Descriptor Prefix

Added On: 02/17/15

SQL Column: DESCRIPTOR_PREFIX

Java Field: descriptorPrefix

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Abbreviated corporate name.

Division Number

Added On: 02/13/12

SQL Column: DIVISION_NUMBER

Java Field: divisionNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Assigned and provided to merchant by First Data. First Data assigns a unique Division Number to process each international currency. A single Division Number can support different transaction types and methods of payment in the same currency.

Filename

Added On: 02/13/12

SQL Column: FILENAME

Java Field: filename

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Name of the uploaded file.

Food And Consumer Number

Added On: 11/30/17

SQL Column: FOOD_AND_CONSUMER_NUMBER

Java Field: foodAndConsumerNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Is Test Mode

Added On: 02/13/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.

Item Description

Added On: 02/13/12

SQL Column: ITEM_DESCRIPTION

Java Field: itemDescription

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Descriptor that will appear on the cardholder’s statement. If this field is blank the descriptor is reset to the default at the division level.

Merchant Category Code

Added On: 11/30/17

SQL Column: MERCHANT_CATEGORY_CODE

Java Field: merchantCategoryCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Merchant City

Added On: 02/17/15

SQL Column: MERCHANT_CITY

Java Field: merchantCity

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

City of the mailing address for the merchant.

Merchant Country Code

Added On: 02/17/15

SQL Column: MERCHANT_COUNTRY_CODE

Java Field: merchantCountryCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Country code of the mailing address for the merchant.

Merchant Email

Added On: 11/30/17

SQL Column: MERCHANT_EMAIL

Java Field: merchantEmail

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Merchant ID

Added On: 02/13/12

SQL Column: MERCHANT_ID

Java Field: merchantId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Merchant’s location ID.

Merchant Location Id

Added On: 11/30/17

SQL Column: MERCHANT_LOCATION_ID

Java Field: merchantLocationId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Merchant Name

Added On: 02/13/12

SQL Column: MERCHANT_NAME

Java Field: merchantName

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Name of merchant.

Merchant Postal Code

Added On: 02/17/15

SQL Column: MERCHANT_POSTAL_CODE

Java Field: merchantPostalCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Postal code (ZIP code) of the mailing address for the merchant.

Merchant Region

Added On: 02/17/15

SQL Column: MERCHANT_REGION

Java Field: merchantRegion

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Region of the mailing address for the merchant.

Merchant Street

Added On: 02/17/15

SQL Column: MERCHANT_STREET

Java Field: merchantStreet

Status: Active

SQL Type: varchar(38)

Java Type: String

Attributes:

Street of the mailing address for the merchant.

PID

Added On: 02/13/12

SQL Column: PID

Java Field: pid

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Presenter’s ID is assigned by First Data.
The PID is a number assigned to the location that physically sends the data file (Presenter).

PID Password

Added On: 02/13/12

SQL Column: PID_PASSWORD

Java Field: pidPassword

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Assigned by First Data.

Retail First Data Compass Profile Cl

Added On: 11/30/17

SQL Column: RETAIL_FIRST_DATA_COMPASS_PROFILE_CL

Java Field: retailFirstDataCompassProfileCl

Status: Active

SQL Type: varchar(6)

Java Type: String

References CC Compass Profile Classifier

Attributes:

Service ID

Added On: 02/13/12

SQL Column: SERVICE_ID

Java Field: serviceId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Digital number that represents the specific code of the product/service.

SID

Added On: 02/13/12

SQL Column: SID

Java Field: sid

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Submitter’s ID is assigned by First Data.

SID Password

Added On: 02/13/12

SQL Column: SID_PASSWORD

Java Field: sidPassword

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Assigned by First Data.

Terminal ID

Added On: 02/13/12

SQL Column: TERMINAL_ID

Java Field: terminalId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Identifies a processing device associated to a Point of Sale division. This is not a required Format Indicator for retail transactions, but should be provided if possible to meet association rules and qualify for the best interchange rates.

TPP ID

Added On: 02/13/12

SQL Column: TPP_ID

Java Field: tppId

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Third Party Processor 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.