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.
- Bin / Location Management
- Data model
The tables behind Bin / Location Management
Bin / Location Management ships with 16 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
- 16
- Features
- 7
- Change it
- Add fields and tables in Proto
How the model is organised
Location setup
Organizations owns storage locations and team members. Team members.User references Users. Stock items defines SKU, base unit and tracking mode for inventory records.
Stock requests
Stock requests references Item, Location and Counterparty, with both location references targeting storage locations. Owner references team members and Organization establishes operating scope.
Slotting plans
Slotting plans.Parent references stock requests. Zone, planned at, capacity cubic feet and required cubic feet accompany channel policy fields and the plan's own Status and Revision.
Lots and reservations
Stock lots connects stock items with storage locations. Stock reservations links Lot to Request and records reserved units, Status, expires at and Revision.
Stock movements
Stock movements links the request, item, storage location and optional lot. Signed quantity and source effect key describe the posted effect; Reverses references the original stock movements record.
Loads and handling
Load stops belongs to Loads and references storage locations. Handling units references an item and location with license plate, Quantity and custody owner.
Evidence and reconciliation
Review decisions, operation receipts and record attachments reference stock requests through Parent. Decisions retain Reviewer and Revision; receipts retain Owner, Action and operation key.
Every table, by feature
- Location setup6
- Stock requests7
- Slotting plans4
- Lots and reservations5
- Stock movements6
- Loads and handling5
- Evidence and reconciliation6
- Storage locations
Warehouses, bins, yards and cold rooms where stock is held.
Linked to Organizations - Organizations
Operating organizations that own warehouses, stock and team members.
- Team members
Warehouse staff and reviewers linked to an organization and platform user.
Linked to Organizations, Users - Users
Users
Linked to Users - Stock items
Stock keeping units with base unit, tracking mode and reorder settings.
- Stock lots
Lot or serial level inventory held at a storage location.
Linked to Stock items, Storage locations
- Stock requests
Requests to receive, move, reserve or issue stock.
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Stock keeping units with base unit, tracking mode and reorder settings.
- Storage locations
Warehouses, bins, yards and cold rooms where stock is held.
Linked to Organizations - Team members
Warehouse staff and reviewers linked to an organization and platform user.
Linked to Organizations, Users - Review decisions
Approved, rejected, returned or escalated decisions on source records.
Linked to Organizations, Team members, Stock requests - Record attachments
Documents and links attached to operational records.
Linked to Stock requests, Organizations - Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Stock requests
- Slotting plans
Channel allocation rules with priority and safety stock.
Linked to Organizations, Stock requests - Stock requests
Requests to receive, move, reserve or issue stock.
Linked to Organizations, Team members, Storage locations, Stock items - Review decisions
Approved, rejected, returned or escalated decisions on source records.
Linked to Organizations, Team members, Stock requests - Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Stock requests
- Stock lots
Lot or serial level inventory held at a storage location.
Linked to Stock items, Storage locations - Stock items
Stock keeping units with base unit, tracking mode and reorder settings.
- Stock reservations
Held, released or consumed reservations against eligible stock lots.
Linked to Stock lots, Stock requests - Stock requests
Requests to receive, move, reserve or issue stock.
Linked to Organizations, Team members, Storage locations, Stock items - Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Stock requests
- Stock movements
Posted signed-quantity movements that change on-hand inventory.
Linked to Organizations, Team members, Storage locations, Stock items - Stock requests
Requests to receive, move, reserve or issue stock.
Linked to Organizations, Team members, Storage locations, Stock items - Stock lots
Lot or serial level inventory held at a storage location.
Linked to Stock items, Storage locations - Stock items
Stock keeping units with base unit, tracking mode and reorder settings.
- Storage locations
Warehouses, bins, yards and cold rooms where stock is held.
Linked to Organizations - Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Stock requests
- Handling units
Pallets, totes and license-plate handling units with custody.
Linked to Storage locations, Stock items - Loads
Inbound and outbound loads with carrier, dock door and seal.
- Load stops
Sequenced stops and dock appointments for a load.
Linked to Loads, Storage locations - Storage locations
Warehouses, bins, yards and cold rooms where stock is held.
Linked to Organizations - Stock items
Stock keeping units with base unit, tracking mode and reorder settings.
- Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Stock requests - Review decisions
Approved, rejected, returned or escalated decisions on source records.
Linked to Organizations, Team members, Stock requests - Record attachments
Documents and links attached to operational records.
Linked to Stock requests, Organizations - Stock requests
Requests to receive, move, reserve or issue stock.
Linked to Organizations, Team members, Storage locations, Stock items - Stock movements
Posted signed-quantity movements that change on-hand inventory.
Linked to Organizations, Team members, Storage locations, Stock items - Stock reservations
Held, released or consumed reservations against eligible stock lots.
Linked to Stock lots, Stock requests
Keys and references
Preserve Id values and their references when migrating. Use storage locations.Code, stock items.SKU and the human request, movement, reservation and receipt numbers to help staff identify records. Names and codes do not replace record identities in relationships.
Stock requests.Revision and slotting plans.Revision belong to their respective records. Keep each review decisions record with its Parent request and recorded Revision. Stock movements.source effect key and operation receipts.operation key identify repeatable effects and operations. Users.User references Users and must be mapped carefully to platform identity.
Agree access to stock items and Loads during setup. Use storage locations.Organization and stock requests.Organization when defining access to related stock and evidence. Apply the agreed permissions to record actions as well as worklists.
Migration order
- Operating identity. Establish Organizations and Users, then map team members to their organization and platform account.
- Locations and items. Create storage locations and stock items with consistent location codes and base units.
- Opening stock. Reconcile stock lots with their items and locations before introducing reservations or posting new movements.
- Authorized work. Load stock requests, then linked slotting plans and stock reservations with preserved states and revisions.
- Physical handling context. Load Loads, load stops and handling units with valid item and location references.
- Historical evidence. Preserve stock movements, reversal links, review decisions, operation receipts and record attachments without re-executing historical effects.
Set up Bin / Location Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.