If active, the customer will be redirected to the specified URL after a successful reservation for this service. This is meant for tracking conversions.
About payments: when redirect is active, the online and local payment settings will work just fine, while discretionary payment setting will not, so no payment option will be presented to the customer after the reservation in this case.
Customers can still pay the reservation by visiting a page where the resides (they must be logged-in).