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 |
|
Contains |
|
Contains |
|
Contained by |
|
Contained by |
|
Contained by |
|
Contained by |
|
Contained by |
|
Contained by |
|
Contained by |
|
Contained by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
|
Handled by |
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.
|
ContactPointPurpose |
string |
The purpose of the contact point. |
ContactPointType |
string |
The type of the contact point. |
ContactPreference |
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 |
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 |
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. |