Can I see the custom part number on the order confirmation email ?

Yes, this is possible - to do this you need to customize the email template or add the following line.

{% if nestedItem.payload.customerProductNumber is defined %}{{ nestedItem.payload.customerProductNumber|u.wordwrap(80) }}{% endif %}