C03
Inventory
Real-time visibility. Better control. Greater efficiency.
asking the database…
Total Inventory Value
—
asking…
Total Quantity
—
asking…
Active SKUs
—
asking…
Low Stock Items
—
no threshold in the schema
Locations
—
asking…
MaterialSpecificationLocationAvailableReservedOn OrderTotalStatus
asking metalzone.curiopal.com/api for the inventory list…
One row per specification with items on the floor. Available, reserved and held are the item statuses summed; on order is the open purchase expectations for the specification; reserved is 0 because the ledger holds no reservation or allocation. "Low Stock" is never printed: no reorder level exists in the schema.
Material Details
select a row
asking…
Inventory by Category
no item carries a landed cost
every row is aluminium (material_family has one value); the board's steel, zinc, copper, nickel and tungsten categories are outside the catalog's scope
Stock Trend
inflow per month: RECEIVED events on the ledger, in tonnes. Not a month-end quantity series: the ledger holds no snapshots
no RECEIVED event on the ledger