Facilitator Profile

Added On: 10/06/15

SQL Table: FACILITATOR_PROFILE

Module: UniCharge

Type: Entity Status: Deleted

Java Class: FacilitatorProfile

Available Fields:

AmEx Seller Code
AmEx Seller ID
City
Code

Contact Phone Number
Country
Email
ID

Name
Region
Service Entitlement Number
State

Street
ZIP Code

AmEx Seller Code

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).

AmEx Seller ID

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.

City

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.

Code

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.

Contact Phone Number

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.

Country

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: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Email address associated with the facilitator profile.

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

Identifier of the object used for references.

Name

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.

Region

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.

Service Entitlement Number

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.

State

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.

Street

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.

ZIP Code

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.