Opportunity Progress Fact
Module:
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 | This column is for Oracle Internal use only. 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 | |||||
| CREATION_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 | |
| CURRENT_STAGE_FLAG | VARCHAR2 | 16 | Currently active |
Copyright © 2019, 2024, Oracle and/or its affiliates.