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.
- Apparel and Footwear OMS
- Data model
The tables behind Apparel and Footwear OMS
Apparel and Footwear 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
Order capture:
Apparel customer orders connects buyer and bill-to records with order lines size and color.
Assortment:
Style variants supplies the style, color, size, season and promotion context for a line.
Review and evidence:
Order review decisions, operation receipts and record attachments retain decisions and operation history.
Execution:
Fulfillment and returns events, payment evidence, order and support exceptions and retail channel handoffs reference the source order.
People and scope:
Retail organizations, merchandising and support team, wholesale accounts and shoppers and Users identify operating context.
Every table, by feature
- Order capture7
- Review and decisions6
- Allocation and fulfillment6
- Returns and support9
- Payment and reconciliation6
- Assortment and channels6
- Shared and settings1
- Apparel customer orders
US apparel and footwear customer orders with order channel, primary style, seasonal promotion code and net order value in USD.
Linked to Retail organizations, Merchandising and support team, Wholesale accounts and shoppers - Order lines size and color
Order lines by style variant, carrying the ordered units, wholesale unit price and size or color substitution allowance.
Linked to Apparel customer orders, Style variants - Style variants
Catalog assortment of apparel and footwear style variants: one row per style, color and size combination with its list price, season and promotion eligibility.
Linked to Retail organizations - Wholesale accounts and shoppers
Department stores, specialty chains and direct shoppers that place US apparel and footwear orders, with fit, sizing and return notes.
Linked to Retail organizations - Merchandising and support team
Merchandising, allocation, fulfillment and customer support staff who own apparel orders and exceptions.
Linked to Retail organizations, Users - Operation receipts
Receipts recorded for every apparel order operation: alignment, allocation, release, reconciliation, cancel and compensation runs.
Linked to Retail organizations, Merchandising and support team, Apparel customer orders - Order review decisions
Independent review decisions on apparel orders, recording the decision, rationale and order revision the reviewer acted on.
Linked to Retail organizations, Merchandising and support team, Apparel customer orders
- Apparel customer orders
US apparel and footwear customer orders with order channel, primary style, seasonal promotion code and net order value in USD.
Linked to Retail organizations, Merchandising and support team, Wholesale accounts and shoppers - Order lines size and color
Order lines by style variant, carrying the ordered units, wholesale unit price and size or color substitution allowance.
Linked to Apparel customer orders, Style variants - Order review decisions
Independent review decisions on apparel orders, recording the decision, rationale and order revision the reviewer acted on.
Linked to Retail organizations, Merchandising and support team, Apparel customer orders - Order and support exceptions
Size and color stock shortages, ship-to address issues, payment holds, damaged or defective items, late shipments and customer support follow-ups on US apparel orders.
Linked to Apparel customer orders, Merchandising and support team - Operation receipts
Receipts recorded for every apparel order operation: alignment, allocation, release, reconciliation, cancel and compensation runs.
Linked to Retail organizations, Merchandising and support team, Apparel customer orders - Record attachments
Fit sheets, packing lists, return authorizations and other evidence attached to an apparel order.
Linked to Apparel customer orders, Retail organizations
- Apparel customer orders
US apparel and footwear customer orders with order channel, primary style, seasonal promotion code and net order value in USD.
Linked to Retail organizations, Merchandising and support team, Wholesale accounts and shoppers - Order lines size and color
Order lines by style variant, carrying the ordered units, wholesale unit price and size or color substitution allowance.
Linked to Apparel customer orders, Style variants - Fulfillment and returns events
Allocation, pick, pack, shipment, delivery and return or exchange events against apparel orders at a DC or store location.
Linked to Apparel customer orders, Retail organizations - Operation receipts
Receipts recorded for every apparel order operation: alignment, allocation, release, reconciliation, cancel and compensation runs.
Linked to Retail organizations, Merchandising and support team, Apparel customer orders - Order and support exceptions
Size and color stock shortages, ship-to address issues, payment holds, damaged or defective items, late shipments and customer support follow-ups on US apparel orders.
Linked to Apparel customer orders, Merchandising and support team - Retail channel handoffs
Handoffs of apparel orders to retail and wholesale channels, with the external reference the connected channel system returns.
Linked to Apparel customer orders, Retail organizations
- Order and support exceptions
Size and color stock shortages, ship-to address issues, payment holds, damaged or defective items, late shipments and customer support follow-ups on US apparel orders.
Linked to Apparel customer orders, Merchandising and support team - Apparel customer orders
US apparel and footwear customer orders with order channel, primary style, seasonal promotion code and net order value in USD.
Linked to Retail organizations, Merchandising and support team, Wholesale accounts and shoppers - Order lines size and color
Order lines by style variant, carrying the ordered units, wholesale unit price and size or color substitution allowance.
Linked to Apparel customer orders, Style variants - Fulfillment and returns events
Allocation, pick, pack, shipment, delivery and return or exchange events against apparel orders at a DC or store location.
Linked to Apparel customer orders, Retail organizations - Payment evidence
Payment evidence captured against apparel orders, with gateway reference, method, verification state and captured USD amount.
Linked to Apparel customer orders - Record attachments
Fit sheets, packing lists, return authorizations and other evidence attached to an apparel order.
Linked to Apparel customer orders, Retail organizations - Wholesale accounts and shoppers
Department stores, specialty chains and direct shoppers that place US apparel and footwear orders, with fit, sizing and return notes.
Linked to Retail organizations - Order review decisions
Independent review decisions on apparel orders, recording the decision, rationale and order revision the reviewer acted on.
Linked to Retail organizations, Merchandising and support team, Apparel customer orders - Operation receipts
Receipts recorded for every apparel order operation: alignment, allocation, release, reconciliation, cancel and compensation runs.
Linked to Retail organizations, Merchandising and support team, Apparel customer orders
- Payment evidence
Payment evidence captured against apparel orders, with gateway reference, method, verification state and captured USD amount.
Linked to Apparel customer orders - Apparel customer orders
US apparel and footwear customer orders with order channel, primary style, seasonal promotion code and net order value in USD.
Linked to Retail organizations, Merchandising and support team, Wholesale accounts and shoppers - Order lines size and color
Order lines by style variant, carrying the ordered units, wholesale unit price and size or color substitution allowance.
Linked to Apparel customer orders, Style variants - Fulfillment and returns events
Allocation, pick, pack, shipment, delivery and return or exchange events against apparel orders at a DC or store location.
Linked to Apparel customer orders, Retail organizations - Operation receipts
Receipts recorded for every apparel order operation: alignment, allocation, release, reconciliation, cancel and compensation runs.
Linked to Retail organizations, Merchandising and support team, Apparel customer orders - Order and support exceptions
Size and color stock shortages, ship-to address issues, payment holds, damaged or defective items, late shipments and customer support follow-ups on US apparel orders.
Linked to Apparel customer orders, Merchandising and support team
- Style variants
Catalog assortment of apparel and footwear style variants: one row per style, color and size combination with its list price, season and promotion eligibility.
Linked to Retail organizations - Wholesale accounts and shoppers
Department stores, specialty chains and direct shoppers that place US apparel and footwear orders, with fit, sizing and return notes.
Linked to Retail organizations - Retail organizations
US retail organizations and wholesale accounts trading apparel and footwear through this order book.
- Apparel customer orders
US apparel and footwear customer orders with order channel, primary style, seasonal promotion code and net order value in USD.
Linked to Retail organizations, Merchandising and support team, Wholesale accounts and shoppers - Order lines size and color
Order lines by style variant, carrying the ordered units, wholesale unit price and size or color substitution allowance.
Linked to Apparel customer orders, Style variants - Retail channel handoffs
Handoffs of apparel orders to retail and wholesale channels, with the external reference the connected channel system returns.
Linked to Apparel customer orders, Retail organizations
Keys and references
Order number identifies the order for operations. Each order line points through Order to apparel customer orders and through style variant to style variants. Review decisions and receipts use source apparel order. Fulfillment events, payment evidence, exceptions and channel handoffs use apparel customer order. Attachments use related apparel order. Team records connect through User to Users and Organization to retail organizations. Preserve these references when importing history so an event or decision is never separated from its order.
Migration order
- Import retail organizations, Users and merchandising and support team.
- Import wholesale accounts and shoppers and style variants with their organization references.
- Import apparel customer orders and order lines size and color with buyer, owner and variant links.
- Import order review decisions, operation receipts and record attachments.
- Import fulfillment and returns events, payment evidence, order and support exceptions and retail channel handoffs.
- Check references and selected order histories before starting current operations.
Set up Apparel and Footwear OMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.