Field schema
The eight fields, exactly as designed in the future-state exhibit
Each field answers one operating question. Together they turn a scattered signal into a visible, owned, time-bound piece of work.
System signal
Control layer
Human owner
Guardrail / escalation
Order IDThe shared key. Connects storefront, 3PL, CS, and inventory records to one exception row.
Exception categoryOne of five: inventory mismatch, 3PL delay, address, partial shipment, damage. Categories drive owner rules.
OwnerThe person or role accountable for the next action. Never blank. Assigned by rule, not by whoever noticed first.
SLA ageThe clock starts when risk is detected, not when the customer emails. Aging drives the daily review order.
Customer impactCustomer-safe status and urgency level. CS can answer before the customer asks, without exposing internal detail.
Next actionWhat happens next, by whom, by when. If this field is empty, the exception is not being worked.
Escalation thresholdFounder sees only high-dollar, aging, VIP, blocked, or repeat issues. Routine queue noise stays off the founder's desk.
Resolution codeThe final code on every closed exception. Feeds reporting, prevention work, and 3PL accountability.