TDV Adapter for Oracle Sales

Build 22.0.8462

Tables

The adapter models the data in Oracle Sales Cloud into a list of tables that can be queried using standard SQL statements.

Generally, querying Oracle Sales Cloud tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

Oracle Sales Cloud Adapter Tables

Name Description
AccountAddresses The address resource is used to view, create, and update addresses of an account. An address represents the location information of an account.
AccountAddressPurposes The address purpose resource is used to view, create, or modify the address purpose. The address purpose describes the use of an address, such as shipping address or billing address.
AccountNotes The note resource is used to capture comments, information, or instructions for an account.
AccountPrimaryAddresses The primary address resource is used to view, create, and update primary address of an account. A primary address is the default communication address of an account.
AccountRelationships The relationship resource is used to view, create, and update account relationships.
AccountResources The sales team member resource represents a resource party and is assigned to a sales account team. A sales account team member has a defined access role for the sales account.
Accounts The sales team member resource represents a resource party and is assigned to a sales account team. A sales account team member has a defined access role for the sales account.
Activities Table to capture task and appointment information.
ActivityAssignees Table used to capture the assignees/resources associated to the activity.
ActivityContacts Table used to capture the contacts associated to the activity.
ActivityNotes Note data objects that capture comments, information or instructions for an Oracle Fusion Applications business object.
ActivityObjectives Table used to capture the objectives associated to the activity.
ContactAddresses Table that includes attributes used to store values while creating or updating an address. An address represents the location information of an account, contact or household.
ContactAddressPurposes The address purpose resource is used to view, create, or modify the address purpose. The address purpose describes the use of an address, such as shipping address or billing address.
ContactNotes The note resource is used to capture comments, information, or instructions for a contact.
ContactPrimaryAddresses The primary address resource is used to view, create, or modify a primary address of a contact. A primary address is the default communication address of an entity.
ContactRelationships The relationship resource includes attributes that are used to store values while viewing, creating, or updating a relationship.
Contacts Table resource items include attributes used to store values while creating or updating a contact.
ContactSalesAccountResources The sales team member resource represents a resource party and is assigned to a sales account team. A sales account team member has a defined access role for the sales account.
EmployeeResourceAttachments The contact picture attachment resource is used to view, create, and update the resource's picture.Get a resource's picture
EmployeeResources The resources resoure is used to view, create, and update a resource. A resource is a person within the deploying company who can be assigned work to accomplish business objectives, such as sales persons or partner members.
Opportunities The opportunity competitor resource is used to view, create, and update the competitors for an opportunity. The opportunity competitors is used to store information about the competitors associated with the opportunity.
OpportunityCompetitors The opportunity competitor resource is used to view, create, and update the competitors for an opportunity. The opportunity competitors is used to store information about the competitors associated with the opportunity.
OpportunityContacts The opportunity contact resource is used to view, create, and update the contacts of an opportunity.The contact associated with the opportunity. You can specify a contact's role, affinity, and influence level on an opportunity. A single contact can be marked as primary.
OpportunityDeals A deal associated with the opportunity.
OpportunityLeads The opportunity lead resource is used to view, create, and update the lead that resulted in an opportunity.
OpportunityNotes The note resource is used to capture comments, information, or instructions for an opportunity.
OpportunityPartners The opportunity partner resource is used to view, create, and update the partners associated with this opportunity.The opportunity partner is used to store information about partners who are contributing to the selling effort of the current opportunity.
OpportunityRevenueItems The revenue items resource is used to view, create, and update revenue items of an opportunity. The revenue items associated with opportunities are products, services, or other items a customer might be interested in purchasing. You add revenue items by selecting a product group or product to associate with an opportunity.
OpportunityRevenueProductGroups The product group resource is used to view, create, and update the product groups associated with an opportunity. The product group let you categorize products and services that you sell.
OpportunityRevenueProducts The following table describes the default response for this task.
OpportunityRevenueTerritories The opportunity revenue territories resource is used to view, create, and update the revenue territories of an opportunity. The territories assigned to an opportunity revenue line. The territories provide the rules for automatically assigning salespeople and other resources to customers, partners, leads, and opportunity line items.
OpportunitySources The opportunity source resource is used to view, create, and update the source of an opportunity.The opportunity source is used to capture the marketing or sales campaign that resulted in this opportunity.
OpportunityTeamMembers The opportunity team members resource is used to view, create, and update the team members associated with an opportunity. The opportunity team member of the deploying organization associated with the opportunity.
Territories The sales territories resource represents the list of sales territories that the logged-in user can view. A sales territory is an organizational domain with boundaries defined by attributes of customers, products, services, resources, and so on. Sales territories can be created based on multiple criteria including postal code, area code, country, vertical market, size of company, product expertise, and geographical location. Sales territories form the fundamental infrastructure of sales management as they define the jurisdiction that salespeople have over sales accounts, or the jurisdiction that channel sales managers have over partners and partner transactions.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462