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