Opportunity Team Member

The employee of the deploying organization who is assisting with the sales opportunity.

QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/}OpportunityResource

Logical Business Objects

  • CRM : Opportunity Management : Opportunity

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contained by

Opportunity

Handled by

Opportunity Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccessLevelCode

string

Access level determines the type of access granted to the opportunity team member, manager, and administrator of the organizations in the hierarchy.

AsgnTerritoryVersionId

long

Version identifier of the territory for the resource that got assigned to the opportunity through territory-based assignment.

AssignmentType

string

Indicates how the resource was added to opportunity team. Ad-Hoc indicates that the resource was either added manually or through rule-based assignment. Territory indicates that the resource was added using territory-based assignment.

ConflictId

long

The attribute value is used to guarantee the uniqueness of the row when duplicates are created in different databases.

CreatedBy

string

The user who created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

DealExpirationDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The end date of the deal protection period of an opportunity team member. The date is set for members of territories that are removed from the opportunity because of territory re-alignment.

DealProtected

string

Indicates whether the resource is under deal protection.

DealProtectedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The start date of the deal protection period of an opportunity team member. The date is set for the members of territories that are removed from opportunity because of territory re-alignment.

EmailAddress

string

The email address associated with the record.

FormattedPhoneNumber

string

The formatted phone number.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated.

LastUpdateLogin

string

The login of the user who last updated the record.

LastUpdatedBy

string

The user who last updated the record.

LockAssignmentFlag

boolean

Flag to prevent an opportunity team member from being removed from the team by automatic assignment.

MemberFunctionCode

string

The role of the team member on the opportunity, such as Integrator, Executive Sponsor, Technical Account Manager, and so on.

MgrResourceId

long

The resource identifier of the opportunity team member's manager.

ObjectVersionNumber

int

The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.

OptyId

long

The unique identifier of the opportunity.

OptyResourceId

long

The identifier of the opportunity team member.
  • Primary Key

OptyResourceNumber

string

Displays the association between an opportunity and a resource (typically an opportunity sales team member).

OrgTreeCode

string

The tree which depicts the organization hierarchy. Managers/Admins of parent resource organizations of the opportunity team member gain access through this hierarchy.

OrgTreeStructureCode

string

The tree structure of the organization hierarchy. Managers/Admins of parent resource organizations of the opportunity team member gain access through this hierarchy.

OrganizationId

long

The resource organization identifier of the opportunity team member.

OrganizationName

string

The name of the party when the party type is Organization.

OwnerFlag

boolean

Indicates if the opportunity team member is also the owner of the opportunity.

PartnerOrgId

long

The party identifier of the partner organization that the partner resource belongs to.

PartnerPartyName

string

The name of the partner organization that the partner resource belongs to.

PartyName

string

The name of the party.

PersonFirstName

string

The first name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Given Name in HL7.

PersonLastName

string

The last name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Family Name in HL7.

ResourceId

long

The unique identifier of the resource.

ResourceOrgId

long

The resource organization identifier of the opportunity team member.

ResourcePartyNumber

string

The resource party number of the opportunity team member.

RoleName

string

Role of the opportunity team member in the resource organization.

TerritoryName

string

The name of the territory of the opportunity team member.

UserLastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date and time when the row was last updated.