Phone Country Code

The country code detail that can be associated with a trading community member's phone number. For example country code for Oracle Corporation is 1.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/phoneFormatService/}PhoneCountryCode

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Trading Community Phone Format

Contains

Trading Community Mobile Phone Prefix

Contains

Phone Area Code

Handled by

Trading Community Information Format for Phone

Attributes

The following table describes attributes in the service data object.

Name Type Description

AreaCodeLength

decimal

Number of fixed area code digits.

CreatedBy

string

The user who created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

IntlPrefix

string

International telephone number prefix.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated.

LastUpdateLogin

string

The login of the user who last updated the record.

LastUpdatedBy

string

The user who last updated the record.

MobilePrefix

Trading Community Mobile Phone Prefix

Prefixes for mobile phone numbers.

ObjectVersionNumber

int

The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.

PhoneAreaCode

Phone Area Code

The area code prefix for the phone number.

PhoneCountryCode

string

The country code prefix for the phone number.

PhoneCountryCodeId

long

Unique identifier for the Phone area codes.
  • Primary Key

PhoneFormat

Trading Community Phone Format

Format associated with phone numbers.

PhoneLength

decimal

Number of fixed telephone number digits.

TerritoryCode

string

Foreign key to the FND_TERRITORIES.TERRITORY_CODE.

TimezoneCode

string

Foreign key to FND_TIMEZONES_B.TIMEZONE_CODE.

TrunkPrefix

string

Long distance telephone number prefix.

ValidationProc

string

PL/SQL validation procedure for telephone numbers of this country.