transaction_lines
The items on each sale. One row is one product on one sale.
- One row is
- one product on one sale
- Columns
- 7
- Rows in Sample
- 759,979
- Rows in Standard
- 7,589,538
- Rows in Full
- 75,761,789
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| line_idkey | integer | Unique id for the row. | |
| transaction_id | integer | The register sale. Links to transactions. | |
| product_id | integer | The item sold to guests. Links to products. | |
| quantity | integer | Units sold. | 1 to 9 |
| unit_price | decimal | Price per unit in dollars. | 3.25 to 144.99 |
| line_amount | decimal | Quantity times unit price. | 3.25 to 778 |
| pos_category_code | text | Category code exactly as the register recorded it at the time. |
How it connects
This table points to
- transaction_id matches transactions.transaction_id
- product_id matches products.product_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| line_id | transaction_id | product_id | quantity | unit_price | line_amount | pos_category_code |
|---|---|---|---|---|---|---|
| 301048702 | 100292807 | 10242 | 1 | 5 | 5 | FB-SNK |
| 301048703 | 100292807 | 10239 | 1 | 5 | 5 | FB-SNK |
| 301049046 | 100292907 | 10147 | 1 | 12.5 | 12.5 | FB-ENT |
| 301049047 | 100292907 | 10154 | 1 | 14.5 | 14.5 | FB-ENT |
| 301049048 | 100292907 | 10162 | 2 | 7.5 | 15 | FB-KID |