Backbar movement-ledger inventory for multi-store retail

Grain Vodka 1.75L (vod-1750)

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
42
Annex Warehouse
hill
16
Capitol Hill
main
20
Downtown
east
34
Eastside
north
14
Northgate

Movements

OccurredLocationKindQty Idempotency keyNote
2026-08-19 03:29 north transfer_in 9 seed-tx-2:in restock
2026-08-19 03:29 east transfer_out -9 seed-tx-2:out restock
2026-08-18 03:29 north sale -7 seed-sale-56-2
2026-08-18 03:29 main sale -5 seed-sale-55-1
2026-08-18 03:29 hill sale -13 seed-sale-54-5
2026-08-15 03:29 hill sale -4 seed-sale-54-3
2026-08-14 03:29 north sale -1 seed-sale-56-6
2026-08-12 03:29 north sale -3 seed-sale-56-0
2026-08-11 03:29 annex adjustment -3 cycle-count:2 cycle count by night crew
2026-08-11 03:29 north sale -3 seed-sale-56-4
2026-08-06 03:29 north sale -3 seed-sale-56-5
2026-08-06 03:29 hill sale -5 seed-sale-54-7
2026-08-06 03:29 hill sale -29 seed-sale-54-0
2026-08-03 03:29 hill sale -11 seed-sale-54-6
2026-08-03 03:29 east sale -8 seed-sale-53-0
2026-08-02 03:29 main sale -12 seed-sale-55-4
2026-07-28 03:29 hill sale -17 seed-sale-54-2
2026-07-28 03:29 hill sale -13 seed-sale-54-1
2026-07-25 03:29 main sale -10 seed-sale-55-0
2026-07-25 03:29 east sale -7 seed-sale-53-2
2026-07-24 03:29 hill sale -8 seed-sale-54-4
2026-07-24 03:29 annex sale -9 seed-sale-52-0
2026-07-23 03:29 main sale -6 seed-sale-55-5
2026-07-23 03:29 main sale -13 seed-sale-55-3
2026-07-22 03:29 main sale -7 seed-sale-55-6
2026-07-22 03:29 hill sale -1 seed-sale-54-8
2026-07-21 03:29 north sale -3 seed-sale-56-1
2026-07-21 03:29 main sale -8 seed-sale-55-2
2026-07-21 03:29 east sale -3 seed-sale-53-1
2026-07-16 03:29 north sale -6 seed-sale-56-3
2026-07-16 03:29 annex sale -5 seed-sale-52-1
2026-07-05 03:29 north receipt 31 seed-po-56 opening receipt
2026-06-14 03:29 hill receipt 117 seed-po-54 opening receipt
2026-06-08 03:29 east receipt 61 seed-po-53 opening receipt
2026-06-07 03:29 main receipt 81 seed-po-55 opening receipt
2026-05-21 03:29 annex receipt 59 seed-po-52 opening receipt