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, Custom Object1 - Custom Object3
Child Components
Activity, Address, Asset, Attachment, Book, Competitor, Contact, CustomObject3, Lead, Multiple Contact Roles, Note, Opportunity, Team, Related Account, Revenue, Order Item, Shared Address, and Team.
Methods Called
The following table details the methods called by the Account service.
Method | Name as Defined in Service |
---|---|
AccountDelete |
|
AccountDeleteChild |
|
AccountInsert |
|
AccountInsertChild |
|
AccountInsertOrUpdate |
|
AccountQueryPage |
|
AccountUpdate |
|
AccountUpdateChild |
Fields
The following table details the required and read-only fields for the account object.
Child Component | Field Name | Type |
---|---|---|
Account (parent) |
AccountName |
Required |
AccountConcatField |
Read-only |
|
Read-only |
||
Activity |
AccountLocation |
Read-only |
CreatedDetail |
Read-only |
|
MEEventName |
Read-only |
|
CreatedbyEmailAddress |
Read-only |
|
ModifiedbyEmailAddress |
Read-only |
|
DealerName |
Read-only |
|
Read-only |
||
Attachment |
DisplayFileName |
Required |
FileNameOrURL |
Required |
|
FileDate |
Read-only |
|
FileSize |
Read-only |
|
AccountId |
Read-only |
|
Id |
Read-only |
|
ModId |
Read-only |
|
Read-only |
||
Book |
BookName |
Required |
BookId |
Read-only |
|
SystemAssociateFlag |
Read-only |
|
ModId |
Read-only |
|
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 |
|
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 |
|
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 |
The following table details the status key for the account object, and the child component on which this key resides.
Child Component | Field Name |
---|---|
Account (parent) |
|
ExternalSystemId |
|
AccountId |
|
IntegrationId |
|
LastUpdated |
|
AccountNote |
|
ExternalSystemId |
|
AccountNoteId |
|
IntegrationId |
|
AccountTeam |
|
AccountTeamId |
|
Activity |
|
ExternalSystemId |
|
ActivityId |
|
IntegrationId |
|
Asset |
|
ExternalSystemId |
|
AssetId |
|
IntegrationId |
|
Attachment |
|
Id |
|
AccountId |
|
ModId |
|
Book |
|
BookId |
|
ModId |
|
Competitor |
|
AccountCompetitorId |
|
CompetitorExternalId |
|
CompetitorId |
|
CompetitorIntegrationId |
|
Contact |
|
AccountId |
|
ContactId |
|
ExternalSystemId |
|
IntegrationId |
|
CustomObject3 |
AccountCustomObject3CreatedById |
AccountCustomObject3CreatedDate |
|
AccountCustomObject3ModifiedById |
|
AccountCustomObject3ModifiedDate |
|
Lead |
|
AccountId |
|
ContactId |
|
ExternalSystemId |
|
IntegrationId |
|
LeadId |
|
OpportunityId |
|
Opportunity |
|
AccountId |
|
ExternalSystemId |
|
IntegrationId |
|
OpportunityId |
|
RelatedAccount |
|
AccountRelationshipId |
|
Revenue |
|
ExternalId |
|
IntegrationId |
|
RevenueId |
|
ServiceRequest |
|
AccountId |
|
ContactId |
|
ExternalSystemId |
|
IntegrationId |
|
ServiceRequestId |
|
Partner |
|
AccountPartnerId |
|
PartnerExternalId |
|
PartnerId |
|
PartnerIntegrationId |
|
Updated |
|
SharedAddress |
The following table details the pick map fields for the account object and the child objects on which they reside.
Child Component | Pick Map Field | Maps To |
---|---|---|
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 |
The following table 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.
Child Components | Filterable Fields | 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 |
The following table details the picklists available for the account object.
Child Component | Field Name |
---|---|
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.