inventory_daily
Stock position of every item at the central warehouse, every day. One row is one stock item on one day.
- One row is
- one stock item on one day
- Columns
- 7
- Rows in Sample
- 449,988
- Rows in Standard
- 449,988
- Rows in Full
- 449,988
This table describes the company, not individual guests, so it is identical in all three sizes.
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| item_idkey | integer | The stock item. Links to inventory_items. | |
| datekey | date | The day. Links to calendar. | |
| opening_quantity | decimal | On hand at the start of the day. | 0 to 21,938.95 |
| received_quantity | decimal | Delivered that day. | 0 to 26,231 |
| used_quantity | decimal | Used that day, worked out from what was sold and the recipes. | 0 to 8,684.08 |
| wasted_quantity | decimal | Thrown out that day. | 0 to 1,512.22 |
| closing_quantity | decimal | On hand at the end of the day: opening plus received less used less wasted. | 0 to 21,938.95 |
How it connects
This table points to
- item_id matches inventory_items.item_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| item_id | date | opening_quantity | received_quantity | used_quantity | wasted_quantity | closing_quantity |
|---|---|---|---|---|---|---|
| 5001 | 2018-01-01 | 186.17 | 0 | 168.79 | 0 | 17.38 |
| 5001 | 2018-01-02 | 17.38 | 564.1 | 177.47 | 1.74 | 402.27 |
| 5001 | 2018-01-03 | 402.27 | 0 | 174.57 | 0 | 227.7 |
| 5001 | 2018-01-04 | 227.7 | 0 | 165.89 | 0 | 61.81 |
| 5001 | 2018-01-05 | 61.81 | 644.4 | 115.74 | 6.18 | 584.29 |