Opportunity Revenue Snapshot Fact
Module:
REVENUE_SNAPSHOT_ID
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 |
Copyright © 2019, 2024, Oracle and/or its affiliates.