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 Lot Tracking
- Data model
The tables behind SCM with Lot Tracking
SCM with Lot Tracking 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 catalog
Organizations own stock items; each stock lot points to its item and carries expiry and release state.
Operating scope
Organizations own storage locations and team members; a team member links to a User.
Request lifecycle
Stock requests links organization, owner, item and locations. Review decisions, record attachments and operation receipts point back to the request.
Stock effects
Stock movements links a request, item and location, with optional lot and reversal references. Stock reservations links a request, item and location, with an optional lot.
Recall work
Recall scopes links to its parent request and organization, retaining affected units and lot code.
Every table, by feature
- Stock catalog5
- Locations and teams7
- Stock requests6
- Review and evidence5
- Movement and reservations6
- Recall scopes8
- Stock items
Stock item master with base unit and lot tracking flag.
Linked to Organizations - Stock lots
Lot and batch records with expiry and release state.
Linked to Stock items - Stock requests
Stock receive, move, reserve and recall requests with lifecycle and revision.
Linked to Organizations, Team members, Storage locations, Stock items - Stock movements
Posted signed stock movements produced by guarded workflows.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock reservations
Active, released and consumed reservations against eligible stock.
Linked to Stock requests, Stock lots, Stock items, Storage locations
- Organizations
Operating organizations that own stock, locations and requests.
- Storage locations
Warehouses, cold rooms and staging areas holding stock.
Linked to Organizations - Team members
People who prepare, review and execute stock operations.
Linked to Organizations, Users - Users
Users
Linked to Users - Stock items
Stock item master with base unit and lot tracking flag.
Linked to Organizations - Stock requests
Stock receive, move, reserve and recall requests with lifecycle and revision.
Linked to Organizations, Team members, Storage locations, Stock items - Stock movements
Posted signed stock movements produced by guarded workflows.
Linked to Stock requests, Stock items, Storage locations, Stock lots
- Stock requests
Stock receive, move, reserve and recall requests with lifecycle and revision.
Linked to Organizations, Team members, Storage locations, Stock items - Review decisions
Independent reviewer decisions on a frozen source revision.
Linked to Stock requests, Team members - Operation receipts
Durable operation receipts keyed by stable operation key.
Linked to Stock requests - Stock movements
Posted signed stock movements produced by guarded workflows.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock reservations
Active, released and consumed reservations against eligible stock.
Linked to Stock requests, Stock lots, Stock items, Storage locations - Recall scopes
Reviewed recall scopes that trace descendants and block affected availability.
Linked to Stock requests, Organizations
- Review decisions
Independent reviewer decisions on a frozen source revision.
Linked to Stock requests, Team members - Record attachments
Uploaded evidence files linked to a stock request.
Linked to Stock requests, Team members - Operation receipts
Durable operation receipts keyed by stable operation key.
Linked to Stock requests - Stock requests
Stock receive, move, reserve and recall requests with lifecycle and revision.
Linked to Organizations, Team members, Storage locations, Stock items - Team members
People who prepare, review and execute stock operations.
Linked to Organizations, Users
- Stock movements
Posted signed stock movements produced by guarded workflows.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock reservations
Active, released and consumed reservations against eligible stock.
Linked to Stock requests, Stock lots, Stock items, Storage locations - Stock requests
Stock receive, move, reserve and recall requests with lifecycle and revision.
Linked to Organizations, Team members, Storage locations, Stock items - Stock lots
Lot and batch records with expiry and release state.
Linked to Stock items - Stock items
Stock item master with base unit and lot tracking flag.
Linked to Organizations - Storage locations
Warehouses, cold rooms and staging areas holding stock.
Linked to Organizations
- Recall scopes
Reviewed recall scopes that trace descendants and block affected availability.
Linked to Stock requests, Organizations - Stock requests
Stock receive, move, reserve and recall requests with lifecycle and revision.
Linked to Organizations, Team members, Storage locations, Stock items - Stock lots
Lot and batch records with expiry and release state.
Linked to Stock items - Stock movements
Posted signed stock movements produced by guarded workflows.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock reservations
Active, released and consumed reservations against eligible stock.
Linked to Stock requests, Stock lots, Stock items, Storage locations - Review decisions
Independent reviewer decisions on a frozen source revision.
Linked to Stock requests, Team members - Operation receipts
Durable operation receipts keyed by stable operation key.
Linked to Stock requests - Record attachments
Uploaded evidence files linked to a stock request.
Linked to Stock requests, Team members
Keys and references
Use the request record number for human discussion and its record reference for joins. Operation key identifies an attempted operation; source revision identifies the request version reviewed. SKU and lot code are useful labels, while item and lot references preserve exact relationships. The self-reference on stock movements records a reversal. The Users table links team membership to an account.
Migration order
- Load Organizations and Users, then team members and storage locations.
- Load stock items and stock lots with their item references and release states.
- Load stock requests with owner, organization, item and location references.
- Add linked review decisions, record attachments and recall scopes.
- Add stock movements, stock reservations and operation receipts after their parent requests exist; preserve reversal links.
- Reconcile quantities, lot identities, decision revisions and evidence before use.
Set up SCM with Lot Tracking your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.