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.
- Hazardous Materials SCM
- Data model
The tables behind Hazardous Materials SCM
Hazardous Materials 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, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Requests:
Stock requests is the parent for inspection, decision, attachment, movement and receipt evidence.
Hazard review:
Hazard checks and review decisions capture the checked scope and human call.
Stock identity:
Stock items, stock lots and storage locations identify the material and place.
Execution:
Stock reservations hold claims; stock movements record signed stock effects; operation receipts record outcomes.
People and sites:
Organizations, team members and Users identify the responsible site and people.
Every table, by feature
- Stock requests
Represents a request to move or transfer stock, used to plan and track fulfillment.
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Defines a product the team stocks, used as the reference point for tracking its inventory.
Linked to Organizations - Storage locations
Represents a place where stock is kept, used to plan and manage where materials sit.
Linked to Organizations - Team members
Represents a person on the team, used to assign roles and track who does what.
Linked to Organizations, Users - Organizations
Represents a company or site the team operates under, used to separate their data and settings.
- Hazard checks
Records a hazardous material inspection and its outcome, used to clear items for storage.
Linked to Stock requests, Organizations - Review decisions
Captures a reviewer's approve or reject call on a change, kept as an audit trail.
Linked to Stock requests, Team members - Stock requests
Represents a request to move or transfer stock, used to plan and track fulfillment.
Linked to Organizations, Team members, Storage locations, Stock items - Storage locations
Represents a place where stock is kept, used to plan and manage where materials sit.
Linked to Organizations - Record attachments
Holds a file attached to another record, like a certificate or photo, for reference.
Linked to Stock requests, Team members - Team members
Represents a person on the team, used to assign roles and track who does what.
Linked to Organizations, Users
- Stock items
Defines a product the team stocks, used as the reference point for tracking its inventory.
Linked to Organizations - Stock lots
Tracks one batch of an item, including its expiration date and approval status, used to trace where it went.
Linked to Stock items - Storage locations
Represents a place where stock is kept, used to plan and manage where materials sit.
Linked to Organizations - Organizations
Represents a company or site the team operates under, used to separate their data and settings.
- Stock requests
Represents a request to move or transfer stock, used to plan and track fulfillment.
Linked to Organizations, Team members, Storage locations, Stock items
- Stock reservations
Holds stock aside for a specific request so it isn't used elsewhere before fulfillment.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock requests
Represents a request to move or transfer stock, used to plan and track fulfillment.
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Defines a product the team stocks, used as the reference point for tracking its inventory.
Linked to Organizations - Stock lots
Tracks one batch of an item, including its expiration date and approval status, used to trace where it went.
Linked to Stock items - Storage locations
Represents a place where stock is kept, used to plan and manage where materials sit.
Linked to Organizations - Stock movements
Logs one change in inventory quantity, letting the team trace what moved, when, and at what cost.
Linked to Stock requests, Stock items, Storage locations, Stock movements
- Stock movements
Logs one change in inventory quantity, letting the team trace what moved, when, and at what cost.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Stock requests
Represents a request to move or transfer stock, used to plan and track fulfillment.
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Defines a product the team stocks, used as the reference point for tracking its inventory.
Linked to Organizations - Stock lots
Tracks one batch of an item, including its expiration date and approval status, used to trace where it went.
Linked to Stock items - Storage locations
Represents a place where stock is kept, used to plan and manage where materials sit.
Linked to Organizations - Operation receipts
Confirms the outcome of an operation, giving the team proof of what actually happened.
Linked to Stock requests
- Review decisions
Captures a reviewer's approve or reject call on a change, kept as an audit trail.
Linked to Stock requests, Team members - Record attachments
Holds a file attached to another record, like a certificate or photo, for reference.
Linked to Stock requests, Team members - Operation receipts
Confirms the outcome of an operation, giving the team proof of what actually happened.
Linked to Stock requests - Stock requests
Represents a request to move or transfer stock, used to plan and track fulfillment.
Linked to Organizations, Team members, Storage locations, Stock items - Hazard checks
Records a hazardous material inspection and its outcome, used to clear items for storage.
Linked to Stock requests, Organizations - Stock movements
Logs one change in inventory quantity, letting the team trace what moved, when, and at what cost.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Team members
Represents a person on the team, used to assign roles and track who does what.
Linked to Organizations, Users
Keys and references
Stock requests connects to Organizations, team members, stock items and storage locations. Hazard checks, review decisions, record attachments, stock movements and operation receipts point back to the request through Parent. Stock reservations uses Request. Stock movements can point to a prior movement through Reverses. Keep record and operation keys stable across corrections.
Migration order
- Load Organizations, Users and team members.
- Load storage locations and stock items, then stock lots.
- Load open stock requests and their hazard checks, record attachments and review decisions.
- Reconcile stock movements, stock reservations and operation receipts against accepted opening stock.
Set up Hazardous Materials SCM your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.