industry-department-solutions
latest
false
- Overview
- API Resources
Supply Chain & Retail Solutions API guide
Last updated Apr 16, 2026
Quote Pricing Data Model
This data model supports the Commercial Pricing solution. For a full overview of the solution, see About the Commercial Pricing Solution.
Tables Summary
| Object | Primary Key | Foreign Keys | Required |
|---|---|---|---|
customer | customer_id, updated_at | - | Yes |
merchant | merchant_id, updated_at | - | No |
product | product_id, updated_at | - | Yes |
project | project_id, updated_at | - | No (highly recommended) |
region | region_id, updated_at | - | Yes |
competitor_price | product_id, region_id, updated_at | product_id → product, region_id → region | No |
list_price | product_id, region_id, price_list_id, updated_at | product_id → products, region_id → region | Yes |
product_cost | product_id, region_id, updated_at | product_id → product, region_id → region | Yes |
quote_line | quote_id, product_id | product_id → product, customer_id → customer, merchant_id → merchant, project_id → project, region_id → region | Yes |
sale | sale_id, product_id | product_id → product, customer_id → customer, merchant_id → merchant, quote_id → quote_lines | Yes |