Opportunity Progress Fact
Module: Opportunity Management
OPPORTUNITY_STAGE_SNAPSHOT_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
OPPORTUNITY_STAGE_SNAPSHOT_ID | NUMBER | 38 | 0 | True | System generated key | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | Unique Identifier | ||||
OPPORTUNITY_ID | NUMBER | 38 | 0 | Opportunity Id | |||
SALES_STAGE_ID | NUMBER | 38 | 0 | Sales Stage Id | DW_CXS_SALES_STAGE_D | SALES_STAGE_ID | |
ACTIVE_FLAG | VARCHAR2 | 16 | Currently active | ||||
STAGE_ENTER_DATE | DATE | Date from | |||||
STAGE_EXIT_DATE | DATE | Date to | |||||
STAGE_ENTER_TIMESTAMP | TIMESTAMP | Date from | |||||
STAGE_EXIT_TIMESTAMP | TIMESTAMP | Date to | |||||
SALES_ACCOUNT_ID | NUMBER | 38 | 0 | Sales Account Identifier maps to the sales account in use for the opportunity | DW_CXS_SALES_ACCOUNT_D | SALES_ACCOUNT_ID | |
PRIMARY_COMPETITOR_PARTY_ID | NUMBER | 38 | 0 | Primary Competitor | DW_CXS_COMPETITOR_D | COMPETITOR_ID | |
PRIMARY_CONTACT_PARTY_ID | NUMBER | 38 | 0 | Primary Contact for the opportunity associated with the sales account | DW_CXS_CONTACT_D | CONTACT_ID | |
PRIMARY_PARTNER_PARTY_ID | NUMBER | 38 | 0 | Primary Partner asociated with the opportunity | DW_CXS_PARTNER_D | PARTNER_ID | |
BUSINESS_UNIT_ID | NUMBER | 38 | 0 | (Internal Organization) to which this Opportunity belongs. | DW_BUSINESS_UNIT_D_TL | BUSINESS_UNIT_ID | |
OWNER_RESOURCE_PARTY_ID | NUMBER | 38 | 0 | Sales resource marked as the owner for the opportunity | DW_CXS_RESOURCE_D | RESOURCE_ID | |
EXPECTED_CLOSE_DATE | DATE | Expected close date unless the opportunity is closed. When opportunity closed then actual close date. | |||||
STATUS_CATEGORY | VARCHAR2 | 32 | Status Category of the Opportunity Status | DW_CXS_STATUS_CATEGORY_D_TL | CODE | ||
CUSTOMER_PARTY_ID | NUMBER | 38 | 0 | Customer party ID maps to Sales Account created | DW_CXS_SALES_ACCOUNT_D | PARTY_ID |