E-commerce
Carts, checkouts, orders, payments, returns and fulfilment or shipment references.
471
Source rows at Day-0
33
Populated tables
33
Exported tables
Collections
Carts9
Shopping carts, converted and abandoned.
Checkouts7
Checkouts started from carts.
Orders5
Online orders and whether each names an ERP sales order. Lines and status history appear inside each.
Payments7
Card payment intents and what was captured or refunded.
Returns2
Return requests against online orders.
Shipment References2
Online orders' shipments, as the Logistics shipment each names.
Representative records
What these records become
Digital Order ×5
Canonical records projected from E-commerce source records. A source record's own page links to the canonical record it resolves or projects to.
Cross-system journeys
Technical schema — 33 exported tables in ecom_src
- address1
- audit_event138
- cancellation2
- cart9
- cart_item10
- category_ref2
- checkout7
- checkout_address14
- coupon_application1
- coupon_ref2
- customer_ref1
- document_sequence7
- ecom_order5
- ecom_role6
- ecom_user6
- ecom_user_role6
- fulfillment_ref2
- idempotency_key138
- message1
- order_line6
- order_status_history18
- outbox_event38
- payment_event14
- payment_intent7
- price_ref5
- product_category4
- product_ref4
- promotion_ref1
- return_item2
- return_request2
- session9
- shipment_ref2
- storefront1