Customer Contact Profile

The person who functions as a contact for an organization.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/relationshipService/}OrganizationContact

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

Customer Contact Responsibility

Contains

Trading Community Organization Contact Additional Information

Contains

Source System Reference

Contained by

Relationship

Handled by

Trading Community Group

Handled by

Trading Community Organization

Handled by

Sales Account Service

Handled by

Sales Party

Handled by

Company and User Registration

Handled by

Sales Party Resource Service

Handled by

Sales Party Territory service

Handled by

Partner Service

Handled by

Trading Community Person Information

Attributes

The following table describes attributes in the service data object.

Name Type Description

Comments

string

The comments for the record.

ContactFormattedAddress

string

The formatted version of the contact address.

ContactFormattedMultilineAddress

string

The formatted multiline version of the contact address.

ContactName

string

The name of the contact.

ContactNumber

string

The user-defined identification number for this contact.

ContactPartyId

long

The unique identifier of the contact.

CorpCurrencyCode

string

The corporate currency code associated with the record. This attribute is used by CRM Extensibility framework.

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.

CurcyConvRateType

string

The currency conversion rate associated with the record. This attribute is used by CRM Extensibility framework.

CurrencyCode

string

The currency code. This attribute is used by CRM Extensibility framework.

CustomerEmailAddress

string

The e-mail address of the customer this contact person belongs to.

CustomerName

string

The name of the customer.

CustomerPartyId

long

The unique identifier of the customer this contact person belongs to.

CustomerPartyNumber

string

The alternate unique identifier of the customer this contact person belongs to.

CustomerUniqueName

string

The unique name of the customer. For an Organization, the value is a concatenation of unique_name_alias and suffix. For a Person, the value is a concatenation of person_name and suffix.

DecisionMakerFlag

boolean

Indicates if this contact is a decision maker. If the value is True, then the contact is a decision maker.

Department

string

The free form text used to name the department for the contact.

DepartmentCode

string

The department code for the contact. A list of accepted values is defined in the lookup DEPARTMENT_TYPE.

EmailAddress

string

The email address associated with the record.

FormattedAddress

string

The formatted address information.

FormattedPhoneNumber

string

The formatted phone number.

JobTitle

string

The free form text for job title.

JobTitleCode

string

The code given to the job title.

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.

OrgContactId

long

The unique identifier of the organization contact.
  • Primary Key

OrgContactInformation

Trading Community Organization Contact Additional Information

The information of the organization contact.

OrganizationContactRole

Customer Contact Responsibility

The role of the contact in the organization.

OrigSystemReference

string

The identifier for the record from the original system.

OriginalSystemReference

Source System Reference

The identifier for the record from the original system.

PartyRelationshipId

long

The unique identifier of the relationship of the party.

PartySiteId

long

The identifier for the party site. It is the foreign key to the HZ_PARTY_SITES table.

PartySiteName

string

The address associated with the party site.

PersonAcademicTitle

string

The part of the person's title that denotes the academic qualification, such as Dr. Jane Smith.

PersonCertReasonCode

string

The reason for the organization's current certification level assignment. A list of accepted values is defined using the lookup HZ_PARTY_CERT_REASON.

PersonCertificationLevel

string

The certification level of a organization. A list of accepted values is defined in the lookup HZ_PARTY_CERT_LEVEL.

PersonFirstName

string

The first name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Given Name in HL7.

PersonLanguageName

string

The language name associated with the person.

PersonLastName

string

The last name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Family Name in HL7.

PersonLastNamePrefix

string

The prefix for the last name of a person, such as fon, van. For example, if a person's name is Hans Van, the last name of the person is captured using this attribute.

PersonMiddleName

string

The middle name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Middle Initial or Name in HL7.

PersonNameSuffix

string

The place in a family structure. For example, in "Tom Jones III", the "III".

PersonPreNameAdjunct

string

The preferred name adjacency of a resource.

PersonPreviousLastName

string

The previous last name of a person.

PersonSecondLastName

string

The second last name for a person. In some cultures it is not uncommon to have double last names. It is used in the same way the field PERSON_SECOND_LAST_NAME in HZ_PERSON_PROFILES is used.

PersonTitle

string

The professional or family title. For example, Don or The Right Honorable.

PreferredContactFlag

boolean

Indicates if this contact person is primary contact for the customer.

PreferredContactMethod

string

The preferred contact method for a person or organization. It is validated against lookup HZ_PREFERRED_CONTACT_METHOD.

PreferredName

string

The denormalized value of the PARTY_NAME field in HZ_ADDTNL_PARTY_NAMES identified by PREFERRED_NAME_ID.

PrimaryCustomerFlag

boolean

Indicates if this customer is primary customer for the contact.

Rank

string

The rank associated with this customer contact.

ReferenceUseFlag

boolean

Indicates if this contact can be used as a reference. If the value is Y, then the contact can be used as a reference.

RequestId

long

A system-generated read-only attribute used by the application framework.

SalesAffinityCode

string

The affinity of a contact to the deploying organization. A list of accepted values is defined in the lookup HZ_SLS_CNTCT_AFFINITY_CODE.

SalesAffinityComments

string

The comments about the contact's affinity to the deploying organization.

SalesBuyingRoleCode

string

The roles played by a contact in the buying process, for example, decision maker or supporting role. A list of accepted values is defined in the lookup HZ_SLS_CNTCT_BUY_ROLE_CODE.

SalesInfluenceLevelCode

string

The influence of the contact has on the deploying organization. A list of accepted values are defined in the lookup HZ_SLS_CNTCT_INFLUENCE_LVL_CD.

Salutation

string

The size of the household this person is a part of.

WebUrl

string

The web URL of contact point.