Log affiliate conversions from payments and create records

Your payments sometimes lack affiliate mapping, causing missed commissions and poor campaign attribution. This captures the conversion and logs a transaction row for same-day reconciliation.