purchase_order_lines
Items on each purchase order. One row is one stock item on one order.
- One row is
- one stock item on one order
- Columns
- 6
- Rows in Sample
- 81,350
- Rows in Standard
- 81,350
- Rows in Full
- 81,350
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 |
|---|---|---|---|
| po_line_idkey | integer | Unique id for the row. | |
| purchase_order_id | integer | Links to purchase_orders. | |
| item_id | integer | The stock item. Links to inventory_items. | |
| quantity | decimal | Units ordered and received. | 0.1 to 26,231 |
| unit_cost | decimal | Cost per unit in dollars. | 0.7 to 157.42 |
| line_amount | decimal | Quantity times unit cost. | 5.03 to 93,544.7 |
How it connects
This table points to
- purchase_order_id matches purchase_orders.purchase_order_id
- 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.
| po_line_id | purchase_order_id | item_id | quantity | unit_cost | line_amount |
|---|---|---|---|---|---|
| 6000001 | 600001 | 5010 | 305.8 | 9.5 | 2905.1 |
| 6000002 | 600001 | 5011 | 252.9 | 1.3 | 328.77 |
| 6000003 | 600001 | 5012 | 602.3 | 8.4 | 5059.32 |
| 6000004 | 600001 | 5013 | 24.8 | 31 | 768.8 |
| 6000005 | 600002 | 5014 | 5.1 | 128 | 652.8 |