This table contains description for sales stages
Module:
SALES_STAGE_ID
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.