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.
- Spare Parts SCM
- Data model and import order
The tables behind Spare Parts SCM
Spare Parts SCM ships with 13 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
- 13
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Stock requests:
Stock requests, critical spares. Keep demand and critical reorder review tied to one parent request.
Part and lot identity:
Stock items, stock lots. Carry SKU, base unit, lot expiry and release state.
Locations and people:
Organizations, storage locations, team members, Users. Define operating scope and actors.
Stock evidence:
Stock reservations, stock movements. Track claims and signed posted effects.
Review evidence:
Record attachments, review decisions, operation receipts. Keep files, human decisions and guarded outcomes distinct.
Every table, by feature
- Stock requests5
- Critical spares5
- Parts and lots4
- Locations and organizations5
- Reservations and movements6
- Review and evidence6
- Stock requests
Stock requests that drive receive, move, reserve, consume and reorder operations.
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Spare part catalog items with base unit and lot-tracking rules.
Linked to Organizations - Storage locations
Warehouses, service depots and vendor stockrooms holding spare parts.
Linked to Organizations - Organizations
Operating organizations that own spare-parts inventory and stock operations.
- Team members
Authenticated platform users acting as inventory coordinators, reviewers and administrators.
Linked to Organizations, Users
- Critical spares
Critical-spare reorder extensions with criticality, minimum units and review state.
Linked to Stock requests, Organizations - Stock requests
Stock requests that drive receive, move, reserve, consume and reorder operations.
Linked to Organizations, Team members, Storage locations, Stock items - Review decisions
Independent approve, reject and return decisions recorded against request revisions.
Linked to Stock requests, Team members - Record attachments
Evidence files attached to stock requests.
Linked to Stock requests, Team members - Operation receipts
Idempotent operation receipts for guarded workflow commands.
Linked to Stock requests
- Stock items
Spare part catalog items with base unit and lot-tracking rules.
Linked to Organizations - Stock lots
Lot and batch tracking records with expiry and release state.
Linked to Stock items - Stock movements
Posted signed stock movements generated by workflow operations.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Stock reservations
Active claims on free stock by item, location and lot.
Linked to Stock requests, Stock items, Storage locations, Stock lots
- Organizations
Operating organizations that own spare-parts inventory and stock operations.
- Storage locations
Warehouses, service depots and vendor stockrooms holding spare parts.
Linked to Organizations - Team members
Authenticated platform users acting as inventory coordinators, reviewers and administrators.
Linked to Organizations, Users - Users
Users
Linked to Users - Stock requests
Stock requests that drive receive, move, reserve, consume and reorder operations.
Linked to Organizations, Team members, Storage locations, Stock items
- Stock reservations
Active claims on free stock by item, location and lot.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock movements
Posted signed stock movements generated by workflow operations.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Stock requests
Stock requests that drive receive, move, reserve, consume and reorder operations.
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Spare part catalog items with base unit and lot-tracking rules.
Linked to Organizations - Stock lots
Lot and batch tracking records with expiry and release state.
Linked to Stock items - Storage locations
Warehouses, service depots and vendor stockrooms holding spare parts.
Linked to Organizations
- Review decisions
Independent approve, reject and return decisions recorded against request revisions.
Linked to Stock requests, Team members - Record attachments
Evidence files attached to stock requests.
Linked to Stock requests, Team members - Operation receipts
Idempotent operation receipts for guarded workflow commands.
Linked to Stock requests - Critical spares
Critical-spare reorder extensions with criticality, minimum units and review state.
Linked to Stock requests, Organizations - Stock requests
Stock requests that drive receive, move, reserve, consume and reorder operations.
Linked to Organizations, Team members, Storage locations, Stock items - Team members
Authenticated platform users acting as inventory coordinators, reviewers and administrators.
Linked to Organizations, Users
Keys and references
Use organization and location codes as stable import keys. Match items by SKU within the intended organization. Preserve request record number and revision. A critical spare, attachment, decision, movement or receipt references its parent request. Lot-linked reservations and movements should point to the same catalog item as the lot. Keep operation key stable across retries and retain source revision on review decisions.
Migration order
- Load Organizations and Users, then active team members and storage locations.
- Load stock items with SKU, base unit and lot-tracking choice; load stock lots against the right item.
- Load stock requests and linked critical spares with their current revisions.
- Load record attachments, review decisions and operation receipts with their parent and actor references.
- Load stock reservations and stock movements, then reconcile quantities, lot links, posted flags and reversals.
Set up Spare Parts SCM your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.