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.
- Returns Processing Center
- Data model
The tables behind Returns Processing Center
Returns Processing Center 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
Return case
Return grades points to stock requests; the request carries item, owner, organization and locations.
Decision and evidence
Review decisions and record attachments point to the source request. Operation receipts record action outcomes for that request.
Inventory
Stock items identifies products, stock lots holds lot-level quantity, stock reservations links holds to requests, and stock movements records posted stock effects and reversals.
People and locations
Organizations owns storage locations and team members; each team members record links to Users.
Every table, by feature
- Return intake6
- Grading4
- Disposition review5
- Stock execution6
- Lots and reservations6
- Evidence and reconciliation6
- Shared and settings2
- Stock requests
Requests to receive, move, reserve or issue stock.
Linked to Organizations, Team members, Storage locations, Stock items - Return grades
Inspection grades for returned stock: disposition, accepted units and release state for a stock request.
Linked to Stock requests, Organizations - 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 - Record attachments
Documents and links attached to operational records.
Linked to Stock requests, Organizations - Team members
Warehouse staff and reviewers linked to an organization and platform user.
Linked to Organizations, Users
- Return grades
Inspection grades for returned stock: disposition, accepted units and release state for a stock request.
Linked to Stock requests, Organizations - Stock requests
Requests to receive, move, reserve or issue stock.
Linked to Organizations, Team members, Storage locations, Stock items - Record attachments
Documents and links attached to operational records.
Linked to Stock requests, Organizations - Review decisions
Approved, rejected, returned or escalated decisions on source records.
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 - Return grades
Inspection grades for returned stock: disposition, accepted units and release state for a stock request.
Linked to Stock requests, Organizations - Stock requests
Requests to receive, move, reserve or issue stock.
Linked to Organizations, Team members, Storage locations, Stock items - Record attachments
Documents and links attached to operational records.
Linked to Stock requests, Organizations - Team members
Warehouse staff and reviewers linked to an organization and platform user.
Linked to Organizations, Users
- 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 lots
Lot or serial level inventory held at a storage location.
Linked to Stock items, Storage locations - 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
- 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 - Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Stock requests
- Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Stock requests - 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 - 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 - Return grades
Inspection grades for returned stock: disposition, accepted units and release state for a stock request.
Linked to Stock requests, Organizations
Keys and references
Stock requests is the case anchor. Return grades.Parent, review decisions.source record, operation receipts.source record and stock movements.Parent lead back to it. Stock reservations joins a request and a lot. Stock movements.Reverses links a compensating entry to the original posting. Operation receipts.operation key and stock movements.source effect key support repeated action handling. Use the exact item and location references when loading records; a text item code alone does not replace the stock items relationship.
Migration order
- Load Organizations and Users, then team members.
- Load storage locations and stock items, then stock lots.
- Load stock requests and linked return grades, record attachments and review decisions.
- Load stock reservations and stock movements with their source and reversal links.
- Load operation receipts after their source requests are available.
Set up Returns Processing Center your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.