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

Trading Community Organization Contact Additional Information

Contains

Source System Reference

Contains

Customer Contact Responsibility

Contained by

Relationship

Handled by

Trading Community Group

Handled by

Trading Community Organization

Handled by

Company and User Registration

Handled by

Sales Account Service

Handled by

Sales Party

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 address for the contact.

ContactFormattedMultilineAddress

string

Formatted Multiline address of Contact.

ContactName

string

Name of contact.

ContactNumber

string

User-defined identification number for this contact.

ContactPartyId

long

Contact Identifier.

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

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

CustomerName

string

Name of customer.

CustomerPartyId

long

Identifier of customer.

CustomerPartyNumber

string

Unique identification number for this party.

CustomerUniqueName

string

Unique name of the customer.

DecisionMakerFlag

boolean

Indicates if this contact is a decision maker. Y for a decision maker, N for someone who is not the decision maker.

Department

string

Free form text used to name the department.

DepartmentCode

string

List of values for possible department codes.

EmailAddress

string

The email address associated with the record.

FormattedAddress

string

Primary formatted address for the contact person.

FormattedPhoneNumber

string

The formatted phone number.

JobTitle

string

Free form text for job title.

JobTitleCode

string

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

Identifier of the organization contact.
  • Primary Key

OrgContactInformation

Trading Community Organization Contact Additional Information

Organization Contact Information.

OrganizationContactRole

Customer Contact Responsibility

Role played by the organization contact.

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

Identifies relationship that contact person has with an organization or person. Foreign key to the HZ_RELATIONSHIPS table.

PartySiteId

long

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

PartySiteName

string

Address associated with the organization contact.

PersonAcademicTitle

string

Academic title that is part of a person's name, such as Dr. John Smith.

PersonCertReasonCode

string

Reason for organization party's cur rent certification level assignment.

PersonCertificationLevel

string

Certification level an organization party.

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

Standard name for a language.

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

Last name prefix for a person.

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

Indicates the place in a family structure. For example, in Tom Jones III, the 'III' is the suffix.

PersonPreNameAdjunct

string

Salutary introduction, such as Mr. or Mrs.

PersonPreviousLastName

string

Previous last or surname of the 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

Importance of the contact relative to other contacts.

ReferenceUseFlag

boolean

Indicates if this contact can be used as a reference. Y for a contact who will act as a reference, N for a contact who cannot act as a reference.

RequestId

long

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

SalesAffinityCode

string

Contact's affinity towards the deploying organization.

SalesAffinityComments

string

Comments describing contact's affinity towards the deploying organization.

SalesBuyingRoleCode

string

Contact's role in the buying process.

SalesInfluenceLevelCode

string

Contact's level of influence in the buying process.

Salutation

string

Phrase used to address a party in any correspondence.

WebUrl

string

Web URL of contact point.