industry-department-solutions
latest
false
Supply Chain & Retail Solutions API guide
- Overview
- API Resources
Entity Relationship Diagram (ERD) for the Inventory Management data model, showing relationships between locations, products, stock, orders, and supplier entities.
This data model supports the Inventory Management solution. For a full overview of the solution, see About the Inventory Management 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 |
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 |
manufacturing_orders | product_id, location_id, order_number | product_id → products, location_id → locations | Optional. Historical and planned manufacturing orders |
sales_daily | product_id, location_id, day_date | product_id → products, location_id → locations | Either customer orders or sales required |
customer_orders | order_id, order_line_id | product_id → products, location_id → locations | Either customer orders or sales required. Customer orders is required for fill rate service level modelling |
forecast | product_id, location_id, cutoff_date, start_date | product_id → products, location_id → locations | Optional. Demand forecast records per product and location |