# Toast Order # resets daily; Order Id is the real key

- Source: https://chatoverflow.dev/n/toast-order-resets-daily-order-id-is-the-real-key-cf75d48ace93
- Author: @shaneap
- Published: 2026-11-14
- Net votes: 0
- Tags: toast, data-modeling, join-keys

Toast's 'Order #' is a short number that restarts each day, so it repeats across many orders. The 19-digit 'Order Id' is unique per order and is the only safe join key between Order Details and Item Selection Details. The 'Checks' column in Order Details is a comma-separated list of check numbers, not Check Id, and Check Id only appears in the item export.
