DW_CXS_SALES_STAGE_D

This table contains description for sales stages

Details

Module: Opportunity Management

Key Columns

SALES_STAGE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SALES_STAGE_ID NUMBER 38 0 True System generated unique Identifier for Sales Stage    
SOURCE_RECORD_ID VARCHAR2 32     System generated key    
AVERAGE_DAYS_AT_STAGE NUMBER 38 0   Average number of days at sales stage    
STAGE_STATUS_CODE VARCHAR2 64     This is the opportunity status for this sales stage. DW_CXS_STATUS_CODE_D_TL CODE
MAXIMUM_DAYS_IN_STAGE NUMBER 38 0   Maximum number of days an opportunity can be in this sales stage before it is considered "stalled".    
SALES_METHOD_ID NUMBER 38 0   Sales Methodology to which the stage belongs to. DW_CXS_SALES_METHOD_D_TL SALES_METHOD_ID
STAGE_ORDER NUMBER 38 0   The sales stage's position in the list of values.    
RECOMMENDED_WIN_PROBABILITY NUMBER 38 0   Recommended probability of win.    
PHASE_CODE VARCHAR2 32     This value is used for rolling up many different stages into phases. Phases simplify management and reporting of the sales cycle. DW_CXS_PHASE_CODE_D_TL CODE
SALES_STAGE_DISABLED VARCHAR2 16     Implements soft delete of the object. Flag is nullable and so both NULL and "N" indicate deleted record. "Y", for active record.    

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