-- Synthetic Theory fixture 2. No customer data.
CREATE VIEW report.reconcile
AS
SELECT
    m.position_id,
    m.as_at_month AS reconciled_month,
    m.gross_amount * r.rate_factor AS reconciled_amount
FROM report.month_end AS m
JOIN ref.rate_lookup AS r ON r.as_at_month = m.as_at_month;