Two date fields. Two different answers.

The agent was asked for this month's revenue. The schema had two date fields: order_date and payment_date. Both are timestamps. Neither has a description. The agent used order_date and returned $4.2M. Finance uses payment_date. Their number was $2.8M.

Order_date is when the contract was signed, the date on the order, and the one most queries reach for. Payment_date is when cash was received. This is what appears in the board deck. The $1.4M gap is three large contracts signed in the period but not yet paid.

Both fields say timestamp in the schema. There is no description on either, no label indicating which one Finance uses for revenue reporting, no annotation pointing to payment_date as the board-approved date.

Amount is a float. The schema says nothing about which date field it should be paired with for board-level reporting. The agent made a defensible choice from what the schema gave it. The schema gave it nothing that would point to payment_date.

The agent returned a confident answer. The schema contained no record of which date field Finance uses.