Resource Sales Representative Setup

The information pertaining to a resource who functions as a sales person. For example, sales credit type information used to calculate sales credit in Financials, sales tax geography code and sales tax inside city limits information.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/resources/resourceServiceV2/}ResourceSalesrep

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

Handled by

Sales Person Setup

Attributes

The following table describes attributes in the service data object.

Name Type Description

CreatedBy

string

Who column: indicates the user who created the row.

CreationDate

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

Who column: indicates the date and time of the creation of the row.

EndDateActive

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

Date this salesrep becomes inactive

LastUpdateDate

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

Who column: indicates the date and time of the last update of the row.

LastUpdateLogin

string

Who column: indicates the session login associated to the user who last updated the row.

LastUpdatedBy

string

Who column: indicates the user who last updated the row.

ObjectVersionNumber

int

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 queried.

ResourceId

long

Identifier for the resource party. Foreign key to the HZ_PARTIES.PARTY_ID.

ResourceSalesrepId

long

Unique Salesrep Identifier
  • Primary Key

SalesCreditTypeId

long

Sales Credit Type Identifier ( FK to so_sales_credit_types)

SalesTaxGeocode

string

sales tax geocode ( used by AR)

SalesTaxInsideCityLimits

string

sales Tax inside city limits ( used by AR)

SalesrepNumber

string

Unique number given to salesrep ( used for OTHER type of salesreps)

SetCode

string

Reference data set for the sales person..

SetId

long

Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs.

StartDateActive

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

Date this salesrep becomes active

Status

string

Status of salesrep whether he or she is active in AR or not ( Used for OTHER type of Salesreps)

WhUpdateDate

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

wh update date ( used by AR)