D1 holds the record
The reusable contracts assume append-only observations and explicit effective views, not in-place correction of provider facts.
Architecture
The design separates facts, operational choices, deterministic read models, and agent explanations so one failure does not quietly become financial truth.
Keep what each source actually said.
Resolve supersession, lifecycle, exclusions, and repairs reversibly.
Cashflow, debt, net worth, merchants, transfers, and recurring commitments.
The reusable contracts assume append-only observations and explicit effective views, not in-place correction of provider facts.
Tool results state freshness, coverage, status, provenance, and limitations beside the requested data.
A steward can retry derived work or investigate a case. It cannot make an unsupported row real.