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.
- Network Inventory Management
- Data model
The tables behind Network Inventory Management
Network Inventory Management 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
Organizations own Assets and team members; Users connect to team members.
Network work
Work orders reference the owner, asset location and item. Port assignments and work evidence attach to the parent.
Review and evidence
Review decisions, operation receipts and record attachments attach to work orders.
Stock context
Stock items and stock lots identify items and positions used in work. Handling units, Loads and load stops retain their own inventory movement context.
Policy
Allocation policies belong to Organizations and hold channel allocation settings.
Every table, by feature
- Asset and item directory5
- Work orders9
- Port assignments5
- Review and decisions6
- Work evidence7
- Operation receipts5
- Shared and settings5
- Organizations
Operating organizations that own warehouses, stock and team members.
- Assets
Network assets and sites directory; each asset belongs to one organization.
Linked to 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, Assets - Team members
Warehouse staff and reviewers linked to an organization and platform user.
Linked to Organizations, Users
- Work orders
Planned and executed asset work; the parent record for evidence, port assignments, decisions and receipts.
Linked to Organizations, Team members, Assets, Stock items - Assets
Network assets and sites directory; each asset belongs to one organization.
Linked to Organizations - Stock items
Stock keeping units with base unit, tracking mode and reorder settings.
- Team members
Warehouse staff and reviewers linked to an organization and platform user.
Linked to Organizations, Users - Port assignments
Port assignment records raised against a parent work order, with status, revision and expiry.
Linked to Stock lots, Work orders, Organizations - Record attachments
Documents and links attached to operational records.
Linked to Work orders, Organizations, Team members - Review decisions
Approved, rejected, returned or escalated decisions on source records.
Linked to Organizations, Team members, Work orders - Work evidence
Evidence ledger for a parent work order: occurrence, quantity, revision and review state.
Linked to Organizations, Team members, Assets, Stock items - Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Work orders
- Port assignments
Port assignment records raised against a parent work order, with status, revision and expiry.
Linked to Stock lots, Work orders, Organizations - Work orders
Planned and executed asset work; the parent record for evidence, port assignments, decisions and receipts.
Linked to Organizations, Team members, Assets, Stock items - Stock lots
Lot or serial level inventory held at a storage location.
Linked to Stock items, Assets - Review decisions
Approved, rejected, returned or escalated decisions on source records.
Linked to Organizations, Team members, Work orders - Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Work orders
- Review decisions
Approved, rejected, returned or escalated decisions on source records.
Linked to Organizations, Team members, Work orders - Work orders
Planned and executed asset work; the parent record for evidence, port assignments, decisions and receipts.
Linked to Organizations, Team members, Assets, Stock items - Port assignments
Port assignment records raised against a parent work order, with status, revision and expiry.
Linked to Stock lots, Work orders, Organizations - Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Work orders - Record attachments
Documents and links attached to operational records.
Linked to Work orders, Organizations, Team members - Team members
Warehouse staff and reviewers linked to an organization and platform user.
Linked to Organizations, Users
- Work evidence
Evidence ledger for a parent work order: occurrence, quantity, revision and review state.
Linked to Organizations, Team members, Assets, Stock items - Work orders
Planned and executed asset work; the parent record for evidence, port assignments, decisions and receipts.
Linked to Organizations, Team members, Assets, Stock items - 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, Assets - Assets
Network assets and sites directory; each asset belongs to one organization.
Linked to Organizations - Record attachments
Documents and links attached to operational records.
Linked to Work orders, Organizations, Team members - Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Work orders
- Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Work orders - Work orders
Planned and executed asset work; the parent record for evidence, port assignments, decisions and receipts.
Linked to Organizations, Team members, Assets, Stock items - Work evidence
Evidence ledger for a parent work order: occurrence, quantity, revision and review state.
Linked to Organizations, Team members, Assets, Stock items - Review decisions
Approved, rejected, returned or escalated decisions on source records.
Linked to Organizations, Team members, Work orders - Team members
Warehouse staff and reviewers linked to an organization and platform user.
Linked to Organizations, Users
Keys and references
Work orders is the parent for a port assignment, review decision, work evidence entry, attachment or receipt. A port assignment also refers to a stock lots record. Work evidence may refer to another work evidence entry through Reverses. Review decisions preserves the source revision considered by the reviewer. Operation receipts carries the operation key and expected revision for an attempted action.
Migration order
- Create Organizations and Users, then team members.
- Create Assets and stock items, then stock lots and allocation policies.
- Create Loads, load stops and handling units where they belong to the operating scope.
- Import work orders, followed by port assignments and record attachments.
- Bring in work evidence, review decisions and operation receipts with their original parent and revision references.
Set up Network Inventory Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.