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.
- OMS for Furniture and Home Goods
- Data model
The tables behind OMS for Furniture and Home Goods
OMS for Furniture and Home Goods 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
Order book
Home goods orders connect trade customers, order line items, delivery coordinators and distribution regions.
Catalog and freight
Furniture catalog items supply linked line identity; freight shipments and freight carrier handoffs carry movement and carrier evidence.
Decisions and delivery
Fulfillment review decisions, delivery receipts, damage and delivery exceptions and order documents retain review and delivery history.
Money and access
Payment records attach payment state to the order; Users connect to delivery coordinators.
Every table, by feature
- Orders and customers6
- Catalog and lines5
- Review and decisions6
- Freight operations6
- Delivery and exceptions7
- Payments and evidence6
- Shared and settings1
- Home goods orders
Furniture and home goods customer orders with delivery window, channel, order value and freight status.
Linked to Distribution regions, Delivery coordinators, Trade customers - Trade customers
Trade and retail accounts buying large-item furniture and home goods, with delivery address and credit notes.
Linked to Distribution regions - Distribution regions
Regional distribution centers that own US furniture and home goods order books, freight dispatch and delivery coverage.
- Delivery coordinators
Order coordinators and delivery schedulers who own furniture orders, freight dispatch and damage claims.
Linked to Distribution regions, Users - Order line items
Line items on a furniture order: catalog item, quantity, unit price and fulfillment state.
Linked to Home goods orders, Furniture catalog items - Damage and delivery exceptions
Damage claims, delivery address issues, late deliveries and stock shortages blocking a furniture order.
Linked to Home goods orders, Delivery coordinators
- Furniture catalog items
Large-item furniture and home goods catalog: sofas, sectionals, beds, dining sets, case goods and outdoor.
Linked to Distribution regions - Order line items
Line items on a furniture order: catalog item, quantity, unit price and fulfillment state.
Linked to Home goods orders, Furniture catalog items - Home goods orders
Furniture and home goods customer orders with delivery window, channel, order value and freight status.
Linked to Distribution regions, Delivery coordinators, Trade customers - Freight shipments
Freight shipment and delivery scheduling events per order: carrier allocation, warehouse pickup, wrapping, transit, delivery and returns.
Linked to Home goods orders, Distribution regions - Distribution regions
Regional distribution centers that own US furniture and home goods order books, freight dispatch and delivery coverage.
- Fulfillment review decisions
Independent review decisions on furniture orders and damage claims, with revision and rationale.
Linked to Distribution regions, Delivery coordinators, Home goods orders - Home goods orders
Furniture and home goods customer orders with delivery window, channel, order value and freight status.
Linked to Distribution regions, Delivery coordinators, Trade customers - Order line items
Line items on a furniture order: catalog item, quantity, unit price and fulfillment state.
Linked to Home goods orders, Furniture catalog items - Damage and delivery exceptions
Damage claims, delivery address issues, late deliveries and stock shortages blocking a furniture order.
Linked to Home goods orders, Delivery coordinators - Delivery receipts
Signed delivery receipts recording units received against a furniture order and the amount billed.
Linked to Distribution regions, Delivery coordinators, Home goods orders - Order documents
Bills of lading, delivery photos, damage-claim photos and signed paperwork backing a furniture order.
Linked to Home goods orders, Distribution regions
- Freight shipments
Freight shipment and delivery scheduling events per order: carrier allocation, warehouse pickup, wrapping, transit, delivery and returns.
Linked to Home goods orders, Distribution regions - Freight carrier handoffs
Handoffs of a furniture order to a freight carrier or 3PL, with the carrier's own reference.
Linked to Home goods orders, Distribution regions - Home goods orders
Furniture and home goods customer orders with delivery window, channel, order value and freight status.
Linked to Distribution regions, Delivery coordinators, Trade customers - Order line items
Line items on a furniture order: catalog item, quantity, unit price and fulfillment state.
Linked to Home goods orders, Furniture catalog items - Delivery receipts
Signed delivery receipts recording units received against a furniture order and the amount billed.
Linked to Distribution regions, Delivery coordinators, Home goods orders - Distribution regions
Regional distribution centers that own US furniture and home goods order books, freight dispatch and delivery coverage.
- Delivery receipts
Signed delivery receipts recording units received against a furniture order and the amount billed.
Linked to Distribution regions, Delivery coordinators, Home goods orders - Damage and delivery exceptions
Damage claims, delivery address issues, late deliveries and stock shortages blocking a furniture order.
Linked to Home goods orders, Delivery coordinators - Home goods orders
Furniture and home goods customer orders with delivery window, channel, order value and freight status.
Linked to Distribution regions, Delivery coordinators, Trade customers - Freight shipments
Freight shipment and delivery scheduling events per order: carrier allocation, warehouse pickup, wrapping, transit, delivery and returns.
Linked to Home goods orders, Distribution regions - Payment records
Payments captured against furniture orders, including refunds issued for damage claims and returns.
Linked to Home goods orders - Order documents
Bills of lading, delivery photos, damage-claim photos and signed paperwork backing a furniture order.
Linked to Home goods orders, Distribution regions - Fulfillment review decisions
Independent review decisions on furniture orders and damage claims, with revision and rationale.
Linked to Distribution regions, Delivery coordinators, Home goods orders
- Payment records
Payments captured against furniture orders, including refunds issued for damage claims and returns.
Linked to Home goods orders - Order documents
Bills of lading, delivery photos, damage-claim photos and signed paperwork backing a furniture order.
Linked to Home goods orders, Distribution regions - Delivery receipts
Signed delivery receipts recording units received against a furniture order and the amount billed.
Linked to Distribution regions, Delivery coordinators, Home goods orders - Home goods orders
Furniture and home goods customer orders with delivery window, channel, order value and freight status.
Linked to Distribution regions, Delivery coordinators, Trade customers - Damage and delivery exceptions
Damage claims, delivery address issues, late deliveries and stock shortages blocking a furniture order.
Linked to Home goods orders, Delivery coordinators - Fulfillment review decisions
Independent review decisions on furniture orders and damage claims, with revision and rationale.
Linked to Distribution regions, Delivery coordinators, Home goods orders
Keys and references
Order number is the operating reference for a home goods orders record. Each order line items row points to its home goods order and catalog item. Freight shipments, delivery receipts, payment records, order documents and damage and delivery exceptions point back to home goods orders. The decision’s order reviewed reference identifies the reviewed order and its Revision. Delivery coordinators connect to Users and distribution regions; region references keep local order and evidence scope together.
Migration order
- Load Users and distribution regions, then assign delivery coordinators.
- Load trade customers and furniture catalog items with their regions.
- Load home goods orders with customer, consignee and coordinator references.
- Load order line items, then linked freight carrier handoffs and freight shipments.
- Load fulfillment review decisions, delivery receipts, order documents, payment records and damage and delivery exceptions with their order references.
- Reconcile counts and totals by region, order number and status before operating on migrated work.
Set up OMS for Furniture and Home Goods your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.