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/resourceService/}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

The user who created the record.

CreationDate

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

The date when the record was created.

EndDateActive

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

The date after which the record becomes inactive.

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.

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.

ResourceId

long

The unique identifier of the resource.

ResourceSalesrepId

long

The unique sales representative identifier.
  • Primary Key

SalesCreditTypeId

long

The sales credit type identifier ( FK to so_sales_credit_types).

SalesTaxGeocode

string

The sales tax geocode ( used by AR).

SalesTaxInsideCityLimits

string

The sales tax inside city limits ( used by AR).

SalesrepNumber

string

The unique number given to the sales representatives ( used for OTHER type of salesreps).

SetCode

string

The 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

The date on which the record becomes active.

Status

string

The status of the record.

WhUpdateDate

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

Wh update date (used by AR).