Contact
The contact object stores information on individuals with whom your organization has a relationship. It allows the user to store information on individuals who are external to your company, but who are associated with the business process. Contacts stored in the Oracle CRM On Demand database can also be associated with an account.
Parent Objects
Account, Activity, Campaign, Custom Object1 - Custom Object3, Household, Opportunity, Product Category, and Life Sciences Edition Parent Objects (Web Services v1.0)
Child Components
Account, Activity, Address, Asset, Attachment, Book, Campaign, CustomObject3, Interests, Lead, Note, Opportunity, Related Contact, Revenue, Order Item, Shared Address, and Team.
For information about using attachments with this object, see Using Attachments with Web Services On Demand.
Methods Called
The following table details the methods called by the Contact service.
Method | Name as Defined in Service |
---|---|
ContactDelete |
|
ContactDeleteChild |
|
ContactInsert |
|
ContactInsertChild |
|
ContactInsertOrUpdate |
|
ContactQueryPage |
|
ContactUpdate |
|
ContactUpdateChild |
Fields
The following table details the required and read-only fields for the contact object.
Child Component | Field Name | Type |
---|---|---|
Contact (parent) |
FirstName |
Required |
LastName |
Required |
|
AlternateAddressId |
Read-only |
|
ContactConcatField |
Read-only |
|
ContactFullName |
Read-only |
|
Read-only |
||
Manager |
Read-only |
|
PrimaryAddressId |
Read-only |
|
Account |
AccountId |
Read-only |
AccountLocation |
Read-only |
|
Activity |
Contact |
Read-only |
CreatedDetail |
Read-only |
|
MEEventName |
Read-only |
|
CreatedbyEmailAddress |
Read-only |
|
ModifiedbyEmailAddress |
Read-only |
|
DescriptionShadow |
Read-only |
|
Read-only |
||
Address |
AddressId |
Read-only |
Asset |
AssetId |
Required |
ContactAssetId |
Read-only |
|
ExternalSystemId |
Read-only |
|
Product |
Read-only |
|
ProductId |
Read-only |
|
ProductPartNumber |
Read-only |
|
ProductType |
Read-only |
|
ProductStatus |
Read-only |
|
CreatedByandDate |
Read-only |
|
ModifiedByandDate |
Read-only |
|
SerialNumber |
Read-only |
|
Attachment |
DisplayFileName |
Required |
FileNameOrURL |
Required |
|
FileDate |
Read-only |
|
FileSize |
Read-only |
|
ContactId |
Read-only |
|
Id |
Read-only |
|
ModId |
Read-only |
|
Read-only |
||
Book |
BookName |
Required |
BookId |
Read-only |
|
SystemAssociateFlag |
Read-only |
|
ModId |
Read-only |
|
Read-only |
||
Campaign |
CampaignContactId |
Read-only |
Read-only |
||
Contact Team |
ContactTeamId |
Read-only |
UserFirstName |
Read-only |
|
UserLastName |
Read-only |
|
UserRole |
Read-only |
|
CustomObject3 |
ContactCustomObject3CreatedById |
Read-only |
ContactCustomObject3CreatedDate |
Read-only |
|
ContactCustomObject3ModifiedById |
Read-only |
|
ContactCustomObject3ModifiedDate |
Read-only |
|
CustomObject3Id |
Read-only |
|
Interests |
Category |
Required |
Interests |
Required |
|
InterestId |
Read-only |
|
Lead |
ContactIntegrationId |
Read-only |
ContactExternalId |
Read-only |
|
OwnerFullName |
Read-only |
|
SalesRepFullName |
Read-only |
|
CreatedbyEmailAddress |
Read-only |
|
ModifiedbyEmailAddress |
Read-only |
|
ReferredByFullName |
Read-only |
|
FuriganaAccountName |
Read-only |
|
FuriganaContactFirstName |
Read-only |
|
FuriganaContactLastName |
Read-only |
|
FirstNameShadow |
Read-only |
|
LastNameShadow |
Read-only |
|
CompanyNameShadow |
Read-only |
|
AssignmentStatus |
Read-only |
|
LastAssignmentCompletionDate |
Read-only |
|
LastAssignmentSubmissionDate |
Read-only |
|
Opportunity |
OwnerFullName |
Read-only |
PrimaryRevenueExpectedValue |
Read-only |
|
CreatedbyEmailAddress |
Read-only |
|
ModifiedbyEmailAddress |
Read-only |
|
FuriganaAccountName |
Read-only |
|
ReassignOwnerFlag |
Read-only |
|
NameShadow |
Read-only |
|
AssignmentStatus |
Read-only |
|
LastAssignmentCompletionDate |
Read-only |
|
LastAssignmentSubmissionDate |
Read-only |
|
Related Contact |
ContactRelationshipId |
Read-only |
ContactId |
Read-only |
|
RelatedContactFirstName |
Read-only |
|
RelatedContactLastName |
Read-only |
|
Revenue |
RevenueId |
Required |
PartNumber |
Required |
|
Revenue |
Required |
|
ContactFullName |
Required |
|
Read-only |
||
ServiceRequest |
Name |
Read-only |
OwnerFullName |
Read-only |
|
CreatedbyEmailAddress |
Read-only |
|
ModifiedbyEmailAddress |
Read-only |
|
LastAssessmentDate |
Read-only |
|
AssignmentStatus |
Read-only |
|
FuriganaAccountName |
Read-only |
|
FuriganaContactFirstName |
Read-only |
|
FuriganaContactLastName |
Read-only |
|
SRNumberShadow |
Read-only |
|
AbstractShadow |
Read-only |
|
LastAssignmentCompletionDate |
Read-only |
|
LastAssignmentSubmissionDate |
Read-only |
|
SharedAddress |
All fields |
Read-only |
The following table details the status key for the contact object.
Child Component | Field Name |
---|---|
Contact (parent) |
|
AccountId |
|
ExternalSystemId |
|
Id |
|
IntegrationId |
|
LastUpdated |
|
Account |
|
Name and Location |
|
AccountExternalId |
|
Activity |
|
ActivityExternalId |
|
ActivityId |
|
ActivityIntegrationId |
|
Asset |
|
Attachment |
|
Id |
|
ContactId |
|
Book |
|
BookId |
|
ModId |
|
Campaign |
|
CampaignContactId |
|
CampaignExternalSystemId |
|
CampaignId |
|
ModId |
|
ContactNote |
|
ContactId |
|
ExternalSystemId |
|
Id |
|
IntegrationId |
|
CustomObject3 |
CustomObject3Id |
ContactCustomObject3CreatedById |
|
ContactCustomObject3CreatedDate |
|
ContactCustomObject3ModifiedById |
|
ContactCustomObject3ModifiedDate |
|
Interests |
|
InterestId |
|
ExternalSystemId |
|
Lead |
|
AccountId |
|
CampaignId |
|
ContactId |
|
ExternalSystemId |
|
IntegrationId |
|
LeadId |
|
OpportunityId |
|
Opportunity |
|
AccountId |
|
ExternalSystemId |
|
IntegrationId |
|
LeadId |
|
OpportunityId |
|
RelatedContact |
|
ContactRelationshipId |
|
RelatedContactId |
|
Revenue |
|
ExternalId |
|
IntegrationId |
|
RevenueId |
|
ServiceRequest |
|
AccountId |
|
ContactID |
|
ExternalSystemId |
|
IntegrationId |
|
ServiceRequestId |
|
SharedAddress |
|
Team |
|
ContactTeamId |
|
UserExternalSystemId |
|
UserId |
|
UserIntegrationId |
The following table details the pick map fields for the contact object.
Child Component | Pick Map Field | Maps To |
---|---|---|
Contact (parent) |
AccountName |
AccountId |
Owner |
AssignedToAlias |
|
SourceCampaignName |
SourceCampaignId |
|
ManagerExternalSystemId |
ManagerId |
|
Account |
AccountExternalId |
AccountId |
Activity |
AccountIntegrationId |
AccountId |
AccountExternalId |
AccountId |
|
AssignedTo |
AssignedToId |
|
CampaignExternalId |
CampaignId |
|
CampaignIntegrationId |
CampaignId |
|
DelegatedBy |
DelegatedById |
|
Dealer |
DealerId |
|
FundRequest |
FundRequestId |
|
OpportunityIntegrationId |
OpportunityId |
|
OpportunityExternalId |
OpportunityId |
|
PrimaryContactIntegrationId |
PrimaryContactId |
|
PrimaryContactExternalId |
PrimaryContactId |
|
LeadIntegrationId |
LeadId |
|
LeadExternalId |
LeadId |
|
OwnerExternalId |
OwnerId |
|
OwnerIntegrationId |
OwnerId |
|
SRIntegrationId |
SRId |
|
SRExternalId |
SRId |
|
CustomObject1Name |
CustomObject1Id |
|
CustomObject2Name |
CustomObject2Id |
|
CustomObject3Name |
CustomObject3Id |
|
Asset |
ExternalSystemId |
AssetId |
IntegrationId |
AssetId |
|
AccountIntegrationId |
AccountId |
|
AccountExternalId |
AccountId |
|
AccountLocation |
AccountId |
|
AccountName |
AccountId |
|
CustomerContactExternalSystemId |
ContactId |
|
Manufacturer |
ManufacturerId |
|
ProductExternalSystemId |
ProductId |
|
ProductPrimaryProductLine |
ProductPrimaryProductLineId |
|
PreferredServiceDealer |
PreferredServiceDealerId |
|
Book |
BookName |
BookId |
Campaign |
CampaignExternalSystemId |
CampaignId |
CampaignName |
CampaignId |
|
Contact Team |
UserExternalSystemId |
UserId |
UserIntegrationId |
UserId |
|
CustomObject3 |
Owner |
OwnerId |
Interests |
InterestExternalSystemId |
InterestId |
Lead |
AccountIntegrationId |
AccountId |
AccountLocation |
AccountId |
|
CampaignExternalId |
CampaignId |
|
CampaignIntegrationId |
CampaignId |
|
CampaignName |
CampaignId |
|
OpportunityIntegrationId |
OpportunityId |
|
OpportunityExternalId |
OpportunityId |
|
OwnerExternalId |
OwnerId |
|
OwnerIntegrationId |
OwnerId |
|
SalesRepAliasId |
SalesRepId |
|
CustomObject1Name |
CustomObject1Id |
|
CustomObject2Name |
CustomObject2Id |
|
CustomObject3Name |
CustomObject3Id |
|
Opportunity |
AccountIntegrationId |
AccountId |
AccountExternalId |
AccountId |
|
AccountLocation |
AccountId |
|
Account |
AccountId |
|
SourceCampaignExternalId |
CampaignId |
|
SourceCampaign |
CampaignId |
|
KeyContactExternalId |
KeyContactId |
|
KeyContactLastName |
KeyContactId |
|
DealerExternalId |
DealerId |
|
OwnerAlias |
OwnerId |
|
SalesStage |
SalesStageId |
|
Territory |
TerritoryId |
|
CustomObject1Name |
CustomObject1Id |
|
CustomObject2Name |
CustomObject2Id |
|
CustomObject3Name |
CustomObject3Id |
|
Related Contact |
RelatedContactExternalId |
RelatedContactId |
RelatedContactIntegrationId |
RelatedContactId |
|
Revenue |
Product |
ProductId |
ProductExternalId |
ProductId |
|
ProductIntegrationId |
ProductId |
|
ProductCategory |
ProductCategoryId |
|
ProductCategoryExternalId |
ProductCategoryId |
|
ProductCategoryIntegrationId |
ProductCategory |
|
Service Request |
AccountIntegrationId |
AccountId |
AccountExternalId |
AccountId |
|
AccountLocation |
AccountId |
|
Account |
AccountId |
|
AssetExternalId |
AssetId |
|
Dealer |
DealerId |
|
ContactExternalId |
ContactId |
|
ContactIntegrationId |
ContactId |
|
OwnerExternalId |
OwnerId |
|
OwnerIntegrationId |
OwnerId |
|
OwnerAlias |
OwnerId |
|
Product |
ProductId |
|
CustomObject1Name |
CustomObject1Id |
|
CustomObject2Name |
CustomObject2Id |
|
CustomObject3Name |
CustomObject3Id |
The following table provides a list of the filterable fields for the child components of the contact objects, and a list of user key combinations for each child component.
Child Components | Filterable Fields | User Key Field Combinations |
---|---|---|
Contact (parent) |
All |
ContactId |
IntegrationId |
||
ExternalSystemId |
||
Account |
AccountId |
AccountId |
AccountExternalId |
AccountExternalId |
|
Location |
Name and Location |
|
Name |
||
Activity |
CallType |
IntegrationId |
ActivityID |
||
ExternalSystemId |
||
Address |
ExternalId |
AddressID |
IntegrationId |
ExternalSystemId |
|
City |
IntegrationId |
|
Country |
||
ZipCode |
||
StateProvince |
||
Province |
||
Asset |
AssetId |
AssetId |
ExternalSystemId |
ExternalSystemId |
|
IntegrationId |
IntegrationId |
|
ProductId |
||
SerialNumber |
||
Attachment |
None |
Id |
ExternalSystemId |
||
FileNameOrURL and FileExtension |
||
Book |
None |
BookId |
BookName |
||
Campaign |
CampaignContactId |
CampaignContactId |
CampaignId |
CampaignId |
|
CampaignExternalSystemId |
CampaignExternalSystemId |
|
CampaignName |
CampaignName |
|
DeliveryStatus |
||
ResponseStatus |
||
ModifiedDate |
||
Contact Note |
Subject |
Subject and Description |
IntegrationId |
||
ExternalSystemId |
||
Contact Team |
ContactTeamId |
UserId |
UserId |
UserIntegrationId |
|
UserExternalSystemId |
UserExternalSystemId |
|
UserIntegrationId |
||
UserFirstName |
||
UserLastName |
||
ContactAccess |
||
UserRole |
||
CustomObject3 |
ContactCustomObject3ModifiedById |
CustomObject3Id |
ContactCustomObject3ModifiedDate |
ExternalSystemId |
|
CustomObject3Id |
IntegrationId |
|
CustomObject3Name |
||
ExternalSystemId |
||
IntegrationId |
||
Type |
||
Interests |
InterestId |
ExternalSystemId |
Category |
InterestId |
|
Interests |
||
Lead |
Campaign |
IntegrationId |
EstimatedCloseDate |
ExternalSystemId |
|
Rating |
LeadId |
|
Source |
||
Status |
||
LeadOwner |
||
PotentialRevenue |
||
ProductInterest |
||
SalesPerson |
||
LeadId |
||
OpportunityId |
||
Opportunity |
Opportunity |
IntegrationId |
OpportunityId |
ExternalSystemId |
|
Owner |
OpportunityId |
|
Revenue |
||
CloseDate |
||
Forecast |
||
ExpectedRevenue |
||
Probability |
||
Priority |
||
ReasonWonLost |
||
SalesStage |
||
Status |
||
Account |
||
Personal Address |
PersonalAddressIntegrationId |
ExternalSystemId |
PersonalAddressName |
||
AlternateCity |
||
AlternateCountry |
||
AlternateZipCode |
||
AlternateStateProvince |
||
AlternateAddress |
||
AlternateAddress2 |
||
AlternateAddress3 |
||
Id |
||
IntegrationId |
||
AddressName |
||
City |
||
Country |
||
ZipCode |
||
StateProvince |
||
Address |
||
ShippingAddress2 |
||
Related Contact |
ContactRelationshipId |
IntegrationId |
RelatedContactId |
RelatedContactExternalId |
|
RelatedContactExternalId |
||
RelatedContactIntegrationId |
||
RelationshipStatus |
||
RelationshipType |
||
StartDate |
||
EndDate |
||
Description |
||
RelationshipRole |
||
ReverseRelationshipRole |
||
Revenue |
ContactFullName |
RevenueId |
Description |
ExternalId |
|
ExternalId |
IntegrationId |
|
Forecast |
ExternalSystemId |
|
Frequency |
||
IntegrationId |
||
ModifiedDate |
||
NumberOfPeriods |
||
Product |
||
ProductId |
||
ProductCategoryId |
||
ProductCategory |
||
ProductCategoryExternalId |
||
ProductCategoryIntegrationId |
||
ProductExternalId |
||
ProductIntegrationId |
||
PurchasePrice |
||
Quantity |
||
Revenue |
||
RevenueId |
||
Status |
||
StartCloseDate |
||
Type |
||
Service Request |
Subject |
SRNumber |
Area |
IntegrationId |
|
Owner |
ExternalSystemId |
|
Priority |
||
Type |
||
Cause |
||
Source |
||
Status |
||
ServiceRequestId |
||
Shared Address |
None |
AddressId |
AddressExternalSystemId |
The following table details the picklists available for the contact object.
Child Component | Field Name |
---|---|
Contact (parent) |
ContactType |
LeadSource |
|
MrMrs |
|
BestTimeToCall |
|
CallFrequency |
|
CurrentInvestmentMix |
|
Degree |
|
ExperienceLevel |
|
Gender |
|
InvestmentHorizon |
|
LifeEvent |
|
MaritalStatus |
|
MarketPotential |
|
Objective |
|
OwnOrRent |
|
PrimaryGoal |
|
RiskProfile |
|
Route |
|
Segment |
|
Tier |
|
Account |
Call Frequency |
Route |
|
Status |
|
Type |
|
Contact Team |
TeamRole |
Interests |
Category |
Subjects |
|
Related Contact |
Relationship |
Status |
|
Revenue |
Type |
Status |
|
Frequency |
|
SharedAddress |
AddressType |
CurrencyCode |
The following table details a number of contact object fields that you must not use for customer integrations.
Field Name |
---|
PartyTypeCode |
PartyUId |
PersonUId |
For more information on the fields accessible through the Contact Web service, go to the Web Services Administration page within the Oracle CRM On Demand application, and generate the WSDL file for the contact object.