DW_CXS_OPPORTUNITY_REVENUE_SNAPSHOT_CF

Opportunity Revenue Snapshot Fact

Details

Module: Opportunity Management

Key Columns

REVENUE_SNAPSHOT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
REVENUE_SNAPSHOT_ID NUMBER 38 0 True Primary key.    
SOURCE_RECORD_ID VARCHAR2 256     Unique Identifier    
PREVIOUS_REVENUE_SNAPSHOT_ID NUMBER 38 0   Previous Revenue Snapshot id    
SNAPSHOT_DATE DATE       Snapshot date    
REVENUE_ID NUMBER 38 0   Revenue Id    
ACTUAL_CLOSE_DATE DATE       the date when the revenue line was closed    
BUSINESS_UNIT_ID NUMBER 38 0   (Internal Organization) to which this Opportunity belongs. DW_BUSINESS_UNIT_D_TL BUSINESS_UNIT_ID
CLOSE_REASON_CODE VARCHAR2 64     Close reason DW_CXS_REASON_WON_LOST_CODE_D_TL CODE
REVENUE_CURRENCY_CODE VARCHAR2 32     CRM common currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
OPPORTUNITY_CURRENCY_CONVERSION_RATE NUMBER       This rate is used for the conversion of the revenue amount to the opportunity summary currency if the currency of the revenue line is different from that of the opportunity.This is the amount that one currency can be exchanged for at a specific point of time.    
OPPORTUNITY_CURRENCY_CONVERSION_RATE_TYP VARCHAR2 32     Currency Conversion rate type DW_CXS_CURRENCY_CONVERSION_RATE_TYP_D_TL CODE
CREATED_BY VARCHAR2 64     user who created the row    
CREATION_DATE DATE       Creation Date    
CREATION_TIMESTAMP TIMESTAMP       Creation Date    
REVENUE_CREATION_DATE DATE       Creation Date    
REVENUE_CREATION_TIMESTAMP TIMESTAMP       Creation Date    
CRM_CURRENCY_CODE VARCHAR2 32     CRM common currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CRM_CONVERSION_RATE NUMBER       This rate is used for the conversion of the revenue amount to the crm common currency for the Revenue Forecast Metrics if the currency of the revenue line is different.This is the amount that one currency can be exchanged for at a specific point of time.    
CRM_CONVERSION_RATE_TYPE VARCHAR2 32     Currency Conversion rate type DW_CXS_CURRENCY_CONVERSION_RATE_TYP_D_TL CODE
CUSTOMER_PARTY_ID NUMBER 38 0   Customer ID DW_CXS_SALES_ACCOUNT_D PARTY_ID
DISCOUNT_PERCENT NUMBER       Discount percent    
EXPECTED_CLOSE_DATE DATE       Estimated close date for this revenue - defaulted from opportunity's close date    
EXPECTED_AMOUNT NUMBER       Expected revenue amount    
PREVIOUS_EXPECTED_AMOUNT NUMBER       Previous Expected revenue amount    
IS_EXPECTED_AMOUNT_CHANGED NUMBER 38 0   Is expected amount changed    
INVENTORY_ITEM_ID NUMBER 38 0   Product inventory item ID DW_CXS_PRODUCT_D INVENTORY_ITEM_ID
INVENTORY_ORGANIZATION_ID NUMBER 38 0   Product inventory organization ID    
LAST_UPDATE_DATE DATE       date and time of the last update    
LAST_UPDATE_TIMESTAMP TIMESTAMP       date and time of the last update    
OPPORTUNITY_ID NUMBER 38 0   Opportunity ID    
OWNER_RESOURCE_PARTY_ID NUMBER 38 0   Salesrep or partner ID DW_CXS_RESOURCE_D RESOURCE_ID
PRIMARY_FLAG VARCHAR2 32     Primary flag - defines the primary revenue record    
PRIMARY_TERRITORY_VERSION_ID NUMBER 38 0   Primary territory version id DW_CXS_SALES_TERRITORY_D TERRITORY_VERSION_ID
PRODUCT_GROUP_ID NUMBER 38 0   The product group id DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
QUANTITY NUMBER       Quantity    
PREVIOUS_QUANTITY NUMBER       Previous Quantity    
IS_QUANTITY_CHANGED NUMBER 38 0   Is expected quantity changed    
RECOMMENDED_REVENUE_AMOUNT NUMBER       Recomented Revenue Amount    
RECOMMENDED_WIN_PROBABILITY NUMBER       Recomented Win probability percent    
PREVIOUS_RECOMMENDED_WIN_PROBABILITY NUMBER       Previous Recomented Win probability percent    
IS_RECOMMENDED_WIN_PROBABILITY_CHANGED NUMBER 38 0   Is expected recommended win probability changed    
RECURRING_END_DATE DATE       The recurrence end date    
RECURRING_FREQUENCY_CODE VARCHAR2 32     Frequency for the receurrence DW_CXS_RECURRING_FREQUENCY_CODE_D_TL CODE
RECURRING_NUMBER_PERIODS NUMBER 38 0   The number of periods for creating the recurrence    
RECURRING_PARENT_REVENUE_ID NUMBER 38 0   Parent revenue id for the recurrence    
RECURRING_QUANTITY NUMBER       The recurrence quantity    
RECURRING_REVENUE_AMOUNT NUMBER       The revenue amount for the recurrence    
RECURRING_START_DATE DATE       The recurrence start date    
RECURRING_TYPE_CODE VARCHAR2 32     Recurring type code DW_CXS_RECURRENCE_TYPE_CODE_D_TL CODE
RECURRING_UNIT_PRICE NUMBER       Unit price for the recurrence    
REVENUE_AMOUNT NUMBER       Revenue amount    
PREVIOUS_REVENUE_AMOUNT NUMBER       Previous Revenue amount    
IS_REVENUE_AMOUNT_CHANGED NUMBER 38 0   Is expected revenue amount changed    
REVENUE_CATEGORY_CODE VARCHAR2 32     Revenue Category DW_CXS_REVENUE_CATEGORY_D_TL CODE
REVENUE_LINE_TYPE_CODE VARCHAR2 32     Type such as Opportunity Summary Revenue Standard Revenue DW_CXS_REVENUE_LINE_TYPE_CODE_D_TL CODE
REVENUE_NUMBER VARCHAR2 32     User editable revenue number. Defaulted from REVN_ID. Needs to be unique cannot be NULL    
REVENUE_SEQUENCE_NUMBER NUMBER 38 0   Revenue Sequence number    
REVENUE_TYPE_CODE VARCHAR2 64     Indicates revenue type DW_CXS_TYPE_CODE_D_TL CODE
SALES_ACCOUNT_ID NUMBER 38 0   Sales Account Id DW_CXS_SALES_ACCOUNT_D SALES_ACCOUNT_ID
SALES_CREDIT_TYPE_CODE VARCHAR2 32     Quota or Non-quota sales credit type DW_CXS_SALES_CREDIT_TYPE_CODE_D_TL CODE
SPLIT_PARENT_REVENUE_ID NUMBER 38 0   Split parent revenue id    
SPLIT_PERCENT NUMBER       Split percent    
SPLIT_TYPE_CODE VARCHAR2 32     Split type code DW_CXS_SPLIT_TYPE_CODE_D_TL CODE
REVENUE_STATUS_CATEGORY VARCHAR2 32     Revenue Sales Status Category DW_CXS_STATUS_CATEGORY_D_TL CODE
STATUS_CODE VARCHAR2 64     Revenue status code DW_CXS_STATUS_CODE_D_TL CODE
TOP_PARENT_REVENUE_NUMBER VARCHAR2 32     Revenue number of the Revenue Line the split recurrence or the split of the recurrence rolls up to. It is non-unique and can be NULL    
UNIT_PRICE NUMBER       Unit Price    
UOM_CODE VARCHAR2 32     Unit of measure code for product DW_UNIT_OF_MEASURE_D_TL UOM_CODE
WIN_PROBABILITY NUMBER       Win probability percent    
PRIMARY_COMPETITOR_PARTY_ID NUMBER       Primary Competitor    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Name of the accounting calendar.    
FISCAL_PERIOD_TYPE VARCHAR2 16     Accounting period type. Examples are Weekly Quarterly.    
PREVIOUS_CRM_REVENUE_AMOUNT NUMBER       Previous CRM Revenue amount    
CRM_REVENUE_AMOUNT NUMBER       Revenue amount    
PREVIOUS_GLOBAL_REVENUE_AMOUNT NUMBER       Previous Global Revenue amount    
GLOBAL_REVENUE_AMOUNT NUMBER       Revenue amount    
PRODUCT_ID NUMBER 38 0   Product Identifier    
ITEM_OR_PRODUCT_GROUP VARCHAR2 32     Indicates whether Revenue line is ProductGroup Or Item    
SNAPSHOT_ID NUMBER 38 0   Snapshot Id DW_CXS_SNAPSHOTS_D SNAPSHOT_ID
CRM_CURRENCY_UNIT_PRICE NUMBER       Unit Price in CRM currency    
CRM_CURRENCY_RECURRING_UNIT_PRICE NUMBER       Unit price for the recurrence in CRM Currency    
PREVIOUS_CRM_CURRENCY_EXPECTED_AMOUNT NUMBER       Previous Expected revenue amount in CRM Currency    
CRM_CURRENCY_EXPECTED_AMOUNT NUMBER       Expected revenue amount in CRM Currency    
CRM_CURRENCY_RECOMMENDED_REVENUE_AMOUNT NUMBER       Recomented Revenue Amount in CRM Currency    
CRM_CURRENCY_RECURRING_REVENUE_AMOUNT NUMBER       The revenue amount for the recurrence in CRM Currency    
GLOBAL_UNIT_PRICE NUMBER       Unit Price in Global currency    
GLOBAL_RECURRING_UNIT_PRICE NUMBER       Unit price for the recurrence in Global currency    
PREVIOUS_GLOBAL_EXPECTED_AMOUNT NUMBER       Previous Expected revenue amount in Global currency    
GLOBAL_EXPECTED_AMOUNT NUMBER       Expected revenue amount in Global currency    
GLOBAL_RECOMMENDED_REVENUE_AMOUNT NUMBER       Recomented Revenue Amount in Global currency    
GLOBAL_RECURRING_REVENUE_AMOUNT NUMBER       The revenue amount for the recurrence in Global currency    
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 mount date 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 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 year changed    

Copyright © 2019, 2023, Oracle and/or its affiliates.