Quote Fact
Module: Common CRM
QUOTE_ID
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.