Multi-system join between Shopify orders and Stripe charges. Surface the canonical reconciliation pattern: orders where Shopify financial_status indicates partial revenue but Stripe carries the full charged amount with refunded=1 — meaning the partial refund hasn't been reflected back to Shopify total_price.