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.
- Warehousing SCM
- Data model
The tables behind Warehousing SCM
Warehousing 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
Organization
Organizations, storage locations and team members define operating scope and accountable people.
Stock identity
Stock items and stock lots identify products, units, lots and release state.
Operations
Stock requests and put away plans hold work scope and review status; stock movements and stock reservations hold recorded quantity effects.
Evidence
Review decisions, record attachments and operation receipts retain the decision and outcome trail.
Every table, by feature
- Organizations and locations4
- Items and lots2
- Stock requests1
- Put-away plans4
- Movements and reservations6
- Review and evidence4
- Organizations
Warehouse operating organizations with code, time zone and reporting currency.
- Storage locations
Bins, zones and warehouses where stock is held, with contact and eligibility notes.
Linked to Organizations - Team members
Warehouse staff membership with organization, platform user, role and time zone.
Linked to Organizations, Users - Users
Users
Linked to Users
- Stock items
Warehouse stock item master with SKU, base unit and lot tracking flag.
Linked to Organizations - Stock lots
Lot and expiry tracking with release state and owner reference for each stock item.
Linked to Stock items
- Stock requests
Warehouse stock requests covering put-away, movement and issue work with lifecycle and revision.
Linked to Organizations, Team members, Storage locations, Stock items
- Put away plans
Put-away plan extensions with zone, planned units and handling class awaiting eligible approval.
Linked to Stock requests, Organizations - Stock requests
Warehouse stock requests covering put-away, movement and issue work with lifecycle and revision.
Linked to Organizations, Team members, Storage locations, Stock items - Review decisions
Independent approve, reject and return decisions recorded against a stock request revision.
Linked to Stock requests, Team members - Operation receipts
Durable operation receipts recording action, expected revision and result state for every guarded write.
Linked to Stock requests
- Stock movements
Posted signed stock movements with source effect keys, unit cost and lot tracking.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Stock reservations
Active, released and consumed reservations holding eligible free quantity at an item and location.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock requests
Warehouse stock requests covering put-away, movement and issue work with lifecycle and revision.
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Warehouse stock item master with SKU, base unit and lot tracking flag.
Linked to Organizations - Stock lots
Lot and expiry tracking with release state and owner reference for each stock item.
Linked to Stock items - Storage locations
Bins, zones and warehouses where stock is held, with contact and eligibility notes.
Linked to Organizations
- Review decisions
Independent approve, reject and return decisions recorded against a stock request revision.
Linked to Stock requests, Team members - Record attachments
Supporting evidence files attached to a stock request with visibility and evidence type.
Linked to Stock requests, Team members - Operation receipts
Durable operation receipts recording action, expected revision and result state for every guarded write.
Linked to Stock requests - Stock requests
Warehouse stock requests covering put-away, movement and issue work with lifecycle and revision.
Linked to Organizations, Team members, Storage locations, Stock items
Keys and references
Stock requests is the parent for plans, attachments, decisions, movements and receipts. Stock reservations points to its request, item and location. Stock lots points to stock items; movements and reservations may also point to a lot. Team members connects a platform user to an organization and appears as request owner, attachment uploader or reviewer. Keep record identifiers stable during migration.
Migration order
- Operating scope. Load Organizations, Users, team members and storage locations.
- Item identity. Load stock items and stock lots with the correct base unit and release state.
- Open work. Load stock requests, then related put away plans and record attachments.
- Effects and evidence. Load stock reservations, stock movements, review decisions and operation receipts with their original references.
Set up Warehousing SCM your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.