DW_CXS_OPPORTUNITY_REVENUE_CF

Opportunity Revenue Fact

Details

Module:

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 This column is for Oracle Internal use only. 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 999 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.
PRIMARY_CAMPAIGN_ID NUMBER 38 0 Primary Campaign Id of the Opportunity. Reference Key to Campaign object.
OPPORTUNITY_PRIMARY_CONTACT_PARTY_ID NUMBER 38 0 Primary Contact DW_CXS_COMPETITOR_D COMPETITOR_ID
INCLUDED_INDICATOR NUMBER 38 0