I have a feature service linked to SQLServer hosted in Enterprise and referenced in ArcGIS Online as a distributed collaboration. Most of the layers in the service have attachments enabled and when added to a map in ArcGIS Online and configured with a pop-up, the attachments work as expected in Field Maps. Photos can be taken or added and then show up at the bottom of the pop-up.
I created a template map where I also used Field Maps Designer