1. Tables and Views for Sales and Fusion Service
  2. CN_SRP_ALTERNATE_PAYEES_GT

CN_SRP_ALTERNATE_PAYEES_GT

This table contains information of payees assigned to salesperson plan component

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: TABLE

Primary Key

Name Columns

CN_SRP_ALTERNATE_PAYEES_G_PK

SRP_ALTERNATE_PAYEE_ID

Columns

Name

SRP_ALTERNATE_PAYEE_IDNUMBER18YesSystem generated primary key.

SRP_PLAN_COMPONENT_IDNUMBER18YesSalesrep plan component identifier

PAYEE_IDNUMBER18YesPayee Identifier

PLAN_COMPONENT_IDNUMBER18YesPlan Component Identifier

PARTICIPANT_IDNUMBER18YesSalesrep Identifier

START_DATEDATEYesStart Date Effective

END_DATEDATEEnd Date Effective

DELETE_FLAGVARCHAR21YesDelete Flag

ATTRIBUTE_CATEGORYVARCHAR230Descriptive Flexfield: structure definition of the user descriptive flexfield.

ATTRIBUTE1VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE2VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE3VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE4VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE5VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE6VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE7VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE8VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE9VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE10VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE11VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE12VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE13VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE14VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE15VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.

CREATED_BYVARCHAR264YesWho column: indicates the user who created the row.

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

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

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

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

ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row.

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

Indexes

Index Uniqueness Columns
CN_SRP_ALTERNATE_PAYEES_GT_U1 Unique SRP_ALTERNATE_PAYEE_ID