Opportunity Snapshot Fact
Module:
OPPORTUNITY_SNAPSHOT_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
OPPORTUNITY_SNAPSHOT_ID | NUMBER | 38 | 0 | True | Primary key | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. System Generated Unique Identifier | ||||
PREVIOUS_OPPORTUNITY_SNAPSHOT_ID | NUMBER | 38 | 0 | previous opporunity snapshot id | |||
SNAPSHOT_DATE | DATE | Snapshot date | |||||
OPPORTUNITY_ID | NUMBER | 38 | 0 | Opportunity id | |||
OWNER_RESOURCE_PARTY_ID | NUMBER | 38 | 0 | Sales Representative | DW_CXS_RESOURCE_D | RESOURCE_ID | |
COMMENTS | VARCHAR2 | 999 | comments about this opportunity | ||||
OPPORTUNITY_NAME | VARCHAR2 | 512 | Opportunity Name | ||||
CUSTOMER_PARTY_ID | NUMBER | 38 | 0 | Customer ID | DW_CXS_SALES_ACCOUNT_D | PARTY_ID | |
SALES_ACCOUNT_ID | NUMBER | 38 | 0 | Sales Account ID | 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 | DW_CXS_CONTACT_D | CONTACT_ID | |
PRIMARY_PARTNER_PARTY_ID | NUMBER | 38 | 0 | Primary Partner | 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 | |
OPPORTUNITY_CREATION_TIMESTAMP | TIMESTAMP | Opportunity Creation date time | |||||
OPPORTUNITY_CREATION_DATE | DATE | Truncated Opportunity creation date for functional use.Can be used for DATE dimension join | |||||
OPPORTUNITY_NUMBER | VARCHAR2 | 32 | Opty number other than ID | ||||
BUDGETED_FLAG | VARCHAR2 | 16 | Customer has budget | ||||
STATUS_CODE | VARCHAR2 | 64 | Status of Opportunity | DW_CXS_STATUS_CODE_D_TL | CODE | ||
SALES_METHOD_ID | NUMBER | 38 | 0 | Sales Method | DW_CXS_SALES_METHOD_D_TL | SALES_METHOD_ID | |
CURRENT_SALES_STAGE_ID | NUMBER | 38 | 0 | Current Sales Stage | DW_CXS_SALES_STAGE_D_TL | SALES_STAGE_ID | |
REASON_WON_LOST_CODE | VARCHAR2 | 64 | Reason for won or lost. | DW_CXS_REASON_WON_LOST_CODE_D_TL | CODE | ||
LINE_OF_BUSINESS_CODE | VARCHAR2 | 32 | The line of business that is responsible for the opportunity | DW_CXS_LINE_OF_BUSINESS_CODE_D_TL | CODE | ||
STATUS_CATEGORY | VARCHAR2 | 32 | Status Category of the Opportunity Status | DW_CXS_STATUS_CATEGORY_D_TL | CODE | ||
STRATEGIC_VALUE_CODE | VARCHAR2 | 64 | Strategy for the opportunity | DW_CXS_STRATEGIC_VALUE_CODE_D_TL | CODE | ||
RISK_LEVEL_CODE | VARCHAR2 | 64 | Risk Level for the opportunity | DW_CXS_RISK_LEVEL_CODE_D_TL | CODE | ||
DECISION_LEVEL_CODE | VARCHAR2 | 64 | Decision level for the opportunity | DW_CXS_DECISION_LEVEL_CODE_D_TL | CODE | ||
DEAL_HORIZON_CODE | VARCHAR2 | 64 | Decision level for the opportunity | DW_CXS_DEAL_HORIZON_CODE_D_TL | CODE | ||
LAST_UPDATE_TIMESTAMP | TIMESTAMP | User last Updated Date Time | |||||
EXPECTED_CLOSE_DATE | DATE | Expected close date unless the opportunity is closed. When opportunity closed then actual close date. | |||||
LAST_UPDATE_DATE | DATE | Truncated User last Updated Date,can be used for DATE Dimension join | |||||
OPPORTUNITY_CREATED_BY | VARCHAR2 | 128 | Who Column : indicates the user who created the Opportunity | ||||
DESCRIPTION | VARCHAR2 | 999 | Opportunity Description | ||||
SUMMARY_REVENUE_ID | NUMBER | 38 | 0 | Added for Opportunity Management (Revenue Schedule Item). It refers to the summary revenue item created in MOO_REVN, i.e. the primary revenue item for this opportunity. Though every opportunity will have a summary revenue. This column should not be made mandatory to avoid circular dependency. | |||
CURRENCY_CODE | VARCHAR2 | 32 | currency code for the extensibility | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
CREATION_TIMESTAMP | TIMESTAMP | Creation Date - Audit column | |||||
CREATION_DATE | DATE | Creation Date - Audit column, will be used for Date dimension join | |||||
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Name of the accounting calendar. | ||||
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. Examples are Weekly Quarterly. | ||||
SNAPSHOT_ID | NUMBER | 38 | 0 | Snapshot id | DW_CXS_SNAPSHOTS_D | SNAPSHOT_ID | |
BUDGET_AMOUNT | NUMBER | Budget Amount | |||||
PREVIOUS_EXPECTED_CLOSE_DATE | DATE | previous expected close date | |||||
IS_EXPECTED_CLOSE_DATE_CHANGED | NUMBER | 38 | 0 | Is expected close date changed | |||
CURRENT_EXPECTED_CLOSE_DATE_MONTH_CODE | VARCHAR2 | 16 | Current expected close date month code (YYYY/MM) | ||||
PREVIOUS_EXPECTED_CLOSE_DATE_MONTH_CODE | VARCHAR2 | 16 | Previous expected close date month code (YYYY/MM) | ||||
IS_EXPECTED_CLOSE_DATE_MONTH_CHANGED | NUMBER | 38 | 0 | Is expected close date month changed | |||
CURRENT_EXPECTED_CLOSE_DATE_QUARTER_CODE | VARCHAR2 | 16 | Current expected close date Quarter code (YYYY Q1) | ||||
PREVIOUS_EXPECTED_CLOSE_DATE_QUARTER_CODE | VARCHAR2 | 16 | Previous expected close date Quarter code (YYYY Q1) | ||||
IS_EXPECTED_CLOSE_DATE_QUARTER_CHANGED | NUMBER | 38 | 0 | Is expected close date quarter changed | |||
CURRENT_EXPECTED_CLOSE_DATE_YEAR_CODE | VARCHAR2 | 16 | Current expected close date Year code (YYYY) | ||||
PREVIOUS_EXPECTED_CLOSE_DATE_YEAR_CODE | VARCHAR2 | 16 | Previous expected close date Year code(YYYY) | ||||
IS_EXPECTED_CLOSE_DATE_YEAR_CHANGED | NUMBER | 38 | 0 | Is expected close date year changed |
Copyright © 2019, 2024, Oracle and/or its affiliates.