Databases

Procurement Orders & Vendor Rating Schema

ER Diagrams · made in Skemio

ER diagram linking procurement requisitions, purchase orders, po lines, item receipts, and vendor rating scorecards.
ER diagram linking procurement requisitions, purchase orders, po lines, item receipts, and vendor rating scorecards.
Open it in SkemioMake your own

What it shows

  • Requisitions convert to POs through a trackable one-to-many relationship.
  • Track receipt quantities against ordered lines to detect partial shipments.
  • Store objective delivery variance metrics to power automated vendor scoring.

The takeaway

Tie receipt line variances directly to vendor scorecards to eliminate manual supplier reviews.

More er diagrams