Oracle Web Services On Demand Guide > Oracle CRM On Demand Objects Accessible Through Web Services > Core Parent Objects (Web Services v1.0) >
Account
The account object stores information about the companies that you do business with and is also used to track partners and competitors. The methods called on the account object require a list (array) of account objects as an input argument. This list of accounts identifies the records on which the operation is to be carried out. Usage
It is important to understand the purpose of the following interfaces in the Account Web Service for accessing contact data related to accounts:
- ListofAccountContact. Use this interface if you need to access or update a unique account-contact relationship, where there is only one record for each related {Account, Contact} pair.
- ListOfContactRole. Use this interface if you need to access or update a unique account-contact-role relationship, where there is only one record for each {Account, Contact, Role} triple. There can be multiple rows for each {Account, Contact} pair (one for each role).
- ListofContact. Use this interface for regular account-contact relationships.
For information about using attachments with this object, see Using Attachments with Web Services On Demand. Parent Objects
Account, CustomObject1 - CustomObject3 Child Components
Activity, Address, Asset, Attachment, Book, Competitor, Contact, CustomObject3, Lead, Multiple Contact Roles, Note, Opportunity, Team, Related Account, Revenue, Service Request, Shared Address, and Team. Methods Called
Table 160 details the methods called by the Account service.
Fields
Table 161 details the required and read-only fields for the account object.
Table 161. Required and Read-Only Fields for the Account Object
|
|
|
Account (parent) |
AccountName |
Required |
AccountConcatField |
Read-only |
Audit Fields |
Read-only |
Activity |
AccountLocation |
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 |
DealerName |
Read-only |
Audit Fields |
Read-only |
Attachment |
DisplayFileName |
Required |
FileNameOrURL |
Required |
FileDate |
Read-only |
FileSize |
Read-only |
AccountId |
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 |
Contact |
Age |
Read-only |
OwnerFullName |
Read-only |
CreatedbyEmailAddress |
Read-only |
ModifiedbyEmailAddress |
Read-only |
LastActivityDate |
Read-only |
FirstNameShadow |
Read-only |
LastNameShadow |
Read-only |
CustomObject3 |
AccountCustomObject3CreatedById |
Read-only |
AccountCustomObject3CreatedDate |
Read-only |
AccountCustomObject3ModifiedById |
Read-only |
AccountCustomObject3ModifiedDate |
Read-only |
CustomObject3Id |
Read-only |
Lead |
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 |
Multiple Contact Roles |
ContactRole |
Required |
ContactId |
Required |
Audit Fields |
Read-only |
Opportunity |
OwnerFullName |
Read-only |
|
PrimaryRevenueExpectedValue |
Read-only |
CreatedbyEmailAddress |
Read-only |
ModifiedbyEmailAddress |
Read-only |
FuriganaAccountName |
Read-only |
NameShadow |
Read-only |
AssignmentStatus |
Read-only |
LastAssignmentCompletionDate |
Read-only |
LastAssignmentSubmissionDate |
Read-only |
RelatedAccount |
AccountRelationshipId |
Read-only |
RelatedAccountId |
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 162 details the status key for the account object, and the child component on which this key resides.
Table 162. Status Key for the Account Object
|
|
Account (parent) |
Audit Fields |
ExternalSystemId |
AccountId |
IntegrationId |
LastUpdated |
AccountNote |
Audit Fields |
ExternalSystemId |
AccountNoteId |
IntegrationId |
AccountTeam |
Audit Fields |
AccountTeamId |
Activity |
Audit Fields |
ExternalSystemId |
ActivityId |
IntegrationId |
Asset |
Audit Fields |
ExternalSystemId |
AssetId |
IntegrationId |
Attachment |
Audit Fields |
Id |
AccountId |
ModId |
Book |
Audit Fields |
BookId |
ModId |
Competitor |
Audit Fields |
AccountCompetitorId |
CompetitorExternalId |
CompetitorId |
CompetitorIntegrationId |
Contact |
Audit Fields |
AccountId |
ContactId |
ExternalSystemId |
IntegrationId |
CustomObject3 |
AccountCustomObject3CreatedById |
AccountCustomObject3CreatedDate |
AccountCustomObject3ModifiedById |
AccountCustomObject3ModifiedDate |
Lead |
Audit Fields |
AccountId |
ContactId |
ExternalSystemId |
IntegrationId |
LeadId |
OpportunityId |
Opportunity |
Audit Fields |
AccountId |
ExternalSystemId |
IntegrationId |
OpportunityId |
RelatedAccount |
Audit Fields |
AccountRelationshipId |
Revenue |
Audit Fields |
ExternalId |
IntegrationId |
RevenueId |
ServiceRequest |
Audit Fields |
AccountId |
ContactId |
ExternalSystemId |
IntegrationId |
ServiceRequestId |
Partner |
Audit Fields |
AccountPartnerId |
PartnerExternalId |
PartnerId |
PartnerIntegrationId |
Updated |
SharedAddress |
Audit Fields |
Table 163 details the pick map fields for the account object and the child objects on which they reside.
Table 163. Pick Map Fields for the Account Object
|
|
|
Account (parent) |
Owner |
OwnerId |
ParentAccount, ParentAccountLocation |
ParentAccountId |
ParentAccountIntegrationId |
ParentAccountId |
ParentAccountExternalSystemId |
ParentAccountId |
Activity |
AccountIntegrationId |
AccountId |
AccountExternalId |
AccountId |
CampaignExternalId |
CampaignId |
CampaignIntegrationId |
CampaignId |
DelegatedBy |
DelegatedById |
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 |
AccountIntegrationId |
AccountId |
Manufacturer |
ManufacturerId |
PreferredServiceDealer |
PreferredServiceDealerID |
Book |
BookName |
BookId |
Competitor |
RelatedAccountExternalId |
RelatedAccountId |
RelatedAccountSystemId |
RelatedAccountId |
Contact |
AccountExternalId |
AccountId |
AccountIntegrationId |
AccountId |
AccountName |
AccountId |
ManagerExternalId |
ManagerId |
ManagerIntegrationId |
ManagerId |
OwnerEmailAddress |
OwnerId |
OwnerExternalId |
OwnerId |
OwnerIntegrationId |
OwnerId |
SourceCampaignName |
SourceCampaignId |
SourceCampaignExternalId |
SourceCampaignId |
TimeZoneName |
TimeZoneId |
CustomObject1Name |
CustomObject1Id |
CustomObject2Name |
CustomObject2Id |
CustomObject3Name |
CustomObject3Id |
CustomObject3 |
Owner |
OwnerId |
Lead |
AccountIntegrationId |
AccountId |
AccountExternalId |
AccountId |
AccountLocation |
AccountId |
AccountName |
AccountId |
CampaignExternalId |
CampaignId |
CampaignIntegrationId |
CampaignId |
CampaignName |
CampaignId |
ContactExternalId |
ContactId |
ContactIntegrationId |
ContactId |
OpportunityIntegrationId |
OpportunityId |
OpportunityExternalId |
OpportunityId |
OwnerExternalId |
OwnerId |
OwnerIntegrationId |
OwnerId |
SalesRepAlias |
SalesRepId |
CustomObject1Name |
CustomObject1Id |
CustomObject2Name |
CustomObject2Id |
CustomObject3Name |
CustomObject3Id |
Multiple Contact Roles |
ContactIntegrationId |
ContactId |
ContactExternalId |
ContactId |
Opportunity |
AccountIntegrationId |
AccountId |
AccountExternalId |
AccountId |
AccountLocation |
AccountId |
Account |
AccountId |
SourceCampaignExternalId |
CampaignId |
SourceCampaign |
CampaignId |
KeyContactExternalId |
KeyContactId |
KeyContactLastName |
KeyContactId |
DealerExternalId |
DealerId |
OwnerAlias |
OwnerId |
CustomObject1Name |
CustomObject1Id |
CustomObject2Name |
CustomObject2Id |
CustomObject3Name |
CustomObject3Id |
Partner |
RelatedAccountExternalId |
RelatedAccountId |
RelatedAccountIntegrationId |
RelatedAccountId |
Related Account |
RelatedAccountExternalId |
RelatedAccountId |
RelatedAccountIntegrationId |
RelatedAccountId |
Revenue |
Product |
ProductId |
ProductExternalId |
ProductId |
ProductIntegrationId |
ProductId |
ProductCategory |
ProductCategoryId |
ProductCategoryExternalId |
ProductCategoryId |
ProductCategoryIntegrationId |
ProductCategoryId |
Service Request |
AccountIntegrationId |
AccountId |
AccountExternalId |
AccountId |
AccountLocation |
AccountId |
Account |
AccountId |
AssetExternalId |
AssetId |
Dealer |
DealerId |
ContactExternalId |
ContactId |
ContactIntegrationId |
ContactId |
|
DealerExternalId |
DealerId |
OwnerExternalId |
OwnerId |
OwnerIntegrationId |
OwnerId |
OwnerAlias |
OwnerId |
Product |
ProductId |
CustomObject1Name |
CustomObject1Id |
CustomObject2Name |
CustomObject2Id |
CustomObject3Name |
CustomObject3Id |
Table 164 provides a list of the filterable fields for the child components of the account objects, and a list of the user key combinations for each child component.
Table 164. Filterable Fields and User Key Fields on the Account Object's Child Components
|
|
User Key Field Combinations |
Account (parent) |
All |
AccountId |
IntegrationId |
ExternalSystemId |
AccountName and Location |
Account Note |
Subject |
Subject and Description |
IntegrationId |
ExternalSystemId |
Account Team |
FirstName |
FirstName and Last Name |
LastName |
UserID |
UserID |
UserRole |
AccountAccess |
OpportunityAccess |
ContactAccess |
ModifiedDate |
ModifiedByID |
Activity |
CallType |
IntegrationId |
ActivityId |
ExternalSystemId |
Address |
AddressId |
AddressId |
ExternalId |
ExternalSystemId |
IntegrationId |
IntegrationId |
City |
Country |
ModifiedDate |
Province |
StateProvince |
ZipCode |
Asset |
AssetId |
AssetId |
Contract |
IntegrationId |
Date |
ExternalSystemId |
ModifiedDate |
PartNumber |
ProductCategory |
Product |
ProjectManager |
PurchaseDate |
Price |
Quantity |
SalesRep |
SerialNumber |
ShipDate |
Status |
Type |
Warranty |
Attachment |
None |
Id |
ExternalSystemId |
FileNameOrURL and FileExtension |
Book |
None |
BookId |
BookName |
Contact |
AccountContactModifiedById |
ExternalSystemId |
AccountContactModifiedDate |
IntegrationId |
ContactType |
ContactFirstName |
ContactLastName |
JobTitle |
Owner |
Competitor |
ModifiedDate |
CompetitorId |
IntegrationId |
CompetitorExternalSystemId |
CustomObject3 |
AccountCustomObject3ModifiedById |
CustomObject3Id |
AccountCustomObject3ModifiedDate |
ExternalSystemId |
CustomObject3Id |
IntegrationId |
CustomObject3Name |
ExternalSystemId |
IntegrationId |
Type |
Lead |
Campaign |
Id |
EstimatedCloseDate |
LeadId |
Rating |
IntegrationId |
Source |
ExternalSystemId |
Status |
LeadOwner |
PotentialRevenue |
ProductInterest |
SalesPerson |
LeadId |
Id |
Multiple Contact Roles |
ContactId |
ContactId |
ContactExternalId |
ContactIntegrationId |
ContactIntegrationId |
ContactExternalId |
ContactRole |
ModifiedDate |
Opportunity |
Owner |
OpportunityId |
Revenue |
Id |
CloseDate |
IntegrationId |
Forecast |
ExternalSystemId |
ExpectedRevenue |
Probability |
Priority |
ReasonWonLost |
Status |
OpportunityId |
Id |
Partner |
AccountPartnerId |
PartnerIntegrationId |
PrimaryContactId |
PartnerExternalSystemId |
EndDate |
PartnerId |
PartnerExternalSystemId |
ReverseRelationshipRole |
RelationshipRole |
StartDate |
ModifiedDate |
Related Account |
AccountRelationshipId |
AccountRelationshipId |
Comments |
RelatedAccountId |
EndDate |
RelatedAccountExternalId |
ModifiedDate |
RelatedAccountIntegrationId |
RelatedAccountExternalId |
RelatedAccountId |
RelatedAccountIntegrationId |
RelationshipRole |
RelationshipStatus |
RelationshipType |
ReverseRelationshipRole |
StartDate |
Revenue |
ContactFullName |
RevenueId |
Description |
ProductId |
ExternalId |
ProductExternalId |
IntegrationId |
ProductIntegrationId |
Forecast |
IntegrationId |
Frequency |
ExternalSystemId |
ModifiedDate |
NumberOfPeriods |
Product |
ProductCategoryId |
ProductCategoryExternalId |
ProductCategoryIntegrationId |
ProductExternalId |
ProductId |
ProductIntegrationId |
PurchasePrice |
Quantity |
Revenue |
RevenueId |
StartCloseDate |
Status |
Type |
Service Request |
Subject |
Id |
Area |
ServiceRequestId |
Owner |
IntegrationId |
Priority |
ExternalSystemId |
Type |
Cause |
Source |
Status |
Id |
ServiceRequestId |
Shared Address |
None |
AddressId |
AddressExternalSystemId |
Table 165 details the picklists available for the account object.
Table 165. Picklists Available for the Account Object
|
|
Account (parent) |
AccountType |
Priority |
Region |
CallFrequency |
InfluenceType |
Route |
Status |
MarketPotential |
MarketingSegment |
Account Team |
TeamRole |
Competitor |
Role |
Multiple Contact Roles |
ContactRole |
Partner |
Role |
RelatedAccount |
Relationship |
Status |
Revenue |
Type |
Status |
Frequency |
SharedAddress |
AddressType |
CurrencyCode |
For more information on the fields accessible through the Account Web service, go to the Web Services Administration page within the Oracle CRM On Demand application, and generate the WSDL file for the account object. Related Topic
Contact
|