DW_CXS_QUOTE_CF

Quote Fact

Details

Module: Common CRM

Key Columns

QUOTE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
QUOTE_ID NUMBER 38 0 True Primary key.    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. Unique Identifier    
QUOTE_HEADER_NUMBER VARCHAR2 32     Order Header Number for the Quote or Order. This is a public surrogate key.    
WIN_STATUS_CODE VARCHAR2 32     The Status Code for the Quote or Order. Stores code for values such as 'Won','Lost','Deleted',' DW_CXS_WIN_STATUS_D_TL CODE
QUOTE_NAME VARCHAR2 512     Stores the Quote or Order Name    
VERSION_NUMBER NUMBER 38 0   Version Number of the Quote or Order    
PROPOSAL_EXIST_FLAG VARCHAR2 16     Flag to identify the associated proposal for the Quote    
ACTIVE_VERSION_FLAG VARCHAR2 16     Flag to indicate the active Quote for the Opportunity    
PLACED_ON_TIMESTAMP TIMESTAMP       Timestamp on which the Order was placed.    
PLACED_ON_DATE DATE       Truncated Placed On Date, can be used for DATE dimension join    
STATUS_CODE VARCHAR2 256     Public Status Code for the Quote or Order. Stores code for values such as 'Created', 'Ordered', and 'Rejected By Customer'. DW_CXS_QUOTE_STATUS_D_TL CODE
CREATED_BY VARCHAR2 128     Who column: indicates the user who created the row.    
CREATION_TIMESTAMP TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
CREATION_DATE DATE       Truncated Creation Date, can be used for DATE dimension join    
LAST_UPDATED_BY VARCHAR2 128     Who column: indicates the user who last updated the row.    
LAST_UPDATE_TIMESTAMP TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
LAST_UPDATE_DATE DATE       Truncated last updated date for functional use. Can be used for DATE dimension join    
EXPIRATION_TIMESTAMP TIMESTAMP       Expiration Timestamp of the Quote or Order    
EXPIRATION_DATE DATE       Truncated Expiration Date of the Quote or Order, can be used for DATE dimension join    
SOLD_CUSTOMER_PARTY_ID NUMBER 38 0   Customer Party Identifier DW_CXS_SALES_ACCOUNT_D PARTY_ID
ACCOUNT_BASED_QUOTE_FLAG VARCHAR2 16     Indicates if the quote is an account based quote.    
OPPORTUNITY_BASED_QUOTE_FLAG VARCHAR2 16     Indicates if the quote is an opportunity based quote.    
OPPORTUNITY_ID NUMBER 38 0   Opportunity Id for the Quote that is created    
QUOTE_CURRENCY_CODE VARCHAR2 16     Currency code for the Quote or Order DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CRM_CURRENCY_CODE VARCHAR2 16     Corporate currency code for extensibility DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CRM_CONVERSION_RATE_TYPE VARCHAR2 32     Currency conversion rate type for extensibility DW_CXS_CURRENCY_CONVERSION_RATE_TYP_D_TL CODE
CRM_CONVERSION_RATE NUMBER       This rate is used for conversion of revenue amount to crm common currency for Quote Metrics.    
ORDER_TOTAL NUMBER       Total Amount    
CONTRACT_START_TIMESTAMP TIMESTAMP       Earliest start date for all the line items within the quote, can be used for DATE dimension join.    
CONTRACT_START_DATE DATE       Truncated Earliest start date for all the line items within the quote, can be used for DATE dimension join.    
CONTRACT_END_TIMESTAMP TIMESTAMP       Latest end date for all the line items within the quote, can be used for DATE dimension join.    
CONTRACT_END_DATE DATE       Truncated Latest end date for all the line items within the quote, can be used for DATE dimension join.    
TOTAL_NON_RECURRING_REVENUE NUMBER       The total non-recurring revenue for the quote    
TOTAL_RECURRING_REVENUE NUMBER       The total recurring revenue for the quote    
TOTAL_USAGE_REVENUE NUMBER       The total usage revenue for the quote    
TOTAL_MONTHLY_RECURRING_REVENUE NUMBER       The total monthly recurring revenue for the quote    
TOTAL_MONTHLY_USAGE_REVENUE NUMBER       The total monthly usage revenue for the quote    
SALES_ACCOUNT_ID NUMBER 38 0   Sales Account Identifier DW_CXS_SALES_ACCOUNT_D SALES_ACCOUNT_ID
SOLD_CONTACT_PARTY_ID NUMBER 38 0   Customer Contact Party Identifier for Quote DW_CXS_CONTACT_D CONTACT_ID
PRIMARY_CONTACT_PARTY_ID NUMBER 38 0   Primary Contact for the Quote or Opportunity if not on Quote DW_CXS_CONTACT_D CONTACT_ID
EXTERNAL_SYSTEM_REFERENCE_CODE VARCHAR2 32     External reference(Third party) type for the Quote or Order    
EXTERNAL_QUOTE_NUMBER VARCHAR2 32     External reference for the Quote or Order, might not be unique    
EXTERNAL_REFERENCE_NUMBER VARCHAR2 128     Identifier for the External Quote or Order    
LAST_OPPORTUNITY_SYNC_TIMESTAMP TIMESTAMP       Last Opportunity Sync date for the quote to identify the Active version of the quote for the opportunity.    
LAST_OPPORTUNITY_SYNC_DATE DATE       Truncated Last Opportunity Sync date for the quote to identify the Active version of the quote for the opportunity.    
DESCRIPTION VARCHAR2 512     Quote or Order Description    
OWNER VARCHAR2 512     Owner of the Quote or Order    
RENEWAL_PROCESS_CODE VARCHAR2 32     The renewal process used to renew the quotes and orders. Stores code for values such as 'Manual',' Do not Renew', 'Automatic' DW_CXS_RENEWAL_PROCESS_D_TL CODE
QUOTE_TYPE_CATEGORY VARCHAR2 32     Specify if the quote is New, Renewal, or an Expansion. DW_CXS_QUOTE_TYPE_CATEGORY_D_TL CODE
CRM_CURRENCY_ORDER_TOTAL NUMBER       Total Amount in CRM currency.    
CRM_CURRENCY_TOTAL_RECURRING_REVENUE NUMBER       The total recurring revenue for the quote in CRM currency.    
CRM_CURRENCY_TOTAL_NON_RECUR_REVENUE NUMBER       The total non-recurring revenue for the quote in CRM currency.    
CRM_CURRENCY_TOTAL_USAGE_REVENUE NUMBER       The total usage revenue for the quote in CRM currency.    
CRM_CURRENCY_TOTAL_MONTHLY_RECUR_REVENUE NUMBER       The total monthly recurring revenue for the quote in CRM currency.    
CRM_CURRENCY_TOTAL_MONTHLY_USAGE_REVENUE NUMBER       The total monthly usage revenue for the quote in CRM currency.    
GLOBAL_CURRENCY_ORDER_TOTAL NUMBER       Total Amount in Global currency.    
GLOBAL_CURRENCY_TOTAL_RECUR_REVENUE NUMBER       The total recurring revenue for the quote in Global currency.    
GLOBAL_CURRENCY_TOTAL_NON_RECUR_REVENUE NUMBER       The total non-recurring revenue for the quote in Global currency.    
GLOBAL_CURRENCY_TOTAL_USAGE_REVENUE NUMBER       The total usage revenue for the quote in Global currency.    
GLOBAL_CURR_TOTAL_MONTHLY_RECUR_REVENUE NUMBER       The total monthly recurring revenue for the quote in Global currency.    
GLOBAL_CURR_TOTAL_MONTHLY_USAGE_REVENUE NUMBER       The total monthly usage revenue for the quote in Global currency.    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
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_NAME VARCHAR2 512     Opportunity Name    
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_EXPECTED_CLOSE_DATE DATE       Expected close date unless the opportunity is closed. When opportunity closed then actual close date.    
OPPORTUNITY_BUSINESS_UNIT_ID NUMBER 38 0   (Internal Organization) to which this Opportunity belongs. DW_BUSINESS_UNIT_D_TL BUSINESS_UNIT_ID
OPPORTUNITY_OWNER_RESOURCE_PARTY_ID NUMBER 38 0   Sales resource marked as the owner for the opportunity DW_CXS_RESOURCE_D RESOURCE_ID
OPPORTUNITY_STATUS_CATEGORY VARCHAR2 32     Status Category of the Opportunity Status. Stores code for values such as 'Open','Won','Lost','No sale' DW_CXS_STATUS_CATEGORY_D_TL CODE
OPPORTUNITY_CREATION_TIMESTAMP TIMESTAMP       Opportunity creation date for functional use.    
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_STATUS_CODE VARCHAR2 64     User configurable status of Opportunity. Stores code for Values such as 'Open','Won','Lost','No Sale' DW_CXS_STATUS_CODE_D_TL CODE
OPPORTUNITY_SALES_CHANNEL_CODE VARCHAR2 64     Sales channel from which the opportunity originates. Stores code for values such as 'Direct', 'Indirect', 'Partner'. DW_CXS_SALES_CHANNEL_CODE_D_TL CODE
OPPORTUNITY_DEAL_HORIZON_CODE VARCHAR2 64     Deal Horizon for the opportunity. Stores code for 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_STRATEGIC_VALUE_CODE VARCHAR2 64     Strategy for the opportunity. Stores code for values Such as 'High', 'Low', 'Medium' DW_CXS_STRATEGIC_VALUE_CODE_D_TL CODE
OPPORTUNITY_DECISION_LEVEL_CODE VARCHAR2 64     Decision level for the opportunity. Stores code for values such as 'CEO', 'CIO', 'Director', 'Manager', 'Other', 'VP' DW_CXS_DECISION_LVL_CODE_D_TL CODE
OPPORTUNITY_RISK_LEVEL_CODE VARCHAR2 64     Risk Level for the opportunity. Stores code for values Such as 'High', 'Low', 'None' DW_CXS_RISK_LVL_CODE_D_TL CODE
OPPORTUNITY_REASON_WON_LOST_CODE VARCHAR2 64     Reason for won or lost. Stores code for 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_CD_D_TL CODE
OPPORTUNITY_LINE_OF_BUSINESS_CODE VARCHAR2 32     The line of business that is responsible for the opportunity. Store values such as 'Consulting','Hardware','Software', and 'Support'. DW_CXS_LINE_OF_BUSINESS_CODE_D_TL CODE
OPPORTUNITY_BUDGETED_FLAG VARCHAR2 16     Indicates if the opportunity target has budgeted for buying the solution proposed by this opportunity.    
OPPORTUNITY_WIN_PROBABILITY NUMBER       Win probability percent    
OPPORTUNITY_LAST_UPDATE_TIMESTAMP TIMESTAMP       Opportunity User last Updated Date    
OPPORTUNITY_LAST_UPDATE_DATE DATE       Opportunity User last Updated Date    
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_CREATED_BY VARCHAR2 128     Opportunity Created by user    
OPPORTUNITY_PRIMARY_COMPETITOR_PARTY_ID NUMBER 38 0   Primary Competitor DW_CXS_COMPETITOR_D COMPETITOR_ID
OPPORTUNITY_COMMENTS VARCHAR2 999     comments about this opportunity    
OPPORTUNITY_CLOSED_FLAG VARCHAR2 16     Opportunity Closed Flag is set to Y when Opportunity status is close else N    
OPPORTUNITY_LOST_FLAG VARCHAR2 16     Opportunity Lost Flag is set to Y when Opportunity status is lost else N    
OPPORTUNITY_BUDGET_AMOUNT NUMBER       Opportunity Budget Amount    
CRM_CURRENCY_OPPORTUNITY_BUDGET_AMOUNT NUMBER       Opportunity Budget Amount in CRM Currency    
GLOBAL_CURR_OPPORTUNITY_BUDGET_AMOUNT NUMBER       Opportunity Budget Amount in Global Currency    
OPPORTUNITY_DESCRIPTION VARCHAR2 999     Opportunity Description    
OPPORTUNITY_CUSTOMER_PARTY_ID NUMBER 38 0   Customer party ID maps to Sales Account created DW_CXS_SALES_ACCOUNT_D PARTY_ID

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