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.
- SCM with Returns Management
- Data model
The tables behind SCM with Returns Management
SCM with Returns Management 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
Operating scope
Organizations, team members and storage locations identify who owns work and where it happens.
Item identity
Stock items and stock lots hold the base unit, lot rule, expiry and release state.
Return work
Stock requests carry the requested quantity, owner, counterparty, status and revision.
Review and evidence
Review decisions, record attachments and operation receipts retain decisions, files and guarded action results.
Quantity effects
Stock reservations hold claims; stock movements record posted signed changes and reversals; refurbishment jobs retain recovered-unit lineage.
Every table, by feature
- Stock requests5
- Review and evidence5
- Stock reservations5
- Stock movements6
- Refurbishment jobs5
- Operations overview5
- Shared and settings1
- Stock requests
Return and stock movement requests raised against a storage location counterparty
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Returnable and refurbishable items with base unit and lot tracking rules
Linked to Organizations - Storage locations
Warehouses, return docks and quarantine areas receiving inspected stock
Linked to Organizations - Organizations
Operating organizations that own return operations
- Team members
Organization members who prepare, review and execute return operations
Linked to Organizations, Users
- Review decisions
Independent review decisions recorded against a frozen stock request revision
Linked to Stock requests, Team members - Record attachments
Return evidence files attached to a stock request
Linked to Stock requests, Team members - Operation receipts
Idempotent receipts for every guarded operation attempt
Linked to Stock requests - Stock requests
Return and stock movement requests raised against a storage location counterparty
Linked to Organizations, Team members, Storage locations, Stock items - Team members
Organization members who prepare, review and execute return operations
Linked to Organizations, Users
- Stock reservations
Reservations holding eligible free quantity for an approved request
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock requests
Return and stock movement requests raised against a storage location counterparty
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Returnable and refurbishable items with base unit and lot tracking rules
Linked to Organizations - Storage locations
Warehouses, return docks and quarantine areas receiving inspected stock
Linked to Organizations - Stock lots
Lot and expiry evidence for lot-tracked returned stock
Linked to Stock items
- Stock movements
Posted signed quantity movements against approved stock requests
Linked to Stock requests, Stock items, Storage locations, Stock movements - Stock requests
Return and stock movement requests raised against a storage location counterparty
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Returnable and refurbishable items with base unit and lot tracking rules
Linked to Organizations - Storage locations
Warehouses, return docks and quarantine areas receiving inspected stock
Linked to Organizations - Stock lots
Lot and expiry evidence for lot-tracked returned stock
Linked to Stock items - Operation receipts
Idempotent receipts for every guarded operation attempt
Linked to Stock requests
- Refurbishment jobs
Refurbishment jobs that release refurbished stock with retained return lineage
Linked to Stock requests, Organizations - Stock requests
Return and stock movement requests raised against a storage location counterparty
Linked to Organizations, Team members, Storage locations, Stock items - Stock movements
Posted signed quantity movements against approved stock requests
Linked to Stock requests, Stock items, Storage locations, Stock movements - Operation receipts
Idempotent receipts for every guarded operation attempt
Linked to Stock requests - Organizations
Operating organizations that own return operations
- Stock movements
Posted signed quantity movements against approved stock requests
Linked to Stock requests, Stock items, Storage locations, Stock movements - Stock reservations
Reservations holding eligible free quantity for an approved request
Linked to Stock requests, Stock items, Storage locations, Stock lots - Operation receipts
Idempotent receipts for every guarded operation attempt
Linked to Stock requests - Stock requests
Return and stock movement requests raised against a storage location counterparty
Linked to Organizations, Team members, Storage locations, Stock items - Stock lots
Lot and expiry evidence for lot-tracked returned stock
Linked to Stock items
Keys and references
Stock requests is the parent of review decisions, attachments, receipts, movements and refurbishment jobs. Stock reservations references its Request, Item, Location and optional Lot. Stock movements references its Parent, Item, Location, optional Lot and optional Reverses movement. Team members links operational ownership and review to Users and Organizations. Preserve these links when importing historical returns.
Migration order
- Load Organizations and Users, then team members and storage locations.
- Load stock items and their stock lots with release state and expiry evidence.
- Load stock requests and their attachments and decisions.
- Load reservations, refurbishment jobs, operation receipts and posted movements with source references.
- Reconcile quantities and corrections by item, location and lot before live use.
Set up SCM with Returns Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.