transactions
Register sales at every venue. One row is one sale.
- One row is
- one sale
- Columns
- 16
- Rows in Sample
- 214,462
- Rows in Standard
- 2,147,571
- Rows in Full
- 21,438,303
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| transaction_idkey | integer | Unique id for the row. | |
| transacted_at | date and time | When the order was placed. | 2018-01-01 06:30 to 2025-12-31 23:04 |
| venue_id | integer | The restaurant, bar, stand or shop. Links to venues. | |
| employee_id | integer | The cashier. Links to employees. | |
| household_id | integer | The household, when the sale could be tied to one. Empty for walk-up visitors. Can be empty. | |
| booking_id | integer | The trip the sale happened on, when known. Can be empty. | |
| order_channel | text | Counter, table or mobile order. | counter; mobile order; table service |
| payment_method | text | How it was paid. The two register systems label the same methods differently. | AMEX; CASH; Card; Cash; DISC; GIFT; Gift Card; MC; MOBILE; Mobile Wallet; ROOM; Room Charge; VISA |
| guests_served | integer | People the order was for. Can be empty. | 1 to 9 |
| subtotal | decimal | Sum of the lines before discount and tax. | 3.25 to 1,044 |
| discount_amount | decimal | Discount taken off. | 0 to 103.04 |
| discount_code | text | Promotion applied. Links to promotions. Can be empty. | MOBILE5; PASSHOLDER |
| tax_amount | decimal | Sales tax. | 0.21 to 73.08 |
| total_amount | decimal | Amount charged: subtotal less discount plus tax. | 3.14 to 1,117.08 |
| ready_at | date and time | When a food order was ready. Empty for shops. Can be empty. | 2018-01-01 06:32 to 2025-12-31 23:02 |
| source_system | text | Register system that recorded the sale. | LegacyPOS; VelaluzPOS |
How it connects
This table points to
- venue_id matches venues.venue_id
- employee_id matches employees.employee_id
- household_id matches households.household_id
- booking_id matches bookings.booking_id
- discount_code matches promotions.promo_code
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.
| transaction_id | transacted_at | venue_id | employee_id | household_id | booking_id | order_channel | payment_method | guests_served | subtotal | discount_amount | discount_code | tax_amount | total_amount | ready_at | source_system |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101048797 | 2018-06-16 13:40:48 | 106 | 215853 | 1061907 | 5092443 | counter | ROOM | 17 | 0 | 1.19 | 18.19 | 2018-06-16 13:45:21 | LegacyPOS | ||
| 101048807 | 2018-06-16 13:41:24 | 202 | 215782 | counter | CASH | 30 | 0 | 2.1 | 32.1 | 2018-06-16 13:44:23 | LegacyPOS | ||||
| 101048849 | 2018-06-16 13:44:34 | 209 | 200008 | 1106907 | counter | VISA | 122.47 | 12.25 | PASSHOLDER | 7.72 | 117.94 | 2018-06-16 13:52:07 | LegacyPOS | ||
| 101048907 | 2018-06-16 13:49:44 | 506 | 207468 | counter | VISA | 44.48 | 0 | 3.11 | 47.59 | 2018-06-16 13:54:59 | LegacyPOS | ||||
| 101049007 | 2018-06-16 13:58:04 | 512 | 209311 | counter | VISA | 90.98 | 0 | 6.37 | 97.35 | LegacyPOS |