It changes your name on their friends list (and in turn Moogle Mail) as well as in your Free Company and any Linkshells you are in. Basically everywhere in game only displays your new name. I haven't checked, but pretty sure also includes any items you've crafted as well.