These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- SCM with Supplier Portal
- Data model
The tables behind SCM with Supplier Portal
SCM with Supplier Portal ships with 50 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 50
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Organization and access
Organizations, Users, team members, Departments and cost centers define identity and buying scope.
Supplier and catalog
Suppliers, supplier contacts, supplier certifications, Categories, Items and contract rates identify eligible buying options.
Demand and sourcing
Purchase requests, purchase lines, purchase requisitions, requisition lines, RF qs and RFQ responses retain need and quotes.
Orders and commitment
Purchase orders, PO line items, master agreements, blanket releases, PO amendments and commitment allocations preserve authorized scope and changes.
Receipt and evidence
Receipts, receipt line items, supplier returns, match exceptions, supplier performance and procurement events trace delivery and review.
Every table, by feature
- Purchase requests and review8
- Supplier relationships6
- Requisitions and sourcing10
- Orders and commitments11
- Receiving and exceptions9
- Performance and evidence8
- Shared and settings8
- Purchase requests
Reviewed demand records that drive supplier commitment.
Linked to Organizations, Team members, Suppliers - Purchase lines
Requested and accepted line detail for each purchase request.
Linked to Purchase requests - Review decisions
Independent reviewer decisions on a frozen source revision.
Linked to Purchase requests, Team members - Record attachments
Supporting evidence files linked to a purchase request.
Linked to Purchase requests, Team members - Supplier acknowledgements
Supplier confirmations and change requests awaiting buyer review.
Linked to Purchase requests, Organizations - Operation receipts
Idempotent record of each guarded operation and its persisted effects.
Linked to Purchase requests - Organizations
Buying organizations that own supplier-portal records.
- Team members
Internal buyers, approvers and auditors with organization scope.
Linked to Organizations, Users 2
- Suppliers
Supplier master: legal vendor identity ordered from and paid through accounts payable.
Linked to Suppliers, Users, Migration batches, Organizations - Supplier contacts
Buyer-facing contacts at the supplier: sales rep, customer service, AR, expediter.
Linked to Suppliers - Supplier certifications
Configured supplier qualification evidence reviewed for activity, location and validity period.
Linked to Suppliers, Users - Categories
Purchasing taxonomy aligned to UNSPSC.
Linked to Categories - Users
Internal user directory for everyone who requests, approves, buys or receives.
Linked to Departments, Cost centers, Users, Suppliers - Organizations
Buying organizations that own supplier-portal records.
- Purchase requisitions
Requisition header: a department user's request to buy something.
Linked to Users, Departments, Cost centers, Purchase orders - Requisition lines
Per-item lines on a requisition: what the requester wants, when, and against which budget.
Linked to Purchase requisitions, Items, Suppliers, Categories - Spend approvals
Versioned authority request and frozen decision for a complete source revision.
Linked to Purchase requisitions, Purchase orders, PO amendments, Master agreements - RF qs
Request-for-quote header for sourced spend that needs a competitive bid.
Linked to Purchase requisitions, Users, Suppliers, RFQ responses - RFQ lines
What is being sourced, one line per item or service.
Linked to RF qs, Items, Requisition lines, Categories - RFQ invited suppliers
The supplier invite list for an RFQ.
Linked to RF qs, Suppliers - RFQ responses
A supplier response revision to an RFQ.
Linked to RF qs, Suppliers, Users, RFQ responses - RFQ response lines
Per-line quoted detail: what the supplier proposed for each requested line.
Linked to RFQ responses, RFQ lines, Items - Bid comparison scores
Computed score per response: normalised price, lead time and quality weighted by RFQ weights.
Linked to RF qs, RFQ responses, Supplier performance - Suppliers
Supplier master: legal vendor identity ordered from and paid through accounts payable.
Linked to Suppliers, Users, Migration batches, Organizations
- Purchase orders
Supplier order with immutable approved revisions.
Linked to Suppliers, Purchase requisitions, RFQ responses, Master agreements - PO line items
Per-item lines on a PO, the level at which receipts and invoice match reconcile.
Linked to Purchase orders, Items, Contract rates, Categories - PO amendments
A reviewed change to an issued or approved PO revision.
Linked to Purchase orders, Users, Spend approvals, Procurement events - PO amendment lines
Per-line before and after on an amendment.
Linked to PO amendments, PO line items, Items, Categories - Master agreements
Umbrella contracts with one supplier authorising a total commitment, called off by blanket releases.
Linked to Suppliers, Categories, Departments, Users - Blanket releases
Call-offs against a Master Agreement umbrella that draw down Total Commit.
Linked to Master agreements, Suppliers, Purchase orders, Users - Blanket release lines
The items called off on a release, each priced at a contract rate under the agreement.
Linked to Blanket releases, Items, Contract rates, Categories - Contract rates
Negotiated Supplier x Item prices valid for a date window.
Linked to Suppliers, Items, Master agreements, Users - Commitment allocations
Immutable signed effects of a business event on a PO line and its funding authority.
Linked to Procurement events, Purchase orders, PO line items, Spend approval lines - Expediting
The expediting worklist: open PO lines past Need By Date or inside the warning window.
Linked to Purchase orders, PO line items, Suppliers, Users - Procurement events
Durable once-only business event and migration provenance.
Linked to Purchase orders, Receipts, Supplier returns, Migration batches
- Receipts
Physical arrival or service acceptance against a PO.
Linked to Purchase orders, Suppliers, Users, Locations - Receipt line items
Per-line received quantity against a PO line.
Linked to Receipts, PO line items, Items, Users - Supplier returns
Controlled return of rejected arrivals or previously accepted goods.
Linked to Receipts, Receipt line items, Purchase orders, Suppliers - Match exceptions
A mismatch returned by accounts payable when the invoice disagrees with order or receipt.
Linked to Purchase orders, PO line items, Receipts, Suppliers - Purchase orders
Supplier order with immutable approved revisions.
Linked to Suppliers, Purchase requisitions, RFQ responses, Master agreements - PO line items
Per-item lines on a PO, the level at which receipts and invoice match reconcile.
Linked to Purchase orders, Items, Contract rates, Categories - Locations
Ship-to and receiving places: a dock, an office or a site.
Linked to Departments - Procurement events
Durable once-only business event and migration provenance.
Linked to Purchase orders, Receipts, Supplier returns, Migration batches - Integration deliveries
Per-event destination outbox for an explicitly configured connection.
Linked to Procurement events, Users
- Supplier performance
Period scorecard per supplier: on-time delivery, quality, price competitiveness.
Linked to Suppliers, Users - Receipt line items
Per-line received quantity against a PO line.
Linked to Receipts, PO line items, Items, Users - Spend approvals
Versioned authority request and frozen decision for a complete source revision.
Linked to Purchase requisitions, Purchase orders, PO amendments, Master agreements - Approval steps
One row per approval tier a requisition, purchase order or amendment passes through.
Linked to Purchase requisitions, Purchase orders, PO amendments, Approval matrix - Procurement events
Durable once-only business event and migration provenance.
Linked to Purchase orders, Receipts, Supplier returns, Migration batches - Commitment allocations
Immutable signed effects of a business event on a PO line and its funding authority.
Linked to Procurement events, Purchase orders, PO line items, Spend approval lines - Migration batches
Reviewed cutover batches for master data, authority, commitments and accepted-quantity baselines.
Linked to Users - Integration deliveries
Per-event destination outbox for an explicitly configured connection.
Linked to Procurement events, Users
Keys and references
A purchase requests record owns its purchase lines, review decisions, record attachments and supplier acknowledgements. Purchase requisitions own requisition lines and may connect to an RFQ, order or blanket release. Purchase orders own PO line items; receipt lines point to those lines. Procurement events and commitment allocations retain source revisions and signed effects. User identity and team membership have separate records; map them carefully during setup.
Migration order
- Load Organizations, Users, team members, Departments and cost centers with reviewed identity mappings.
- Load Suppliers, Categories, Items, Locations and qualification evidence.
- Review approval matrix, approval delegations, contract rates and master agreements with their effective dates.
- Bring in approved requisitions, orders and open commitments through migration batches with reconciled control totals.
- Add receipt baselines, supplier evidence and event delivery destinations; compare accepted quantity and commitment totals before activation.
Set up SCM with Supplier Portal your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.