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.
- E-commerce Fulfillment SCM
- Data model
The tables behind E-commerce Fulfillment SCM
E-commerce Fulfillment SCM ships with 13 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
- 13
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
Every table, by feature
- Orders and customers4
- Order lines and products4
- Fulfillment events5
- Carrier labels4
- Review and operations5
- Payment and attachments5
- Shared and settings1
- Customer orders
E-commerce orders moving through pick-pack-ship
Linked to Organizations, Team members, Customers - Customers
Ordering parties served by the operation
Linked to Organizations - Organizations
Fulfillment operating entities
- Team members
People with an authorized fulfillment role
Linked to Organizations, Users
- Order lines
Ordered, allocated and shipped quantities per SKU
Linked to Customer orders - Products
Sellable SK us with base unit and standard price
- Customer orders
E-commerce orders moving through pick-pack-ship
Linked to Organizations, Team members, Customers - Fulfillment events
Actual allocated, picked, shipped, delivered and returned events
Linked to Customer orders, Products
- Fulfillment events
Actual allocated, picked, shipped, delivered and returned events
Linked to Customer orders, Products - Customer orders
E-commerce orders moving through pick-pack-ship
Linked to Organizations, Team members, Customers - Products
Sellable SK us with base unit and standard price
- Order lines
Ordered, allocated and shipped quantities per SKU
Linked to Customer orders - Operation receipts
Idempotent record of each executed operation
Linked to Customer orders
- Carrier labels
Packed-order carrier labels under review
Linked to Customer orders, Organizations - Customer orders
E-commerce orders moving through pick-pack-ship
Linked to Organizations, Team members, Customers - Review decisions
Independent review outcomes per source revision
Linked to Customer orders, Team members - Operation receipts
Idempotent record of each executed operation
Linked to Customer orders
- Operation receipts
Idempotent record of each executed operation
Linked to Customer orders - Review decisions
Independent review outcomes per source revision
Linked to Customer orders, Team members - Customer orders
E-commerce orders moving through pick-pack-ship
Linked to Organizations, Team members, Customers - Fulfillment events
Actual allocated, picked, shipped, delivered and returned events
Linked to Customer orders, Products - Carrier labels
Packed-order carrier labels under review
Linked to Customer orders, Organizations
- Payment evidence
Provider-confirmed authorization, capture and refund events
Linked to Customer orders - Record attachments
Supporting evidence files per order
Linked to Customer orders, Team members - Customer orders
E-commerce orders moving through pick-pack-ship
Linked to Organizations, Team members, Customers - Fulfillment events
Actual allocated, picked, shipped, delivered and returned events
Linked to Customer orders, Products - Team members
People with an authorized fulfillment role
Linked to Organizations, Users
Keys and references
Customer orders is the anchor for line, event, label, payment, attachment, review and receipt history. External order ID, external event ID, provider event ID and operation key identify incoming or executed work. Check these values and the relevant Revision before writing an effect. Team members links the operational owner or reviewer to a Users identity and organization.
Migration order
- Load Organizations, Users and team members, then Customers and Products.
- Load customer orders with its organization, customer and owner references.
- Load order lines and reconcile SKU and unit quantities.
- Load fulfillment events, carrier labels and their external identifiers.
- Load payment evidence, record attachments, review decisions and operation receipts with their order references.
Set up E-commerce Fulfillment SCM your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.