Facilitator Profile


Added On:  10/06/15 
SQL Table:  FACILITATOR_PROFILE 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  FacilitatorProfile 
Added On:  10/06/15
SQL Column:  NAME
Java Field:  name
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Name associated with the facilitator profile.
Added On:  10/06/15
SQL Column:  STREET
Java Field:  street
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street address associated with the facilitator profile.
Added On:  10/06/15
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City address associated with the facilitator profile.
Added On:  10/06/15
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State address associated with the facilitator profile.
Added On:  10/06/15
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP (or postal) code of the address associated with the facilitator profile.
Added On:  10/06/15
SQL Column:  COUNTRY
Java Field:  country
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country address associated with the facilitator profile.
Added On:  10/06/15
SQL Column:  CONTACT_PHONE_NUMBER
Java Field:  contactPhoneNumber
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Contact phone number associated with the facilitator profile.
Added On:  10/06/15
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email address associated with the facilitator profile.
Added On:  10/06/15
SQL Column:  SERVICE_ENTITLEMENT_NUMBER
Java Field:  serviceEntitlementNumber
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
If alternative Service Entitlement number needs to be used for non-bank cards, this information should be provided.
Added On:  10/07/15
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly
Identifier of the object used for references.
Added On:  10/07/15
SQL Column:  CODE
Java Field:  code
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Facilitator's profile code in the system.
Added On:  10/27/15
SQL Column:  AMEX_SELLER_ID
Java Field:  amexSellerId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Merchant assigned Seller/Vendor unique numeric identifier.
Left justified, space filled at right.

Note: The Seller ID is mandatory to be used only by aggregators. Space filled for non seller ID transaction by Aggregators.
Added On:  10/27/15
SQL Column:  AMEX_SELLER_CODE
Java Field:  amexSellerCode
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Seller code that is issued by the credit card processor (American Express).
Added On:  11/05/15
SQL Column:  REGION
Java Field:  region
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Region address associated with the facilitator profile.