Sales Account Resource

An object representing a resource party that is assigned to a sales account team and has a defined access role for the sales account.

QName: {http://xmlns.oracle.com/apps/crmCommon/salesParties/salesPartiesService/}SalesAccountResource

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

Sales Party

Contained by

Sales Account

Handled by

Sales Account Service

Handled by

Sales Party

Handled by

Sales Account Resource Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccessLevelCode

string

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.

AccountDirectorId

long

The party identifier for the resource designated as the sales account owner.

AssignmentTypeCode

string

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

Attribute1

string

The segment of the user descriptive flex field.

Attribute10

string

The segment of the user descriptive flex field.

Attribute11

string

The segment of the user descriptive flex field.

Attribute12

string

The segment of the user descriptive flex field.

Attribute13

string

The segment of the user descriptive flex field.

Attribute14

string

The segment of the user descriptive flex field.

Attribute15

string

The segment of the user descriptive flex field.

Attribute2

string

The segment of the user descriptive flex field.

Attribute3

string

The segment of the user descriptive flex field.

Attribute4

string

The segment of the user descriptive flex field.

Attribute5

string

The segment of the user descriptive flex field.

Attribute6

string

The segment of the user descriptive flex field.

Attribute7

string

The segment of the user descriptive flex field.

Attribute8

string

The segment of the user descriptive flex field.

Attribute9

string

The segment of the user descriptive flex field.

AttributeCategory

string

The structure definition of the user descriptive flex field.

AttributeDate1

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

The segment of the user descriptive flex field.

AttributeDate2

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

The segment of the user descriptive flex field.

AttributeDate3

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

The segment of the user descriptive flex field.

AttributeDate4

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

The segment of the user descriptive flex field.

AttributeDate5

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

The segment of the user descriptive flex field.

AttributeNumber1

decimal

The segment of the user descriptive flex field.

AttributeNumber2

decimal

The segment of the user descriptive flex field.

AttributeNumber3

decimal

The segment of the user descriptive flex field.

AttributeNumber4

decimal

The segment of the user descriptive flex field.

AttributeNumber5

decimal

The segment of the user descriptive flex field.

CpdrfLastUpd

string

The standard replication column.

CpdrfVerPillar

int

The standard replication column.

CpdrfVerSor

int

The standard replication column.

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.

EffectiveEndDate

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

The date at the end of the date range within which the row is effective.

EffectiveStartDate

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

The date at the beginning of the date range within which the row is effective.

EmailAddress

string

The email address associated with the record.

EndDateActive

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

The date after which the record becomes inactive.

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.

LockAssignmentBooleanFlag

boolean

Indicates whether the sales account resource is enabled for locked assignment, which means the sales account resource cannot be removed from the team at future territory assignments.

LockAssignmentFlag

boolean

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 to `Y'.

ManagerPartyId

long

The party identifier for the manager.

MemberFunctionCode

string

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.

Name

string

The name of the organization for the resource.

Name1

string

The name of the territory.

NamedAccountFlag

boolean

The indicator for whether a sales account is a named sales account.

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.

ObjectVersionNumber1

int

The attribute is used to implement optimistic 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 detect whether another session has updated the row since it was last queried.

ObjectVersionNumber2

int

The number to implement optimistic 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 detect whether another session has updated the row since it was queried.

OrgTreeCode

string

The code for the organization hierarchy tree. Managers and administrators of sales account resource gain access through this hierarchy.

OrgTreeStructureCode

string

The structure code for the organization hierarchy tree. Managers/Administrators of parent member organizations will gain access through this hierarchy.

OrganizationId

long

The identifier for the organization the sales account resource belongs.

OwnerResourceId

long

The identifier for the sales account owner.

PartyName

string

The name of the party.

PartyName1

string

The party name of the manager.

PrTerritoryId

long

The territory the sales account team resource belongs to.

ReportsToFlag

boolean

The indicator showing a resource reports to another resource in the same account team.

ResourceId

long

The unique identifier of the resource.

ResourceOrgId

long

The resource organization identifier.

ResourcePartyId

long

The party identifier for the resource.

ResourcePrimaryOrgId

long

The resource primary organization identifier.

ResourcePrimaryOrgName

string

The resource primary organization name.

RoleName

string

The list of all roles for the resources in the organization.

SAccountResourceId

long

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

SalesAccountId

long

The identifier for the sales account.

SalesAccountPartyId

long

The unique identifier for the sales account.

StartDateActive

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

The date on which the record becomes active.

TerritoryVersionId

long

The territory version is a primary key.

TypeCode

string

The type code for the territory of which the resource is member of.

UserLastUpdateDate

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

The date and time when the row was last updated.