DW_CXS_OPPORTUNITY_REVENUE_SNAPSHOT_CF

Opportunity Revenue Snapshot Fact

Details

Module:

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 This column is for Oracle Internal use only. System Generated Unique Identifier
PREVIOUS_REVENUE_SNAPSHOT_ID NUMBER 38 0 Previous Revenue Snapshot id
SNAPSHOT_DATE DATE Date when the snapshot was generated
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 code 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 Who Column : indicates the user who created the row
CREATION_DATE DATE Creation Date
CREATION_TIMESTAMP TIMESTAMP Creation Date Time
REVENUE_CREATION_DATE DATE Revenue Creation Date
REVENUE_CREATION_TIMESTAMP TIMESTAMP Revenue Creation Date Time
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 percentage
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 percentage
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
OPPORTUNITY_SNAPSHOT_ID NUMBER 38 0 Opportunity Snapshot id
OPPORTUNITY_SNAPSHOT_DATE DATE Snapshot date
OPPORTUNITY_OWNER_RESOURCE_PARTY_ID NUMBER 38 0 Sales Representative
OPPORTUNITY_COMMENTS VARCHAR2 999 comments about this opportunity
OPPORTUNITY_NAME VARCHAR2 512 Opportunity Name
OPPORTUNITY_CUSTOMER_PARTY_ID NUMBER 38 0 Customer ID
OPPORTUNITY_SALES_ACCOUNT_ID NUMBER 38 0 Sales Account ID
OPPORTUNITY_PRIMARY_COMPETITOR_PARTY_ID NUMBER 38 0 Primary Competitor
OPPORTUNITY_PRIMARY_CONTACT_PARTY_ID NUMBER 38 0 Primary Contact
OPPORTUNITY_PRIMARY_PARTNER_PARTY_ID NUMBER 38 0 Primary Partner
OPPORTUNITY_BUSINESS_UNIT_ID NUMBER 38 0 (Internal Organization) to which this Opportunity belongs.
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
OPPORTUNITY_BUDGETED_FLAG VARCHAR2 16 Customer has budget
OPPORTUNITY_STATUS_CODE VARCHAR2 64 Status of Opportunity
OPPORTUNITY_SALES_METHOD_ID NUMBER 38 0 Sales Method
OPPORTUNITY_CURRENT_SALES_STAGE_ID NUMBER 38 0 Current Sales Stage
OPPORTUNITY_REASON_WON_LOST_CODE VARCHAR2 64 Reason for won or lost.
OPPORTUNITY_LINE_OF_BUSINESS_CODE VARCHAR2 32 The line of business that is responsible for the opportunity
OPPORTUNITY_STATUS_CATEGORY VARCHAR2 32 Status Category of the Opportunity Status
OPPORTUNITY_STRATEGIC_VALUE_CODE VARCHAR2 64 Strategy for the opportunity
OPPORTUNITY_RISK_LEVEL_CODE VARCHAR2 64 Risk Level for the opportunity
OPPORTUNITY_DECISION_LEVEL_CODE VARCHAR2 64 Decision level for the opportunity
OPPORTUNITY_DEAL_HORIZON_CODE VARCHAR2 64 Decision level for the opportunity
OPPORTUNITY_SNAPSHOT_LAST_UPDATE_TIMESTAMP TIMESTAMP User last Updated Date Time
OPPORTUNITY_EXPECTED_CLOSE_DATE DATE Expected close date unless the opportunity is closed. When opportunity closed then actual close date.
OPPORTUNITY_SNAPSHOT_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
OPPORTUNITY_DESCRIPTION VARCHAR2 999 Opportunity Description
OPPORTUNITY_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.
OPPORTUNITY_CURRENCY_CODE VARCHAR2 32 currency code for the extensibility
OPPORTUNITY_SNAPSHOT_CREATION_TIMESTAMP TIMESTAMP Creation Date - Audit column
OPPORTUNITY_SNAPSHOT_CREATION_DATE DATE Creation Date - Audit column, will be used for Date dimension join
OPPORTUNITY_BUDGET_AMOUNT NUMBER Budget Amount
INCLUDED_INDICATOR NUMBER 38 0