UiPath Documentation
industry-department-solutions
latest
false

Supply Chain & Retail Solutions user guide

Quote line dataset

The Quote Line dataset contains detailed line-item information for customer quotes. It represents individual pricing decisions made during the quoting process and provides the core behavioral data used to analyze quote performance.

This dataset is required for application deployment and pricing insights analysis.

→ For the canonical technical schema (data types, validation rules, request/response examples), see Quote Line in the API Guide.

Purpose

The commercial pricing solution uses the Quote Line dataset to:

  • Analyze quoted prices at the product and customer level
  • Evaluate win/loss behavior in response to pricing decisions
  • Measure discounting patterns relative to list price
  • Support pricing recommendations for future quotes

This dataset is essential for Quote Pricing use cases.

Required fields

About the Nullable column: every field below must appear in your data. Nullable: Yes means the field can be sent as null (or left blank in your source) when no value is available; Nullable: No means a non-null value is required for every row.

FieldDescriptionTypeNullable
quote_idUnique identifier for each quote.stringNo
product_idUnique identifier of the product. Used to join product metadata to the table.stringNo
original_quote_idUnique identifier of the original quote being replaced. Used to track re-negotiated quotes through the pricing lifecycle.stringYes
quote_statusStatus of the quote (won, lost, pending, or archived). Used in model training to learn which quotes converted.stringYes
price_list_idPrice list used for this quote.stringYes
quoted_atTimestamp when the record was quoted. Used in model training to understand seasonal effects on the optimal quote price.timestamp_tzYes
decided_atTimestamp when the quote was decided — when it was won, lost, cancelled, or replaced.timestamp_tzYes
customer_idUnique identifier of the customer. Used to join customer metadata to the table.stringYes
merchant_idUnique identifier of the merchant. Used to join merchant metadata to the table.stringYes
project_idUnique identifier of the project. Used to join project metadata to the table.stringYes
region_idUnique identifier of the region the quote applies to. Used as a model feature, since optimal prices vary by region.stringYes
quantityQuantity of the product in the quote. Used as a feature in model training as the quantity demanded impacts the optimal price.floatYes
selling_priceSelling price for the product. The price on the quotation for the product. Used to calculate the discount applied to the quote for model training.floatYes

Usage notes

  • All referenced identifiers (product_id, customer_id, merchant_id, project_id) must exist in their corresponding datasets.
  • Quote lines should reflect actual quoted pricing behavior, not list prices.
  • Quote stage information helps differentiate early-stage quotes from finalized quotes.
  • Historical quote data improves pricing model accuracy and recommendation stability.
  • Units of measure must align with related datasets (Products, Sales).
  • Purpose
  • Required fields
  • Usage notes

Was this page helpful?

Connect

Need help? Support

Want to learn? UiPath Academy

Have questions? UiPath Forum

Stay updated