Sales Lookup

The configurable setup data defined specifically for sales usage.

QName: {http://xmlns.oracle.com/apps/sales/baseSales/common/salesLookups/salesLookupService/}LookupValues

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

Contains

Sales Lookup Translation SDO

Handled by

Sales Lookup

Attributes

The following table describes attributes in the service data object.

Name Type Description

AppliesTo

string

The object for which the lookup value is applicable.

ConflictId

long

The attribute value is used to guarantee the uniqueness of the row when duplicates are created in different databases.

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.

Description

string

The free text description of the record.

DisplaySequence

long

The order in which the status code is displayed.

EnabledFlag

boolean

The flag indicating whether the Lookup value is enabled.

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.

LookupCategory

string

The attribute for lookup category associated with lookup value.

LookupCode

string

The attribute for lookup code associated with lookup value.

LookupType

string

The attribute for lookup type associated with the lookup value.

LookupValuesId

long

The unique identifier for the Lookup Value.
  • Primary Key

LookupValuesTranslation

Sales Lookup Translation

The attribute for list of translated sales lookup values.

Meaning

string

The translated value of the lookup value.

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.

SetCode

string

The sales status lookup value's reference data set code.

SetId

long

The identifier for sales status lookup value's reference data set.

SetName

string

The identifier name of sales status lookup value's reference data set.

StartDateActive

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

The date on which the record becomes active.

UserLastUpdateDate

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

The date and time when the row was last updated.