DW_CXS_QUOTE_LINES_CF

Activity Fact

Details

Module: Common CRM

Key Columns

QUOTE_LINE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
QUOTE_LINE_ID NUMBER 38 0 True Primary key    
SOURCE_RECORD_ID VARCHAR2 256     Unique Identifier    
QUOTE_HEADER_ID NUMBER 38 0   Order Header ID for the Order Line.    
OPPORTUNITY_ID NUMBER 38 0   Opportunity Id for the Quote that is associated to the record    
OPPORTUNITY_CUSTOMER_PARTY_ID NUMBER 38 0   Denormalized Opportunity Customer Party ID DW_CXS_SALES_ACCOUNT_D PARTY_ID
OPPORTUNITY_REVENUE_ID NUMBER 38 0   Revenue ID of the associated revenue line.    
INVENTORY_ITEM_ID NUMBER 38 0   Product inventory item ID of sales order line. DW_CXS_PRODUCT_D INVENTORY_ITEM_ID
INVENTORY_ORGANIZATION_ID NUMBER 38 0   Product inventory organization ID of sales order line.    
LINE_STATUS_CODE VARCHAR2 32     Public status of the sales order line. DW_CXS_QUOTE_STATUS_D_TL CODE
ITEM_TYPE_CODE VARCHAR2 32     Type of the sales order line item. DW_CX_QUOTE_LINE_ITEM_TYPE_CODE_D_TL CODE
UOM_CODE VARCHAR2 16     Unit of Measure of the order line. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PRICE_TYPE_CODE VARCHAR2 32     The type of pricing associated with the order line. DW_CXS_PRICE_TYPE_D_TL CODE
PRICE_PERIOD_CODE VARCHAR2 32     The period for which the price associated with the order line is specified. DW_CXS_RECURRING_FREQUENCY_CODE_D_TL CODE
CURRENCY_CODE VARCHAR2 16     The currency the amount on this order line is based on. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CRM_CURRENCY_CODE VARCHAR2 16     Corporate currency code for extensibility DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
WIN_LOSS_STATUS_CODE VARCHAR2 32     Summary-level status of the order line. DW_CXS_WIN_STATUS_D_TL CODE
CONTRACT_START_DATE DATE       The start date of the contract associated with the order line on the sales order.    
CONTRACT_END_DATE DATE       The end date of the contract associated with the order line on the sales order.    
REQUEST_DATE DATE       The requested date for the product on the order line.    
ORDER_DATE DATE       Date on which the order line was ordered.    
CREATION_DATE DATE       indicates the date and time of the creation of the row.    
LAST_UPDATE_DATE DATE       indicates the date and time of the last update of the row    
CONTRACT_START_TIMESTAMP TIMESTAMP       The start date of the contract associated with the order line on the sales order.    
CONTRACT_END_TIMESTAMP TIMESTAMP       The end date of the contract associated with the order line on the sales order.    
REQUEST_TIMESTAMP TIMESTAMP       The requested date for the product on the order line.    
ORDER_TIMESTAMP TIMESTAMP       Date on which the order line was ordered.    
CREATION_TIMESTAMP TIMESTAMP       indicates the date and time of the creation of the row.    
LAST_UPDATE_TIMESTAMP TIMESTAMP       indicates the date and time of the last update of the row    
QUOTE_LINE_NUMBER VARCHAR2 32     Order Line Number for the sales order line. This is a public surrogate key    
OPPORTUNITY_CUSTOMER_PARTY_TYPE VARCHAR2 32     Denormalized Opportunity Customer Party Type    
EXTERNAL_ORDER_LINE_NUMBER VARCHAR2 128     External reference for the Quote Line or Order Line, might not be unique.    
ROOT_LINE_CODE VARCHAR2 16     Indicate if the quote line is of type root DW_CXS_YES_NO_D_TL Code
CURRENCY_CONVERSION_RATE_TYPE VARCHAR2 32     Currency conversion rate type for extensibility    
REVENUE_TYPE_CATEGORY VARCHAR2 32     The Revenue category type of the opportunity revenue line.    
SALES_PRODUCT_TYPE VARCHAR2 32     The type of product that is being sold - warranty, subscription, or training.    
ORDER_NUMBER VARCHAR2 128     Reference to a fulfillment order. It will be null if the transaction is a quote and has not been ordered.    
CREATED_BY VARCHAR2 128     indicates the user who created the row.    
LAST_UPDATED_BY VARCHAR2 128     indicates the user who last updated the row.    
LAST_UPDATE_LOGIN VARCHAR2 64     indicates the session login associated to the user who last updated the row.    
CRM_CONVERSION_RATE NUMBER       This rate is used for conversion of revenue amount to crm common currency for Revenue Forecast Metrics.    
QUANTITY NUMBER       Quantity of the sales order line item.    
UNIT_LIST_PRICE NUMBER       Quantity of the sales order line item.    
PRICE NUMBER       Price of sales order line per unit.    
AMOUNT NUMBER       Total amount of sales order line.    
SUBTOTAL NUMBER       The amount associated with an order line depending on the price type.    
NON_RECURRING_REVENUE NUMBER       Non-Recurring Revenue Amount (Net)    
RECURRING_REVENUE NUMBER       The recurring revenue for the quote line    
USAGE_REVENUE NUMBER       The usage revenue for the quote line    
CONTRACT_VALUE NUMBER       The total amount associated with an order line over the life of the contract.    
DISCOUNT_PERCENTAGE NUMBER       The discount applied to the specific order line in percentage.    
CONTRACT_PERIODS NUMBER 38 0   The number of contract periods associated with the order line.    
NONRECUR_REVENUE_SUMMABLE NUMBER       The non-recurring revenue for the quote line, which can be used for reporting needs, as a summation attribute    
RECUR_REVENUE_SUMMABLE NUMBER       The recurring revenue for the quote line, which can be used for reporting needs, as a summation attribute    
USAGE_REVENUE_SUMMABLE NUMBER       The usage revenue for the quote line, which can be used for reporting needs, as a summation attribute    
CONTRACT_VALUE_SUMMABLE NUMBER       The contract value for the quote line, which can be used for reporting needs, as a summation attribute    
MONTHLY_RECURRING_REVENUE NUMBER       The monthly recurring revenue for the quote line    
MONTHLY_USAGE_REVENUE NUMBER       The monthly usage revenue for the quote line    
CRM_CURRENCY_AMOUNT NUMBER       Total amount of sales order line.    
CRM_CURRENCY_SUBTOTAL NUMBER       The amount associated with an order line depending on the price type.    
CRM_CURRENCY_NON_RECUR_REVENUE NUMBER       Non-Recurring Revenue Amount (Net)    
CRM_CURRENCY_RECUR_REVENUE NUMBER       The recurring revenue for the quote line    
CRM_CURRENCY_USAGE_REVENUE NUMBER       The usage revenue for the quote line    
CRM_CURRENCY_CONTRACT_VALUE NUMBER       The total amount associated with an order line over the life of the contract.    
CRM_CURRENCY_NONRECUR_REVENUE_SUMMABLE NUMBER       The non-recurring revenue for the quote line, which can be used for reporting needs, as a summation attribute    
CRM_CURRENCY_RECUR_REVENUE_SUMMABLE NUMBER       The recurring revenue for the quote line, which can be used for reporting needs, as a summation attribute    
CRM_CURRENCY_USAGE_REVENUE_SUMMABLE NUMBER       The usage revenue for the quote line, which can be used for reporting needs, as a summation attribute    
CRM_CURRENCY_CONTRACT_VALUE_SUMMABLE NUMBER       The contract value for the quote line, which can be used for reporting needs, as a summation attribute    
CRM_CURRENCY_MONTHLY_RECUR_REVENUE NUMBER       The monthly recurring revenue for the quote line    
CRM_CURRENCY_MONTHLY_USAGE_REVENUE NUMBER       The monthly usage revenue for the quote line    
GLOBAL_CURRENCY_AMOUNT NUMBER       Total amount of sales order line.    
GLOBAL_CURRENCY_SUBTOTAL NUMBER       The amount associated with an order line depending on the price type.    
GLOBAL_CURRENCY_NON_RECUR_REVENUE NUMBER       Non-Recurring Revenue Amount (Net)    
GLOBAL_CURRENCY_RECUR_REVENUE NUMBER       The recurring revenue for the quote line    
GLOBAL_CURRENCY_USAGE_REVENUE NUMBER       The usage revenue for the quote line    
GLOBAL_CURRENCY_CONTRACT_VALUE NUMBER       The total amount associated with an order line over the life of the contract.    
GLOBAL_CURR_NONRECUR_REVENUE_SUMMABLE NUMBER       The non-recurring revenue for the quote line, which can be used for reporting needs, as a summation attribute    
GLOBAL_CURRENCY_RECUR_REVENUE_SUMMABLE NUMBER       The recurring revenue for the quote line, which can be used for reporting needs, as a summation attribute    
GLOBAL_CURRENCY_USAGE_REVENUE_SUMMABLE NUMBER       The usage revenue for the quote line, which can be used for reporting needs, as a summation attribute    
GLOBAL_CURR_CONTRACT_VALUE_SUMMABLE NUMBER       The contract value for the quote line, which can be used for reporting needs, as a summation attribute    
GLOBAL_CURRENCY_MONTHLY_RECUR_REVENUE NUMBER       The monthly recurring revenue for the quote line    
GLOBAL_CURRENCY_MONTHLY_USAGE_REVENUE NUMBER       The monthly usage revenue for the quote line    
QUOTE_ACTIVE_VERSION_FLAG VARCHAR2 16     Flag to indicate the active Quote for the Opportunity    
QUOTE_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    
QUOTE_PROPOSAL_EXIST_FLAG VARCHAR2 16     Flag to identify the associated proposal for the Quote    
QUOTE_PLACED_ON_TIMESTAMP TIMESTAMP       Timestamp on which the Order was placed.    
QUOTE_PLACED_ON_DATE DATE       Truncated Placed On Date, can be used for DATE dimension join    
QUOTE_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
QUOTE_EXPIRATION_TIMESTAMP TIMESTAMP       Expiration Timestamp of the Quote or Order    
QUOTE_EXPIRATION_DATE DATE       Truncated Expiration Date of the Quote or Order, can be used for DATE dimension join    
QUOTE_SOLD_CUSTOMER_PARTY_ID NUMBER 38 0   Customer Party Identifier DW_CXS_SALES_ACCOUNT_D PARTY_ID
QUOTE_ACCOUNT_BASED_QUOTE_FLAG VARCHAR2 16     Indicates if the quote is an account based quote.    
QUOTE_OPPORTUNITY_BASED_QUOTE_FLAG VARCHAR2 16     Indicates if the quote is an opportunity based quote.    
QUOTE_CURRENCY_CODE VARCHAR2 16     Currency code for the Quote or Order DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
QUOTE_CRM_CURRENCY_CODE VARCHAR2 16     Corporate currency code for extensibility DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
QUOTE_CRM_CONVERSION_RATE_TYPE VARCHAR2 32     Currency conversion rate type for extensibility DW_CXS_CURRENCY_CONVERSION_RATE_TYP_D_TL CODE
QUOTE_CRM_CONVERSION_RATE NUMBER       This rate is used for conversion of revenue amount to crm common currency for Quote Metrics.    
QUOTE_SALES_ACCOUNT_ID NUMBER 38 0   Sales Account Identifier DW_CXS_SALES_ACCOUNT_D SALES_ACCOUNT_ID
QUOTE_SOLD_CONTACT_PARTY_ID NUMBER 38 0   Customer Contact Party Identifier for Quote DW_CXS_CONTACT_D CONTACT_ID
QUOTE_EXTERNAL_SYSTEM_REFERENCE_CODE VARCHAR2 32     External reference(Third party) type for the Quote or Order    
QUOTE_EXTERNAL_QUOTE_NUMBER VARCHAR2 32     External reference for the Quote or Order, might not be unique    
QUOTE_EXTERNAL_REFERENCE_NUMBER VARCHAR2 128     Identifier for the External Quote or Order    
QUOTE_LAST_OPPORTUNITY_SYNC_TIMESTAMP TIMESTAMP       Last Opportunity Sync date for the quote to identify the Active version of the quote for the opportunity.    
QUOTE_LAST_OPPORTUNITY_SYNC_DATE DATE       Truncated Last Opportunity Sync date for the quote to identify the Active version of the quote for the opportunity.    
QUOTE_DESCRIPTION VARCHAR2 512     Quote or Order Description    
QUOTE_OWNER VARCHAR2 512     Owner of the Quote or Order    
QUOTE_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
QUOTE_CREATION_TIMESTAMP TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
QUOTE_CREATION_DATE DATE       Truncated Creation Date, can be used for DATE dimension join    
QUOTE_LAST_UPDATE_TIMESTAMP TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
QUOTE_LAST_UPDATE_DATE DATE       Truncated last updated date for functional use. Can be used for DATE dimension join    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
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_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_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_LAST_UPDATE_TIMESTAMP TIMESTAMP       Opportunity User last Updated Date    
OPPORTUNITY_LAST_UPDATE_DATE DATE       Opportunity User last Updated Date    

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