DW_CXS_QUOTE_LINES_CF

Quote Lines 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 This column is for Oracle Internal use only. 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 Time
OPPORTUNITY_LAST_UPDATE_DATE DATE Opportunity User last Updated Date