Soft red winter wheat across the Maumee/Toledo group — Maumee Conant (5110), Maumee Illinois (5116), Maumee Edwin (5123), and Maumee Kuhlman (5124). Same facilities rolled up in the Toledo/Maumee section of the grain receipts page (Reynolds excluded).
Data: gold/toledo_facility_daily_inventory.parquet,
gold/toledo_facility_open_contracts.parquet,
gold/toledo_facility_recent_flows.parquet
Inventory is rebuilt from SAP month-end stock balances
(mardh) re-anchored each month plus the day-to-day net of goods
movements (mseg), summed across every storage bin. The "All
Maumee/Toledo" line sums the four facilities, so transfers between them net out.
Only owned unrestricted stock is counted — consignment and
other non-owned positions are excluded, because that is what the SAP stock
balance reports. With that filter the reconstructed line ties to each month-end
balance and to the live stock snapshot exactly.
The Stock column on the flows table flags whether a movement is
Owned grain (which moves inventory) or Vendor consignment / other
non-owned stock. Consignment receipts and issues typically pair up when we make a
CME futures delivery — the buyer owns grain sitting in our warehouse —
so they appear as large offsetting 501/601 flows that do
not change owned inventory.
Open contracts come from the contract delivery schedule; each
row is identified by its contract number and shows the open balance,
delivery window, and price. Recent flows roll up goods movements
to one row per day, facility, bin, and movement type; each row lists the
ticket count, the material-document range
(from – to), and the purchase order / delivery
document behind it. Use those numbers to pull the underlying detail.
Common movement types: 101 goods receipt vs a purchase order (grower
truck receipts), 102 receipt reversal, 601 goods issue
against a delivery (shipment out), 301/311 transfers between plants /
bins, 501/502 receipt without a purchase order and its reversal (used
for positioning / futures-delivery bookings), 941/962 inventory
adjustments.