CC Compass Profile


Parent:    CC Profile
Added On:  02/13/12 
SQL Table:  CC_COMPASS_PROFILE 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  CcCompassProfile 
Entity that represents configuration settings for batch credit card processing through FirstData Compass.
Added On:  02/13/12
SQL Column:  CC_COMPASS_PROFILE_CL
Java Field:  ccCompassProfileCl
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Represents current (or selected) type of credit card FirstData Compass profile.
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
Added On:  02/27/15
SQL Column:  DESCRIPTOR
Java Field:  descriptor
Status:  Active
SQL Type:  varchar(21)
Java Type:  String
Attributes:
Catalogue name/product type/instalment information.
Added On:  02/27/15
SQL Column:  DESCRIPTOR_PREFIX
Java Field:  descriptorPrefix
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Abbreviated corporate name.
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.
Added On:  02/13/12
SQL Column:  FILENAME
Java Field:  filename
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
The name given to a file in order to distinguish it from other files in Compass system.
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.
Added On:  12/13/17
SQL Column:  MERCHANT_CATEGORY_CODE
Java Field:  merchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  02/27/15
SQL Column:  MERCHANT_CITY
Java Field:  merchantCity
Status:  Active
SQL Type:  varchar(21)
Java Type:  String
Attributes:
Merchant city where the transaction took place.
Added On:  02/27/15
SQL Column:  MERCHANT_COUNTRY_CODE
Java Field:  merchantCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Merchant country code where the transaction took place.
Added On:  12/13/17
SQL Column:  MERCHANT_EMAIL
Java Field:  merchantEmail
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  12/13/17
SQL Column:  MERCHANT_LOCATION_ID
Java Field:  merchantLocationId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Assigned and provided to merchant by First Data.
Added On:  02/27/15
SQL Column:  MERCHANT_POSTAL_CODE
Java Field:  merchantPostalCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Merchant ZIP/Postal code where the transaction took place.
Added On:  02/27/15
SQL Column:  MERCHANT_REGION
Java Field:  merchantRegion
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Merchant State/Province where the transaction took place.
Added On:  02/27/15
SQL Column:  MERCHANT_STREET
Java Field:  merchantStreet
Status:  Active
SQL Type:  varchar(38)
Java Type:  String
Attributes:
Merchant street address where the transaction took place.
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)
Added On:  02/13/12
SQL Column:  PID_PASSWORD
Java Field:  pidPassword
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The PID password assigned by First Data.
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.
Added On:  02/13/12
SQL Column:  SID_PASSWORD
Java Field:  sidPassword
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The SID password, assigned by First Data.
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 - 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.