Phone

The phone number associated with a trading community member. For example, the phone number for Oracle Corporation is 650-506-6000.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/contactPointService/}Phone

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 Contact Point Additional Information
Contains	Source System Reference
Contains	Contact Preference
Contained by	Trading Community Person Details
Contained by	Marketing Response
Contained by	Partner
Contained by	Household
Contained by	Contact Address
Contained by	Address
Contained by	Trading Community Organization Details
Contained by	Relationship
Handled by	Trading Community Group
Handled by	Deal Registration Service
Handled by	Trading Community Organization
Handled by	Sales Account Service
Handled by	Sales Party
Handled by	Marketing Response Service
Handled by	Company and User Registration
Handled by	Sales Party Resource Service
Handled by	Sales Party Territory service
Handled by	Partner Service
Handled by	Partner Program Enrollment Service
Handled by	Trading Community Person Information

Attributes

The following table describes attributes in the service data object.

Name	Type	Description
ContactPointId	long	The unique primary key identifier for the contact point. Primary Key
ContactPointPurpose	string	The purpose of the contact point.
ContactPointType	string	The type of the contact point.
ContactPreference	Contact Preference	The contact preference associated with the record.
CreatedBy	string	The user who created the record.
CreatedByModule	string	The module that created the record.
CreationDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The date when the record was created.
EndDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	Indicates the date till which the entity is active. This date is inclusive and the status of the entity is dependent on this.
FormattedPhoneNumber	string	The formatted phone number.
LastContactDtTime	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date and time of last contact placed to this contact point.
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.
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.
OrigSystem	string	The source system name.
OrigSystemReference	string	The identifier for the record from the original system.
OriginalSystemReference	Source System Reference	The identifier for the record from the original system.
OverallPrimaryFlag	boolean	Indicator to specify if this is the primary contact point of the contact irrespective of the context. Y stands for primary contact and N for all others.
OwnerTableId	long	The unique identifier for a record in the owner table.
OwnerTableName	string	The Trading Community Architecture (TCA) tables that have source system reference column.
PagerTypeCode	string	The PAGER_TYPE_CODE column stores the lookup code for the type of pager. The type of pager determines how the page is received. For example, tone, number, alphanumeric or two-way alphanumeric.
PartyName	string	The name of the party.
PartyUsageCode	string	The usage context of a party's contact point.
PhoneAreaCode	string	The area code prefix for the phone number.
PhoneCallingCalendar	string	The name or code for a calling calendar used with this telephone number. This attribute is no longer used in Fusion applications.
PhoneCountryCode	string	The country code prefix for the phone number.
PhoneExtension	string	The additional number addressed after initial connection to an internal telephone system.
PhoneInformation	Trading Community Contact Point Additional Information	The additional information for the trading community phone.
PhoneLineType	string	The lookup code for the type of phone line. For example, general, fax, inbound, or outbound.
PhoneNumber	string	The telephone number in the local format. The number should not include area code, country code, or extension.
PrimaryByPurpose	string	Indicates whether this is the primary contact point of the contact point purpose for the party or site. The value Y indicates that the contact point is the primary contact point. A party or site can have only one contact point with value Y.
PrimaryFlag	boolean	Indicator to specify if this is the primary contact point of the contact point type for referenced party, site, or location. Y stands for primary contact and N for all others.
RawPhoneNumber	string	The unformatted telephone number.
RelationshipId	long	The relationship identifier for the record.
RequestId	long	A system-generated read-only attribute used by the application framework.
StartDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	Indicates the date from which this entity is active. This date is inclusive and the status of an entity is dependent on this.
Status	string	The status of the record.
TimezoneCode	string	The foreign key to FND_TIMEZONES_B.TIMEZONE_CODE.
TransposedPhoneNumber	string	This column stores the concatenation of PHONE_COUNTRY_CODE, PHONE_AREA_CODE, and PHONE_NUMBER in reverse order. For example, if PHONE_COUNTRY_CODE=1, PHONE_AREA_CODE=650 and PHONE_NUMBER=5065747, this column stores 74756050561. This column is used for building an index to search for any combination of the above three columns.