Sales Cloud Contact

An object that includes attributes used to store values while creating or updating a contact. A contact is a person who either has a relationship to other objects like contact and household or is a standalone customer or prospect. This object is an aggregation of person profile, contact information, and references a single primary address.

QName: {http://xmlns.oracle.com/apps/crmCommon/salesParties/contactService/}Contact

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

Sales Cloud Primary Address

Contains

Note

Contains

Sales Team Member

Handled by

Sales Cloud Contact

Attributes

The following table describes attributes in the service data object.

Name Type Description

AcademicTitle

string

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

AccountName

string

The name of the sales account that this contact belongs to.

AccountPartyId

long

The unique identifier of sales account that this contact belongs to. To specify the account for a contact, you can provide an Account's party ID, PartyNumber, SourceSystem, or SourceSystemReference.

AccountPartyNumber

string

The party number of the sales account that this contact belongs to. To specify the account for a contact, you can provide an Account's party ID, PartyNumber, SourceSystem, or SourceSystemReference.

AccountSourceSystem

string

The Source System code of the sales account that this contact belongs to. To specify the account for a contact, you can provide an Account's party ID, PartyNumber, SourceSystem, or SourceSystemReference.

AccountSourceSystemReferenceValue

string

The Source System Reference value of the sales account that this contact belongs to. To specify the account for a contact, you can provide an Account's party ID, PartyNumber, SourceSystem, or SourceSystemReference.

AddressElementAttribute1

string

Additional address element to support flexible address format

AddressElementAttribute2

string

Additional address element to support flexible address format

AddressElementAttribute3

string

Additional address element to support flexible address format

AddressElementAttribute4

string

Additional address element to support flexible address format

AddressElementAttribute5

string

Additional address element to support flexible address format

AddressLine1

string

First line of address.

AddressLine2

string

Second line of address.

AddressLine3

string

Third line of address.

AddressLine4

string

Fourth line of address.

AddressLinesPhonetic

string

The phonetic or Kana representation of the Kanji address lines (used in Japan).

AddressNumber

string

Alternate unique identifier for the address. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update. If not specified, then it is automatically generated. Prefix defined as in profile option ZCA_PUID_PREFIX concatenated with an internally generated unique sequence number.

AddressType

string

Additional information as type of address like BillTo, ShipTo.

AssignmentExceptionFlag

boolean

Indicates whether the sales account has the required dimensions to allow assignment manager to assign territories to the sales account. If the value is True, then the sales account has the required dimensions. The default value is False.

Building

string

Specific building name or number at a given address.

CertificationLevel

string

The certification level the organization party as indicated in the HZ_PARTY_CERT_LEVEL lookup type.

CertificationReasonCode

string

The reason for the contact's current certification level assignment. A list of accepted values are defined using the lookup HZ_PARTY_CERT_REASON. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.

City

string

The city element of address.

ClassificationCategory

string

A valid classification category code for the contact. This is defined by an admin and is marked as primary.

ClassificationCode

string

A valid classification code corresponding to the classification category, which is marked as primary.

Comments

string

The comments for the record.

ContactIsPrimaryForAccount

string

The preferred contact for the account.

ContactName

string

The derived name of the contact.

ContactRole

string

Specifies the role of the contact.

ContactUniqueName

string

The unique contact name displayed on contact related screens. The default value for ContactUniqueName is the concatenation of attributes ContactName and UniqueNameSuffix. If the attribute UniqueNameSuffix is nil, then the ContactName is concatenated with a system generated number.

CorpCurrencyCode

string

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

Country

string

Country code of the address.

County

string

County element of address.

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.

DataCloudStatus

string

The enrichment status of the contact record from Data cloud. A list of accepted values are defined in the lookup DATA_CLOUD_STATUS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

DateOfBirth

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the person was born.

DateOfDeath

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Date when the person died.

DeceasedFlag

boolean

Indicates whether the person deceased or not. If the value is True, then the person is deceased. The default value is False.

DeclaredEthnicity

string

The declared ethnicity of the person.

DeleteFlag

boolean

Indicates whether the record can be deleted or not.

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. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.

DoNotCallFlag

boolean

Indicates if the user can call the person or not. If the value is True, then the user must not call the person. The default value is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.

DoNotContactFlag

boolean

Indicates if the user can contact the person or not by phone, email, or mail. If the value is True, then the user must not contact the person. The default is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.

DoNotEmailFlag

boolean

Indicates if the user can email the person or not. If the value is True, then the user must not contact the person by e-mail. The default is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.

DoNotMailFlag

boolean

Indicates if the user can send mail to the person or not. If the value is True, then the user must not contact the person by mail. The default is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.

EmailAddress

string

The email address associated with the record.

EmailFormat

string

The preferred format for email addressed to this address such as HTML or ASCII. A list of accepted values is defined using the lookup EMAIL_FORMAT. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

ExistingCustomerFlag

boolean

Indicates whether there is an existing selling or billing relationship with the sales account. If the value is true, then there is an existing relationship with the sales account. The default value is False. Such relationships are defined by the existence of a Sell_To or Bill_To address.

ExistingCustomerFlagLastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the ExistingCustomerFlag was last modified. It is internally populated by the application.

FavoriteContactFlag

boolean

Indicates whether the person is a key contact. If the value is True, then person is a key contact. The default value is False.

FaxAreaCode

string

The area code.

FaxCountryCode

string

The international country code for a telephone number, such as 33 for France.

FaxExtension

string

The additional number addressed after initial connection to an internal telephone system.

FaxNumber

string

A telephone number formatted in the local format without the area code, country code, or extension.

FirstName

string

The first name of the person.

FloorNumber

string

Specific floor number at a given address or in a particular building when building number is provided

FormattedFaxNumber

string

The formatted fax number information.

FormattedHomePhoneNumber

string

Formatted mobile phone number information.

FormattedMobileNumber

string

Formatted work phone number information.

FormattedWorkPhoneNumber

string

The formatted work phone number information.

Gender

string

The gender of the person, such as male, female, and unknown. A list of accepted values are defined in the lookup HZ_GENDER. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

HeadOfHouseholdFlag

boolean

Indicates if the person is the head of the household. If the value is True, then the person is the head of the household. The default value is False.

HomePhoneAreaCode

string

The area code within a country code.

HomePhoneCountryCode

string

The international country code for a telephone number, such as 33 for France.

HomePhoneNumber

string

The home phone number formatted in the local format without the area code, country code, or extension.

HouseholdIncomeAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The income of the household that this person is a part of.

HouseholdSize

decimal

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

Initials

string

The initials of the contact's name.

JobTitle

string

The free form text for job title.

JobTitleCode

string

Code given to the job title.

LastAssignmentDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the sales account territory assignment was last run by assignment manager.

LastAssignmentDateTime

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

The date and time when the sales account territory assignment was last run by assignment manager.

LastContactDate

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

The date when the contact was last contacted.

LastEnrichmentDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the contact record was last enriched with data from external sources by using Data-as-a-Service.

LastName

string

The last name of the person.

LastNamePrefix

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.

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.

Mailstop

string

A user-defined code to indicate a mail drop point within their organization

MaritalStatus

string

The marital status of the person. A list of accepted values is defined in the lookup MARITAL_STATUS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

MaritalStatusEffectiveDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the person's marital status was changed.

MiddleName

string

The middle name of the person.

MobileAreaCode

string

The area code for the contact's mobile phone.

MobileCountryCode

string

The international country code for a contact's mobile phone number, such as 33 for France.

MobileExtension

string

The additional number addressed after initial connection to an internal telephone system.

MobileNumber

string

The mobile phone number formatted in the local format. The number should not include area code, country code, or extension.

MyBusinessContact

string

Indicates if searching on business contact belongs to login user. If the value is True, then the business contact belongs to login user. The default value is False.

NameSuffix

string

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

NamedFlag

boolean

Indicates whether a sales account is a named sales account. If the value is True, then the sales account is a named sales account. The default value is False.

Note

Note

The note about the contact.

OwnerEmailAddress

string

The email address of a valid employee resource who owns and manages the sales account. To assign an owner to the sales account, user can provide one of the following attributes pertaining to the owner: PartyID, PartyNumber or E-mail Address. This is provided if user wants to change the owner of the contact or create contact with a different owner than the login user. If provided, then OwnerPartyID, OwnerPartyNumber, and OwnerEmailAddress are honored in this order to determine the owner for the contact.

OwnerName

string

The name of the sales account owner.

OwnerPartyId

long

The unique identifier of a valid employee resource who owns and manages the sales account. The owner is a valid employee resource defined within Sales Cloud. To assign an owner to the sales account, user can provide one of the following attributes pertaining to the owner: PartyID, PartyNumber, or E-mail Address. This is provided if user wants to change the owner of the contact or create contact with a different owner than the login user. If provided, then OwnerPartyID, OwnerPartyNumber, and OwnerEmailAddress are honored in this order to determine the owner for the contact. During create, if none of the OwnerPartyID, OwnerPartyNumber, or OwnerEmailAddress is provided, then the contact is assigned by default to the login user. The login user's partyID is used to populate OwnerPartyID.

OwnerPartyNumber

string

The party number of a valid employee resource who owns and manages the sales account. To assign an owner to the sales account, user can provide one of the following attributes pertaining to the owner: PartyID, PartyNumber, or E-mail Address. This is provided if user wants to change the owner of the contact or create contact with a different owner than the login user. If provided, then OwnerPartyID, OwnerPartyNumber, and OwnerEmailAddress are honored in this order to determine the owner for the contact.

PartyId

long

The unique identifier of the contact party.
  • Primary Key

PartyNumber

string

The unique identification number for the party.

PartyStatus

string

The status of the contact. A list of valid values are defined in the lookup HZ_STATUS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

PersonalIncomeAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The estimated gross annual income of the person.

PlaceOfBirth

string

The place where the person was born, such as city or country.

PostalCode

string

Postal code as defined by the formal countrywide postal system

PostalPlus4Code

string

Four digit extension to the United States Postal ZIP code.

PreferredContactMethod

string

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

PreferredFunctionalCurrency

string

The preferred functional currency for the person or organization. The denormalized value of the PREF_FUNCTIONAL_CURRENCY in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES.

PreviousLastName

string

The previous last name or surname of the person.

PrimaryAddress

Sales Cloud Primary Address

The primary address of the contact.

Province

string

Province element of address.

RawFaxNumber

string

The unformatted fax number information.

RawHomePhoneNumber

string

Unformatted home phone number information.

RawMobileNumber

string

The unformatted mobile phone number information.

RawWorkPhoneNumber

string

The unformatted work phone number information.

RecordSet

string

The search results displayed under the selected record set.

RegistrationStatus

string

Specifies the registration status of the contact.

RentOrOwnIndicator

string

Indicates if this contact owns or rents his or her residence. A list of valid values for rent, own, and lease is defined in the lookup OWN_RENT_IND. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

SalesAffinityCode

string

The affinity of a contact to the deploying organization. A list of accepted values are defined in the lookup HZ_SLS_CNTCT_AFFINITY_CODE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.

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. Review and update the values for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.

SalesProfileStatus

string

A valid user defined status of the sales account.

SalesTeamMember

Sales Team Member

The unique alternate identifier of the sales team member.

Salutation

string

The phrase used to address a contact party in any correspondence.

SalutoryIntroduction

string

The title or a salutary introduction for a contact, such as Mr., Herr, and so on. A list of accepted values is defined in the lookup CONTACT_TITLE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

SecondLastName

string

The second last name for a person. A list of accepted values is defined in the lookup HZ_PERSON_PROFILES. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

SourceSystem

string

The source system name where the record originated.

SourceSystemReferenceValue

string

The identifier for the record from an external source system.

State

string

State element of address.

TaxpayerIdentificationNumber

string

The taxpayer identification number, which is often a unique identifier of the contact. These typical values are the taxpayer Id in USA or the fiscal code, or the NIF in Europe.

TimezoneCode

string

Time zone of a contact to know preferred time to call or email.

Title

string

A professional or family title, such as Don or The Right Honorable.

Type

string

The contact party type that defines whether the contact is a sales account, a prospect, a contact or any other user-defined party type. The default value is ZCA_CUSTOMER. A list of accepted values is defined in the lookup ZCA_CONTACT_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

UniqueNameSuffix

string

The system generated or manually overridden suffix. The suffix is used to generate the PartyUniqueName attribute and is concatenated to the ContactName attribute to generate the PartyUniqueName. The primary address is defaulted as the suffix.

UpdateFlag

boolean

This flag controls if the user has access to update the record.

WorkPhoneAreaCode

string

The area code for the contact's work phone.

WorkPhoneCountryCode

string

The international country code for a contact's work phone number, such as 33 for France.

WorkPhoneExtension

string

The additional number addressed after initial connection to an internal telephone system.

WorkPhoneNumber

string

The work phone number formatted in the local format without the area code, country code, or extension.