purchase_orders
Orders placed with suppliers, one per delivery. One row is one order.
- One row is
- one order
- Columns
- 6
- Rows in Sample
- 9,689
- Rows in Standard
- 9,689
- Rows in Full
- 9,689
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 |
|---|---|---|---|
| purchase_order_idkey | integer | Unique id for the row. | |
| supplier_id | integer | Links to suppliers. | |
| ordered_date | date | Day the order was placed. | 2017-12-05 to 2025-12-30 |
| expected_at | date and time | When the delivery was due. | 2018-01-01 07:00 to 2025-12-31 07:00 |
| received_at | date and time | When it arrived. More than an hour after expected_at counts as late. | 2018-01-01 06:50 to 2025-12-31 07:02 |
| order_total | decimal | Value of the order in dollars. | 0 to 376,708.67 |
How it connects
This table points to
- supplier_id matches suppliers.supplier_id
Tables that point here
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| purchase_order_id | supplier_id | ordered_date | expected_at | received_at | order_total |
|---|---|---|---|---|---|
| 600001 | 2 | 2017-12-31 | 2018-01-01 07:00:00 | 2018-01-01 06:58:11 | 9061.99 |
| 600002 | 3 | 2017-12-29 | 2018-01-01 07:00:00 | 2018-01-02 06:42:16 | 25983.62 |
| 600003 | 4 | 2017-12-30 | 2018-01-01 07:00:00 | 2018-01-01 06:59:18 | 23435.94 |
| 600004 | 6 | 2017-12-31 | 2018-01-01 07:00:00 | 2018-01-01 06:50:05 | 20360.78 |
| 600005 | 1 | 2017-12-30 | 2018-01-02 07:00:00 | 2018-01-02 06:46:45 | 105584.69 |