Local DNS records are similar to the /etc/hosts file, but stored in /etc/pihole/custom.list. They store local mappings of IP to client names.
If you have hostnames define in your DHCP settings, you typically do not need additional mapping.
Additional discussion here - note comment number 16 or 17, which discusses the priority among the various hosts files.