DW_CXS_SALES_STAGE_D

This table contains description for sales stages

Details

Module:

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 This column is for Oracle Internal use only. 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 The sales stage's position in the list of values.
RECOMMENDED_WIN_PROBABILITY NUMBER 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.