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.
- Retail Replenishment SCM
- Data model
The tables behind Retail Replenishment SCM
Retail Replenishment 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
Organization
Organizations own storage locations, stock items and team members; team members link to Users.
Requests
Stock requests bind an item, location, counterparty, owner and organization. Store replenishments point to the parent request.
Stock
Stock lots belong to stock items. Stock reservations relate a request to an item and location, with an optional lot. Stock movements record posted signed effects.
Evidence
Review decisions, record attachments and operation receipts point to stock requests.
Every table, by feature
- Stock requests4
- Store replenishments3
- Stock position6
- Locations and items5
- Review and evidence5
- Operations overview5
- Shared and settings1
- Stock requests
Replenishment stock requests raised for a store or distribution center item.
Linked to Organizations, Team members, Storage locations, Stock items - Store replenishments
Store-level replenishment proposals and their review and execution state.
Linked to Stock requests, Organizations - Review decisions
Independent review decisions recorded against a stock request revision.
Linked to Stock requests, Team members - Record attachments
Supporting evidence files linked to a stock request.
Linked to Stock requests, Team members
- Store replenishments
Store-level replenishment proposals and their review and execution state.
Linked to Stock requests, Organizations - Stock requests
Replenishment stock requests raised for a store or distribution center item.
Linked to Organizations, Team members, Storage locations, Stock items - Operation receipts
Durable operation receipts with stable operation keys for every guarded action.
Linked to Stock requests
- Stock reservations
Held, released or consumed reservations against eligible stock.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock lots
Lot-tracked stock lots with expiry and release state.
Linked to Stock items - Stock movements
Posted signed stock movements that carry the authoritative on-hand effect.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Stock items
Replenished retail stock items with their base unit and lot tracking rule.
Linked to Organizations - Storage locations
Stores and distribution centers holding replenishment stock.
Linked to Organizations - Stock requests
Replenishment stock requests raised for a store or distribution center item.
Linked to Organizations, Team members, Storage locations, Stock items
- Organizations
Retail organizations operating replenishment across stores and distribution centers.
- Storage locations
Stores and distribution centers holding replenishment stock.
Linked to Organizations - Stock items
Replenished retail stock items with their base unit and lot tracking rule.
Linked to Organizations - Stock lots
Lot-tracked stock lots with expiry and release state.
Linked to Stock items - Team members
Named retail supply chain staff authorized on stock requests and review decisions.
Linked to Organizations, Users
- Review decisions
Independent review decisions recorded against a stock request revision.
Linked to Stock requests, Team members - Record attachments
Supporting evidence files linked to a stock request.
Linked to Stock requests, Team members - Operation receipts
Durable operation receipts with stable operation keys for every guarded action.
Linked to Stock requests - Stock requests
Replenishment stock requests raised for a store or distribution center item.
Linked to Organizations, Team members, Storage locations, Stock items - Team members
Named retail supply chain staff authorized on stock requests and review decisions.
Linked to Organizations, Users
- Stock requests
Replenishment stock requests raised for a store or distribution center item.
Linked to Organizations, Team members, Storage locations, Stock items - Store replenishments
Store-level replenishment proposals and their review and execution state.
Linked to Stock requests, Organizations - Stock reservations
Held, released or consumed reservations against eligible stock.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock movements
Posted signed stock movements that carry the authoritative on-hand effect.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Operation receipts
Durable operation receipts with stable operation keys for every guarded action.
Linked to Stock requests
Keys and references
Use the organization code, location code and item SKU consistently when bringing historical data in. Stock requests carry their own record number and revision. A decision’s source revision identifies which request version was reviewed. A movement’s source effect key and a receipt’s operation key help reconcile action evidence. Preserve the links to parent requests and team members.
Migration order
- Bring in Organizations and Users.
- Add storage locations, stock items and team members.
- Add stock lots for lot-tracked items.
- Bring in stock requests and linked store replenishments.
- Attach record attachments and review decisions.
- Reconcile stock reservations, stock movements and operation receipts with their parent cases.
Set up Retail Replenishment SCM your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.