TDV Adapter for Oracle Sales

Build 22.0.8462

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.

Columns

Name Type ReadOnly References Description
TeamMemberId [KEY] Long False

This is the primary key of the sales account resources table.

PartyNumber [KEY] String False

Contacts.PartyNumber

AccessLevelCode String False

The type of access granted to the resource as well as managers of the organizations. A list of accepted values is 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.

AssignmentTypeCode String False

The code indicating how the resource is assigned to the sales account team. A list of accepted values is 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 sales team member record.

CreationDate Datetime False

The date and time when the sale team member record was created.

EndDateActive Datetime False

Date on which this sales team member is no longer active.

LastUpdateDate Datetime False

The date when the sales team member record was last updated.

LastUpdatedBy String False

The user who last updated the sales team member record.

LastUpdateLogin String False

The session login associated to the user who last updated the sales team member 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. The default value is False. 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.

ResourceEmailAddress String False

The e-mail address of the resource.

ResourceId Long False

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

ResourceName String False

The name of the sales team member.

ResourceOrgName String False

The name of the organization that the sales team member belongs to.

ResourcePartyNumber String False

The unique public identifier of the resource record.

ResourcePhoneNumber String False

The primary phone number of the sales team member.

ResourceRoleName String False

The roles assigned to the sales team member.

SalesProfileId Long False

The unique identifier of the sales profile of the resource.

StartDateActive Datetime False

Date on which this sales team member becomes active.

UserLastUpdateDate Datetime False

The date and time when the sales team member was last updated from mobile.

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