DW_CXS_OPPORTUNITY_REVENUE_CF

Opportunity Revenue Fact

Details

Module: Opportunity Management

Key Columns

REVENUE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
REVENUE_ID NUMBER 38 0 True Primary key.    
SOURCE_RECORD_ID VARCHAR2 256     Unique Identifier    
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_TIMESTAMP TIMESTAMP       Creation Timestamp - Audit column    
CREATION_DATE DATE       Creation Date - Audit column    
REVENUE_CREATION_TIMESTAMP TIMESTAMP       Revenue Creation Date    
REVENUE_CREATION_DATE DATE       Revenue 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    
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_TIMESTAMP TIMESTAMP       date and time of the last update    
LAST_UPDATE_DATE DATE       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    
RECOMMENDED_REVENUE_AMOUNT NUMBER       Recomented Revenue Amount    
RECOMMENDED_WIN_PROBABILITY NUMBER       Recomented Win probability percent    
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_REVENUE_INDICATOR VARCHAR2 16     Derived from column RECURRING_TYPE_CODE, will store "P" for parent recurrence, "C" for child recurrence and "N" for all the non recurring records.    
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    
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_REVENUE_INDICATOR VARCHAR2 32     Derived from column SPLIT_TYPE_CODE, will store P for parent split, C for child split and N for all the non split records.    
SPLIT_TYPE_CODE VARCHAR2 32     Split type code DW_CXS_SPLIT_TYPE_CODE_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    
REVENUE_STATUS_CATEGORY VARCHAR2 32     Revenue Sales Status Category DW_CXS_STATUS_CATEGORY_D_TL CODE
PRIMARY_COMPETITOR_PARTY_ID NUMBER       Primary Competitor DW_CXS_COMPETITOR_D COMPETITOR_ID
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    
CRM_REVENUE_AMOUNT NUMBER       CRM Revenue amount    
OPPORTUNITY_CURRENCY_CODE VARCHAR2 16     currency code for the extensibility DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
OPPORTUNITY_CURRENCY_REVENUE_AMOUNT NUMBER       Opportunity currency Revenue amount    
OPPORTUNITY_NAME VARCHAR2 512     Opportunity Name    
OPPORTUNITY_CREATION_DATE DATE       Truncated Opportunity creation date for functional use.Can be used for DATE dimension join    
OPPORTUNITY_CURRENT_SALES_STAGE_ID NUMBER 38 0   Current Sales Stage DW_CXS_SALES_STAGE_D_TL SALES_STAGE_ID
OPPORTUNITY_CLOSE_DATE DATE       Expected close date unless the opportunity is closed. When opportunity closed then actual close date.    
OPPORTUNITY_PRIMARY_COMPETITOR_PARTY_ID NUMBER 38 0   Primary Competitor DW_CXS_COMPETITOR_D COMPETITOR_ID
OPPORTUNITY_PRIMARY_PARTNER_PARTY_ID NUMBER 38 0   Primary Partner asociated with the opportunity DW_CXS_PARTNER_D PARTNER_ID
GLOBAL_REVENUE_AMOUNT NUMBER       Global Revenue amount    
PRODUCT_ID NUMBER 38 0   Stores Product group ID if Item ID is null, else it will store Item ID    
OPPORTUNITY_OWNER_RESOURCE_PARTY_ID NUMBER 38 0   Salesrep or partner ID DW_CXS_RESOURCE_D RESOURCE_ID
SALES_ACCOUNT_OWNER_PARTY_ID NUMBER 38 0   Sales Account owner Id DW_CXS_RESOURCE_D RESOURCE_ID
PRIMARY_TERRITORY_OWNER_PARTY_ID NUMBER 38 0   Primary territory owner id DW_CXS_RESOURCE_D RESOURCE_ID
ITEM_OR_PRODUCT_GROUP VARCHAR2 32     Indicates whether Revenue line is ProductGroup Or Item    
GLOBAL_EXPECTED_AMOUNT NUMBER       Global Expected revenue amount    
CRM_CURRENCY_EXPECTED_AMOUNT NUMBER       CRM currency Expected revenue amount    
OPPORTUNITY_CURRENCY_EXPECTED_AMOUNT NUMBER       Opportunity currency Expected revenue amount    
GLOBAL_RECOMMENDED_REVENUE_AMOUNT NUMBER       Global Recommended Revenue Amount    
CRM_CURRENCY_RECOMMENDED_REVENUE_AMOUNT NUMBER       CRM currency Recommended Revenue Amount    
OPPORTUNITY_CURRENCY_RECOMND_REVENUE_AMT NUMBER       Opportunity currency Recommended Revenue Amount    
GLOBAL_RECURRING_REVENUE_AMOUNT NUMBER       Global revenue amount for the recurrence    
CRM_CURRENCY_RECURRING_REVENUE_AMOUNT NUMBER       CRM currency revenue amount for the recurrence    
OPPORTUNITY_CURRENCY_RECURNG_REVENUE_AMT NUMBER       Opportunity currency revenue amount for the recurrence    
GLOBAL_RECURRING_UNIT_PRICE NUMBER       Global Unit price for the recurrence    
CRM_CURRENCY_RECURRING_UNIT_PRICE NUMBER       CRM currency Unit price for the recurrence    
OPPORTUNITY_CURRENCY_RECURRING_UNITPRICE NUMBER       Opportunity currency Unit price for the recurrence    
GLOBAL_UNIT_PRICE NUMBER       Global Unit Price    
CRM_CURRENCY_UNIT_PRICE NUMBER       CRM currency Unit Price    
OPPORTUNITY_CURRENCY_UNIT_PRICE NUMBER       Opportunity currency Unit Price    
CAMPAIGN_ID NUMBER 38 0   Campaign Identifier    
CAMPAIGN_ACTUAL_COST NUMBER       Amount of money spent to run the campaign.    
CAMPAIGN_BUDGETED_COST NUMBER       Amount of money budgeted for the campaign.    
CAMPAIGN_CURRENCY_CODE VARCHAR2 16     Currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CAMPAIGN_OWNER_RESOURCE_PARTY_ID NUMBER 38 0   Owner of the campaign row. DW_CXS_RESOURCE_D RESOURCE_ID
CAMPAIGN_CREATED_BY VARCHAR2 64     Who column: indicates the user who created the row.    
CAMPAIGN_REGION_CODE VARCHAR2 128     Region code of the Campaign.    
CAMPAIGN_NAME VARCHAR2 128     Name of the campaign    
CAMPAIGN_START_DATE DATE       Starting Date for the campaign    
CAMPAIGN_END_DATE DATE       Ending date for the campaign. Responses received after this date are still counted    
CAMPAIGN_PRODUCT_DESCRIPTION VARCHAR2 128     Product Name on the Campaign.    
CAMPAIGN_STATUS_CODE VARCHAR2 32     Status code of the Campaign created. ('ORA_DRAFT', 'ORA_COMPLETED, ORA_ACTIVE') DW_CXM_CAMPAIGN_STATUS_D_TL CODE
CAMPAIGN_TYPE_CODE VARCHAR2 32     Type of campaign. ( 'ORA_EVENT','ORA_BLOG_POST') DW_CXM_CAMPAIGN_TYPE_D_TL CODE
CAMPAIGN_DESCRIPTION VARCHAR2 2048     Description of the campaign    
CAMPAIGN_ACTIVE_FLAG VARCHAR2 16     Indicates whether the campaign is active('Y') or not ('N')    
GLOBAL_CURRENCY_CAMPAIGN_ACTUAL_COST NUMBER       Campaign actual cost in global currency    
GLOBAL_CURRENCY_CAMPAIGN_BUDGETED_COST NUMBER       Campaign budgeted cost in global currency    
CAMPAIGN_CREATION_DATE DATE       Who column: indicates the date of the creation of the row.    
SOURCED_FROM_CAMPAIGN_FLAG VARCHAR2 16     Flag to identifiy if an opportunity is linked to any marketing campaign    
CREATED_BY_MODULE VARCHAR2 32     Created By Module, it will be used to identify the opportunities converted from leads    
CONTRACT_START_DATE DATE       The start date of the contract for the quote    
CONTRACT_START_TIMESTAMP TIMESTAMP       The start date and time of the contract for the quote    
CONTRACT_END_DATE DATE       The end date of the contract for the quote    
CONTRACT_END_TIMESTAMP TIMESTAMP       The end date and time of the contract for the quote    
REVENUE_TYPE_CATEGORY VARCHAR2 32     The Revenue category type on the opportunity revenue line. DW_CXS_REVENUE_CATEGORY_TYPE_D_TL CODE
NON_RECURRING_REVENUE NUMBER       Non-Recurring Revenue Amount    
RECURRING_REVENUE NUMBER       The recurring revenue amount on the revenue line    
USAGE_REVENUE NUMBER       The usage revenue amount on the revenue line    
MONTHLY_RECURRING_REVENUE NUMBER       The monthly recurring revenue on the revenue line    
MONTHLY_USAGE_REVENUE NUMBER       The monthly usage revenue on the revenue line    
CRM_CURRENCY_NON_RECURRING_REVENUE NUMBER       Non-Recurring Revenue Amount in CRM currency    
CRM_CURRENCY_RECURRING_REVENUE NUMBER       The recurring revenue amount on the revenue line in CRM currency    
CRM_CURRENCY_USAGE_REVENUE NUMBER       The usage revenue amount on the revenue line in CRM currency    
CRM_CURRENCY_MONTHLY_RECURRING_REVENUE NUMBER       The monthly recurring revenue on the revenue line in CRM currency    
CRM_CURRENCY_MONTHLY_USAGE_REVENUE NUMBER       The monthly usage revenue on the revenue line in CRM currency    
GLOBAL_CURRENCY_NON_RECURRING_REVENUE NUMBER       Non-Recurring Revenue Amount in Global currency    
GLOBAL_CURRENCY_RECURRING_REVENUE NUMBER       The recurring revenue amount on the revenue line in Global currency    
GLOBAL_CURRENCY_USAGE_REVENUE NUMBER       The usage revenue amount on the revenue line in Global currency    
GLOBAL_CURRNCY_MONTHLY_RECURRING_REVENUE NUMBER       The monthly recurring revenue on the revenue line in Global currency    
GLOBAL_CURRENCY_MONTHLY_USAGE_REVENUE NUMBER       The monthly usage revenue on the revenue line in Global currency    
PRICE_TYPE_CODE VARCHAR2 32     The type of pricing associated with the revenue line DW_CXS_PRICE_TYPE_D_TL CODE
OPPORTUNITY_QUOTES_ASSOCIATION_FLAG VARCHAR2 16     Opporunity quote assoisction flag    
OPPORTUNITY_EXPECTED_CLOSE_DATE DATE       Expected close date unless the opportunity is closed. When opportunity closed then actual close date.