Inventory Management Data Model

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