|
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 190 details the methods called by the Contact service.
Fields
Table 191 details the required and read-only fields for the contact object.
Table 191. 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 192 details the status key for the contact object.
Table 192. 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 193 details the pick map fields for the contact object.
Table 193. 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 194 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 194. 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 195 details the picklists available for the contact object.
Table 195. 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 196 details a number of contact object fields that you must not use for customer integrations.
Table 196. 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.
| 
