Opportunity Revenue Snapshot Fact
Module: Opportunity Management
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 | 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.