Orders by payment outcome and payment method

Orders CREATED in the period (creation day in UTC), one row per payment method chosen at checkout, each order in exactly one outcome: paid (the payment was approved, even if the order was canceled afterwards), canceled (canceled without a payment: refused, or expired and canceled by the platform) or pending (still open without a payment). unpaidValue, canceledValue and pendingValue are the real order totals, not an estimate. Each order is counted once, in its newest copy. VTEX: vtex_orders by creation_date; paid = authorized_date set; canceled = status canceled / cancelled / cancellation-requested; value = value. Tray: tray_orders by date; paid = payment_date set (has_payment is TRUE on every order, so it is not read); canceled = order_status_type canceled/cancelled or a status label starting with CANCELADO; value = total. Shopify does not extract the payment method: supported is false, methods is empty and the totals are zeros (no warehouse read). Null or blank payment methods are bucketed as (sem valor). Aggregates only: no customer data. Both dates are required; the period spans at most 366 days.