CData Python Connector for Oracle Sales

Build 20.0.7745

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.

Columns

Name Type ReadOnly References Description
OptyResourceId [KEY] Long False

This is the primary key of the opportunity team members table.

OptyNumber [KEY] String False

Opportunities.OptyNumber

AccessLevelCode String False

The type of access granted to the resource as well as managers of the organizations. A list of accepted values are defined in the lookup ZCA_ACCESS_LEVEL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

AsgnTerritoryVersionId Long False

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

AssignmentType String False

The code indicating how the resource is assigned to the sales account team. A list of accepted values are defined in the lookup ZCA_ASSIGNMENT_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

CreatedBy String False

The user who created the opportunity resource record.

CreationDate Datetime False

The date and time when the resource record was created.

DealExpirationDate Datetime False

The date on which the deal protection period of an opportunity team member ends. The date is updated for territory members when they are unassigned from a opportunity because of a territory realingment.

DealProtected String False

Indicates if the resource is under deal protection. If the value is True, then the resource is under deal protection. The default value is False.

DealProtectedDate Datetime False

The date on which the deal protection period of an opportunity team member starts. The date is updated for territory members when they are unassigned from a opportunity because of a territory realingment.

EmailAddress String False

The e-mail address of the opportunity team member.

FormattedPhoneNumber String False

The formatted phone number of the opportunity team member.

LastUpdateDate Datetime False

The date when the record was last updated.

LastUpdatedBy String False

The user who last updated the record.

LastUpdateLogin String False

The session login associated to the user who last updated the record.

LockAssignmentFlag Boolean False

Indicates if the automatic territory assignment can be set. If the value is True, then the automatic territory assignment cannot remove the sales account team resource. When a sales account team member is added manually, this flag is defaulted to `Y'.

MemberFunctionCode String False

The code indicating the role of a sales team member in the resource team such as Integrator, Executive Sponsor, and Technical Account Manager. A list of accepted values is defined in the lookup FND_LOOKUPS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.

MgrResourceId Long False

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

OptyId Long False

The unique Identifier of the opportunity.

OptyResourceNumber String False

The label that represents the association between the opportunity and resource.

OwnerFlag Boolean False

Indicates if the opportunity team member is the owner of the opportunity. If the value is True, then the opportunity team member is also the owner fo the opportunity. The default value is False.

PartnerOrgId Long False

The unique identifier of the partner organization.

PartnerPartyName String False

The name of the partner associated with the partner resource.

PartyName String False

The name of the opportunity team member.

PersonFirstName String False

The first name of the opportunity team member.

PersonLastName String False

The last name of the opportunity team member.

ResourceId Long False

The unique party identifier for the existing resource record in Oracle Sales.

RoleName String False

The role of the opportunity team member in the resource organization.

TerritoryName String False

The name of the opportunity team member's territory.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
RecordSet String

Input specifying the resource type.

Finder String

Input specifying the Finder type.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7745