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 | 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. |
Copyright © 2019, 2025, Oracle and/or its affiliates.