Backbar movement-ledger inventory for multi-store retail

Blanco Tequila 750ml (tequ-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
10
Annex Warehouse
hill
8
Capitol Hill
main
16
Downtown
east
22
Eastside
north
5
Northgate

Movements

OccurredLocationKindQty Idempotency keyNote
2026-08-19 03:29 hill transfer_in 2 seed-tx-0:in restock
2026-08-19 03:29 north transfer_out -2 seed-tx-0:out restock
2026-08-17 03:29 annex sale -6 seed-sale-43-5
2026-08-15 03:29 east sale -7 seed-sale-44-4
2026-08-15 03:29 east sale -6 seed-sale-44-1
2026-08-13 03:29 east sale -5 seed-sale-44-2
2026-08-12 03:29 main sale -5 seed-sale-46-6
2026-08-12 03:29 hill sale -3 seed-sale-45-3
2026-08-12 03:29 annex sale -7 seed-sale-43-4
2026-08-11 03:29 annex sale -18 seed-sale-43-1
2026-08-10 03:29 hill sale -1 seed-sale-45-1
2026-08-09 03:29 main sale -1 seed-sale-46-3
2026-08-08 03:29 main sale -3 seed-sale-46-4
2026-08-07 03:29 main sale -11 seed-sale-46-5
2026-08-06 03:29 main adjustment -1 cycle-count:1 cycle count by night crew
2026-08-03 03:29 north sale -2 seed-sale-47-3
2026-08-03 03:29 north sale -4 seed-sale-47-0
2026-08-02 03:29 annex sale -25 seed-sale-43-0
2026-08-01 03:29 north sale -2 seed-sale-47-2
2026-07-30 03:29 main sale -11 seed-sale-46-1
2026-07-29 03:29 east sale -17 seed-sale-44-0
2026-07-28 03:29 annex sale -5 seed-sale-43-6
2026-07-25 03:29 hill sale -1 seed-sale-45-2
2026-07-23 03:29 hill sale -1 seed-sale-45-0
2026-07-20 03:29 north sale -2 seed-sale-47-4
2026-07-20 03:29 annex sale -8 seed-sale-43-2
2026-07-19 03:29 north sale -2 seed-sale-47-5
2026-07-19 03:29 east sale -8 seed-sale-44-3
2026-07-18 03:29 north sale -1 seed-sale-47-1
2026-07-12 03:29 main sale -10 seed-sale-46-2
2026-07-12 03:29 main sale -9 seed-sale-46-0
2026-07-12 03:29 annex sale -3 seed-sale-43-3
2026-07-10 03:29 main receipt 67 seed-po-46 opening receipt
2026-07-08 03:29 annex receipt 82 seed-po-43 opening receipt
2026-06-25 03:29 hill receipt 12 seed-po-45 opening receipt
2026-06-14 03:29 north receipt 20 seed-po-47 opening receipt
2026-06-10 03:29 east receipt 65 seed-po-44 opening receipt