USDA Commodity Manager Flow

Pillar 11 of 11 · Filtered to USDA items + customers + conditions · 11 tools · Single-model

01 User Input 02 USDA Filter 03 Tool Layer 04 Filtered Sources 05 Response User Question "Open USDA POs?" Pillar = usda_ commodity_manager R85 ROLE_FILTERS · USDA scope Filter: USDA claim list_items_by_claim('usda_commodity') Filter: USDA customers school districts · SY classifier get_commodity_ program active USDA programs get_sales_order + get_purchase_order filtered to USDA items get_invoice + get_vendor_ bill + get_customer_payment filtered transactions get_inventory_ movements + WO/IR/IF list_open_work_orders transactions (USDA) filtered subset items (USDA flag) spec_items.claims inventory_ movements + WO USDA item subset Citations API USDA program refs Response USDA-scoped report ai_audit_log + chat_messages Legend User UI Worker / agent D1 table / store CF binding Tool / action External system Policy / gate

Tools available (11)

  • • get_sales_order · get_purchase_order
  • • get_invoice · get_vendor_bill
  • • get_customer_payment · get_check
  • • get_inventory_movements
  • • list_open_receipts / fulfillments / WOs
  • • get_commodity_program
  • • list_items_by_claim

Filter dimensions

  • • Items: spec_items.claims contains 'usda_commodity'
  • • Customers: school districts (SY classifier)
  • • Programs: active USDA contracts
  • • Conditions: USDA-specific (BB pancakes, etc.)

Cross-pillar overlap

  • • Order mgmt + Inventory + Production = filtered subset
  • • USDA drawdown (FIFO barrel cheddar) is here
  • • Brown Box pancakes bid lives here

Workflow diagram • Built with Archify • Press T for theme and E for export