JDBC Driver for Oracle Sales Cloud

Build 20.0.7654

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.

Columns

Name Type ReadOnly References Description
TeamMemberId [KEY] Long False

The surrogate primary key for the member of the sales account resource team.

PartyNumber [KEY] String False

Accounts.PartyNumber

AccessLevelCode String False

The access level determines the type of access granted to the resource as well as managers of the organizations. The possible values are contained in the ZCA_ACCESS_LEVEL lookup.

AssignmentTypeCode String False

The code indicating how the resource is assigned to the sales account team. The possible values are contained in the ZCA_ASSIGNMENT_TYPE lookup.

CreatedBy String False

The user who created the record.

CreationDate Datetime False

The date and time the record was created.

EndDateActive Datetime False

Indicates the date on which the association of resource is ended to the sales account.

LastUpdatedBy String False

The date on which the record is last updated.

LastUpdateLogin String False

The user who last updated the record.

LockAssignmentFlag Boolean False

The user login for the user who last updated the record.

MemberFunctionCode String False

The flag indicates automatic territory assignment cannot remove the sales account team resource when this flag is Y'. When a sales account team member is added manually, this flag is defaulted toY'. Otherwise,

ResourceEmailAddress String False

The lookup code indicating a sales account resource's role on the resource team such as Integrator, Executive Sponsor and Technical Account Manager. The code lookup is stored in FND_LOOKUPS.

ResourceId Long False

Unique identifier for the resource

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

Unique identifier for the resource

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 identifier for the sales account.

StartDateActive Datetime False

Indicates the date on which the association of resource is created to the sales account.

UserLastUpdateDate Datetime False

The date and time of the last update from mobile.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654