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 223 details the methods called by the Contact service.
Fields
Table 224 details the required and read-only fields for the contact object.
Table 224. 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 |
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 225 details the status key for the contact object.
Table 225. 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 226 details the pick map fields for the contact object.
Table 226. 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 227 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 227. 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 228 details the picklists available for the contact object.
Table 228. 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 229 details a number of contact object fields that you must not use for customer integrations.
Table 229. 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.
|