DW_CXS_OPPORTUNITY_ACCESS_D

Opportunity Access

Details

Module: Opportunity Management

Key Columns

OPPORTUNITY_ACCESS_ID, TYPE_CODE

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

Copyright © 2019, 2023, Oracle and/or its affiliates.