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.
- Consumer Electronics OMS
- Data model
The tables behind Consumer Electronics OMS
Consumer Electronics OMS ships with 14 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
- 14
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Orders
Customer orders connects Customers, Organizations and team members to the order owner and counterparty.
Product detail
Order lines connects each customer orders record with a Products record, quantity and price.
Execution
Fulfillment events and operation receipts attach activity and its result to the order.
Commercial evidence
Payment evidence and retail channel handoffs retain payment and external-channel references.
Review
Warranty checks, review decisions and record attachments keep device cases, decisions and documents linked to the order.
Every table, by feature
- Orders and customers8
- Products and order lines4
- Allocation and shipping5
- Payment and reconciliation6
- Warranty and returns6
- Review and audit trail6
- Shared and settings1
- Customer orders
Customer orders moving through draft, review, approval, execution and cancellation.
Linked to Organizations, Team members, Customers - Customers
Customer accounts that place orders across channels.
Linked to Organizations - Organizations
Operating organizations that own orders, customers, products and fulfillment activity.
- Team members
Internal staff who own orders, reviews and operational records.
Linked to Organizations, Users - Retail channel handoffs
Handoffs of a customer order to a retail or marketplace channel, with the channel's external reference and outcome.
Linked to Customer orders, Organizations - Order lines
Product lines belonging to a customer order with quantity, price and line total.
Linked to Customer orders, Products - Review decisions
Independent review decisions recorded against an order revision.
Linked to Organizations, Team members, Customer orders - Operation receipts
Durable receipts for each executed operation with status and source record.
Linked to Organizations, Team members, Customer orders
- Products
Sellable products with SKU, pricing, unit of measure and inventory tracking.
Linked to Organizations - Order lines
Product lines belonging to a customer order with quantity, price and line total.
Linked to Customer orders, Products - Customer orders
Customer orders moving through draft, review, approval, execution and cancellation.
Linked to Organizations, Team members, Customers - Fulfillment events
Allocation, pick, ship, delivery and return events recorded against an order.
Linked to Customer orders, Organizations
- Customer orders
Customer orders moving through draft, review, approval, execution and cancellation.
Linked to Organizations, Team members, Customers - Order lines
Product lines belonging to a customer order with quantity, price and line total.
Linked to Customer orders, Products - Fulfillment events
Allocation, pick, ship, delivery and return events recorded against an order.
Linked to Customer orders, Organizations - Operation receipts
Durable receipts for each executed operation with status and source record.
Linked to Organizations, Team members, Customer orders - Products
Sellable products with SKU, pricing, unit of measure and inventory tracking.
Linked to Organizations
- Payment evidence
Captured payment evidence for an order with method, amount and reference.
Linked to Customer orders - Customer orders
Customer orders moving through draft, review, approval, execution and cancellation.
Linked to Organizations, Team members, Customers - Order lines
Product lines belonging to a customer order with quantity, price and line total.
Linked to Customer orders, Products - Fulfillment events
Allocation, pick, ship, delivery and return events recorded against an order.
Linked to Customer orders, Organizations - Operation receipts
Durable receipts for each executed operation with status and source record.
Linked to Organizations, Team members, Customer orders - Warranty checks
Warranty registration and coverage checks raised against a customer order: serial match, activation, warranty window and damage assessment.
Linked to Customer orders, Team members
- Warranty checks
Warranty registration and coverage checks raised against a customer order: serial match, activation, warranty window and damage assessment.
Linked to Customer orders, Team members - Customer orders
Customer orders moving through draft, review, approval, execution and cancellation.
Linked to Organizations, Team members, Customers - Order lines
Product lines belonging to a customer order with quantity, price and line total.
Linked to Customer orders, Products - Review decisions
Independent review decisions recorded against an order revision.
Linked to Organizations, Team members, Customer orders - Operation receipts
Durable receipts for each executed operation with status and source record.
Linked to Organizations, Team members, Customer orders - Record attachments
Documents and links attached to an order as supporting evidence.
Linked to Customer orders, Organizations
- Review decisions
Independent review decisions recorded against an order revision.
Linked to Organizations, Team members, Customer orders - Operation receipts
Durable receipts for each executed operation with status and source record.
Linked to Organizations, Team members, Customer orders - Record attachments
Documents and links attached to an order as supporting evidence.
Linked to Customer orders, Organizations - Customer orders
Customer orders moving through draft, review, approval, execution and cancellation.
Linked to Organizations, Team members, Customers - Fulfillment events
Allocation, pick, ship, delivery and return events recorded against an order.
Linked to Customer orders, Organizations - Warranty checks
Warranty registration and coverage checks raised against a customer order: serial match, activation, warranty window and damage assessment.
Linked to Customer orders, Team members
Keys and references
Use the order record number for the team’s case reference and preserve the underlying record ID for relationships. Product SKU and customer code identify masters in daily work. An order revision makes review decisions specific to the state the reviewer saw. Fulfillment events, payment evidence, receipts, attachments and handoffs each reference the relevant order. The warranty check uses its parent order reference. Keep the external channel reference separate from the internal order number.
Migration order
- Load Organizations and Users, then team members for ownership and review assignments.
- Load Customers and Products with their operating organization references.
- Load customer orders and order lines, checking product, customer and owner references.
- Load retail channel handoffs, payment evidence and record attachments against the correct orders.
- Load fulfillment events, warranty checks, review decisions and operation receipts with their source-order history.
- Reconcile representative orders and revisions before giving teams the new views.
Set up Consumer Electronics OMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.