Issue: Proper handling of unauthenticated (future) notes throughout the transaction pipeline

Issue: Proper handling of unauthenticated (future) notes throughout the transaction pipeline: a task in LegoFlow-SWE (Harbor dataset). All existence checks must consult the canonical persistent storage, not an in‑memory cache.