URL

This is provider specific type of record and not a DNS standard. It may behave differently for each provider that handles it.

Namecheap

This is a URL Redirect record with a type of "Unmasked", it creates a 302 redirect to the target.

You can read more at the Namecheap documentation