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.
- Supply Chain Analytics
- Data model and import order
The tables behind Supply Chain Analytics
Supply Chain Analytics 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
Purchase Demand:
Purchase requests and purchase lines, with Suppliers. Each request belongs to an organization, names a supplier and owner and carries a version.
Review Queue:
Review decisions record the decision, reason and approver against a request version.
Commitments and Receipts:
Purchase requests carry the order reference; purchase lines carry accepted quantity, time and invoice reference.
Service Snapshots:
Service snapshots record scope, date and units, linked to a request and organization.
Activity and Evidence:
Record attachments and operation receipts belong to a request.
Access:
Organizations, team members and Users scope staff.
Every table, by feature
- Purchase Demand4
- Review Queue4
- Commitments and Receipts3
- Service Snapshots3
- Supplier Performance4
- Activity and Evidence4
- Shared and settings1
- Purchase requests
Purchase demand records with lifecycle, owner, counterparty and approved commitment.
Linked to Organizations, Team members, Suppliers - Purchase lines
Requested and accepted line detail for each purchase request.
Linked to Purchase requests - Suppliers
Eligible supplier parties that receive purchase commitments.
Linked to Organizations - Record attachments
Evidence files attached to a purchase request.
Linked to Purchase requests, Team members
- Review decisions
Independent review decisions recorded against a source revision.
Linked to Purchase requests, Team members - Purchase requests
Purchase demand records with lifecycle, owner, counterparty and approved commitment.
Linked to Organizations, Team members, Suppliers - Service snapshots
Reconciled service snapshot records supporting the lock operation.
Linked to Purchase requests, Organizations - Team members
Named team members with organization membership and platform identity.
Linked to Organizations, Users
- Purchase requests
Purchase demand records with lifecycle, owner, counterparty and approved commitment.
Linked to Organizations, Team members, Suppliers - Purchase lines
Requested and accepted line detail for each purchase request.
Linked to Purchase requests - Suppliers
Eligible supplier parties that receive purchase commitments.
Linked to Organizations
- Service snapshots
Reconciled service snapshot records supporting the lock operation.
Linked to Purchase requests, Organizations - Purchase requests
Purchase demand records with lifecycle, owner, counterparty and approved commitment.
Linked to Organizations, Team members, Suppliers - Organizations
Operating organizations that own supply chain records.
- Suppliers
Eligible supplier parties that receive purchase commitments.
Linked to Organizations - Purchase lines
Requested and accepted line detail for each purchase request.
Linked to Purchase requests - Purchase requests
Purchase demand records with lifecycle, owner, counterparty and approved commitment.
Linked to Organizations, Team members, Suppliers - Service snapshots
Reconciled service snapshot records supporting the lock operation.
Linked to Purchase requests, Organizations
- Record attachments
Evidence files attached to a purchase request.
Linked to Purchase requests, Team members - Operation receipts
Idempotent operation receipts recording guarded action outcomes.
Linked to Purchase requests - Purchase requests
Purchase demand records with lifecycle, owner, counterparty and approved commitment.
Linked to Organizations, Team members, Suppliers - Team members
Named team members with organization membership and platform identity.
Linked to Organizations, Users
Keys and references
Every request keeps a stable record number, every supplier and organization a code. Import lines by request record number and line number. Keep order and invoice references as received.
The app holds 10 tables and 15 relationships.
Migration order
- Load Organizations, Users and team members.
- Load Suppliers with eligibility notes.
- Load open purchase requests with purchase lines and record attachments.
- Load accepted quantities on received lines.
- Load prior service snapshots as completed history.
- Reconcile open quantities and commitment with the source before raising new demand.
Set up Supply Chain Analytics your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.