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.
- E-procurement Portal
- Data model
The tables behind E-procurement Portal
E-procurement Portal ships with 11 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
- 11
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Organization
Organizations own suppliers, team members, requests and tenders.
Operations
Purchase requests carry demand; purchase lines describe quantities; tender submissions record offers and evaluation.
Review and Evidence
Review decisions, record attachments and operation receipts stay linked to the parent request.
Reference
Users link to team members; exchange rates stores effective currency rates.
Every table, by feature
- Purchase demand5
- Supplier register3
- Tender desk4
- Review and award4
- Ordering and receipt4
- Evidence and exceptions4
- Shared and settings2
- Purchase requests
Demand records raised by buyers, carrying lifecycle, budget and supplier context.
Linked to Organizations, Team members, Suppliers - Purchase lines
Line items belonging to a purchase request, with requested and accepted quantities.
Linked to Purchase requests - Organizations
Buying organizations that own procurement records.
- Team members
Authenticated platform identities with a role inside an organization.
Linked to Organizations, Users - Suppliers
Registered suppliers eligible to receive tender invitations and orders.
Linked to Organizations
- Suppliers
Registered suppliers eligible to receive tender invitations and orders.
Linked to Organizations - Organizations
Buying organizations that own procurement records.
- Team members
Authenticated platform identities with a role inside an organization.
Linked to Organizations, Users
- Tender submissions
Sealed tender submissions evaluated and awarded against a purchase request.
Linked to Purchase requests, Organizations - Purchase requests
Demand records raised by buyers, carrying lifecycle, budget and supplier context.
Linked to Organizations, Team members, Suppliers - Suppliers
Registered suppliers eligible to receive tender invitations and orders.
Linked to Organizations - Organizations
Buying organizations that own procurement records.
- Review decisions
Independent reviewer decisions recorded against a purchase request revision.
Linked to Purchase requests, Team members - Tender submissions
Sealed tender submissions evaluated and awarded against a purchase request.
Linked to Purchase requests, Organizations - Operation receipts
Idempotent receipts for every guarded operation executed against a purchase request.
Linked to Purchase requests - Purchase requests
Demand records raised by buyers, carrying lifecycle, budget and supplier context.
Linked to Organizations, Team members, Suppliers
- Purchase requests
Demand records raised by buyers, carrying lifecycle, budget and supplier context.
Linked to Organizations, Team members, Suppliers - Purchase lines
Line items belonging to a purchase request, with requested and accepted quantities.
Linked to Purchase requests - Suppliers
Registered suppliers eligible to receive tender invitations and orders.
Linked to Organizations - Operation receipts
Idempotent receipts for every guarded operation executed against a purchase request.
Linked to Purchase requests
- Record attachments
Evidence files attached to a purchase request with visibility scope.
Linked to Purchase requests, Team members - Review decisions
Independent reviewer decisions recorded against a purchase request revision.
Linked to Purchase requests, Team members - Operation receipts
Idempotent receipts for every guarded operation executed against a purchase request.
Linked to Purchase requests - Purchase requests
Demand records raised by buyers, carrying lifecycle, budget and supplier context.
Linked to Organizations, Team members, Suppliers
Keys and references
The request is the parent for purchase lines, tenders, review decisions, attachments and operation receipts. Its owner is a team member and its counterparty is a supplier. A tender also identifies its buying organization. A review decision names the reviewer and source revision. The operation receipt records an operation key and expected revision so an action can be reconciled with its parent.
Migration order
- Load organizations and users, then link team members to both.
- Load suppliers under the right organization.
- Load purchase requests with owner and counterparty references.
- Add purchase lines and tender submissions under their requests.
- Add attachments, decisions and operation receipts with the correct parent.
- Check request and tender states against linked evidence before releasing reports.
Set up E-procurement Portal your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.