Quote Lines Fact
Module: Common CRM
QUOTE_LINE_ID
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 |
Copyright © 2019, 2024, Oracle and/or its affiliates.