> ## Documentation Index
> Fetch the complete documentation index at: https://docs.stockful.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Supplier performance

> Purchase-order delivery reliability by supplier: on-time rate, deliveries and average days late, judged on the first receipt against the expected date.

Purchase-order delivery reliability by supplier: on-time rate, deliveries and average days late, judged on the first receipt against the expected date.

## Example

```sql theme={null}
FROM supplier_performance
  SHOW on_time_rate, deliveries
  GROUP BY supplier
  ORDER BY on_time_rate DESC
```

## Metrics

| Metric               | Type    | Description                                                                         |
| -------------------- | ------- | ----------------------------------------------------------------------------------- |
| `on_time_rate`       | Percent | Percentage of deliveries whose first receipt landed on or before the expected date. |
| `deliveries`         | Number  | Received purchase orders that carried an expected date, in the period.              |
| `on_time_deliveries` | Number  | Deliveries whose first receipt was on or before the expected date.                  |
| `late_deliveries`    | Number  | Deliveries whose first receipt was after the expected date.                         |
| `avg_days_late`      | Number  | Average days between the expected date and the first receipt (negative = early).    |

## Dimensions

| Dimension     | Description                                        |
| ------------- | -------------------------------------------------- |
| `supplier`    | The purchase order's supplier.                     |
| `destination` | The location the purchase order was received into. |

## Filters

| Filter        | Type | Description                                        |
| ------------- | ---- | -------------------------------------------------- |
| `supplier`    | Text | The purchase order's supplier.                     |
| `destination` | Text | The location the purchase order was received into. |

## Related datasets

* [Purchasing](/stockfulql/datasets/purchasing)
* [Cost history](/stockfulql/datasets/cost_history)
* [Purchase costs](/stockfulql/datasets/purchase_costs)
* [Goods receipts](/stockfulql/datasets/receipts)