DW_CXS_OPPORTUNITY_CAMPAIGN_CF

OPPORTUNITY_CAMPAIGN_ID

Details

Module:

Key Columns

OPPORTUNITY_CAMPAIGN_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
OPPORTUNITY_CAMPAIGN_ID NUMBER 38 0 True OptyCampaignId    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. System    
OPPORTUNITY_ID NUMBER 38 0   OptyId    
CAMPAIGN_ID NUMBER 38 0   CampaignId    
CREATION_TIMESTAMP TIMESTAMP       CreationDate    
CREATION_DATE DATE       CreationDate    
CREATED_BY VARCHAR2 128     CreatedBy    
LAST_UPDATE_TIMESTAMP TIMESTAMP       LastUpdateDate    
LAST_UPDATE_DATE DATE       LastUpdateDate    
LAST_UPDATED_BY VARCHAR2 128     LastUpdatedBy    
REVENUE_PERCENTAGE NUMBER       RevenuePercentage    
FIRST_TOUCH_FLAG VARCHAR2 32          
LAST_TOUCH_FLAG VARCHAR2 32          
TOTAL_NUMBER_OF_CAMPAIGN NUMBER 38 0        
U_SHAPED_FLAG VARCHAR2 32          
ORDER_OF_CAMPAIGN_ASSOCIATION NUMBER 38 0        
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_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_START_TIMESTAMP TIMESTAMP       Starting TIMESTAMP for the campaign    
CAMPAIGN_END_DATE DATE       Ending date for the campaign. Responses received after this date are still counted    
CAMPAIGN_END_TIMESTAMP TIMESTAMP       Ending TIMESTAMP for the campaign. Responses received after this date are still counted    
CAMPAIGN_CREATION_DATE DATE       creation date for the campaign.    
CAMPAIGN_CREATION_TIMESTAMP TIMESTAMP       creation TIMESTAMP for the campaign.    
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    
OPPORTUNITY_OWNER_RESOURCE_PARTY_ID NUMBER 38 0   Sales resource marked as the owner for the opportunity DW_CXS_RESOURCE_D RESOURCE_ID
OPPORTUNITY_NAME VARCHAR2 512     Opportunity Name    
OPPORTUNITY_CUSTOMER_PARTY_ID NUMBER 38 0   Customer party ID maps to Sales Account created DW_CXS_SALES_ACCOUNT_D PARTY_ID
OPPORTUNITY_SALES_ACCOUNT_ID NUMBER 38 0   Sales Account Identifier maps to the sales account in use for the opportunity DW_CXS_SALES_ACCOUNT_D SALES_ACCOUNT_ID
OPPORTUNITY_PRIMARY_COMPETITOR_PARTY_ID NUMBER 38 0   Primary Competitor DW_CXS_COMPETITOR_D COMPETITOR_ID
OPPORTUNITY_PRIMARY_CONTACT_PARTY_ID NUMBER 38 0   Primary Contact for the opportunity associated with the sales account DW_CXS_CONTACT_D CONTACT_ID
OPPORTUNITY_PRIMARY_PARTNER_PARTY_ID NUMBER 38 0   Primary Partner asociated with the opportunity DW_CXS_PARTNER_D PARTNER_ID
OPPORTUNITY_BUSINESS_UNIT_ID NUMBER 38 0   (Internal Organization) to which this Opportunity belongs. DW_BUSINESS_UNIT_D_TL BUSINESS_UNIT_ID
OPPORTUNITY_BUDGETED_FLAG VARCHAR2 16     Indicates if the opportunity target has budgeted for buying the solution proposed by this opportunity.    
OPPORTUNITY_ACTUAL_CLOSE_DATE DATE       when opty is closed (status category in win/loss/no sale) then it is equal to effective date else null    
OPPORTUNITY_STATUS_CODE VARCHAR2 64     User configurable status of Opportunit Stores Values such as Open Won Lost and No Sale DW_CXS_STATUS_CODE_D_TL CODE
OPPORTUNITY_SALES_METHOD_ID NUMBER 38 0   Sales Method associated to an opportunity gives information about various stages that opportunity will go through DW_CXS_SALES_METHOD_D_TL SALES_METHOD_ID
OPPORTUNITY_CURRENT_SALES_STAGE_ID NUMBER 38 0   Current Sales Stage and Stores Values such as 'Short List', 'Negotiation', 'Closed', 'Discovery',' Discovery',' Solution Presentation', 'Short List' DW_CXS_SALES_STAGE_D_TL SALES_STAGE_ID
OPPORTUNITY_REASON_WON_LOST_CODE VARCHAR2 64     Reason for won or lost. And Which Stores Values such as 'Customer not ready', 'Good lead', 'Install base', 'Lost to competition', 'Lost to internal development', 'Lost to no decision', 'No budget' DW_CXS_REASON_WON_LOST_CODE_D_TL CODE
OPPORTUNITY_SALES_CHANNEL_CODE VARCHAR2 64     Sales channel from which the opportunity originates DW_CXS_SALES_CHANNEL_CODE_D_TL CODE
OPPORTUNITY_LINE_OF_BUSINESS_CODE VARCHAR2 32     The line of business that is responsible for the opportunity DW_CXS_LINE_OF_BUSINESS_CODE_D_TL CODE
OPPORTUNITY_STATUS_CATEGORY VARCHAR2 32     Status Category of the Opportunity Status DW_CXS_STATUS_CATEGORY_D_TL CODE
OPPORTUNITY_PREDICTED_WIN_PROBABILITY NUMBER       Opportunity AI predicted win probability    
OPPORTUNITY_STRATEGIC_VALUE_CODE VARCHAR2 64     Strategy for the opportunity and Stores Values Such as 'High', 'Low', 'Medium' DW_CXS_STRATEGIC_VALUE_CODE_D_TL CODE
OPPORTUNITY_RISK_LEVEL_CODE VARCHAR2 64     Risk Level for the opportunity. And Stores Values Such as 'High', 'Low', 'None' DW_CXS_RISK_LEVEL_CODE_D_TL CODE
OPPORTUNITY_DECISION_LEVEL_CODE VARCHAR2 64     Decision level for the opportunity. And Stores values such as 'CEO', 'CIO', 'Director', 'Manager', 'Other', 'VP' DW_CXS_DECISION_LEVEL_CODE_D_TL CODE
OPPORTUNITY_DEAL_HORIZON_CODE VARCHAR2 64     Deal Horizon for the opportunity. And Stores values such as 'Greater than 120 days', 'Less than 15 days','15 - 30 days','31 - 60 days','61 - 120 days' DW_CXS_DEAL_HORIZON_CODE_D_TL CODE
OPPORTUNITY_EXPECTED_CLOSE_DATE DATE       Expected close date unless the opportunity is closed. When opportunity closed then actual close date.    
OPPORTUNITY_LOST_FLAG VARCHAR2 16     LOST_FLAG is set to Y when status is lost else N    
OPPORTUNITY_CLOSED_FLAG VARCHAR2 16     CLOSED_FLAG is set to Y when status is close else N    
OPPORTUNITY_AMOUNT NUMBER       Revenue amount at Opportunity Header level    
OPPORTUNITY_CURRENCY_CODE VARCHAR2 16     Opportunity revenue amount currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
OPPORTUNITY_CRM_CURRENCY_CODE VARCHAR2 16     CRM common currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
OPPORTUNITY_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.    
OPPORTUNITY_CRM_CONVERSION_RATE_TYPE VARCHAR2 32     currency conversion rate type for extensibility DW_CXS_CURRENCY_CONVERSION_RATE_TYP_D_TL CODE
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
OPPORTUNITY_CRM_OPPORTUNITY_AMOUNT NUMBER       Opportunity amount converted to CRM currency equivalent    
OPPORTUNITY_GLOBAL_OPPORTUNITY_AMOUNT NUMBER       Opportunity amount converted to Global currency equivalent    
OPPORTUNITY_BUDGET_AMOUNT NUMBER       Amount budgeted for this opportunity from customer/prospect side.    
OPPORTUNITY_CRM_CURRENCY_BUDGET_AMOUNT NUMBER       Amount budgeted for this opportunity from customer/prospect side in CRM currency    
OPPORTUNITY_GLOBAL_BUDGET_AMOUNT NUMBER       Amount budgeted for this opportunity from customer/prospect side in Global currency    

Copyright © 2019, 2024, Oracle and/or its affiliates.