industry-department-solutions
latest
false
- Overview
- API Resources
Supply Chain & Retail Solutions API guide
Last updated Apr 16, 2026
Inventory Management Data Model
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, updated_at | - | Required |
products | product_id, updated_at | - | Required |
suppliers | supplier_id, updated_at | - | Required |
stock | 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, updated_at | product_id → products, location_id → locations | Required |
purchase_orders | order_number, updated_at | product_id → products, location_id → locations | Required |
transfers | product_id, location_id, order_number, updated_at | product_id → products, location_id → locations | Optional. This table can be empty if no transfers exist |
product_extra | product_id, product_extra_id, updated_at | product_id → products | Optional. Tenant-specific product attributes in key-value format |
location_extra | location_id, location_extra_id, updated_at | location_id → locations | Optional. Tenant-specific location attributes in key-value format |
sku_calendar | product_id, location_id, updated_at | product_id → products, location_id → locations | Optional. End date required for discontinued products |
manufacturing_orders | product_id, location_id, order_number, updated_at | product_id → products, location_id → locations | Optional. Historical and planned manufacturing orders |
production_lines | product_id, location_id, production_line_id, created_at | product_id → products, location_id → locations | Optional. Contains production line configurations and capacities |
sales | 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, updated_at | product_id → products, location_id → locations | Either customer orders or sales required. Customer orders is required for fill rate service level modelling |
products_parent_child_mapping | child_id, updated_at | parent_id → products, child_id → products | — |