Hey Jacob,
As you noticed, the default template for estimates does not support "Manufacturer's Part Number". You would need to add this field to the table, then customize the screen to add the field.
If you need help doing this, check out the webinar "Tables and Field", you can find that here.
Once you add the field to the table, you will be able to use this field in your reports.
This should help you out.