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 Consignment Tracking
- Data model
The tables behind SCM with Consignment Tracking
SCM with Consignment Tracking 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
Organization context
Organizations, team members, stock items and storage locations define the people and stock master records.
Stock identity
Stock lots carries lot code, expiry, release state and owner reference for a stock items item.
Operational work
Stock requests holds owner, item, location, quantity, revision and status; stock reservations holds a quantity claim against a request.
Evidence and effect
Review decisions, record attachments and operation receipts remain linked to the request; stock movements records signed posted effects.
Consumption
Consignment usage links used quantity and agreement context to the parent request and organization.
Every table, by feature
- Stock requests4
- Consigned stock5
- Reservations5
- Usage confirmation5
- Reviews and evidence5
- Movement history6
- Shared and settings1
- Stock requests
Business requests that drive consigned stock receipt, movement, reservation and consumption.
Linked to Organizations, Team members, Storage locations, Stock items - Record attachments
Supporting evidence files linked to stock requests.
Linked to Stock requests, Team members - Review decisions
Independent reviewer decisions on submitted revisions.
Linked to Stock requests, Team members - Operation receipts
Durable record of every guarded operation attempt and its result state.
Linked to Stock requests
- Organizations
Legal business entities that own consignment stock and operational records.
- Stock items
Consigned product master data.
Linked to Organizations - Stock lots
Lot and expiry evidence for lot-tracked consigned stock.
Linked to Stock items - Storage locations
Physical sites where consigned stock is held.
Linked to Organizations - Team members
Named staff members who own and review consignment records.
Linked to Organizations, Users
- Stock reservations
Held claims against eligible consigned stock.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock requests
Business requests that drive consigned stock receipt, movement, reservation and consumption.
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Consigned product master data.
Linked to Organizations - Stock lots
Lot and expiry evidence for lot-tracked consigned stock.
Linked to Stock items - Storage locations
Physical sites where consigned stock is held.
Linked to Organizations
- Consignment usage
Confirmed consigned consumption records supporting usage-based billing.
Linked to Stock requests, Organizations - Stock requests
Business requests that drive consigned stock receipt, movement, reservation and consumption.
Linked to Organizations, Team members, Storage locations, Stock items - Stock reservations
Held claims against eligible consigned stock.
Linked to Stock requests, Stock items, Storage locations, Stock lots - Stock movements
Posted signed quantities for consigned stock, including compensating reversals.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Review decisions
Independent reviewer decisions on submitted revisions.
Linked to Stock requests, Team members
- Review decisions
Independent reviewer decisions on submitted revisions.
Linked to Stock requests, Team members - Record attachments
Supporting evidence files linked to stock requests.
Linked to Stock requests, Team members - Operation receipts
Durable record of every guarded operation attempt and its result state.
Linked to Stock requests - Stock requests
Business requests that drive consigned stock receipt, movement, reservation and consumption.
Linked to Organizations, Team members, Storage locations, Stock items - Team members
Named staff members who own and review consignment records.
Linked to Organizations, Users
- Stock movements
Posted signed quantities for consigned stock, including compensating reversals.
Linked to Stock requests, Stock items, Storage locations, Stock movements - Stock requests
Business requests that drive consigned stock receipt, movement, reservation and consumption.
Linked to Organizations, Team members, Storage locations, Stock items - Stock items
Consigned product master data.
Linked to Organizations - Stock lots
Lot and expiry evidence for lot-tracked consigned stock.
Linked to Stock items - Storage locations
Physical sites where consigned stock is held.
Linked to Organizations - Operation receipts
Durable record of every guarded operation attempt and its result state.
Linked to Stock requests
Keys and references
A request is the central reference for review decisions, attachments, operation receipts, movements and usage. A reservation uses its Request reference to connect a claim to the same action. Stock movements.Reverses points to an earlier movement when a correction offsets a posted quantity. Team members.User connects a named staff member to the user account.
Migration order
- Organizations and users. Establish the legal operating scope and staff identities.
- Items and locations. Load active products and physical sites under their organizations.
- Lots. Add release and expiry evidence for lot-tracked items.
- Requests. Bring over the current operational cases with owner, item and site links.
- Effects and evidence. Link reservations, decisions, attachments, receipts, movements and usage to the correct request.
Set up SCM with Consignment Tracking your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.