DW_CXS_OPPORTUNITY_SNAPSHOT_F

Opportunity Snapshot Fact

Details

Module:

Key Columns

OPPORTUNITY_SNAPSHOT_ID

Columns

Columns
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.