DW_CXS_OPPORTUNITY_STAGE_PROGRESS_F

Opportunity Progress Fact

Details

Module: Opportunity Management

Key Columns

OPPORTUNITY_STAGE_SNAPSHOT_ID

Columns

Columns
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    
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, 2023, Oracle and/or its affiliates.