maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Per-day stock position by product × warehouse. Unique constraint (product_id, warehouse_code, snapshot_date) means re-seeding is deterministic. Drives inventory-health metrics (stockout risk, days-of-cover, under-reorder count).
8 of 8
Column
Description
Tests · PII
snapshot_id
Primary key — BIGSERIAL.
2 tests
product_id
FK to `products.product_id`. NOT NULL.
1 test
warehouse_code
`us-west` / `us-east` / `eu-central`.
1 test
snapshot_date
Date the snapshot was taken.
1 test
on_hand_qty
Units physically on hand. Non-negative.
reserved_qty
Units allocated to in-flight orders. Non-negative.
reorder_point
Threshold below which a reorder fires.
created_at
Row insert timestamp in the source DB.