DW_CXS_OPPORTUNITY_ACCESS_D

Opportunity Access

Details

Module:

Key Columns

TYPE_CODE, OPPORTUNITY_ACCESS_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
OPPORTUNITY_ACCESS_ID NUMBER 38 0 True Unique ID for Opportunity Access.
TYPE_CODE VARCHAR2 32 True Type of the Group - 'RESOURCE' OR ' TERRITORY'.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Source Record ID
OPPORTUNITY_ID NUMBER 38 0 Opportunity Id of the referenced Opportunity
GROUP_ID NUMBER 38 0 Contains either Resources Party Id or Territory Id based on Type column value
OPPORTUNITY_RESOURCE_ID NUMBER 38 0 ID for Opportunity Sales Team member.
REVENUE_TERRITORY_ID NUMBER 38 0 ID for Opportunity Summary Revenue Line Territory Association.
ACCESS_LEVEL_CODE VARCHAR2 32 Access level determines the type of access granted to the manager/admin of the organizations in the hierarchy.
OPPORTUNITY_EFFECTIVE_DATE DATE Estimated close date for this opportunity - defaulted from opportunity's close date.
OPPORTUNITY_STATUS_CODE VARCHAR2 32 Status code of this opportunity - defaulted from opportunity's status code.
CREATED_BY VARCHAR2 128 Indicates the user who created the row.
CREATION_DATE TIMESTAMP Indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 128 Indicates the user who last updated the row
LAST_UPDATE_DATE TIMESTAMP Indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 64 Indicates the session login associated to the user who last updated the row