industry-department-solutions
latest
false
Supply Chain & Retail Solutions API guide
- Overview
- API Resources
Entity Relationship Diagram (ERD) for the Rebuy & Replenishment data model, showing relationships between locations, products, stock, orders, and supplier entities.
This data model supports the Rebuy & Replenishment capability of the Merchandising solution. For a full overview of the solution, see About the Merchandising Solution.
Tables Summary
| Table | Primary Key | Foreign Keys | Required |
|---|---|---|---|
locations | location_id | - | Required |
products | product_id | - | Required |
suppliers | supplier_id | - | Required |
stock_daily | product_id, location_id, day_date | product_id → products, location_id → locations | Required |
pricing | product_id, location_id, created_at | product_id → products, location_id → locations | Required |
order_parameters | product_id, location_id | product_id → products, location_id → locations | Required |
purchase_orders | order_number | product_id → products, location_id → locations | Required |
sales_daily | product_id, location_id, day_date | product_id → products, location_id → locations | Required |
transfers | product_id, location_id, order_number | product_id → products, location_id → locations | Optional. This table can be empty if no transfers exist |
product_extra | product_id, product_extra_id | product_id → products | Optional. Tenant-specific product attributes in key-value format |
sku_calendar | product_id, location_id | product_id → products, location_id → locations | Optional. End date required for discontinued products |
products_parent_child_mapping | child_id | parent_id → products, child_id → products | Optional. Parent-child relationships between products for substitution and hierarchy modelling |