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 Multi-warehouse
- Data model
The tables behind SCM with Multi-warehouse
SCM with Multi-warehouse 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
Network setup
Organizations own storage locations, stock items and team members. Team members link to Users.
Request work
Stock requests name the organization, owner, item, location and counterparty location. Network transfers, record attachments, review decisions, operation receipts and stock movements link to a parent request.
Stock scope
Stock lots belong to stock items. Stock reservations link a request, item and location with an optional lot.
Quantity evidence
Stock movements link an item, location and optional lot; a correcting movement may point to another stock movements record through Reverses.
Every table, by feature
- Stock requests
Requests to receive, move, reserve or transfer stock across the warehouse network.
Linked to Organizations, Team members, Storage locations, Stock items - Record attachments
Supporting evidence files attached to a stock request.
Linked to Stock requests, Team members - Review decisions
Independent reviewer decisions recorded against a stock request revision.
Linked to Stock requests, Team members - Stock items
Stock keeping units with their base unit of measure and lot tracking policy.
Linked to Organizations - Storage locations
Warehouses, yards and staging sites where stock is held.
Linked to Organizations - Team members
People who coordinate and review inventory operations for an organization.
Linked to Organizations, Users
- Network transfers
Inter-warehouse transfer extensions executed against a parent stock request.
Linked to Stock requests, Organizations - Stock requests
Requests to receive, move, reserve or transfer stock across the warehouse network.
Linked to Organizations, Team members, Storage locations, Stock items - Organizations
Operating organizations participating in the warehouse network.
- Operation receipts
Durable receipts for every guarded operation, keyed for safe retries.
Linked to Stock requests
- Stock items
Stock keeping units with their base unit of measure and lot tracking policy.
Linked to Organizations - Stock lots
Lot and expiry evidence for lot-tracked stock items.
Linked to Stock items - Stock movements
Posted signed-quantity ledger rows per item, location, lot and base unit.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Storage locations
Warehouses, yards and staging sites where stock is held.
Linked to Organizations - Stock requests
Requests to receive, move, reserve or transfer stock across the warehouse network.
Linked to Organizations, Team members, Storage locations, Stock items
- Stock reservations
Claims against free quantity for an exact item, location and lot scope.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock requests
Requests to receive, move, reserve or transfer stock across the warehouse network.
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Stock keeping units with their base unit of measure and lot tracking policy.
Linked to Organizations - Storage locations
Warehouses, yards and staging sites where stock is held.
Linked to Organizations - Stock lots
Lot and expiry evidence for lot-tracked stock items.
Linked to Stock items
- Review decisions
Independent reviewer decisions recorded against a stock request revision.
Linked to Stock requests, Team members - Record attachments
Supporting evidence files attached to a stock request.
Linked to Stock requests, Team members - Operation receipts
Durable receipts for every guarded operation, keyed for safe retries.
Linked to Stock requests - Stock requests
Requests to receive, move, reserve or transfer stock across the warehouse network.
Linked to Organizations, Team members, Storage locations, Stock items - Team members
People who coordinate and review inventory operations for an organization.
Linked to Organizations, Users
- Organizations
Operating organizations participating in the warehouse network.
- Storage locations
Warehouses, yards and staging sites where stock is held.
Linked to Organizations - Team members
People who coordinate and review inventory operations for an organization.
Linked to Organizations, Users - Users
Users
Linked to Users - Stock items
Stock keeping units with their base unit of measure and lot tracking policy.
Linked to Organizations
Keys and references
Keep organization codes, location codes, item SK us and lot codes consistent during migration. Record number identifies a row. Revision on stock requests and network transfers, source revision on review decisions and expected revision on operation receipts connect decisions and outcomes to the version of work they concern. Operation key distinguishes guarded action attempts.
Migration order
- Import Organizations and Users, then team members.
- Create storage locations and stock items under their organizations.
- Add stock lots for tracked items.
- Import stock requests with owners, items and locations resolved.
- Link network transfers, record attachments and review decisions to requests.
- Add stock reservations, stock movements and operation receipts after their parent and stock references exist.
Set up SCM with Multi-warehouse your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.