sm_views contains report views generated for Managed Data Warehouse customers. These views are designed for common reporting workflows and are built on top of transformed SourceMedium tables.
rpt_customers_first_and_last_order_summary_v1
One row per customer: lifetime totals plus first and last order details.
rpt_order_returns_v1
One row per order with a return: counts, economics, and order context.