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.
- Automated Storage (AS/RS)
- Data model
The tables behind Automated Storage (AS/RS)
Automated Storage (AS/RS) ships with 17 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
- 17
- Features
- 7
- Change it
- Add fields and tables in Proto
How the model is organised
Storage Locations and Items
Organizations owns storage locations and team members. Stock items holds SKU, base unit, tracking mode, unit cost, reorder point and safety stock. Team members.User references Users.
Induction and Handling Units
Induction slots connects inbound transfers to storage locations with Sequence and slot at. Handling units links Item and Location and records tote code, custody owner, Quantity and Status.
Stock Requests
Stock requests references Organization, Owner, Item, Location and Counterparty. Both Location and Counterparty reference storage locations; requested units and Revision define the proposed scope.
Lots and Reservations
Stock lots connects Item and storage location. Stock reservations references Lot and Request with Quantity, expires at, Revision and Status. Storage policies carries Organization, Channel, Priority, safety stock units and effective from.
Robot Tasks
Robot tasks references Parent and Organization. Device reference, requested at, requested units and controller event ID describe the task context alongside Status and Revision.
Stock Movements
Stock movements references Parent, Item, Lot, Location, Organization and Owner. Signed quantity records the effect; source effect key identifies it; Reverses links compensation to the original movement.
Review and Reconciliation
Review decisions, operation receipts and record attachments reference their parent stock requests and Organization. Decisions retain source revision; receipts retain operation key and failure reason.
Every table, by feature
- Storage Locations and Items5
- Induction and Handling Units5
- Stock Requests7
- Lots and Reservations7
- Robot Tasks5
- Stock Movements6
- Review and Reconciliation6
- 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.
- 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
- Inbound transfers
Inbound and outbound loads with carrier, dock door and seal.
- Induction slots
Sequenced stops and dock appointments for a load.
Linked to Inbound transfers, Storage locations - Handling units
Totes, pallets and other handling units with their custody owner, item, location and movement status.
Linked to Storage locations, Stock items - 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.
- 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 - 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 - Team members
Warehouse staff and reviewers linked to an organization and platform user.
Linked to Organizations, Users
- Stock lots
Lot or serial level inventory held at a storage location.
Linked to Stock items, Storage locations - 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 - 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 - Storage policies
Channel allocation rules with priority and safety stock.
Linked to Organizations - Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Stock requests
- Robot tasks
Validated robot move submissions for a stock request, with device, controller and review evidence.
Linked to Stock requests, Organizations - Stock requests
Requests to receive, move, reserve or issue stock.
Linked to Organizations, Team members, Storage locations, Stock items - Organizations
Operating organizations that own warehouses, stock and team members.
- 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 movements
Posted signed-quantity movements that change on-hand inventory.
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 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 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
- 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 - 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 - Robot tasks
Validated robot move submissions for a stock request, with device, controller and review evidence.
Linked to Stock requests, Organizations
Keys and references
Use actual reference identifiers when importing related records. SKU, tote code and location Code help people identify stock but do not replace the stored reference. Resolve the current user through team members.User before filtering stock requests.Owner.
Follow stock lots.storage location and handling units.Location to establish location context. Load access must be agreed alongside the locations referenced by induction slots; shared item definitions need an explicit access policy. Review decisions.Parent points to stock requests, so robot-task creator and decision authority must be checked through the guarded task action’s identity context.
Preserve the Users.User self-reference and resolve its platform identity behavior during setup. Keep the original stock movements record immutable during reversal; the compensating record carries Reverses. Distinguish item unit cost from movement unit cost USD when agreeing imports and reporting.
Migration order
- Organizations and users. Establish Organizations, platform Users and team members with verified identity references.
- Items and locations. Import stock items and storage locations, checking base units, tracking choices and eligibility.
- Loads and handling units. Import inbound transfers, then induction slots and handling units with resolved location and item references.
- Lots and policies. Import stock lots under their items and locations; establish storage policies under their organizations.
- Requests and child work. Link stock requests, then stock reservations and robot tasks to the correct request and stock context.
- Historical evidence. Preserve genuine stock movements, review decisions, record attachments and operation receipts with original keys and reversal references. Do not replay an imported posting as a new physical effect.
Set up Automated Storage (AS/RS) your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.