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.
- Health and Beauty OMS
- Data model
The tables behind Health and Beauty OMS
Health and Beauty OMS ships with 18 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
- 18
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Orders and customers
Organizations, Customers, team members and Users establish the operating context. Customer orders owns the order identity, status and commercial total. Open orders, orders awaiting review and fulfilled orders carry order list records for their respective operating states.
Products and lines
Products defines the SKU and product settings. Order lines links each ordered product and quantity to its parent order.
Review and control
Review decisions, operation receipts and record attachments keep decisions and evidence linked to the order revision and activity.
Fulfillment and finance
Fulfillment events records allocation through return events; payment evidence records payment method, status and amount.
Support and returns
Order exceptions, batch return reviews and channel handoffs connect issue resolution and batch disposition to the parent order.
Every table, by feature
- Orders and customers6
- Products and order lines4
- Review and evidence6
- Allocation and fulfillment5
- Payments and reconciliation5
- Returns and support6
- Shared and settings3
- Customer orders
Customer orders for beauty and wellness products, driven from draft through approval and fulfillment.
Linked to Organizations, Team members, Customers - Customers
Shoppers buying skincare, cosmetics and wellness products, with beauty profile and eligibility notes.
Linked to Organizations - Organizations
Skincare, cosmetics and wellness brands and retail banners operating in this app.
- Team members
Beauty advisors, fulfillment and support staff who own beauty orders.
Linked to Organizations, Users - Users
Users
Linked to Users - Channel handoffs
Support and channel handoffs for beauty orders and follow-up queries.
Linked to Customer orders, Organizations
- Products
Skincare, cosmetics and wellness catalog with batch tracking, shelf life and unit pricing.
Linked to Organizations - Order lines
Line-level beauty products on an order, with batch code, ordered units and net unit price.
Linked to Customer orders, Products - Customer orders
Customer orders for beauty and wellness products, driven from draft through approval and fulfillment.
Linked to Organizations, Team members, Customers - Order exceptions
Stock, batch, promotion and delivery exceptions raised on beauty orders, with support resolution.
Linked to Customer orders, Team members
- Review decisions
Independent review decisions recorded against beauty orders and exceptions.
Linked to Organizations, Team members, Customer orders - Operation receipts
Recorded operational receipts confirming what happened against a beauty order.
Linked to Organizations, Team members, Customer orders - Record attachments
Batch certificates of analysis and other attachments evidencing beauty order quality.
Linked to Customer orders, Organizations - Customer orders
Customer orders for beauty and wellness products, driven from draft through approval and fulfillment.
Linked to Organizations, Team members, Customers - Order lines
Line-level beauty products on an order, with batch code, ordered units and net unit price.
Linked to Customer orders, Products - Order exceptions
Stock, batch, promotion and delivery exceptions raised on beauty orders, with support resolution.
Linked to Customer orders, Team members
- Customer orders
Customer orders for beauty and wellness products, driven from draft through approval and fulfillment.
Linked to Organizations, Team members, Customers - Order lines
Line-level beauty products on an order, with batch code, ordered units and net unit price.
Linked to Customer orders, Products - Fulfillment events
Allocation, picking, packing, shipping, delivery and return events for beauty orders.
Linked to Customer orders, Organizations - Operation receipts
Recorded operational receipts confirming what happened against a beauty order.
Linked to Organizations, Team members, Customer orders - Products
Skincare, cosmetics and wellness catalog with batch tracking, shelf life and unit pricing.
Linked to Organizations
- Payment evidence
Payment evidence captured against beauty orders.
Linked to Customer orders - Operation receipts
Recorded operational receipts confirming what happened against a beauty order.
Linked to Organizations, Team members, Customer orders - Customer orders
Customer orders for beauty and wellness products, driven from draft through approval and fulfillment.
Linked to Organizations, Team members, Customers - Order lines
Line-level beauty products on an order, with batch code, ordered units and net unit price.
Linked to Customer orders, Products - Fulfillment events
Allocation, picking, packing, shipping, delivery and return events for beauty orders.
Linked to Customer orders, Organizations
- Order exceptions
Stock, batch, promotion and delivery exceptions raised on beauty orders, with support resolution.
Linked to Customer orders, Team members - Batch return reviews
Domain-specific batch return reviews supporting disposition of a beauty-product return.
Linked to Customer orders, Organizations - Channel handoffs
Support and channel handoffs for beauty orders and follow-up queries.
Linked to Customer orders, Organizations - Review decisions
Independent review decisions recorded against beauty orders and exceptions.
Linked to Organizations, Team members, Customer orders - Record attachments
Batch certificates of analysis and other attachments evidencing beauty order quality.
Linked to Customer orders, Organizations - Customer orders
Customer orders for beauty and wellness products, driven from draft through approval and fulfillment.
Linked to Organizations, Team members, Customers
Keys and references
The parent reference on a line, event, decision, receipt, attachment, exception, payment, return review or handoff points to customer orders. Order lines also references Products. Customer orders references its organization, owner, counterparty and billing customer. Review decisions identifies its reviewer; team members links to Users. Keep those references intact when importing records so a reviewer can follow one order across commercial, fulfillment and support activity.
Migration order
- Set organizations and people. Load Organizations, Users and team members with their organization and user references.
- Load commercial masters. Bring in Customers and Products with stable codes and SK us.
- Load orders and lines. Add customer orders before order lines and check customer, owner and product references.
- Load operating evidence. Attach review decisions, operation receipts, record attachments, fulfillment events and payment evidence to their parent orders.
- Load follow-up. Link order exceptions, batch return reviews and channel handoffs. Reconcile the state-specific order lists with the canonical order records.
Set up Health and Beauty OMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.