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.
- IT Procurement System
- Data model
The tables behind IT Procurement System
IT Procurement System ships with 10 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
- 10
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Organization and access
Organizations own purchasing scope; team members connect Users to an organization and role.
Purchasing work
Purchase requests link to Suppliers, purchase lines and optional asset requests.
Review
Review decisions name the reviewer and source revision of a parent purchase requests record.
Evidence
Record attachments and operation receipts retain files and guarded-action outcomes under the same parent request.
Every table, by feature
- Purchase requests5
- Asset requests3
- Supplier records3
- Review decisions3
- Purchase lines2
- Evidence and receipts5
- Shared and settings1
- Purchase requests
IT purchase requests with lifecycle status, owner, counterparty and requested USD amount.
Linked to Organizations, Team members, Suppliers - Purchase lines
Requested and accepted line items belonging to exactly one purchase request.
Linked to Purchase requests - Organizations
Legal entities that own procurement records, with time zone and reporting currency.
- Team members
Authenticated platform identities with an active membership and role in an organization.
Linked to Organizations, Users - Suppliers
Eligible supplier parties with contact, address and eligibility evidence.
Linked to Organizations
- Asset requests
IT asset extension requests supporting approval of an IT purchase request.
Linked to Purchase requests, Organizations - Purchase requests
IT purchase requests with lifecycle status, owner, counterparty and requested USD amount.
Linked to Organizations, Team members, Suppliers - Organizations
Legal entities that own procurement records, with time zone and reporting currency.
- Suppliers
Eligible supplier parties with contact, address and eligibility evidence.
Linked to Organizations - Organizations
Legal entities that own procurement records, with time zone and reporting currency.
- Purchase requests
IT purchase requests with lifecycle status, owner, counterparty and requested USD amount.
Linked to Organizations, Team members, Suppliers
- Review decisions
Independent reviewer decisions recorded against a purchase request revision.
Linked to Purchase requests, Team members - Purchase requests
IT purchase requests with lifecycle status, owner, counterparty and requested USD amount.
Linked to Organizations, Team members, Suppliers - Team members
Authenticated platform identities with an active membership and role in an organization.
Linked to Organizations, Users
- Purchase lines
Requested and accepted line items belonging to exactly one purchase request.
Linked to Purchase requests - Purchase requests
IT purchase requests with lifecycle status, owner, counterparty and requested USD amount.
Linked to Organizations, Team members, Suppliers
- Record attachments
Uploaded evidence files linked to a purchase request with visibility scope.
Linked to Purchase requests, Team members - Operation receipts
Idempotent operation receipts recording the actual result of each guarded action.
Linked to Purchase requests - Review decisions
Independent reviewer decisions recorded against a purchase request revision.
Linked to Purchase requests, Team members - Purchase requests
IT purchase requests with lifecycle status, owner, counterparty and requested USD amount.
Linked to Organizations, Team members, Suppliers - Team members
Authenticated platform identities with an active membership and role in an organization.
Linked to Organizations, Users
Keys and references
A purchase request’s record number identifies the business case. Its Id links child records through Parent. The request carries Organization, Owner and Counterparty references. The reviewer decision carries source revision and Reviewer; an operation receipt carries expected revision and operation key. Keep those links when importing historical cases so the decision remains attached to the request version that was examined.
Migration order
- Load Organizations and Users.
- Load team members and Suppliers under the correct organization.
- Load purchase requests with owners and counterparties.
- Load purchase lines and asset requests under their parent request.
- Load review decisions, record attachments and operation receipts with their source references and dates.
Set up IT Procurement System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.