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.
- Pallet Tracking System
- Data model
The tables behind Pallet Tracking System
Pallet Tracking System 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
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Organization and access
Organizations, team members and Users identify the operating group and people; storage locations belongs to an organization.
Stock identity
Stock items identifies the SKU; stock lots carries the item and storage location; pallet custody carries handling-unit identity and current owner.
Work and effect
Stock requests is the parent for stock movements, operation receipts, review decisions and record attachments; stock reservations links a request to a lot.
Transport context
Loads contains carrier and dock detail; load stops connects a load to a location and appointment.
Every table, by feature
- Pallet custody9
- Stock requests9
- Lot inventory7
- Movements and reservations7
- Loads and stops6
- Review and evidence7
- Shared and settings2
- Pallet custody
Pallets, totes and license-plate handling units with custody.
Linked to Storage locations, Stock items, Stock requests, Organizations - 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 - 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 - 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 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 - Stock reservations
Held, released or consumed reservations against eligible stock lots.
Linked to Stock lots, Stock requests - Stock movements
Posted signed-quantity movements that change on-hand inventory.
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 - Pallet custody
Pallets, totes and license-plate handling units with custody.
Linked to Storage locations, Stock items, Stock requests, Organizations
- 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 - Storage locations
Warehouses, bins, yards and cold rooms where stock is held.
Linked to Organizations - 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 movements
Posted signed-quantity movements that change on-hand inventory.
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 reservations
Held, released or consumed reservations against eligible stock lots.
Linked to Stock lots, 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
- 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 - Pallet custody
Pallets, totes and license-plate handling units with custody.
Linked to Storage locations, Stock items, 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
- 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 - Team members
Warehouse staff and reviewers linked to an organization and platform user.
Linked to Organizations, Users - Organizations
Operating organizations that own warehouses, stock and team members.
Keys and references
A pallet code identifies a handling unit. A request record number identifies authorized work. Movement records link to their parent request and may link to a lot; a reversal points to the movement it compensates. Review decisions and operation receipts link back to the request. A team member links an organization to a platform user. Use these relationships when importing history or tracing an exception.
Migration order
- Organization and people. Add Organizations, Users and team members.
- Locations and items. Add storage locations, stock items and allocation policies.
- Stock and units. Add stock lots and pallet custody with current quantities and owners.
- Loads and work. Add Loads, load stops and open stock requests.
- Evidence. Bring related stock reservations, stock movements, review decisions, operation receipts and record attachments with their parent references.
Set up Pallet Tracking System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.