Pricing Cascade — Master Meta-Diagram

How 3 pipelines interlock · sources → orchestrators → HITL queue → drain → D1+NS → verify

01 / Source Signals 02 / Workflow Orchestrators 03 / HITL — proposed_actions Queue 04 / Apply — Drain Handlers 05 / Persist — D1 + NetSuite 06 / Verify — Reconciliation NetSuite vendor_bill · PO · invoice · SO Dropbox spec sheets · bid intake · pricing AI agents Council v2 · pattern intent Mike (admin) manual · X-Edit-Token vendor_cost_review price-update-pipeline new_spec workflow spec intake → versions annual_roll src/annual_roll_workflow.ts proposed_actions single HITL queue · all writes proposed-actions.html review · diff · approve /decide gate X-Edit-Token · ADR-031 drain handlers bulk_cost_basis · price_change · spec pricing_snapshots immutable change record NS_PUSH_QUEUE all NS writes go here D1 canonical pricing_master · spec_items · 109 tables spec_versions immutable spec history NetSuite write OAuth1 TBA · price + spec records sync_reconciliation D1 ↔ NS drift log audit_netsuite_coverage every NS write verified llm_wiki refresh Pillar 4 narrative + decision corpus vendor_bill delta SY data spec PDF kickoff HITL gate approve OAuth1 mirror-back Pillar 4 learn Legend User UI Agent logic Policy Tool action Context / trace

Three interlocking pipelines

  • • 1 · vendor_cost_review (price-update-pipeline.html)
  • • 2 · new_spec workflow (new-ingredient-spec-workflow.html)
  • • 3 · annual_roll (annual-bid-rollover.html · CF Workflow)
  • • All three feed the same proposed_actions queue

Single HITL gate

  • • proposed_actions is the ONE write-back queue (ADR-031)
  • • proposed-actions.html is the single review surface
  • • X-Edit-Token enforced on /decide for every action
  • • Standing invariant: HITL on every NS write

Apply path

  • • drain handlers process approved actions
  • • Snapshot first (pricing_snapshots · spec_versions)
  • • Then UPDATE D1 canonical state
  • • Then enqueue NS_PUSH_QUEUE for OAuth1 TBA write
  • • No path writes to NS without going through NS_PUSH_QUEUE

Verify path

  • • sync_reconciliation logs D1 ↔ NS drift
  • • audit_netsuite_coverage verifies every NS write
  • • llm_wiki absorbs outcomes (Pillar 4 narrative)
  • • Mirror-back wait per ADR-019 (30m settle)