Backbar movement-ledger inventory for multi-store retail

London Dry Gin 750ml (gin-750)

Every row below is a fact that was written once and never edited. The on-hand figures are the sum of these rows and are computed at read time.

annex
21
Annex Warehouse
hill
11
Capitol Hill
main
31
Downtown
east
13
Eastside
north
58
Northgate

Movements

OccurredLocationKindQty Idempotency keyNote
2026-08-19 03:29 annex transfer_in 5 seed-tx-5:in restock
2026-08-19 03:29 north transfer_out -5 seed-tx-5:out restock
2026-08-19 03:29 hill transfer_in 11 seed-tx-1:in restock
2026-08-19 03:29 east transfer_out -11 seed-tx-1:out restock
2026-08-18 03:29 east sale -8 seed-sale-16-1
2026-08-16 03:29 north sale -11 seed-sale-18-1
2026-08-15 03:29 annex sale -27 seed-sale-15-1
2026-08-12 03:29 annex sale -6 seed-sale-15-4
2026-08-11 03:29 annex sale -13 seed-sale-15-3
2026-08-10 03:29 north sale -21 seed-sale-18-3
2026-08-10 03:29 main sale -7 seed-sale-17-1
2026-08-09 03:29 north sale -12 seed-sale-18-2
2026-08-08 03:29 main sale -2 seed-sale-17-3
2026-08-07 03:29 east sale -5 seed-sale-16-5
2026-08-05 03:29 annex sale -10 seed-sale-15-5
2026-08-04 03:29 east sale -3 seed-sale-16-4
2026-08-03 03:29 main sale -1 seed-sale-17-5
2026-08-03 03:29 annex sale -8 seed-sale-15-7
2026-08-02 03:29 east sale -2 seed-sale-16-8
2026-08-02 03:29 east sale -17 seed-sale-16-2
2026-07-30 03:29 north sale -8 seed-sale-18-0
2026-07-27 03:29 east sale -1 seed-sale-16-3
2026-07-27 03:29 annex sale -4 seed-sale-15-6
2026-07-22 03:29 main sale -9 seed-sale-17-0
2026-07-21 03:29 east sale -2 seed-sale-16-7
2026-07-19 03:29 annex sale -11 seed-sale-15-0
2026-07-18 03:29 main sale -16 seed-sale-17-2
2026-07-16 03:29 main sale -10 seed-sale-17-4
2026-07-15 03:29 east sale -26 seed-sale-16-0
2026-07-12 03:29 annex sale -11 seed-sale-15-2
2026-07-11 03:29 east sale -7 seed-sale-16-6
2026-07-10 03:29 east receipt 95 seed-po-16 opening receipt
2026-06-13 03:29 north receipt 115 seed-po-18 opening receipt
2026-05-28 03:29 annex receipt 106 seed-po-15 opening receipt
2026-05-23 03:29 main receipt 76 seed-po-17 opening receipt