industry-department-solutions
latest
false
Supply Chain & Retail Solutions API guide
- Overview
- API Resources
Entity Relationship Diagram (ERD) for the B2B pricing (quote pricing) data model, showing relationships between customers, merchants, products, and quote lines.
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 |