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 193 details the methods called by the Account service.
Fields
Table 194 details the required and read-only fields for the account object.
Table 194. 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 |
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 195 details the status key for the account object, and the child component on which this key resides.
Table 195. 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 196 details the pick map fields for the account object and the child objects on which they reside.
Table 196. 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 197 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 197. 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 198 details the picklists available for the account object.
Table 198. 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
|