Oracle Web Services On Demand Guide > Oracle CRM On Demand Objects Accessible Through Web Services > Core Parent Objects (Web Services v1.0) >
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, CustomObject1 - CustomObject3, 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, Service Request, Shared Address, and Team. For information about using attachments with this object, see Using Attachments with Web Services On Demand. Methods Called
Table 208 details the methods called by the Contact service.
Fields
Table 209 details the required and read-only fields for the contact object.
Table 209. Required and Read-Only Fields for the Contact Object
|
|
|
Contact (parent) |
FirstName |
Required |
LastName |
Required |
AlternateAddressId |
Read-only |
ContactConcatField |
Read-only |
ContactFullName |
Read-only |
Audit Fields |
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 |
CODInteractionTime |
Read-only |
CODWrapUpTime |
Read-only |
CODHandleTime |
Read-only |
CODIVRTime |
Read-only |
CODQueueHoldTime |
Read-only |
CODTotalHoldTime |
Read-only |
DescriptionShadow |
Read-only |
Audit Fields |
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 |
Audit Fields |
Read-only |
Book |
BookName |
Required |
BookId |
Read-only |
SystemAssociateFlag |
Read-only |
ModId |
Read-only |
Audit Fields |
Read-only |
Campaign |
CampaignContactId |
Read-only |
Audit Fields |
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 |
Audit Fields |
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 |
Table 210 details the status key for the contact object.
Table 210. Status Key for the Contact Object
|
|
Contact (parent) |
Audit Fields |
AccountId |
ExternalSystemId |
Id |
IntegrationId |
LastUpdated |
Account |
Audit Fields |
Name and Location |
AccountExternalId |
Activity |
Audit Fields |
ActivityExternalId |
ActivityId |
ActivityIntegrationId |
Asset |
Audit Fields |
Attachment |
Audit Fields |
Id |
ContactId |
Book |
Audit Fields |
BookId |
ModId |
Campaign |
Audit Fields |
CampaignContactId |
CampaignExternalSystemId |
CampaignId |
ModId |
ContactNote |
Audit Fields |
ContactId |
ExternalSystemId |
Id |
IntegrationId |
CustomObject3 |
CustomObject3Id |
ContactCustomObject3CreatedById |
ContactCustomObject3CreatedDate |
ContactCustomObject3ModifiedById |
ContactCustomObject3ModifiedDate |
Interests |
Audit Fields |
InterestId |
ExternalSystemId |
Lead |
Audit Fields |
AccountId |
CampaignId |
ContactId |
ExternalSystemId |
IntegrationId |
LeadId |
OpportunityId |
Opportunity |
Audit Fields |
AccountId |
ExternalSystemId |
IntegrationId |
LeadId |
OpportunityId |
RelatedContact |
Audit Fields |
ContactRelationshipId |
RelatedContactId |
Revenue |
Audit Fields |
ExternalId |
IntegrationId |
RevenueId |
ServiceRequest |
Audit Fields |
AccountId |
ContactID |
ExternalSystemId |
IntegrationId |
ServiceRequestId |
SharedAddress |
Audit Fields |
Team |
Audit Fields |
ContactTeamId |
UserExternalSystemId |
UserId |
UserIntegrationId |
Table 211 details the pick map fields for the contact object.
Table 211. Pick Map Fields for the Contact Object
|
|
|
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 |
Table 212 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.
Table 212. Filterable Fields and User Key Fields on the Contact Object's Child Components
|
|
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 |
Table 213 details the picklists available for the contact object.
Table 213. Picklists Available for the Contact Object
|
|
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 |
Table 214 details a number of contact object fields that you must not use for customer integrations.
Table 214. Contact Object Fields That You Must Not Use
|
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.
|